Real estate website example (ASP. NET+SQL)
Source: Number of hits: 37
This paper is about:
Keywords: real estate information release ASP.NET SQL Server 2000
introduce
Design and Implementation of Real Estate Information Publishing Website
Chinese abstract of graduation project (thesis)
This design specification mainly introduces the research background, research status at home and abroad, development process and completed functions of this topic, focusing on the design idea of this topic and the detailed design process of each module. After testing, the developed system has the advantages of strong practicability, low cost and high efficiency, so that both real estate developers and consumers can obtain the real estate information they care about in time and quickly.
This system is a real estate information publishing system based on ASP.NET technology and SQL Server 2000 database management system. Starting from simple operation, friendly interface and practical functions, the whole system provides a broad and cheap platform for the release and management of real estate information, provides customers with convenient and comprehensive real estate information, and allows customers to quickly and conveniently know the houses with suitable conditions, locations and prices. This design and development mainly includes personal information management, information release (rental, leasing, second-hand real estate, latest real estate, transaction information reporting), housing management, information exchange, site search, policy news, user management and other functions, which basically meets the needs of real estate information release websites.
Today, with the rapid development of Internet, e-commerce represents a new trend. It provides an online trading platform, which facilitates the communication between enterprises and customers and improves work efficiency. In this process, the wide application of e-commerce has also penetrated into the real estate market, and the release of real estate information is an indispensable part of the whole real estate market.
Foreign language abstract of graduation design (thesis)
Design and Implementation of Housing Information Publishing Website
Abstract: Nowadays, with the rapid development of Internet, e-commerce is booming as a new trend. It provides an online trading platform for the communication between enterprises and customers, and improves work efficiency. In this process, the extensive use of e-commerce has penetrated into the real estate market, and real estate information and dissemination is an indispensable part of the whole real estate market.
The system uses ASP.NET technology and SQL Server 2000 database management system to build an e-commerce platform. The whole system is simple in operation, friendly in interface and practical in function, aiming at providing a broad and cheap platform for real estate information release and management, and providing customers with convenient and comprehensive housing rental information. Through this platform, customers can quickly and conveniently find houses with suitable conditions, location and price. The functions mainly include personal information management, information release, housing inquiry, housing management and information exchange, which can basically meet the rental demand.
This paper introduces the development background, design process and functional requirements of the system. In addition, this paper mainly expounds the design concept and detailed design process of each part. After testing, the system has the advantages of strong practicability and friendly interface. The transaction between consumers based on ASP.NET online auction system becomes simpler and more interesting.
Keywords: housing information release ASP.NET SQL Server 2000
catalogue
Keywords: real estate information release ASP.NET SQL Server 2000
1. 1 project background and research significance ... 1
1. 1. 1 project background ... 1
1. 1.2 Significance and purpose of the study ... 1
1.2 Feasibility analysis ... 2
1.2. 1 technical feasibility ... 2
1.2.2 Economic feasibility ...
1.2.3 legal feasibility ...
1.2.4 Operational feasibility ... 2
2 Demand analysis ... 3
2. 1 Analysis of system functional requirements ... 3
2. 1. 1 user function ... 3
2. 1.2 Administrator function ... IV
2.2 System Security Requirements Analysis ... IV
2.3 Business flow and data flow analysis ... IV
2.3. 1 Analysis on the process of publishing information by registered users of real estate information publishing website ... 5
2.3.2 Analysis of Background Management Process ... 5
Data flow analysis ... 6
Data dictionary ... 8
3 system design ... 16
3. 1 overall structural design of the system ... 16
3.2 System data structure design ... 17
3.2. 1 E-R diagram of the whole system: ... 17
3.2.2 E-R diagram of system entity: ... 17
3.2.3 Data logical structure design-relational model ... 20
3.2.4 Data logical structure design-relational table ... 2 1
3.3 Determination of system development and operation environment ... 25
3.3. 1 system development environment and development tools ... 25
3.3.2 Advantages of using ASP.NET as a system foreground development tool ...
3.3.3 Advantages of using SQL Server2000 as a database development tool ... 27
3.3.4 System Operating Environment ... 28
4 Design and Implementation of Real Estate Information Publishing Subsystem ...
4. 1 Introduction of real estate information publishing subsystem ... 29
4.2 Detailed design of real estate information publishing subsystem ... 29
4.2. 1 Functional Structure Diagram of Real Estate Information Publishing Subsystem ... 29
4.2.2 Flowchart of Real Estate Information Publishing Subsystem: ... 29
4.2.3 Detailed design of real estate information release ... 30
4.3 Difficulties and solutions of real estate information publishing subsystem ...
5. Background design and implementation of real estate information publishing system ...
5. 1 Functional Structure Diagram of Real Estate Information Publishing Subsystem ... 35
5.2 Detailed design of real estate information release ... 35
5.2. 1 Flowchart of Real Estate Information Backstage Management Subsystem ... 35
5.2.2 Detailed Design of Real Estate Information Backstage Management Subsystem ... 36
5.3 Difficulties and Solutions in Detailed Design of Real Estate Information Management ...
6. Detailed background design of in-station search subsystem ... 4 1
6. 1 Search children's functional structure diagram ... 4 1
6.2 Detailed design of in-station search subsystem ... 4 1
6.2. 1 Flowchart of in-station search subsystem ... 1
6.2.2 Detailed design of in-station search subsystem ... 4 1
6.3 Difficulties and Solutions in Station Search Subsystem ...
7 Design and Implementation of the Backstage of Forum Information Publishing System ...
7.2 Detailed Design of Forum Information Subsystem ...
7.2. 1 Flowchart of Forum Information Subsystem: ... 44
7.2.2 Forum information browsing management design ... 45
7.2.3 Management Design of Forum Information Reply ... 45
7.3 Difficulties and Solutions in the Design of Forum Management Subsystem ...
8 User Manual ... 49
8. 1 Brief introduction of system functions ... 49
8.2 Operating environment ... 49
8.3 Software Maintenance ... 50
9 system evaluation ... 5 1
9. 1 Introduction of system features/advantages ... 5 1
9.2 system defects and improvement scheme ... 5 1
9.3 Design experience and experience ... 5 1
Thank you ... 54
Reference 55
1 Introduction
1. 1 project background and research significance
1. 1. 1 project background
Due to the global and open characteristics of the Internet, international e-commerce has become a natural extension and an organic part of e-commerce from the very beginning. Theoretically, as long as an enterprise establishes its own website on the Internet, it will immediately become a multinational company. Because the network itself transcends national boundaries, more importantly, it eliminates the time and space obstacles in the real world, so that any network user in any country can conveniently visit its website and conduct online information inquiry, release and transaction with it. Therefore, it is a logical choice to adopt e-commerce in international trade. As a brand-new international trade transaction mode, international e-commerce has developed rapidly and become more and more important.
The wide application of e-commerce has also penetrated into the real estate market, and the release of real estate information is an indispensable part of the whole real estate market.
For example, 95% of housing transactions in the United States are conducted through MLS(multiple listing service), and MLS has developed into the largest industry organization in the United States. * * * Enjoy systematic information resources and conduct transactions quickly and effectively. MLS is a technical term derived from American real estate, also known as "multiple listing service". Its core is to make all the independent intermediaries' housing information joining the system form a unified intercommunication system through specific software technology and network means. Customers who want to rent or buy a house can find out all eligible houses by inputting the characteristics of the house they want to rent or buy on the computer terminal of the real estate agent or intermediary, and can check the actual location of the selected house through the online electronic map, and check whether the appearance, environment and indoor pattern of the real estate meet their preferences through the online live video. If the company's housing is not rich enough, customers can also find relevant housing in the database of all companies that join the system through MLS system. If the transaction can be concluded, the companies involved in the transaction will be divided into a certain proportion. In China and Shanghai, real estate e-commerce is also developing very fast, with an average annual growth rate of 47.72%.
However, the management level of real estate is still relatively backward, and many jobs are still using traditional industrial management, which is not conducive to the current and future development requirements. In order to improve this work, computer technology can be used to improve the housing transaction management and realize the modernization, electronization and informatization of the housing transaction management system. This topic is produced under this background.
1. 1.2 research significance and purpose
The significance and purpose of this study mainly include the following aspects.
(1) By studying the main modes and business processes of the real estate information publishing website, the design and implementation of the real estate information publishing website are completed by using the relevant theories and knowledge of website design;
(2) Through the design and implementation of the website, master the ASP.Net technology and the development technology of the database system under the Web environment;
(3) Through the research and development of the subject, master the general steps, methods and skills of MIS development, learn to write various document reports in each process of software development in a standardized way, and develop a good code writing style;
(4) Cultivate the ability to analyze and solve specific problems by comprehensively applying the knowledge and technology learned, develop a correct way of thinking and a scientific and rigorous style of study, and learn to develop and innovate.
Through the design and development of real estate information publishing website, I have further mastered the knowledge I have learned.
data flow analysis
Data flow analysis mainly includes the analysis of information flow, transmission, processing and storage. The purpose of data flow analysis is to find and solve problems in data circulation. Data flow diagram is a graphic technology, which describes the transformation of information flow and data from input to output. The specific method is: according to the business process sequence sorted out by the business flow chart, draw the data processing flow mastered in the corresponding investigation process into a complete data flow chart, and check the corresponding data, statements and models while drawing.
The data flow of real estate information publishing system is that system administrators can view and modify their personal information and publish real estate information after authentication. After authentication, users can view and modify personal information, query and publish real estate information. The system administrator can modify the administrator password, and manage the housing information, registered users and forum posts accordingly.
The specific system data flow chart of this system is shown in Figure 2-3:
Figure 2-3 Top Data Flow Diagram of Real Estate Information Publishing System
The main data flow chart of the system is shown in Figure 2-4.
Figure 2. -4 main data flow chart of real estate information publishing system
4.2 Detailed design of real estate information publishing subsystem
The real estate information publishing subsystem can be divided into publishing the latest real estate information, renting information, rent-seeking information, second-hand housing information and transaction declaration information. These functions will be designed in detail below.
4.2. 1 Functional Structure Diagram of Real Estate Information Publishing Subsystem
The functional structure design of the system is shown in Figure 4- 1:
Figure 4- 1 Functional Diagram of Real Estate Information Publishing Subsystem
4.2.2 Flow chart of real estate information publishing subsystem:
The flow chart of real estate information publishing subsystem is shown in Figure 4-2:
Figure 4-2 Flowchart of Real Estate Information Publishing Subsystem
4.2.3 Detailed design of real estate information release
After logging in, members can publish their own real estate information on the information publishing page, including new house information, second-hand house information, rental information, rent-seeking information and transaction declaration information. Can choose the nature of the house, the specific interface design as shown in figure 4-3:
Figure 4-3 Real Estate Information Publishing Interface
Many validation controls have been added to this page design. For example, users can choose the real estate information they want to publish according to their own needs. Users should fill in the required information when filling in the real estate release information, otherwise the user will fail to send it. After users publish information, they can find the published information in other corresponding places on this website. Some main codes for publishing information are as follows:
string strconn = configuration settings。 AppSettings[" DSN "]；
connection = new SqlConnection(strconn)；
String sql
If( rent_RBut。 Check)//Select the lease button.
{
sql="Insert into rent(hcounty，haddress，htype，hstructure，hfloor，harea，hrepair，price，tel，uname，qq，validate，
Remarks) value (""+DropDownList 1. SelectedItem+" ' '，' ' "+TextBox 1。 Text.Trim()+" ' '，' ' "+DropDownList2。 Select the edit item+"'',
“”+DropDownList3。 SelectedItem+“”，“”+TextBox2。 Text.Trim()+" ' '，' ' "+TextBox3。 Text.Trim()+" ' '，' ' "+
Drop-down list 4. SelectedItem+“”，“”+TextBox4。 Text.Trim()+" ' '，' ' "+TextBox6。 Text.Trim()+" ' '，' ' "+
Text box 7. Text.Trim()+" ' '，' ' "+TextBox8。 Text.Trim()+" ' '，' ' "+DropDownList5。 Select the edit item+"'',
' "+TextBox9。 text . Trim()+" ' ')"； //Insert the lease information to be published into the database.
SqlCommand cmd = new SqlCommand(SQL，connection)；
Contact. open()；
attempt
{
cmd=new SqlCommand(sql，connection)；
cmd。 ExecuteNonQuery()；
Response. Write ("< scripting language ='' javascript''> alarm ("Lease information published successfully ").
}
catch
{
Response. Write ("< scripting language ='' javascript''> alert ("Failed to publish lease information ").
}
finally
{
cmd。 dispose()；
Contact. close()；
}
}
4.3 Difficulties and solutions of real estate information publishing subsystem
Question 1: How to verify that the text content is not empty?
Solution: Use the verification control RequriedFiledValidator generated by Visual Studio to verify that the text content is not empty.
Question 2: According to the nature of the publishing attribute selected by the user, insert it into the corresponding database.
Solution: Use the Check events in the same group of RadioButton to judge the nature of the attribute to be published by the user, and then write it into the corresponding database.
5 Design and Implementation of the Background of Real Estate Information Publishing System
This module mainly refers to the information management, user management, post management and housing information management after the system administrator logs in this website. The main thing is the management of housing information, which mainly refers to the addition, deletion and update of housing, the addition, deletion and update of housing type, structure and area, and the query, deletion and management of real estate (latest real estate, rental, second-hand real estate and transaction report) information. Binding attribute information table with DataGrid control. Then, the administrator can delete and update the house.
5. 1 Functional Structure Diagram of Real Estate Information Publishing Subsystem
The structural design of the system management function is shown in Figure 5- 1.
Figure 5- 1 System Background Management Interface
5.2 Detailed design of real estate information release
5.2. 1 Flowchart of Real Estate Information Backstage Management Subsystem
The system flow chart design is shown in Figure 5-2:
Figure 5-2 Real Estate Information Release Background Management Flowchart
5.2.2 Detailed design of real estate information background management subsystem
The system administrator will directly enter the management interface after logging in to this website. Interface design as shown in figure 5-3:
Figure 5-3 System Interface
System administrators can modify their passwords here, and the interface design is shown in Figure 5-4:
Figure 5-4 Modify System Administrator Password Interface
When the system administrator thinks it is necessary to add more binding information in the building structure, building type and building area, or wants to delete the binding information, the administrator can do it here. Modify and delete huxing interface design as shown in figure 5-5:
Figure 5-5 Modify and Delete House Type Interface.
In the housing information management, you can edit and delete the bound housing structure, and the interface design for editing and deleting the housing structure is shown in Figure 5-6:
Figure 5-6 Delete House Structure Interface
Housing information management mainly refers to the deletion management of real estate information sent by users of this website. System administrators can view the site's real estate information here, and can delete and manage it. The shell interface design is shown in Figure 5-7:
Figure 5-7 Source Management Interface
User management mainly refers to the management of registered users of this site, including browsing, querying and deleting users. interface design
As shown in figure 5-8:
Figure 5-8 User Query Interface
Figure 5-9 Browse Delete User Interface
Example of real estate website