Technology Sharing

Table of contents

Chapter 1Introduction

1.1Background

1.2Research status

1.3Paper Structure

chapter 2System Requirements Analysis

2.1System feasibility analysis

2.1.1Technical feasibility analysis

2.1.2Economic feasibility analysis

2.1.3Legal feasibility analysis

2.1.4Operational feasibility analysis

2.2System functional requirements analysis

2.3Systematic needs analysis

2.4System Use Case Analysis

2.5System process analysis

2.5.1Add data flow

2.5.2Modify data flow

2.5.3Deleting data process

Chapter 3Overall system design

3.1System functional module design

3.2Database Design

3.2.1Database conceptual structure design

3.2.2Database table design

Chapter 4Design and implementation of key modules

4.1Login Module

4.2Register Module

4.3Password modification module

4.4Navigation map module

4.5Popular attractions management module

4.6Attraction ticket purchase management module

4.7Hotel recommendation management module

4.8Hotel Reservation Management Module

Chapter 5System experiment and result analysis

5.1Test Methods

5.2System test cases

5.3System test results

Chapter 6in conclusion

references

Acknowledgements

SpringBoot Tourism Navigation System

Summary

With the rapid development of the Internet, more and more people choose to obtain travel information and plan their trips online. China, as a country with rich natural scenery and long history and culture, attracts a large number of tourists every year. The goal of this website is to provide tourists with accurate and comprehensive travel information, as well as convenient navigation and route planning services. By integrating various tourism resources, including introductions to scenic spots, food types, accommodation information, etc., users can obtain the relevant information they need on the website.

This project uses the Spring Boot framework as the backend development tool, which is simple and efficient and can quickly build reliable Web applications. Java is used as the main programming language to ensure the stability and scalability of the system. MySQL is used as the backend database to store and manage important data such as user information, travel data, and user feedback. By using MySQL, efficient storage and retrieval of data can be achieved, providing users with a good user experience.

This study aims to design and develop a tourism navigation system background and significance. By developing this website, we aim to provide tourists with convenient tourism information services and improve tourists' travel experience. At the same time, this project also helps to promote the development of tourism and provide reference and reference for the development of tourism navigation systems in other regions.

Key words：Tourism navigation system; JAVA language; SpringBoot framework; MYSQL database

SpringBoot Tourist Navigation System

Abstract

With the rapid development of the Internet, more and more people choose to obtain travel information and plan their trips through the Internet. As a country with rich natural scenery and a long history and culture, China attracts the attention of a large number of tourists every year. The goal of this website is to provide visitors with accurate and comprehensive travel information, as well as to provide convenient navigation and route planning services. By integrating various tourism resources, including attraction introduction, food type, accommodation information, etc., users can obtain the relevant information they need on the website.

This project uses the Spring Boot framework as a back-end development tool, which is simple and efficient, and can quickly build reliable web applications. The use of Java as the main programming language ensures the stability and scalability of the system. MySQL is used as a back-end database to store and manage important data such as user information, travel data, and user feedback. By using MySQL, you can efficiently store and retrieve data and provide users with a good user experience.

The purpose of this study is to design and develop a tourist navigation system for the background and significance. By developing this website, we aim to provide visitors with a convenient tourist information service and improve their travel experience. At the same time, this project will also help to promote the development of tourism and provide reference for the development of tourism navigation systems in other regions.

Keywords: travel navigation system, JAVA language, SpringBoot framework, MYSQL database

• Chapter 1Introduction
  1. Background

In the past few decades, with the booming development of the global tourism industry, people's demand for travel experience has also increased. The research background of tourism navigation system can be traced back to people's urgent need for more convenient and efficient travel methods. Traditional travel methods often rely on maps, guidebooks or verbal guidance, but these methods have many limitations, such as untimely information updates, easy to get lost, language communication barriers, etc.

With the continuous development of science and technology, people began to explore how to use computer and Internet technology to improve the travel navigation experience. This demand has promoted the research and development of tourism navigation systems. Early tourism navigation systems were mainly based on GPS technology. They can determine the user's location through satellite positioning and provide route planning and navigation guidance. This system greatly simplifies people's travel process, allowing them to find their destination more easily and save time and energy. However, traditional GPS navigation systems still have some problems, such as the inability to provide real-time traffic information and lack of personalized recommendations. In order to solve these problems, researchers began to introduce artificial intelligence technology into tourism navigation systems. By analyzing big data and using machine learning algorithms, the new generation of tourism navigation systems can more accurately predict traffic conditions, recommend personalized travel routes, and provide real-time surrounding service information.

In addition, with the popularization of mobile Internet, smartphones have become an important tool for people to travel, which also provides new opportunities for the development of tourism navigation systems. Modern tourism navigation apps can not only provide navigation services on mobile phones, but also combine AR (augmented reality) technology to present users with a more intuitive and vivid navigation experience. For example, users can view the surrounding street scenes through the mobile phone camera, and the best route will be displayed on the screen, which greatly improves the convenience and practicality of navigation.

In addition to individual travelers, travel navigation systems also play an important role in the development of the tourism industry. Tourism companies can use these systems to improve service quality and attract more customers. For example, some tourist attractions can provide voice interpretation services through navigation systems to bring tourists a richer visiting experience; travel agencies can use the system to analyze user preferences, recommend more suitable travel routes, and improve customer satisfaction and loyalty.

1. 1. Research status

domestic,The research and application of tourism navigation systems have received a certain amount of attention and development. Many studies are devoted to integrating and displaying tourism-related information, including scenic spot introductions, transportation guides, hotel reservations, etc. These studies provide detailed tourism information by developing websites or applications to help users understand the characteristics of the destination and various services. In order to provide convenient navigation services, some studies focus on the development of tourism navigation and route planning algorithms. These algorithms are based on geographic location data and traffic information and can provide users with the best travel routes and transportation methods. In order to improve user experience, some studies focus on user interface design and the development of personalized recommendation systems. By analyzing user interests and preferences, these systems can provide users with personalized travel recommendations and customized services. With the development of Internet technology, data security and privacy protection have become important issues in the research of tourism navigation systems. Some studies are committed to developing secure data transmission and storage mechanisms to protect the security of user personal information. In order to improve the quality and service level of tourism navigation systems, some studies focus on the collection and analysis of user evaluations and feedback. By analyzing user evaluations and opinions, problems can be discovered and improved in a timely manner to provide better user experience and services.

Tourism navigation systems are relatively mature in foreign countries. Foreign research focuses on developing intelligent navigation and recommendation systems, which provide personalized tourism recommendations and navigation services to users based on their interests and preferences by using machine learning and artificial intelligence technologies. Due to the popularity of mobile devices, foreign research focuses on developing cross-platform applications and using mobile technology to provide tourism navigation services. These studies are committed to providing convenient mobile applications that support functions such as real-time navigation, attraction recommendations, and interactive maps. Foreign research incorporates social media and user-generated content into the research scope of tourism navigation systems. By integrating social media data and user comments, researchers can provide users with more comprehensive tourism information and real user experience feedback. With the development of virtual reality (VR) and augmented reality (AR) technologies, some foreign research is committed to applying them to the field of tourism navigation. By using VR and AR technologies, users can experience attractions and navigation services in a more intuitive and immersive way. Foreign research pays great attention to sustainable tourism and environmental protection. Some studies are committed to providing sustainable tourism recommendations and environmentally friendly travel route planning to promote sustainable development and protect the natural environment.

In general, foreign tourism navigation system research covers intelligent navigation and recommendation systems, cross-platform applications and mobile technologies, social media and user-generated content, virtual reality and augmented reality technologies, and sustainable tourism and environmental protection. These research results provide tourists with more convenient, personalized and immersive navigation and tourism experiences. This study will draw on foreign research results and combine regional characteristics to develop a comprehensive, accurate and user-friendly tourism navigation system to meet tourists' needs for tourism information and services.

1. 1. Paper Structure

The paper will be organized in layers. Apart from the abstract, acknowledgments and references, the main body will analyze the system requirements, explain the general design and implemented functions, and finally list some debugging records. The main structure of the paper is as follows:

Chapter 1 explains the background of the project, the current status of developing the system, and the chapter arrangement of the paper.

Chapter 2 analyzes the specific requirements of the system.

Chapter 3 describes the design of the system, which covers functional design as well as database design.

Chapter 4 explains the implementation of each functional module of the tourism navigation system and presents it in the form of pictures and texts.

Chapter 5 lists some records of system debugging and testing.

Chapter 6 introduces the conclusion of the tourism navigation system.

• Chapter 2System Requirements Analysis

Requirements analysis is the first thing to do before developing a system. If a system is not worth developing or violates relevant laws and regulations, then the developed system will be worthless. Therefore, before development, we must first analyze the system requirements and whether the system development is feasible. If feasible, we will then specifically analyze the user needs, analyze the system functions, and analyze the system performance.

1. 1. System feasibility analysis
      1. Technical feasibility analysis

The technical feasibility mainly considers whether the development language, database, etc. used when developing the tourism navigation system are feasible. This system chooses JAVA as the language, and adopts the SpringBoot framework and MYSQL database. These technologies are currently very mature, and the JAVA language not only supports process-oriented, but also object-oriented, so it will be more flexible when used, and there is no problem in the choice of technology.

1. 1. 1. Economic feasibility analysis

The economic feasibility mainly considers the cost and benefit. From the cost perspective, JAVA, SpringBoot, MYSQL, etc. used in the development process can be downloaded through online search without any charge, and the development cost is almost non-existent; from the benefit perspective, the completion of the system can provide support to users, reduce enterprise costs, and improve management efficiency, so there is no problem economically.

1. 1. System functional requirements analysis

The tourism navigation system provides ordinary users with comprehensive tourism information query, scenic spot ticket purchase and hotel reservation functions, while administrators can easily manage the various contents and functions of the website. Such functional settings will provide users with convenient tourism services and build a comprehensive and efficient online platform for the tourism industry.

1. 1. 1. Legal feasibility analysis

The main legal consideration is whether the development of the system is illegal. The tourism navigation system developed is strictly in accordance with the "Computer Software Protection Regulations of the People's Republic of China", "Copyright Law of the People's Republic of China" and other laws and regulations. The development of the system can bring benefits to the enterprise and there is no illegal behavior. Therefore, it is legally feasible.

1. 1. 1. Operational feasibility analysis

The main considerations in terms of operation are whether it is simple and feasible for users to use and managers to manage, and whether users without any computer knowledge can use it. The developed tourism navigation system is designed with the concept of being simple and easy to learn. After the user enters the system, there will be fixed navigation buttons, and the operation can be completed as long as the user recognizes the words. The administrator only needs to simply add, delete, modify and check to complete it, so it is also feasible in operation.

In general, the developed tourism navigation system has no problem in terms of feasibility and is worthy of development, and the other completions are of great significance to the development of the industry.

The main functions of ordinary users are as follows:

1. Register and log in: Users need to log in with their registered account and password to enter the homepage.
2. Website Announcement: Users can view information about our website announcement, contact information, etc.
3. Help Feedback: Users can leave messages to express their need for help.
4. Route planning: Users can view route name, attractions passed, travel cost, travel days, etc., view the map, and can like, collect, comment, etc.
5. Attraction information: Users can view the attraction information list and check the latest introduction to tourist attractions, including attraction introduction, transportation guide, business hours, attraction introduction, attraction ratings, etc. They can also like, collect and comment on the attractions they are interested in and the reverse trip.
6. Food information: Display recommended food information, including food name, type, characteristics, picture display, etc. Users can choose to like, collect, comment, etc.
7. Accommodation information: Users can view the accommodation information list and check the accommodation information details, including folk name, star rate, contact number, address and other information. They can also like, collect and comment.
8. Travel information: Users can view detailed travel information about each place, and can like, collect, and comment on the attractions they are interested in.
9. Personal Center: Users can manage their personal information, including avatar, nickname, contact information, etc. They can also view their own collections and message board management.

Administrator side:

1. Backstage homepage: The administrator account already has an account login account and password to enter the backstage homepage.
2. System user management: manage the account information of administrators and ordinary users, including operations such as adding users, modifying user information and deleting users.
3. Route planning management: manage route planning list additions, including adding route name, passing attractions, travel cost, travel days, suitable groups of people, route strategies and other information.
4. Scenic spot classification management: Administrators can manage and add to the scenic spot classification list.
5. Attraction information management: Manage the attraction information list and add information, including attraction name, attraction classification, attraction promotion, business hours, ratings, contact numbers and other information.
6. Food type management: Administrators can manage and add food type lists.
7. Food information management: Manage the food information list and add information, including food name, food type, food promotion, food location, food allusions and other information.
8. Accommodation information management: manage the recommended accommodation information list and add accommodation information, including the name of the B&B, B&B star rating, contact number, B&B location, B&B services and other information.
9. System management: Manage the display and switching of the homepage carousel, including adding, editing and deleting pictures and links of the carousel.
10. Message management: Administrators help respond to user message feedback.
11. Website announcement management: manage the release and display of notifications and announcements, including adding, editing and deleting the title, content and validity period of notifications and announcements.
12. Resource management: Manage the release and display of tourism information, including adding, editing and deleting the title, content, pictures and release date of the information.
    1. Systematic needs analysis

The performance requirements analysis of the tourism navigation system mainly analyzes the security of the system (whether user personal information will be leaked), reliability (whether information can be displayed according to actual operations when users operate), performance (whether the operation is smooth), scalability (whether the functions can be further expanded), etc. It can be specifically expressed in the following table 2.1:

Table 2.1 Non-functional requirements table of tourism navigation system

1. 1. System Use Case Analysis

The tourism navigation system provides general users with comprehensive tourism information query, attraction ticket purchase and hotel reservation functions. The user's use case diagram is shown below:

Figure 2.1 User role use case diagram

Figure 2.2 Administrator role use case diagram

1. 1. System process analysis
      1. Add data flow

All users in the system (administrators and users) can add data. Figure 2.3 shows the process of adding data.

Figure 2.3 Add data flow chart

1. 1. 1. Modify data flow

No one is perfect, and everyone makes mistakes. If there is an error in the information entered into the system, the data in the system can be edited. Figure 2.4 shows the process of modifying data.

Figure 2.4 Modify data flow chart

1. 1. 1. Deleting data process

There are often some expired data in the system, such as user logout, etc., so you can delete these data directly. Figure 2.5 is the flow chart for deleting data.

Figure 2.5 Flow chart of deleting data

• Chapter 3Overall system design

After analyzing the feasibility and functions of the system, the next step is to design the system specifically. Through feasibility analysis, we conclude that the system is worth developing. Through functional analysis, we can determine what specific functions the system implements, and then complete the functional design of the system based on functional requirements. This chapter introduces the functional modules and the system database.

1. 1. System functional module design

Through the functional requirements analysis in the previous chapter, we can derive the functional structure diagram of this tourism navigation system. Figure 3.1 is the functional module diagram of the system.

Figure 3.1 Functional module diagram of tourism navigation system

1. 1. Database Design

Database design is the foundation of a system. No matter what system it is, no matter how beautiful the interface design is, it cannot run without a powerful database to support it. When designing a database, we first analyze the database, then design the conceptual model, and finally establish the database table, as shown below.

1. 1. 1. Database conceptual structure design

When designing a database conceptual model, an ER entity diagram is generally used for display. The entity diagram can display all the field names in the database table. The main database ER model diagram in this system is shown in the figure below.

Figure 3.2 ER relationship diagram of popular attractions

Figure 3.3 Food information ER relationship diagram

Figure 3.4 Accommodation information ER relationship diagram

1. 1. 1. Database table design

In the database table, we can see the system's table name, primary key, foreign key and other information. We associate each table through the primary key and foreign key of the database table, and then display it in the interface. The main database tables of this travel navigation system are as follows:

Table access_token (login access duration)

Table accommodation_information (accommodation information)

Table article (article: article for content management system)

Table article_type (article category)

Table attraction_information (attraction information)

Table auth (user rights management)

Table classification_of_tourist_attractions (attraction classification)

Table collect (collection)

Table comment

Table food_information (food information)

Table food_types (food type)

Table hits (user clicks)

Table message (message board)

Table notice (announcement)

Praise

Table registered_users (registered users)

Table route_planning (route planning)

Table slides (carousel)

Table upload (file upload)

Table user (user account: used to save user login information)

Table user_group (user group: used for user front-end identity and authentication)

• Chapter 4Design and implementation of key modules
  1. Log inModules

Administrators and users enter their account + password on the login interface, complete verification, and click the "Login" button. The system will match the administrator and user accounts in the user database table. If the account + password is correct, they will log in to the main management interface of each user in the system. Otherwise, the corresponding information will be prompted and the login interface will be returned. The main interface is shown in Figure 4.1 below.

Figure 4.1 Login interface

The login code is as follows:

/**

* Log in

     * @param data

     * @param httpServletRequest

     * @return

     */

    @PostMapping("login")

    public Map<String, Object> login(@RequestBody Map<String, String> data, HttpServletRequest httpServletRequest) {

log.info("[Execute login interface]");

        String username = data.get("username");

        String email = data.get("email");

        String phone = data.get("phone");

        String password = data.get("password");

        List resultList = null;

        Map<String, String> map = new HashMap<>();

        if(username != null && "".equals(username) == false){

            map.put("username", username);

            resultList = service.selectBaseList(service.select(map, new HashMap<>()));

        }

        else if(email != null && "".equals(email) == false){

            map.put("email", email);

            resultList = service.selectBaseList(service.select(map, new HashMap<>()));

        }

        else if(phone != null && "".equals(phone) == false){

            map.put("phone", phone);

            resultList = service.selectBaseList(service.select(map, new HashMap<>()));

        }else{

return error(30000, "Account or password cannot be empty");

        }

        if (resultList == null || password == null) {

return error(30000, "Account or password cannot be empty");

        }

// Check if there is such a user

        if (resultList.size()<=0){

return error(30000,"User does not exist");

        }

        User byUsername = (User) resultList.get(0);

        Map<String, String> groupMap = new HashMap<>();

        groupMap.put("name",byUsername.getUserGroup());

        List groupList = userGroupService.selectBaseList(userGroupService.select(groupMap, new HashMap<>()));

        if (groupList.size()<1){

return error(30000,"User group does not exist");

        }

        UserGroup userGroup = (UserGroup) groupList.get(0);

//Query user review status

        if (!StringUtils.isEmpty(userGroup.getSourceTable())){

            String res = service.selectExamineState(userGroup.getSourceTable(),byUsername.getUserId());

            if (res==null){

return error(30000,"User does not exist");

            }

if (!res.equals("Passed")){

return error(30000,"The user review failed");

            }

        }

//Query user status

        if (byUsername.getState()!=1){

return error(30000,"The user is not available and cannot log in");

        }

        String md5password = service.encryption(password);

        if (byUsername.getPassword().equals(md5password)) {

//Store Token in the database

            AccessToken accessToken = new AccessToken();

            accessToken.setToken(UUID.randomUUID().toString().replaceAll("-", ""));

            accessToken.setUser_id(byUsername.getUserId());

            Duration duration = Duration.ofSeconds(7200L);

            redisTemplate.opsForValue().set(accessToken.getToken(), accessToken,duration);

// Return user information

            JSONObject user = JSONObject.parseObject(JSONObject.toJSONString(byUsername));

            user.put("token", accessToken.getToken());

            JSONObject ret = new JSONObject();

            ret.put("obj",user);

            return success(ret);

        } else {

return error(30000, "The account or password is incorrect");

        }

    }

1. 1. Register Module

The user enters the account + password on the login interface, completes the verification, and clicks the "Login" button. The system will match the administrator and user accounts in the user database table. If the account + password is correct, the user will be logged in to the main management interface of each user in the system. Otherwise, the corresponding information will be prompted and the user will return to the login interface. The main interface is shown in Figure 4.2 below.

Figure 4.1 Registration interface

The registration code is as follows:

/**

* register

     * @param user

     * @return

     */

    @PostMapping("register")

    public Map<String, Object> signUp(@RequestBody User user) {

// Query user

        Map<String, String> query = new HashMap<>();

        Map<String,Object> map = JSON.parseObject(JSON.toJSONString(user));

        query.put("username",user.getUsername());

        List list = service.selectBaseList(service.select(query, new HashMap<>()));

        if (list.size()>0){

return error(30000, "user already exists");

        }

        map.put("password",service.encryption(String.valueOf(map.get("password"))));

        service.insert(map);

        return success(1);

}  

1. 1. Password modification module

After the user completes the registration with the system, if the user needs to modify the login password, the system can also provide the user with password modification permissions. All operators in the system can change their password information. To perform this function, you must first log in to the system, then select the password change option and fill in the initial password and new password in the given text box to complete the password change operation. When filling in, if there is a difference between the two passwords, the password change operation fails. The following picture shows the interface corresponding to this section. The interface is shown below.

Figure 4.3 Password modification interface

The password modification code is as follows:

  /**

* change Password

     * @param data

     * @param request

     * @return

     */

    @PostMapping("change_password")

    public Map<String, Object> change_password(@RequestBody Map<String, String> data, HttpServletRequest request){

// Get UserId based on Token

        String token = request.getHeader("x-auth-token");

        Integer userId = tokenGetUserId(token);

// Get the user based on UserId and old password

        Map<String, String> query = new HashMap<>();

        String o_password = data.get("o_password");

        query.put("user_id" ,String.valueOf(userId));

        query.put("password" ,service.encryption(o_password));

        int count = service.selectBaseCount(service.count(query, service.readConfig(request)));

        if(count > 0){

// change Password

            Map<String,Object> form = new HashMap<>();

            form.put("password",service.encryption(data.get("password")));

            service.update(query,service.readConfig(request),form);

            return success(1);

        }

return error(10000,"Password modification failed!");

    }

1. 1. Route PlanningModules
2. Route planning: Users can view route names, attractions, trip costs, trip duration, etc., view maps, and click likes, favorites, and comments. The interface is shown below.

Figure 4.4 Route planning interface

1. 1. Attractions list

Attraction information: Users can view the attraction information list and check the latest tourist attraction introduction, including attraction introduction, transportation guide, business hours, attraction introduction, attraction rating, etc. They can also like, collect and comment on the attractions they are interested in. The interface is shown in the figure below.

Figure 4.5 Attraction information interface

1. 1. Food information list

Food information list: Displays recommended food information, including food name, type, characteristics, picture display, etc. Users can choose to like, collect, comment, etc. The interface is shown in the figure below.

Figure 4.6 Food information list interface

1. 1. Admin route planningManagement Module

Route planning management: manage route planning list additions, including adding route name, passing attractions, trip cost, trip days, suitable crowds, route strategies and other information. The interface is shown below.

Figure 4.7 Route planning management interface

1. 1. Administrator attraction informationManagement Module

Attraction information management: Manage the attraction information list and add information, including attraction name, attraction classification, attraction publicity, business hours, ratings, contact numbers, etc. The interface is shown in the figure below.

Figure 4.8 Scenic spot information management interface

1. 1. Administrator food informationManagement Module

Food information management: Manage the food information list to add information, including food name, food type, food promotion, food location, food allusions, etc. The interface is shown in the figure below.

Figure 4.9 Food information adding interface

1. 1. Administrator accommodationManagement Module

Accommodation information management: manage the recommended accommodation information list and add accommodation information, including the name of the homestay, homestay star rating, contact number, homestay location, homestay services, etc. The interface is shown in the figure below.

Figure 4.10 Hotel booking interface

1. 1. Administrator SystemManagement Module

System Management: Manage the display and switching of the homepage carousel, including adding, editing and deleting pictures and links of the carousel, etc. The interface is shown in the figure below.

Figure 4.11 System management interface

• Chapter 5System experiment and result analysis

At this point, the development of the system is basically completed. Next, we will analyze the system's experiments and results to ensure that the system can operate normally and then put it into use. The detection method for the system's experiments and results analysis is the system test. Testing is the last step in the completion of the system. A system that has not been tested cannot be put into use, otherwise it will cause losses once a bug occurs. Below we analyze the test method and test use cases, and finally give the system test results.

1. 1. Test Methods

There are two types of system testing, one is black box testing, and the other is white box testing. Black box testing is generally speaking functional testing, which we also call requirement testing. In the process of black box testing, we don't know its development principle, but just test the system as a user. We mainly rely on previous testing experience, take some critical values, and then test it through test cases. This testing method is the fastest way to find problems. Secondly, we can find some representative data and perform case tests on the system. In the process of black box testing, the commonly used testing tools are winrunner and AutoRunner; white box testing is called result testing, which is logic-driven testing. In the process of white box testing, we mainly test according to the principles of system development, mainly as a developer to test whether the code has completed its specific functions and whether the specific path of implementation is correct. Of course, this testing method is time-consuming and laborious, because each function has more than one running path. By testing the running path in the program, we can detect whether there are bugs in the developed code and whether it has achieved expectations. In the process of white box testing, the commonly used testing tools are Jcontract, C++ Test and CodeWizard.

1. 1. System test cases

Functional test of login module:

Table 5.1 Login module function test table

User information adding function test:

Table 5.2 User information adding function test table

Query tourism information function module test:

Table 5.3 Query tourism information function test table

Test of adding function modules for popular attractions:

Table 5.4 Add popular attractions function test table

1. 1. System test results

In this chapter, we conducted a black-and-white box test on the tourism navigation system and analyzed some of the functions in the system. We found that the system is relatively stable and all the functions of the system can be basically realized, which can meet the needs of administrators and users for tourism information, adding popular attractions, adding user information, etc. Through testing, we can see that during the operation of the system, its functions are complete. For input error information, the error information can be prompted, which is convenient for users to find out where the information they input is wrong during operation and then make corrections. In addition, the system interface is equipped with a navigation bar, which is very convenient to operate and does not require any training for users. It is a very valuable system for enterprises.

• Chapter 6in conclusion

After several months of hard work, this tourism navigation system is finally completed. Although I have developed some small systems during my school years, they were all completed with the explanation and assistance of teachers. I did not go through the demand analysis and system analysis before development. I started directly from system design. Therefore, the tourism navigation system developed this time is of great significance to me.

At the beginning of system development, we first investigated the needs of the tourism navigation system to understand what functions the developed system needs to implement in order to meet the management needs of users for the enterprise, and then analyzed the needs; secondly, we chose the JAVA language and MYSQL database that we are more familiar with, and used the SpringBoot framework for design and development. We consulted and learned these technologies through CNKI, school libraries, etc., mastered the ideas and methods of programming, and then analyzed the system. We conducted a comprehensive analysis of the system from the aspects of the feasibility of system development, the functions implemented by the system, the performance that the system should have, and the operating procedures of the system, determined the final functions of the system, and designed the system functions and database. Finally, we implemented the system and tested the implemented functions to ensure the stable operation of the system.

During the development process, I exposed many problems of my own, such as insufficient preparation in the early stage, and I could not fully master the operation process; I was not proficient in JAVA programming during the development process, and there were still many problems in the system environment configuration, which often caused errors when the project was running. Learning never ends. By consulting the information and asking the tutor for advice, I slowly solved these problems. In the future, I will be more rigorous in my studies and work. Through the development of this project, I will benefit for life!

references

[1] Wu Linglin. Design and implementation of customer relationship management system based on SpringBoot[J]. Wireless Internet Technology, 2023, 20(24): 60-62.

[2] Huang Saiying. Design of hospital archive management system based on Springboot[J]. Integrated Circuit Applications, 2023, 40(11): 384-385.

[3] Lin Shengfeng, Yao Jinjiang, Lin Tao, Liu Jiaxiao, Tian Zhizhuo, Li Chao. Design of university laboratory management system based on SpringBoot[J]. Wireless Internet Technology, 2023, 20(18): 80-82.

[4] Wang Rong, Li Qiang, He Ying, Guo Ya, Wu Xiaomin, Yang Zhenglin, Huang Yiwang. Design and implementation of personalized tourism recommendation system[J]. Computer, 2023, 39(09): 95-99.

[5] Yin Li, Du Xiaonan. Design and implementation of campus points system based on SpringBoot and Vue[J]. Integrated Circuit Applications, 2023, 40(07): 414-415.

[6] Li Qin, Cui Mingyang, Qian Yiwen, Liu Jingjing. Development of graduate student academic archive management system based on SpringBoot[J]. Computer Knowledge and Technology, 2023, 19(18): 46-48+51.

[7] Li En. Design and implementation of Wuhan red tourism platform based on user recommendation algorithm[D]. Yangtze University, 2023.

[8] Wan Yanbing. Research and development of personalized tourism recommendation system based on Flink[D]. Guangxi University for Nationalities, 2023.

[9] Yang Jiapeng, Zu Yuwei, Ji Jiaqi, Chen Lifang. Waterfall-type fusion tourism recommendation system based on Spark framework[J]. Intelligent Computers and Applications, 2023, 13(04): 142-146.

[10]Yu Yang.Design and Implementation of Student Information Management System Based on Springboot[J].Advances in Computer, Signals and Systems,2022,6(6):

[11] Chen Yong. Design of tourism recommendation system based on collaborative filtering algorithm[J]. Value Engineering, 2022, 41(30): 160-162.

[12] Zhang Min, Zhang Lamei, Chen Zhengyu. Web-based tourism recommendation system[J]. Information Recording Materials, 2022, 23(10): 132-135.

[13] Chen Ling. Design and implementation of Chinese red tourism recommendation system based on Django[J]. Software, 2022, 43(09): 100-103.

[14] Xu Yang. Travel route recommendation system based on knowledge graph[D]. Inner Mongolia University, 2022.

[15]Wu Hejing.Commerce Middle Office Management System Based on Springboot[J].International Journal of Advanced Network, Monitoring and Controls,2022,7(2):32-45.

[16] Liu Xiuhuan. Design and implementation of parent-child travel recommendation system[D]. Qufu Normal University, 2021.

[17] Li Wei. Research on the design of smart tourism recommendation system based on big data mining technology[J]. Modern Computer, 2021, 27(32): 117-120.

[18]Fuyuan Cheng.Talent Recruitment Management System for Small and Micro Enterprises Based on Springboot Framework[J].Advances in Educational Technology and Psychology,2021,5(2):

[19]Guanhong Chen,Jiangming Xu.Design and implementation of efficient Learning platform based on SpringBoot Framework[J].Journal of Electronics and Information Science,2020,6(1):

[20]Jian Chen,Chen Jian,Pan Hailan.Design of Man Hour Management Information System on SpringBoot Framework[J].Journal of Physics: Conference Series,2020,1646(1):012136-.