Students can have the ability to modify and view some information after logging into the system, and can modify personal information. Students can check all their grades, as shown in Figure 5- 13.
Figure 5- 13 Student Achievement View
Some function codes for checking students' grades:
After the students log in, they can click the course information management button and click the course list to view their course information, as shown in Figure 5- 14.
Figure 5- 14 Course Selection View
Some codes of the course selection and viewing function are as follows:
After logging in the student account, click Modify = Student Information button in personal information, and students can modify their personal information (gender, name, phone number, QQ, class), as shown in Figure 5- 15.
Figure 5- 15 student information modification
6 system testing
(System test) is a test of the whole system, which takes the hardware, software and operators as a whole to check whether it is inconsistent with the system specification. This test can find errors in system analysis and design. For example, security testing is to test whether the security measures are perfect and whether the system can be protected from illegal intrusion. For another example, stress testing is to test whether the system can work normally under the condition of normal data volume and overload (such as multiple users accessing at the same time). The main purpose is to find as many errors as possible in the programmed program.
After the design and development of student information management system is completed, it needs to be tested and analyzed. In order to test the feasibility of student information management system and possible problems in all aspects. The test of student information management system consists of the main content and analysis of the test.
6. 1 User login function test
The user login function test mainly tests whether only users existing in the database can log in to the system under the premise of entering the correct password. See table 6- 1 for a test example of user login function.
Table 6- 1 User Login Test
The name of the test user login test.
The purpose of the test is to check whether there is any problem with the function of the user login interface of the system.
The prerequisite is to log in with three different identities.
The test procedure logs in with existing and non-existing administrator user names and passwords under the precondition.
Expected results Only the existing user name and the corresponding correct password in the database can successfully log in to the system.
The result of the test passed.
The name of the test user login test.
The purpose of the test is to check whether there is any problem with the function of the user login interface of the system.
The prerequisite is to log in with three different identities.
The test procedure logs in with existing and non-existing administrator user names and passwords under the precondition.
Expected results Only the existing user name and the corresponding correct password in the database can successfully log in to the system.
The result of the test passed.
According to the steps in the table, there is no problem. The user login function test is successful and meets the design purpose and requirements.
6.2 Management function test of all kinds of information
Every information management function test needs to test whether users can log in and whether students, teachers and administrators can use their own functions of adding, deleting and modifying information. Examples of management function test for modifying various information are shown in Table 6-2.
Table 6-2 Various Information of Management Function Test
The name of the test, information management function test.
The purpose of the test is to check whether the functions of adding, modifying and deleting in various information management functions of different users correspond.
The prerequisite is to log in with different identities (teachers, students, administrators) that already exist in the three system databases.
The test step (1) uses a student user to log in to the system and modify the password and add or delete personal information respectively. (2) Use teacher users to log in to the system, and modify passwords, add and delete student information respectively. (3) Log into the system as an administrator, and add, modify and delete teachers and students respectively.
Identities with different expected effects can log in with different permissions (add, delete and modify functions).
The result of the test passed.
The name of the test, information management function test.
The purpose of the test is to check whether the functions of adding, modifying and deleting in various information management functions of different users correspond.
The prerequisite is to log in with different identities (teachers, students, administrators) that already exist in the three system databases.
The test step (1) uses a student user to log in to the system and modify the password and add or delete personal information respectively. (2) Use teacher users to log in to the system, and modify passwords, add and delete student information respectively. (3) Log into the system as an administrator, and add, modify and delete teachers and students respectively.
Identities with different expected effects can log in with different permissions (add, delete and modify functions).
The result of the test passed.
According to the steps in the table, there is no problem, and all information management functions have passed smoothly, which meets the design purpose and requirements.
6.3 Excel Export Student Report Function Test
The function test of exporting students' scores needs to test the export operation of students' scores after the user logs in, and check whether the function of exporting students' report forms is normal. The functional test cases of Excel exporting student reports are shown in Table 6-3.
Table 6-3 Student Information Management Function Test
Test Name Excel Export Student Report Function Test
The purpose of the test is to check whether the function of exporting student report forms meets the requirements.
Pre-conditions use the existing information of teachers and administrators in the database to log in to the system.
Test steps: click on the score information management, click on the score list, click on the export operation, select the export directory, and export the student report.
The expected results usually lead to the function of the student report form.
The test results passed.
Test Name Excel Export Student Report Function Test
The purpose of the test is to check whether the function of exporting student report forms meets the requirements.
Pre-conditions use the existing information of teachers and administrators in the database to log in to the system.
Test steps: click on the score information management, click on the score list, click on the export operation, select the export directory, and export the student report.
The expected results usually lead to the function of the student report form.
The test results passed.
According to the steps in the table, there is no problem, and the student score export function of Excel has been successfully passed, achieving the design purpose and requirements.
abstract
The system mainly realizes administrator module, teacher module and student module, and mainly realizes the operation of adding, deleting, modifying and querying the data of teachers, students and courses in the system by the administrator. And the teacher's management of students' related information, such as students' grades and attendance information; As well as the modification of students' personal information and the view of course selection information and course results. Because the functions used are basically the same, the jump page is similar, and the difference is only the click event and the function. Save a lot of tedious jumping to different pages, design and realize the simplicity of interface design, and save the complexity of code.
Although this paper designs an information-based student information management system, due to the lack of personal ability and time, the design of this system is not perfect enough, and there are still some shortcomings in the system design. Because the mastery of Java and database is not complete, some difficult functions have not been completed. I will strengthen my understanding and study of Java and database, and then I will learn the mainstream SpringBoot framework to simplify the development process of the system, and add some middleware such as Redis to improve the robustness of the system.
Express gratitude/gratitude
Time flies, now suddenly looking back, I have been studying in Nanxin College for three years. I vaguely remember that ignorant boy looking up at Nanxin school gate. When I first entered school, I was still an ignorant person who couldn't tell the difference between changing jobs. After four years, our professional knowledge is excellent. This is due to the hard work and selfless dedication of teachers. Come with a heart, and don't take away half a blade of grass. Thanks to the teachers of Nanxin Institute! You led me to the academic hall, and you led me to swim in the ocean of knowledge. Under the teacher's inculcation, I broadened my horizons, deepened my thoughts and enriched my knowledge. Especially in the guidance of graduation thesis, teachers dare not slack off. From the beginning of the topic selection, the teacher devoted a lot of effort. Thanks to the teacher's inspiration, I chose to study the sunk cost effect. I feel very helpless in this sea of paper and books in Wang Yang. However, thanks to the guidance and help of the teacher, I am no longer afraid. I have the courage and patience to finish my task.
Then, I want to thank my thesis advisor, Mr. Li Jiang. His serious and responsible attitude and careful guidance have benefited me a lot. I am very grateful for the patient guidance. I am grateful to Nanjing Institute of Information Technology for providing me with such a learning opportunity, which made me feel deeply and further strengthened my mastery of software development technology. Then, I also thank my roommates for their warm help when I don't understand, so that I don't have to dwell on any problems all the time and relax a lot. Finally, thank everyone who has accompanied me through these three years. Because of you, life has become beautiful and learning has become happy.
refer to
1 Shi Jian. Development and Application of Training Competition Management System in Hainan Sports Vocational and Technical College [J]. Contemporary Style
Educational science and technology, 20 17.
2, Rao Yunbo. Computer culture foundation [M]. Beihang Press, 20
(09).
3 Zhao, a person. Mobile web front-end development. Beijing institute of technology press, 20 18, (09).
Song Xie Dong. Dreamweaver web page design and production. Beijing institute of technology press, 20 17, (07).
Fifty thousand Zheng, Luo, and Wan Changxuan. University computer foundation of computational thinking. Beijing Higher Education Press, 20 15, (02).
Sixty thousand Zheng, Luo, and Wan Changxuan. Principle and design of database system 3rd edition. Beijing Tsinghua University Publishing House, 20 17, (09).
7 Zhang Cong. Design of a multi-mode warehouse logistics distribution management system [J]. Shopping Mall Modernization, 20 17, (07): 86-87.
Yu Haiwei Design and Implementation of Handicraft Enterprise Management System [D]. Xiamen University, 20 17.
9 Fang Yinbin. Design and Implementation of Big Data Platform Based on Mobile Internet of Things [D]. University of Electronic Science and Technology of China, 20 14.
/kloc-0 0 dino esposito. Social authentication in MVC 4 in ASP.NET [J].MSDN Magazine, 2013,28 (5): 6-10.