Third-year training Java and database use, three people a group, I this component to the topic is "Real Estate management System"
Project requirements:
Project Objective: The system should be able to manage the property information, household basic information (head of household, family member) and so on. All information can be easily added, modified, deleted and other operations.
At least the system functions should be implemented: system settings, including the type of information items required, code and other data maintenance, housing information in the community, buildings, housing and other information maintenance;
Household information management, household information, family members information maintenance, query module includes a variety of information query, statistics and so on.
The training altogether two weeks more time, because I need to help other groups of classmates, so I used 3-5 days of time simple completed my this task, the code is basically I complete alone, the function is relatively simple, the final review got a good. Good teacher, no way.
Interface flowchart for first post-program
1, the first is the login interface
2, click Login to the Master interface
Here are four messages, the total number of houses, the number of houses sold, the number of houses to be controlled, the total income (the total income from the sale of housing)
A total of 3 buttons, respectively into three interface, inquiry, sale, recycling
3.
(1) Click on the "Housing Enquiry" button
Here, the default is to show all housing information, showing the housing information can be seen from the figure, of course, only the first 7 of the data, and other data through the "previous" "Next Page" button to achieve the display
Query types are divided into three parts: all, sold, unsold housing information showing the response separately
Query methods are divided into two categories: according to the housing number query, according to the name of the head of the two types of search for a single housing information
,
The interface also has a modification function, that is, the Change button in the back of each housing can modify the information of the housing, of course, there is a precondition, when there is housing information can be modified and only in the sale of housing query results under the change
(2) "Home Sale button"
Default display of 5 unsold housing information after each housing message there is a sell button, and the "sell" button has the correct response only when the bank has housing information
Point Repair sell button to go to the "Housing Sale Registration" interface
Fill in the information and must be filled in each edit box to modify the information in the database
(3) "Housing recycling"
Display all sold housing information, corresponding to each housing a recall button
Click the Retract button to enter the Reclaim housing registration screen
Click the Recycle button to modify the corresponding data in the database
Above is the interface part of the program.
The following is the database section.
The database I'm using is MySQL
Set up a table name house has 11 properties
CREATE TABLE House (t_id char) primary Key,t_add char (no Null,t_area char) not Null,t_money char (TEN) not null,t_ Host char (T_sex), char (5), T_mem Char, T_date char (5), T_tel char (+), T_iden char (.), T_flags, char () not NULL);
From top to bottom: Housing number, housing address, housing area, housing price, name of head of household, gender of head of household, family member of household, home sale date, contact number of householder, head of household ID number, mark housing vacant
(due to insufficient consideration, I am all set to string form, the specification is my practice is wrong)
My train of thought is that housing exists, the housing owner is not necessarily exist, the existence of the housing has been sold, the housing owner does not exist, the housing is not sold, while using t_flags housing is vacant
So first insert the information of n housing in the database
Like what:
Insert into House (t_id,t_add,t_area,t_money,t_flags) VALUES (' 10010 ', ' Zibo Zhangdian District Chaoyang District 1th, Room 101 ', ' 100㎡ ', ' x ', ' Y ');
Insert n Such data, the default housing number, address, price, area, whether vacant are present.
When modifying housing information in the interface, modify the corresponding data
When the housing is sold, the corresponding data is modified
When the housing is recycled, the corresponding data is modified to ""
Code download
Note: con = drivermanager.getconnection ("Jdbc:mysql://localhost:3306/test", "root", "19931223") in the Dataconection class;
Test is the database name you used 19931223 is your password to enter MySQL
2015-1-18 End of Practice training