Record a project experience and technologies encountered in the project

project ： Student management system

The main purpose is to facilitate personal review and sorting , There is no other use .

Technical support ： Java、Servlet、mysql、DBUtils Connection pool 、jsp Dynamic pages 、jQuery、Ajax、Filter filter ,EL expression 、jstl.
lib:druid-1.0.9.jar 、jstl.jar、mysql-connector-java-8.0.16.jar 、standard.jar、javaee-api-7.0.jar
Software used ：IDEA2021.3、Navicat Premium 15、tomcat 8.5.34

Main functions ：

Basic function ：

1. Login function
   1.1 Verification of user name, password and database
   1.2 Wrong user name and password , Page prompt
   1.3 Sign in establish session
2. New students
   2.1 Student information Page required verification + Enter the database
3. Delete students
   3.1 Delete student information + Delete student information from the database
4. Modify student information
   4.1 Student number input Read only grayed out and cannot be selected +jquery Realization
   4.2 Save after modification + Update the database
5. Look up the list of students
   5.1 Dynamic query student information + Query the database
6. Fuzzy query
   6.1 Fuzzy query according to the student's name %stuName%
   6.2 Query according to the student number
   6.3 Query according to students' gender
7. Page navigation
   7.1 home page The previous page The next page Tail page Jump +EL expression

Improve supplementary functions ：

1. ajax+jquery+servlet Realize the repeated asynchronous verification of the student number of new students
2. filter+web.xml +Session Filter implementation , Illegal access to other pages by non logged in users

Recording time 2022/1/3