A successful project should clarify the purpose of construction, determine the function, determine the scale, input costs, and conduct necessary market analysis. Only detailed planning can avoid many problems in the construction of the construction of the country, so that the construction can be carried out smoothly. At the same time, a large-scale computer system must have a correct design guiding ideology, through the reasonable selection of data structure, network structure, operating system and development environment, constitute a perfect network architecture, in order to give full play to the advantages of computer information management. According to the actual needs of netizens in real life, the design of this system is carried out in accordance with the following principles.
1.Validity: Actually, validity here includes two meanings: usefulness and usability. Usefulness refers to the potential functionality of a site to meet the needs of users, while usability refers to the ability to achieve a specific goal through the operation of the site. It can be seen that a site is not a good site if it is not functioning properly or is designed to be very sloppy. The benefits of the available site should be very high, easy to learn, and satisfying and error-free in achieving user goals.
2.High reliability: A practical and reliable at the same time, this design through a reasonable and advanced network design and software and hardware optimization selection, can ensure the reliability and fault tolerance.
3.High security: In the design, various security measures provided by network software and hardware will be fully utilized, which can not only ensure that users share resources, but also fully consider the requirements of disaster recovery, backup and recovery of system and data resources. Provide a powerful database backup tool for the system. The security of critical data can be guaranteed. The operation permission level is set to ensure that the operation permission of each step can be set by the administrator.
4.Advanced: Adopt the most advanced development technology in the world, use JSP development technology, and MySQL as the best back-end database. The use of these technologies reduces the operating cost of the system in the future, and improves the stability and ease of maintenance of the system.
5.Adopt standard technology: All designs of this ** are carried out in accordance with the current international standards to improve the openness of the system.
6.Appearance and technical balance: The system adopts a web-style interface design, which is friendly, beautiful, easy to use, easy to learn and use. The key issue of design is the balance of appearance and technology. It's annoying to have a bad appearance, the site can work well, but it doesn't motivate users, and conversely, if the appearance is very expressive, but the technology is limited, the user will be very disappointed. A clear and continuous relationship needs to be established between appearance and technology, that is, appearance is related to the intent of the site, and different types of ** are treated differently.
Directory. 1System Overview 1
1.1 Background 1
1.2Purpose of the study 1
1.3System Design Ideas 1
2Related Technologies 3
2.1 MySQL database 3
2.2 b s structure 3
2.3 Introduction to the Spring Boot Framework 4
2.4 vue framework 4
3 Systems Analysis 5
3.1 Feasibility analysis 5
3.1.1Technical feasibility 5
3.1.2Economic viability 5
3.1.3Operational feasibility 5
3.2System performance analysis 6
3.2.1 System Security 6
3.2.2 Data Integrity 6
3.3System interface analysis 6
3.4System Flow and Logic 8
4System Overview Design 9
4.1Overview 9
4.2System structure 10
4.3.Database Design 11
4.3.1Database entity 11
4.3.2 Database Design Table 13
5 Detailed implementation of the system 17
5.1 Implementation of the Administrator Module 17
5.1.1 User Management 17
5.1.2 Article Categories 17
5.2.1 Classification of data 18
5.3 Implementation of the user module 18
5.2.2 Article information 18
5.3.1 Forum Exchange 19
5.3.2 Material** 20
6System testing 21
6.1 Concept and Meaning 21
6.2 characteristics 21
6.3 Importance 22
6.4Test Method 22
6.5 Functional Testing 22
6.6Usability testing 23
6.7Performance testing 23
6.8 Test analysis 24
6.9Analysis of test results 24
Conclusion 24Acknowledgments 25
Ref. 25
MySQL database.
MySQL is a true multi-user, multi-threaded SQL database server. It is a relational database management system based on the client server model of SQL, which has some powerful functions, simple use, convenient management, high security and reliability, fast running speed, multi-threading, cross-platform, complete networking, stability, etc., which is very suitable for the development of the database back-end of the web site or other application software. In addition, users can write programs in many languages to access the MySQL database. As one of the products of the open source ** movement, MySQL relational database management system is becoming more and more popular and widely used. The speed and ease of use make MySQL particularly suitable for the development of the database backend of a web site or application software.
MySQL database has the following features:
1. C and C++ are used and tested to ensure the portability and flexibility of the source compiler.
2. Support a variety of operating systems AIX, FreeBSD, HP-UX, LINUX and Mac OS, Novell Netware, OpenBSD, OS 2 Wrap, Solaris, Windows, etc.
3. APIs for different programming languages are provided. Programming languages such as C, C++, Python and J**A, Perl, PHP, Eiffel Tower, Ruby and TCL.
4. As well as the CPU resources used to support multi-threading.
5. The algorithm optimizes the query SQL and effectively improves the search speed.
6. The client and server on the network can be used to program any independent programming environment, there are also Chinese, GB2312, BIG5, Japanese writing, general **, used to support multiple Chinese, and can be embedded in the data table and other software shift jis access column can be used as the name.
7. TCP IP, ODBC and JDBC databases, and provide connections to others.
8. Management of management tools, control and optimization of database operations.
9. Tens of millions of records can be recorded in a large database.
b s structure.
BS architecture is a kind of software system development architecture based on Internet system, which is a software system structure that is used in a large number of software system development nowadays. Nowadays, the BS architecture has been widely used, which breaks the structure of the CS structure and provides good support for the software system based on the network structure. The BS architecture has been gradually developed and updated with the development of computer network technology. With the further development of the Internet, most of the management system requirements can not only be used on one computer, but also can be used by other computers connected to the Internet to operate and use the system. In this context, the software system design method based on the BS architecture has been used more and more extensively, and the basic part is constantly updated.
The BS architecture is used using a browser in the operating system, not a form software system, and does not need to be installed on the computer using the system. The operation mode of BS architecture is to deploy the developed software system on a remote server on a remote server, and after the software system is deployed, the deployed software system can be accessed on any computer connected to the Internet. The BS architecture brings great convenience to users who use the management system.
In a three-tier architecture of the Browser Server (BS) system, users can make requests to numerous servers distributed across the network through a browser. The BS system greatly simplifies the workload of the client, the client only needs to install and configure a small number of clients to run the software, the server will take on a lot of work, and the access to the database and the execution of the application will be completed by the server.
The continuous maturity of the BS architecture, mainly using www browser technology, combined with a variety of browser scripting languages, with a general browser needs to realize the powerful functions of the original complex proprietary software, and saves development costs, is a new software architecture. The BS system includes: the presentation logic layer, the control logic layer, and the data presentation layer, which are relatively independent and interrelated.
vue framework.
vue (pronounced vju, similar to view) is a progressive framework for building user interfaces. Unlike other large frameworks, Vue is designed to be applied layer by layer from the bottom up. Vue's core library focuses only on the view layer, making it easy to get started with and easy to integrate with third-party libraries or existing projects. On the other hand, when combined with a modern toolchain and a variety of supporting libraries, Vue is also fully capable of powering complex single-page applications. vue.At its core, JS is a system that allows data to be rendered declaratively into the DOM using a concise template syntax.
References. 1] Fu Xin. Implementation of warehouse management system based on B S mode[J].Journal of Shandong Provincial College of Agricultural Management, 2010, 27(4):166-168
2] Lei Wenhua, Xue Xiaowen. Application of MATLAB and Servlet in Network Data Processing[J].Electronic Testing, 2010, (11):81-86
3] Huang Yanfeng. Research and Exploration on the Implementation of "Case Teaching" in J**A Language[J].Computer Knowledge and Technology, 2010, 6(5):1148-1149
4] Wang Yuying. MySQL database access technology based on JSP[J].Modern Computer:Professional Edition, 2010, 19(14):63-66
5] Zhao Gang. Research on the application of web mode of JSP servlet+EJB[J].Electronic Design Engineering, 2013, 21(13):47-49
6] d**id l.anderson.managing information systems.Tsinghua University Press, 2002:16
7] Wang Jiahua, Software Engineering[M], Shenyang: Northeastern University Press, 2011:46