JSP 机试测试：大学生管理系统 - 完整功能实现与评分标准

"JSP Machine Test: College Student Management System"\n\n1 Language and Environment\n1.1 Language Used\nJSP+Servlet\n1.2 Environment Requirements\nJDK 8, MySQL version 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- Pagination for viewing all student information (student ID, name, gender, major, phone number, email)\n- Fuzzy search for student information based on name\n- Check for duplicate student IDs\n\n2.2 Specific Business Functionality Requirements\n2.2.1 Search Student Information Based on Conditions\nFunctionality 1: Open the student management page. If no search conditions are entered, query all student information. By default, display the first page of student information using pagination.\nFunctionality 2: Sort the displayed student list in ascending order based on student ID.\nFunctionality 3: Read the student's major from the major table dynamically.\nFunctionality 4: Perform a fuzzy search for student information based on name.\n\n(Image 1)\nIf search conditions are entered, search for students with similar names and display them in the list.\n\n(Image 2)\n\n2.2.2 Add Student Information\nFunctionality 1: Click the "Add Student" button on the list page to navigate to the page for adding a new student.\nFunctionality 2: Click the "Submit" button to save the information to the database.\nFunctionality 3: Student name, major, gender, phone number, and email are required fields.\nFunctionality 4: After submission, return to the student information list.\nFunctionality 5: Click "Return" to directly return to the original student information list.\n\n(Image 3)\nPrompt box when student ID is duplicated.\n\n2.3 Database Requirements\n2.3.1 Design Specifications for Database Tables\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, no uppercase 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\tEvaluation Item\tPoints\n1\tSuccessfully creating the database\t10\n2\tEstablishing a successful connection to the database\t10\n3\tAbility to display information on the webpage\t10\n4\tProper implementation of pagination functionality\t20\n5\tImplementation of fuzzy search functionality\t20\n5\tProper implementation of student information addition\t15\n7\tImplementation of duplicate student ID check\t15\n8\tCorrect implementation of sorting\t5\n9\tNo exception handling\t-10\n10\tNot using transactions correctly\t-10\n11\tNot following the database table design specifications\t-10\n12\tNot following code naming conventions\t-5\n14\tNot following code formatting conventions\t-5\n15\tNot following code commenting conventions\t-5