Abstract: With the wide popularization of network technology and computers, most colleges and universities use computer management systems reasonably. Based on B/S mode, the development tools used are eclipse and Android studio. Then based on MySQL database, beautify the interface with Adobe Photoshop CS6 image processing software. In the process of system development, postman testing tool is used, and after the system development is completed, the relevant modules are tested by use cases. The interface of the system is beautiful and friendly, and the man-machine information is safe, reliable, flexible and convenient. The system has strong expansibility. Taking the student information management system as an example, this paper expounds the application of Java Web in information management, which provides high theoretical guidance and practical significance for the development of management information system. Java Webb/S； relational database
catalogue
1 Introduction to ............................. 1
The research background and significance of 1. 1 ....................................................................... 1
1.2 research status ......................... 1
2. System related technology analysis ................................................................................................ 2
2. 1 Java 2
2.2 javaweb
2.3 Database
3 Feasibility and demand analysis
3. 1 Feasibility analysis
3.2 Overall demand analysis
4. Design of the system ............................................................................................ VII
4. 1 system architecture design
4.2 System function module design
4.3 System Database Design 8
5. System development and implementation of ................................................................................................................ 10.
5. Implementation of1login interface .................................................................................................................................................................
5.2 the realization of teacher management ..........................................................................................................................................................................
5.3 the realization of student management .........................................................................................................................................................................
5.4 the realization of curriculum management ..........................................................................................................................................................................
5.5 the implementation of the teacher module .........................................................................................................................................................................
5.6 Implementation of Student Module
6 system testing
6. 1 User login function test
6.2 Testing of various information management functions
6.3 Excel Export Student Report Function Test 24
abstract
Thank you ... thank you ... thank you ... thank you.
Refer to .................. 27
1 introduction 1. 1 research background and significance
Students' information must be managed safely and efficiently. Therefore, the student information management system is an indispensable part of a school. Because of the huge amount of students' information, systematic management statistics is more convenient for colleges and universities that need to record and archive more data. Moreover, when looking for records, you only need to enter the relevant information of students to find almost all the information.
Information-based student information management system can effectively solve the shortcomings of traditional manual file management, make full use of the advantages of information management, and improve the efficiency of student status management. The student information management system is more effective and convenient for the management of student information. Effective management of students' state information not only ensures the efficient and orderly management of students' state, but also enables colleges and universities to achieve a certain degree of rapid development.
In order to improve the management efficiency of students' personal information, the student information management system designed in this paper will greatly improve the management efficiency of college students' information. Developing a fully functional student information management system can improve the management efficiency of college student information files.
Research status of 1.2
Information administrators in colleges and universities in China are generally older aunts and uncles, and some of them have lower education level. Therefore, the old dormitory managers who use the student information management system are unfamiliar with the operation of the computer system, need the guidance of others, and even have a low acceptance of the system, they still choose to use paper to record information. If students have a lot of information to repair, there will be problems that cannot be solved in time.
Therefore, the future development route of information management system in colleges and universities in China needs to further simplify the use of information management system, make the audience of the system bigger and more people can use it, so as to better improve the efficiency and convenience of student information management system and provide more systematic services.
1.3 the necessity of student information management system
At present, the population explosion and the number of students increase sharply, which provides great challenges for colleges and universities to count a large number of student information. Student information management system can reduce the burden of students' information statistics and make students' information statistics and query more convenient and fast. This paper focuses on the application of WEB framework in student information management system, which is of great significance to the long-term student information construction and the realization of student information digitization.
2 system related technology analysis
This system adopts mature Java programming language and object-oriented thinking. Java 1.8, Eclipse integrated development environment, Tomcat7.0 and Mysql database are used in the development process.
2. 1 Java
Java is an object-oriented programming language introduced by Sun Company, which is widely welcomed by developers all over the world and occupies a major position in the field of software development. Java language has the advantages of powerful function, simplicity, high development efficiency, stable operation and independent operation. Because Java language can independently build a program running environment, it can be used without a powerful platform. At the same time, Java language also supports multi-thread development and can be combined with the Internet.
The design of Java language focuses on objects and their interfaces, providing a simple class mechanism and a dynamic interface model. The object encapsulates its state variables and corresponding methods, realizing modularity and information hiding; Class provides the prototype of the class, and through the inheritance mechanism, subclasses can use the methods provided by the parent class to realize code reuse.
Java is different from the general compilation and execution computer language, and it is also different from the interpretation and execution computer language. It first compiles the source code into binary bytecode, and then relies on virtual machines on various platforms to interpret and execute bytecode. Thus, the cross-platform feature of "compile once and execute everywhere" is realized. However, it takes some time to execute the compiled bytecode every time, which also reduces the performance of Java programs to some extent.
2.2 JavaWeb
2.2. 1 HTML
HTML5 is a standard version of HTML, which is used to replace the standards of HTML 4.0 1 and XHTML 1.0 formulated by 1999. It is still in the development stage, but most browsers already support some HTML5 technologies. HTML 5 has two characteristics: first, it strengthens the performance of web pages. Secondly, the functions of Web applications such as local database are added. Broadly speaking, HTML5 actually refers to a set of technology combinations including HTML, CSS and JavaScript. It hopes to reduce the browser's demand for plug-in-based rich Internet applications (RIA), such as Adobe Flash, Microsoft Silverlight and Oracle JavaFX, and provide more standard sets that can effectively enhance network applications.
HTML is the so-called Hypertext Markup Language, which is ubiquitous in all web pages in the network and is one of the basic tools for developing web pages. HTML mainly uses tags to control images, videos, texts and other information in web pages, so as to achieve the expected display effect. Internet operations generated by HTML language will be restricted by http protocol, and browsers will also be restricted when running HTML language. The rapid and large-scale application of HTML is mainly due to the adoption of hypertext technology, which enables it to transmit data with any networked computer. The so-called "hypertext" essentially refers to other content that does not contain text, such as video and audio.
Servlet
Servlet is a brand-new technology developed on the basis of JSP technology, which is mainly used in servers and has the functions of receiving data requests and forwarding data requests. Essentially, Servlet belongs to a Java program. Servlet mainly runs according to the following process: after the server receives the Http request, it will immediately analyze the accepted request, create a servlet on this basis, and then feed back the request information to the client through various means such as calling, and finally the server restarts and calls destroy.
The request submitted by the browser is a text conforming to the Http protocol, which is accepted and parsed by the server container (such as Tomcat) and encapsulated into a request of HttpServletrequest type. All HTTP header data can be queried (get) by the method corresponding to request. When it needs to be output to the client browser, Tomcat encapsulates the output stream text into a response object of HttpServletresponse, and controls the output content by setting the properties of Response. Among them, Tomcat uses request and response as parameters to call methods in Servlet, such as doget (request, response);
JSP
JSP actually belongs to one of the branch technologies of Java Servlet. It is a web development technology based on B/S structure, which allows users to interact with web pages and greatly enhances the expansibility of web pages. JSP mainly follows the following process: using JSP tags to insert the code written in Java language into the webpage developed by Hypertext Markup Language. The standard JSP tag format is "".
JSP technology mainly plays the role of realizing Java web user interface. Before JSP programming, HTML, XHTML and XML should be effectively combined. JSP technology usually uses forms to realize various requirements, such as data input, database access and so on. After you get all the information, you can start designing the web page.
JSP tag can realize various functions and requests such as database access, and in addition, it can forward, transmit and * * * enjoy the information sent by each webpage, which mainly includes five steps: request, conversion, compilation, execution and response.
Step 1, the client will send a web page request; Step 2, the JSP container converts the web page request into a Servlet file; Step 3, further compile the Servlet file into a. class file; Fourthly, executing a webpage request to generate a Servlet instance; Step 5, return the Servlet instance requested by the webpage to the client for response.
Generally speaking, the two core stages of JSP execution should be the request period and the translation period. As the name implies, the so-called request period refers to return. Class files are sent to the client, and the so-called translation period is to convert web page requests into. Gradually establish class files.
JSP has many performance advantages. After applying JSP technology, the complexity of programming work faced by program developers will be significantly reduced, and it can be used in conjunction with visualization tools to further reduce the development pressure of program developers. In addition, because JSP itself contains built-in objects and other characteristics, it can greatly help servlet programming, effectively improve programming speed and reduce programming difficulty, so that program developers do not need to manually translate web page requests and external information. Moreover, JSP contains all the technical contents of Java, so all plug-in packages, toolkits and so on supported by Java can be called by JSP without a powerful operating platform.
2.2.4 B/S structure
Advantages of b/s (browser/server) architecture:
(1) program is basically built in the server, which is convenient for maintenance and update;
(2) The logic processing and data processing operations of the client can be effectively distinguished, so that other contents do not need to be changed when maintaining the client.
Interactive mode of B/S architecture;
B/S structure can connect the web page request and the return response, and then realize the real-time interaction between them, and allow the browser to send the request directly and rely on the server to access the system server and the database server. From the perspective of the application server, the application server can obtain the required data from the database, then send a request to the browser, and finally the browser processes the HTML file.
2.3 Mysql database
Database, in short, can be regarded as an electronic filing cabinet-the place where electronic files are stored, and users can add, intercept, update and delete the data in the files. The so-called "database" is a data collection database management system (DBMS) that is stored together in a certain way, can be shared by multiple users, has as little redundancy as possible, and is independent of applications. It is a computer software system designed for database management, which generally has basic functions such as storage, interception, security and backup.
Database management systems are mainly divided into the following two categories: relational databases (relational databases are databases created on the basis of relational models, and the data in the databases are processed by mathematical concepts and methods such as set algebra. All kinds of entities in the real world and all kinds of relationships between entities are represented by relational models. Non-relational database NoSQL (non-relational database is the general name of database management system which is different from traditional relational database. The biggest difference from relational database is that SQL is not used as the query language. )。 Almost all database management systems are equipped with open database connectivity (ODBC) drivers, which can integrate various databases.
Mysql is a widely used and popular database server. It is a collection of data stored on computer equipment for a long time, which is organized and communicated by various users and applications according to certain rules. In short, it is a large warehouse for storing data files. It is powerful, easy to use and manage, safe and reliable, cross-platform interface, network security and stability, suitable for the back-end development of most software and application software databases. In addition, Mysql database allows users to write programs in multiple languages for access. At the same time, Kaiyuan is the biggest feature of this data path, which can work on different platforms and can also be applied to the data backend of Web development sites and other programs.
3 Feasibility and demand analysis
3. 1 Feasibility analysis
3. 1. 1 Technical feasibility analysis
The price of computer products designed based on Java acquisition and monitoring system is not strict. You only need to be proficient in using java and database, and you don't need too many different types of complex languages, which reduces the complexity of design and implementation. High cost performance; High security.
3. 1.2 Feasibility analysis of operating conditions
The operability is mainly to complete the design of the monitoring and management system for collecting commodity prices and the use of user experience, which can completely allow managers to conveniently manage relevant data information and user information requests at any time through the system. Managers do not need experts to manage the operation of data and information systems, and can directly correspond to the operability of general module systems for operation management. Because the operation of the system also uses the interface window to log in, the operator can operate completely as long as the operation is simple.
3.2 Overall demand analysis
The system mainly realizes the management of students' information, and administrators can directly operate (add, modify and delete) students, teachers and courses, specifically:
(1) Add new teachers;
(2) Modify the teacher information that has been added and existed in the system database;
(3) Delete the existing teacher data in the student information management system;
(4) Check all the existing teacher data in the system.
There are related operations on course data, including:
(1) Add new curriculum data;
(2) Modifying the existing course data in the system database;
(3) Delete the course data that has been added in the system;
(4) Check all the existing course data in the system.
Administrator's own operation: click the button to modify personal information, and the administrator can modify his own password.
For example, as shown in Figure 3- 1, it involves the use of administrators in the database.
Figure 3- 1 Administrator Use Case Diagram
The main functions of the teacher module include the modification of course data and student-related data. The specific operation is similar to that of the administrator. The use case diagram of the teacher module is shown in Figure 3-2.
Figure 3-2 Teacher Role Use Case Diagram
The main functions of the student module include modifying and viewing personal information and viewing grades, as shown in Figure 3-3.
Figure 3-3 Student Role Use Case Diagram
4 system design
4. 1 system architecture design
The purpose of architecture design is to reflect the relationship between a structure and other elements. It is abstract and usually used to guide large-scale software systems, including model layer, view layer and control layer. Combined with the overall design idea of factory pattern, a factory class is encapsulated at the top of each layer of data access layer and service layer. The control layer calls related services through the factory class of service layer, and the service class calls the factory class of data access layer to realize related data access layer operations. The architecture design details of the system are shown in Figure 4- 1.
Figure 4- 1 Structure Diagram of Student Information Management System
4.2 System function module design
This student information management system * * * has designed four functional modules, namely, teacher management function module, student information management function module, course management function module and achievement management function module. The functional module design of the system is shown in Figure 4-2.
Figure 4-2 System Function Module Design
4.3 System Database Design
1. Teachers can manage all the information of students (student number, name, gender, date of birth) as well as courses and grades.
2. Students choose courses, work as teachers, grant students the selected courses and give them grades, and students have grades. As shown in Figure 4-3.
Figure 4-3 ER Diagram of System Database
The administrator in the system has two attributes: user name and password, which are used to log in to the system, as shown in Figure 4- 1.
Figure 4- 1 administrator information map
The name of the student information table in the database is defined as student, and its * * * has seven fields to store the student's student number, name, class, gender, ID number, province and telephone information. Specific student information table fields as shown in figure 4-2.
Figure 4-2 Student Information Map
The table name of the course information table in the database is defined as course, and its * * * has six fields to store the course number, course name, class, teacher, class hour and course credit information of the course. The specific course information table fields are shown in Figure 4-3.
Figure 4-3 Course Information Diagram
The table name of the grade information table in the database is defined as grade, and its * * * has eight fields to store grade number, student number, student name, course class, course number, course name, grade score and grade type respectively. Specific achievement information table fields are shown in Figure 4-4.
Figure 4-4 Performance Information Diagram
The name of the teacher information table in the database is defined as teacher, and its * * * has seven fields for storing teacher information. Specific teacher information table fields are shown in Figure 4-5.
Figure 4-5 Teacher Information Map
5 system development and implementation
5. Implementation of1login interface
The login interface is shown in Figure 5- 1. In the login interface, you need to select different login objects, enter the corresponding user name, password and verification code after selection, and then click OK to log in to the student status information management system.
Figure 5- 1 Login Interface
(1) Click the administrator login option in the login options, and enter the administrator account and password for administrator login. The administrator login part code is:
//Administrator login
(2) Click the student login option in the login options, and enter the student account and password at the student end to log in. Students can modify their related information (personal information, password, etc.) after logging in. ).
Student login component code:
//Student login
(3) Click the teacher login option in the login options, and enter the teacher account and password at the teacher's end to log in.
Teacher login part code:
//Teacher login
After logging in, you can see the main interface of the system, and the navigation menu is on the left. After logging in with different identities, the navigation menu has different functions:
Student login: students can modify their personal information, choose courses, punch in, ask for leave, and inquire about their course selection and grades.
Teacher login: Teachers can add, modify, delete and export student scores.
Administrator login: Administrators can add, modify and delete information of students and teachers.
As shown in Figure 5-2.
Figure 5-2 System Main Interface
5.2 the realization of teacher management
After successful login, the administrator can complete the management of teachers in the system, modify and add teacher data. Add teachers as shown in figure 5-3.
Figure 5-3 Add Teachers
The main codes for adding teacher functions are as follows:
After the teacher is successfully added, you can view the added teachers, and you can still modify and delete the added teacher information. As shown in figure 5-4.
Figure 5-4 Teacher List View
If you need to modify the teacher's related information, you need to select the teacher to modify first, and click Modify to modify the information, as shown in Figure 5-5.
Figure 5-5 Teacher Information Modification
Teacher information modification code is as follows:
If there is any teacher-related information that needs to be deleted, first select the teacher to be modified, and click the Delete button to delete the teacher to be deleted, as shown in Figure 5-6.
Figure 5-6 Teacher Delete
The main codes of the teacher deletion function are as follows:
5.3 the realization of student management
After successfully logging in, the administrator can complete the management of students and add, delete and change teacher data in the system. The management of students is similar to that of teachers, and the interface of student management is shown in Figure 5-7.
Figure 5-7 Student Management Interface
5.4 the realization of curriculum management
After the administrator logs in successfully, he can complete the course management in the system and add, delete and modify the course data. Course management is similar, so I won't go into details. The course management interface is shown in Figure 5-8.
Figure 5-8 Course Management Interface
5.5 Implementation of Teacher Module
Teachers can manage students' attendance information and grades after logging into the system. To add students' grades, click the Add button to add students' grade information. Select a student and click Modify to modify the student's grades, as shown in Figure 5-9.
Figure 5-9 Revision of Students' Grades
The code of the student score modification function is as follows:
Teachers can also make statistics on students' grades and view the statistical chart of all students' grades in each course, as shown in Figure 5- 10.
Figure 5- 10 Student Achievement Statistics
Teachers can export students' report forms. The export of student reports is shown in figure 5- 1 1.
Figure 5- 1 1 student report card export
The effect of exporting students' grades is shown in Figure 5- 12.
Figure 5- 12 Export of Students' Scores