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 online game trading system
College (Department): School of Information Science and Technology major: student ID: student name: Admission year: mentor: Completion Date:
Summary
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. Product management information because of its management content The complexity and large number of management means that manual processing cannot meet the needs of the majority of users, so a corresponding online game trading system has emerged.
This online game trading system has two permissions: administrator and user. The administrator can manage the user’s basic information content, manage car information and car rental information, and can communicate with users and other operations. Users can view product management. Information, you can view news and view administrator reply messages and other operations.
This online game trading 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 online game trading system can solve many problems of traditional manual operations, such as long delays in data query and cumbersome data management steps. In general, the online game trading system has stable performance, comprehensive functions, and is very cost-effective when put into operation.
Keywords: online game trading 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 12
5.1 Implementation of administrator function module 12
5.1.1 Product management list 12
5.1.2 News information management 12
5.1.3 News type management 12
Chapter 6 System Test 14
6.1 Software testing 14
6.2 Test environment 14
6.3 Test Case 14
6.3.1 User login test 14
6.4.2 Add car category test 15
6.5 Test results 15
Conclusion 16
Reference 17
Thanks 18
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 online game trading system developed this time realizes functions such as shopping cart management, dictionary management, forum management, news information management, merchant management, product management, product collection management, product evaluation management, product order management, user management, administrator management, etc. . 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 security, allowing the online game trading 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 online game trading 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. Car rental stores have long overdue changes in their management operations of car rental information. 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 online game trading 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 more intuitively understand the functions of the online game trading system, 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 online game trading system 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 online game trading system uses the B/S structure model for program development. The program development uses SSM technology. The data information of the online game trading 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 online game trading system developed using the B/S structure can greatly facilitate the user’s operation. Users can access the online game trading system anytime and anywhere. They only need to have a computer that can connect to the network, and use B The online game trading system developed in the /S mode is based on the browser’s operation mode. It 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. When we use the online game trading system, the system will also be improved and upgraded according to user needs. There is no need to worry about the online game trading system 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. The picture below shows the B/S structure diagram.
Figure 2.2 B/S structure diagram
2.2 MySQL database
The backend database of the online game trading 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.
