The article only shows part of the content. For detailed thesis and demonstration videos, you can send a private message to my KouKou.
Undergraduate thesis (design)
Design and implementation of questionnaire survey system
College (Department): School of Information Science and Technology Major: Computer Science and Technology (Normal College) student ID: student name: Admission year: mentor: Completion Date:
Summary
Traditional information management mostly 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. Questionnaire information has complicated management content. , the large number of management results in manual processing that cannot meet the needs of the majority of users, so a corresponding questionnaire system came into being.
This questionnaire survey system has two permissions: administrator and user. The administrator can manage the basic information content of users, manage news information and rental information of news information, and can communicate with users. Users can view the questionnaire. Information, you can view news information and view administrator reply messages and other operations.
The questionnaire survey system 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. This questionnaire survey system can solve many problems of traditional manual operations, such as long delays in data query and cumbersome data management steps. In general, the questionnaire survey system has stable performance, relatively complete functions, and is very cost-effective when put into operation.
Keywords: Questionnaire survey system; MySQL database; SSM technology
Abstract
Most of the management of traditional car rental information relies on the manual registration and management of managers. However, with the rapid development of information technology in recent years, many old-fashioned information management models have been iterated and updated, and car rental information is because of its The management content is complicated, and the large number of managements leads to manual processing that cannot meet the needs of the majority of car rental users. Therefore, the corresponding car rental management system should be born.
The car rental management system is divided into two functions: the administrator and the user. The administrator can manage the basic information content of the user, can manage the car information and the rental information of the car, and can communicate with the user, etc ., and the user can view the car information. You can rent a car online, you can leave a message online, and view the administrator’s reply information.
The car rental management system adopts the most popular B/S three-layer structure mode in WEB application development, and uses a small but full-featured MySQL database for data storage operations. The system development technology uses JSP technology. can solve many traditional manual operation problems, such as long delays in data query and cumbersome data management steps. In general, the car rental management system has stable performance and full-featured functions.
Key Words：Car rental management system; MySQL database; SSM technology
Table of contents
Abstract I
Abstract II
Catalog III
Chapter 1 Project Background and Research Content 1
1.1 Topic background 1
1.2 Development purpose and significance 1
1.3 Thesis research content 1
Chapter 2 Related Technologies 3
2.1 B/S structure 3
2.2 MySQL database 3
Chapter 3 System Analysis 5
3.1 Feasibility analysis 5
3.1.1 Time feasibility 5
3.1.2 Economic feasibility 5
3.1.3 Operational feasibility 5
3.1.4 Technical feasibility 5
3.1.5 Legal feasibility 5
3.2 System process analysis 6
3.3 System functional requirements analysis 7
3.4 System non-functional requirements analysis 7
Chapter 4 System Design 9
4.1 Overall functionality 9
4.2 System module design 9
4.3 Database design 10
4.3.1 Database design 10
4.3.2 Database E-R Figure 10
4.3.3 Database table design 11
Chapter 5 System Implementation 13
5.1 Implementation of administrator function module 13
5.1.1 Questionnaire list 13
5.1.2 News information management 13
5.1.3 News information type management 14
Chapter 6 System Test 15
6.1 Software testing 15
6.2 Test environment 16
6.3 Test Case 16
6.3.1 User login test 16
6.4.2 Add news information category test 16
6.5 Test results 16
Conclusion 17
Reference 19
Thanks 20
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 questionnaire survey system developed this time implements functions such as questionnaires. 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. Moreover, the program also has all the functions required by the program, which greatly improves the operability and security, allowing the questionnaire system to move from concept to reality, and truly allowing 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 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 questionnaire survey system 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. News and Information Rental stores should have reformed their management of car rental information long ago. Using software to manage car rental information and save manpower and material costs is a new pioneering work in car rental information management.
1.3 Research content of the paper
The paper on the questionnaire survey system 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 development process of the system 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 understand the functions of the questionnaire survey system more intuitively, designs the background 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 questionnaire survey system to see whether the program can meet the user requirements and whether the program can be submitted for acceptance.
Chapter 2 Related Technologies
The questionnaire system developed this time uses the B/S structure model for program development, and the data information of the questionnaire system 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 questionnaire system developed using the B/S structure can greatly facilitate the user’s operation. Users can access the questionnaire system anytime and anywhere. They only need to have a computer that can connect to the network and use B/S. The questionnaire system developed by the model is based on the browser’s operation mode. It will be more attractive in terms of interaction with users and program performance. This model also reduces the difficulty for programmers to develop programs, and the program development cost will also be corresponding. A lot of reduction. When we use the questionnaire system, the system will also be improved and upgraded according to user needs. There is no need to worry about the questionnaire system developed using the B/S mode, because its upgrade speed is fast and the cost of the upgrade is very low. Most of them rely on users to download the latest version from the Internet to install and complete program updates. The picture below shows the B/S structure diagram.
Figure 2.2 B/S structure diagram
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 that needs to be developed and meets the data storage requirements required to run the program function. For example, if you need to develop a commercial-level program and the stored data has higher requirements on the database, you can choose Oracle. If It is 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 background database of the questionnaire survey system 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 it 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.
