JSP 机试测试：大学生管理系统 - 实现分页查询和新增学生功能

JSP Machine Test: College Student Management System\n\n1 Language and Environment\n1.1 Programming Language\nJSP+Servlet\n1.2 Environment Requirements\nJDK 8, MySQL 5.5 or above.\n\n2 Functional Requirements\n2.1 Overview of Functionality\nImplement partial functionality of a college student management system using JSP+Servlet, with MySQL as the backend database.\nThe main functionalities to be implemented include:\n- Paginated view of all student information (student ID, name, gender, major, phone number, email)\n- Fuzzy search student information by name\n- Check for duplicate student ID\n\n2.2 Specific Business Functional Requirements\n2.2.1 Query Student Information based on Conditions\nFunction 1: Open the student management page. If no search criteria are entered, query all student information and display the first page using pagination.\nFunction 2: Sort the displayed student list in ascending order by student ID.\nFunction 3: Retrieve the student's major from the major table dynamically.\nFunction 4: Fuzzy search student information based on name.\n\n(Image 1)\nIf search criteria are entered, fuzzy search the students by name and display the results in the list.\n\n(Image 2)\n2.2.2 Add New Student Information\nFunction 1: Click the "Add Student" button on the list page to navigate to the page for adding a new student.\nFunction 2: Click the "Submit" button to save the information to the database.\nFunction 3: Student name, major, gender, phone number, and email are required fields.\nFunction 4: After submission, return to the student information list.\nFunction 5: Click "Back" to directly return to the original student information list.\n\n(Image 3)\nWhen the student ID is duplicated, display a prompt.\n\n2.3 Database Requirements\n2.3.1 Database Table Design Guidelines\n- Database Name: student_course\n- Database character set encoding: utf8mb4\n- Table names should start with "t_".\n- Table and column names should be in lowercase, uppercase characters are not allowed.\n\n2.3.2 Database Table Design Reference\n- Major table includes primary key, major name, and other fields.\n- Student table includes primary key, student name, student ID, gender, phone number, and email.\n\n3 Grading Criteria\nNumber\tAssessment Item\tScore\n1\tCorrectly create the database\t10\n2\tProgram successfully connects to the database\t10\n3\tAbility to display information on the page\t10\n4\tCorrectly implement pagination functionality\t20\n5\tImplement fuzzy search functionality\t20\n5\tCorrectly implement student information addition\t15\n7\tImplement duplicate student ID check\t15\n8\tCorrect implementation of sorting\t5\n9\tNo exception handling\t-10\n10\tNo proper use of transactions\t-10\n11\tDoes not adhere to database table design guidelines\t-10\n12\tDoes not adhere to code naming conventions\t-5\n14\tDoes not adhere to code formatting guidelines\t-5\n15\tDoes not adhere to code commenting guidelines\t-5