Youth apartment service platform source code database based on springboot

Most of the traditional information management relies on manual registration and management by managers. However, with the rapid development of information technology in recent years, many old-fashioned information management models have been updated and iterated. Because of the complicated management content of housing information, , the large number of managements means that manual processing cannot meet the needs of the majority of users, so the corresponding youth apartment service platform came into being.

This youth apartment service platform has two permissions: administrator and user. The administrator can manage the basic information content of users, manage housing complaint information and rental information of housing complaints, and can communicate with users and other operations. Users can view For housing information, you can view housing complaints and view the administrator's reply information, etc.

The youth apartment service platform adopts the most popular B/S three-tier structure model in WEB application development. It uses a MySQL database that takes up little space but has complete functions for data storage operations. The system development technology uses JSP technology. The youth apartment service platform can solve many traditional manual operation problems, such as long delays in data query and cumbersome data management steps. In general, the youth apartment service platform has stable performance, comprehensive functions, and is very cost-effective when put into operation.

Chapter 1 Project Background and Research Content

1.1 Background of the topic

Information data has been undergoing changes from tradition to contemporary times. The sudden emergence of the Internet has given traditional information management a revolutionary dawn, because traditional information management has failed in terms of timeliness, security, and operability. Only when we encountered the Internet era did we realize that we could make up for the shortcomings from ancient times and effectively improve management efficiency and business level. In the traditional management model, the longer the time, the more content is managed, and more people are needed to organize the data. Moreover, the efficiency of data summary query is also extremely low, and data security can never be guaranteed. Combined with the various shortcomings of data content management, it can be effectively supplemented in the Internet era. Combined with advanced Internet technology, we develop software that meets the needs, so that data content management can achieve the highest accuracy in terms of timeliness of entry, timeliness of viewing, and timeliness of summary analysis, making management more scientific and convenient. The youth apartment service platform developed this time realizes blog management, blog collection management, blog message management, dictionary management, house management, house collection management, house message management, appointment viewing management, house complaint management, user management, merchant management, Administrator management and other functions. The system uses MySql, the king of relational databases, as the database of the system, which effectively securely stores data, provides effective backup, and ensures data reliability. And the program also has all the functions required by the program, which greatly improves the operability and safety, allowing the youth apartment service platform to move from concept to reality, and truly allows people to improve information processing efficiency.

1.2 Development purpose and significance

The arrival of the moderately prosperous era has led to an increase in people's satisfaction, and many changes have taken place in all aspects of life. For example, offices have corresponding software, and many jobs require employees to be able to operate computers. It can be said that the current era is basically covered by software. Software The characteristic of the industry is that everyone is using software to replace traditional manual recording operations. The emergence of software has opened a new chapter in our lives and work. The Youth Apartment Service Platform is a platform that uses software to manage vehicle rental information. Administrators no longer need to use paper to record information and query management operations when managing car rental information. All operations are performed using computers. Users need to use passwords and usernames to log in to the system, and display each function according to the system homepage interface. Performing related operations, whether adding or deleting, editing or modifying queries, etc., does not take much time and can be done in just a few minutes. Moreover, the software does not limit the office location and office hours. As long as there is an operational need, you can log in to the system anytime and anywhere to complete the task. Improving office efficiency is no longer a problem. Housing complaints The rental store’s management and operation of car rental information should have been reformed long ago. Using software to manage car rental information and save manpower and material costs is a new innovation in car rental information management.

1.3 Research content of the paper

The paper on the youth apartment service platform developed this time is written from the following parts:

Chapter 1: This chapter introduces the background and purpose of program development, lists the content information of thesis writing, and lets us know how the thesis writing progresses.

Chapter 2: This chapter mainly explains the relevant technical knowledge used in system development, such as SSM technology, MySQL database knowledge, etc. Help people better understand the relevant knowledge of system technology.

Chapter 3: Chapter 3 of the article mainly introduces the feasibility of system development. It gives a general introduction from the aspects of economy, time, operation, etc. to confirm that system development is indeed feasible. Then it analyzes the system development process and determines what the system needs to have. The approximate functions ensure that the system can be used and operated stably.

Chapter 4: This chapter mainly draws the functional architecture of the system, allowing us to more intuitively understand the functions of the youth apartment service platform, designs the backend database table, and draws the corresponding ER diagram.

Chapter 5: This chapter mainly introduces the interface effects of the specific functions of each part of the system. Let us know the functional details of each part.

Chapter 6: This part is mainly to conduct an overall test of the youth apartment service platform to see whether the program can meet the user requirements and whether the program can be submitted for acceptance.

Chapter 2 Related Technologies

This development of the youth apartment service platform uses the B/S structure model for program development. The data information of the youth apartment service platform is stored in the MySQL database.

2.1 B/S structure

The B/S structure is actually the abbreviation of Browser/Server. The B/S structure is the mainstream structure in current software development. Most software developers adopt a three-tier architecture such as B/S. The youth apartment service platform developed using the B/S structure can greatly facilitate users to use and operate. Users can access the youth apartment service platform anytime and anywhere. They only need to have a computer that can connect to the network, and use B The youth apartment service platform developed in /S mode is based on browser operation, which will be more attractive in terms of interaction with users and program performance. This mode also reduces the difficulty for programmers to develop programs and reduces program development costs. It will also be reduced accordingly. While we are using the youth apartment service platform, the system will also be improved and upgraded according to user needs. There is no need to worry about the youth apartment service platform developed using the B/S model, because its upgrade speed is fast and the cost of the upgrade is very small. Low, most of them rely on users to download the latest version from the Internet to install and complete program updates.

2.2 MySQL database

The developed program only faces users with the functional interface of the program, allowing users to operate various functions of the program interface. Then many people will ask, where is the data information generated by the user using the program functions? This requires knowledge of databases. Generally speaking, program development usually analyzes and compares the characteristics of commonly used data storage tools, such as the characteristics and advantages of Mysql database, the characteristics and advantages of Access database, and the characteristics of Sqlserver database. In the end, it depends on which database matches the program to be developed and meets the data storage requirements for running the program functions. For example, if you need to develop a commercial-level program and the stored data has higher database requirements, you can choose Oracle. It is just a relatively simple program that does not have too many requirements for data storage. You can choose Microsoft's Access. When developing a program that requires the database to occupy a small space and meet the program data storage requirements, you can consider Oracle from the Swedish MySQL AB company. I acquired a relational database a long time ago, which is now the Mysql database. Therefore, the backend database of the youth apartment service platform uses MySQL for database development. MySQL is a platform software developed by Microsoft. This software can provide users with efficient intelligent data, and the data information is still very reliable. Use Its data storage can meet the needs of mass enterprises to manage various data information. MySQL is the most comprehensive and powerful development platform among the MySQL versions. MySQL has improved operations in many key areas. It has also added many new features. These improvements and updates allow companies to develop critical applications. The program runs efficiently and also allows companies to reduce the cost of sending information to users and reducing the infrastructure for data information management. Therefore, MySQL has a very high status in companies and enterprises. ERP, OA systems, and corporate financial systems are all inseparable from MySQL. Today, when software development is very popular, MySQL is also used as a website for website development. Backend database, it can be said that the company's use of MySQL for data management not only saves costs, but also greatly improves the management efficiency of the company's data information. The company's data is stored on the MySQL platform, and there is no need to worry about the security of the data information, because MySQL can provide the database with The logs, data files and the entire database are encrypted. In addition, MySQL also provides an online backup function, which can save storage space and speed up data backup. In short, it is very advantageous to choose MySQL for back-end database development of online systems. This is a good software choice.

Chapter 3 System Analysis

3.1 Feasibility analysis

Feasibility analysis investigates and studies from the aspects of time, economy, operation and technology to ensure the rational use of information resources, avoid the trouble caused by insufficient consideration in the process of program design, and help us design programs better.

3.1.1 Time feasibility

For this system development, I have set aside two months to complete it. From the system requirements analysis, functional structure design, functional detailed design and system testing, it takes two months to complete the program development operation. I plan to I write programs every morning, noon and evening. During this period, I also check various materials and information. With the help and guidance of my classmates and teachers, I believe that the time for program development will be shortened a lot. So it is feasible in time.

3.1.2 Economic feasibility

The development platform of the youth apartment service platform is IDEA, the database is MySQL database, and the browsers used are all popular browsers. These software can be downloaded and installed without charging. In terms of hardware selection for system development, I use my own laptop for development operations. Therefore, no additional financial expenditure is required when developing the system. The developed program can improve office efficiency and bring relatively high economic benefits. The input-output ratio of system development is very impressive.

3.1.3 Operational feasibility

The interface design of the youth apartment service platform is relatively simple. The interface layout is designed according to the daily usage habits of users. Various functions of the website are clearly visible in the navigation bar. The data operations of the website are visualized. Users do not need training to operate the website to get started. They only need to follow the website. Just follow the function prompts.

3.1.4 Technical feasibility

As a computer science student, I learned a lot about programming knowledge in school, such as SSM technology and MySQL database knowledge. I am also relatively proficient in the operation of the IDEA development platform and MySQL database, so I still have a certain grasp of the technology. .

3.1.5 Legal Feasibility

The software I developed myself and the sources of information used are from libraries, Baidu Library and Baidu web pages, and do not involve any illegal activities. In personal graduation projects, there is no plagiarism in either source code or thesis writing content.

From the above analysis of economy, operation and time, we can conclude that the youth apartment service platform developed this time can be developed. The development of the system can create greater economic benefits. The earlier it is developed, the more room for appreciation it will have. big.

3.2 System process analysis

The development of the youth apartment service platform also has a corresponding process. Before development, user functional requirements must be analyzed, and finally the website design and database-related data design work should be carried out according to the functional requirements.

After the system development is completed, the user will be provided with a login entrance. The information entered by the user on this interface will be verified. Only after passing the verification can the user enter the main interface of the youth apartment service platform.

3.3 System functional requirements analysis

System development is inseparable from early demand analysis. This stage is to let programmers know what they should do. When conducting demand analysis, the focus is on the user's functional requirements for the system. If the analysis at this stage is in place, the system When developed and put into use, users will find that the system's functions are consistent with user needs, and program stability is up to standard. It can be said that demand analysis is the key to determining the success or failure of system development. It mainly abstracts the real world and then Abstract objects are used to build models.

The main beneficiaries of the youth apartment service platform are staff. The website can facilitate users to search and manage data information. The interface display we designed for the website developed this time is mainly divided into administrator interface and user interface. The specific interface The functions are distributed as follows.

The youth apartment service platform administrator can manage users' basic information, can manage housing complaint information, can manage housing complaint information, etc.

3.4 System non-functional requirements analysis

(1) Integrity requirements

The data information recorded in the youth apartment service platform developed this time cannot be left empty, and the data information must be verified correctly. The connections between the data in the system cannot be wrong and cannot be ignored. The same data in the data table is in different places. The display content in the data table must be the same.

(2) Performance requirements

When users operate various parts of the youth apartment service platform, the response time of the pop-up page should not be too long. It is best to control it within three seconds. The maximum limit is four seconds. This is to give users a good program experience. And the system must be able to carry multiple people online to access the youth apartment service platform at the same time.

(3) Interface requirements

The interface design of the youth apartment service platform should take into account the daily operating habits of users. For example, the design of the navigation bar cannot be on the right side. This completely violates the user's operating habits of using the website. At the same time, the font and color of the functional navigation should be more conspicuous so that users can easily find it. , to prevent users from wasting too much time on functional operations.

(4) Security requirements

The security of the youth apartment service platform must be guaranteed and give users a sense of reliability and trust. The system cannot always make mistakes during operation. When interacting with users on the functional interface, feedback information must be given in a timely manner. In addition, the system It is necessary to set up a login window so that users who are not the system cannot access the system function interface. System users must also fill in the username and password before they can enter the main interface of the system. This ensures that system data information is in a safe state.

Chapter 4 System Design

4.1 Overall functionality

The youth apartment service platform is customized and developed according to needs. The development software uses the IDEA platform and the MySQL database to build the development environment. The website is developed using the most popular B/S structure in WEB applications. Users only need to access system data on the client Install Google Chrome or a commonly used browser to access website content.

4.2 System module design

When the youth apartment service platform system divides the functional modules in the system, it uses a hierarchical diagram to represent it. The hierarchical diagram has a tree structure and can use rectangular boxes to depict data information. The data structure represented by the top layer is very complete. The data represented by the rectangular box below the top layer is the subset data. Of course, the rectangular box at the bottom is the data element that cannot be subdivided. Using a hierarchical box diagram to describe the system functions allows users to understand at a glance. You can understand the functions of the system and the sub-functions under the corresponding function sections. The youth apartment service platform is divided into two operating roles: administrators and users. Their functions will be explained below.

4.3 Database Design

Developing a system also requires designing the database in advance. The database here is a collection of related data, and the data stored together is also organized in a certain way. At present, the database can serve a variety of applications because it has the best storage method and the advantage of low data redundancy rate. Although the database provides information storage services for the program, it can also maintain a high degree of independence from the program. All in all, the database has experienced a long period of development, from being unknown at the beginning to being well-known now. Its related technologies have become more mature and it also has a solid theoretical foundation.

4.3.1 Database Concept Design

This part of the content needs to be completed with the help of database relationship diagrams, and also requires the use of tools specifically designed to draw database relationship diagrams. For example, Visio tools can design ER diagrams (database relationship diagrams). Designing a database also needs to follow the design process. First, the entities must be determined according to the requirements, the characteristics of the entities must be analyzed, and the relationships between entities must be determined. Finally, the ER model representation method is used to draw the ER diagram of the system. Regardless of whether you use Edraw software or Visio tools, the representation symbols for ER models are the same. Usually rectangles represent entities, the relationships between entities are represented by diamond symbols, and the attributes of entities, that is, the characteristics of entities, are represented by symbolic ellipses. Finally use straight lines to connect symbols such as rectangles, rhombuses and ovals.

4.3.3 Database table design

The data tables in the database store various data records. When we perform system addition, deletion, modification and query operations, we are actually performing addition, deletion, modification and query operations in the corresponding data table. A good database can shorten the information processing time, so database The design work should not be underestimated. Which tables should be set up in the database, the field design in the tables, field types and field lengths and other information must be carefully considered. For example, the data type of the time field cannot be int type, otherwise in the During system operation, an error message indicating that the input data format does not meet the requirements will pop up. The following is a brief introduction to some data tables of the youth apartment service platform.

Table 4.1 Blog table

serial number

List

type of data

illustrate

Allow empty

1

ID

Int

ID

no

2

yonghu_id

Integer

user

yes

3

boke_name

String

Blog name

yes

4

boke_uuid_number

String

Blog number

yes

5

boke_photo

String

Blog photos

yes

6

boke_types

Integer

Blog type

yes

7

boke_clicknum

Integer

Blog popularity

yes

8

boke_content

String

Blog content

yes

9

shangxia_types

Integer

Is it on the shelves?

yes

10

boke_delete

Integer

Tombstone

yes

11

create_time

Date

creation time

yes

Table 4.2 Blog collection table

serial number

List

type of data

illustrate

Allow empty

1

ID

Int

ID

no

2

boke_id

Integer

blog

yes

3

yonghu_id

Integer

user

yes

4

boke_collection_types

Integer

type

yes

5

insert_time

Date

Collection time

yes

6

create_time

Date

creation time

yes

Table 4.3 Blog message form

serial number

List

type of data

illustrate

Allow empty

1

ID

Int

ID

no

2

boke_id

Integer

blog

yes

3

yonghu_id

Integer

user

yes

4

boke_liuyan_text

String

Message content

yes

5

insert_time

Date

Message Time

yes

6

reply_text

String

Reply content

yes

7

update_time

Date

Response Time

yes

8

create_time

Date

creation time

yes

Table 4.4 Dictionary table

serial number

List

type of data

illustrate

Allow empty

1

ID

Int

ID

no

2

dic_code

String

Field

yes

3

dic_name

String

Field name

yes

4

code_index

Integer

coding

yes

5

index_name

String

encoding name

yes

6

super_id

Integer

Parent field id

yes

7

beizhu

String

Remark

yes

8

create_time

Date

creation time

yes

Table 4.5 House table

serial number

List

type of data

illustrate

Allow empty

1

ID

Int

ID

no

2

shangjia_id

Integer

Merchant

yes

3

fangwu_name

String

House name

yes

4

fangwu_uuid_number

String

Number of the house

yes

5

fangwu_photo

String

house photos

yes

6

fangwu_xiaoqu

String

Community

yes

7

fangwu_address

String

Address

yes

8

fangwu_types

Integer

Property Type

yes

9

fangwu_chaoxiang_types

Integer

house orientation

yes

10

fangwu_pingmi

String

square meters

yes

11

fangwu_old_money

BigDecimal

Original price of house

yes

12

fangwu_new_money

BigDecimal

House current price/month

yes

13

fangwu_clicknum

Integer

house popularity

yes

14

fangwu_content

String

House details

yes

15

shangxia_types

Integer

Is it on the shelves?

yes

16

fangwu_delete

Integer

Tombstone

yes

17

create_time

Date

creation time

yes

Table 4.6 House collection table

serial number

List

type of data

illustrate

Allow empty

1

ID

Int

ID

no

2

fangwu_id

Integer

houses

yes

3

yonghu_id

Integer

user

yes

4

fangwu_collection_types

Integer

type

yes

5

insert_time

Date

Collection time

yes

6

create_time

Date

creation time

yes

Table 4.7 House message form

serial number

List

type of data

illustrate

Allow empty

1

ID

Int

ID

no

2

fangwu_id

Integer

houses

yes

3

yonghu_id

Integer

user

yes

4

fangwu_liuyan_text

String

Message content

yes

5

insert_time

Date

Message Time

yes

6

reply_text

String

Reply content

yes

7

update_time

Date

Response Time

yes

8

create_time

Date

creation time

yes

Table 4.8 Appointment to view the house

serial number

List

type of data

illustrate

Allow empty

1

ID

Int

ID

no

2

fangwu_order_uuid_number

String

Viewing number

yes

3

fangwu_id

Integer

houses

yes

4

yonghu_id

Integer

user

yes

5

insert_time

Date

application time

yes

6

yuyue_time

Date

Apply for viewing time

yes

7

fangwu_order_yesno_types

Integer

Appointment status

yes

8

fangwu_order_yesno_text

String

Audit opinion

yes

9

fangwu_order_shenhe_time

Date

review time

yes

10

create_time

Date

creation time

yes

Table 4.9 Housing Complaint Form

serial number

List

type of data

illustrate

Allow empty

1

ID

Int

ID

no

2

fangwu_id

Integer

houses

yes

3

yonghu_id

Integer

user

yes

4

fangwu_tousu_uuid_number

String

Housing Complaint Number

yes

5

fangwu_tousu_name

String

Complaint title

yes

6

fangwu_tousu_types

Integer

Complaint type

yes

7

fangwu_tousu_content

String

Complaint details

yes

8

insert_time

Date

Complaint time

yes

9

fangwu_tousu_chuli_types

Integer

Whether to process

yes

10

fangwu_tousu_chuli_content

String

process result

yes

11

fangwu_tousu_delete

Integer

Tombstone

yes

12

create_time

Date

creation time

yes

Table 4.10 User table

serial number

List

type of data

illustrate

Allow empty

1

ID

Int

ID

no

2

yonghu_name

String

username

yes

3

yonghu_phone

String

User mobile phone number

yes

4

yonghu_id_number

String

User ID number

yes

5

yonghu_photo

String

profile picture

yes

6

yonghu_shiyong_types

Integer

Account Status

yes

7

yonghu_email

String

E-mail

yes

8

create_time

Date

creation time

yes

Table 4.11 Merchant table

serial number

List

type of data

illustrate

Allow empty

1

ID

Int

ID

no

2

shangjia_name

String

the shop's name

yes

3

shangjia_phone

String

Contact information

yes

4

shangjia_email

String

Mail

yes

5

shangjia_photo

String

Business photos

yes

6

shangjia_xingji_types

Integer

Merchant Credit Type

yes

7

shangjia_shiyong_types

Integer

Account Status

yes

8

shangjia_content

String

Business profile

yes

9

shangjia_delete

Integer

Tombstone

yes

10

create_time

Date

creation time

yes

Table 4.12 Administrator table

serial number

List

type of data

illustrate

Allow empty

1

ID

Int

ID

no

2

username

String

username

yes

3

password

String

password

yes

4

role

String

Role

yes

5

addtime

Date

Add time

yes