大学生系统开发 - 分页查询和新增学生功能实现 - 常规

Language and Environment\n1.1 Implementation Language\nJSP+Servlet\n1.2 Environment Requirements\nJDK 8, MySQL 5.5 or above.\n2. Functional Requirements\n2.1 Overview of Functionality\nUse JSP+Servlet to implement partial functionality of a college student system (pagination query of student information and add student functionality), with MySQL as the backend database.\nThe main functionalities to be implemented include:\n- Paginate and view all student information (student ID, name, gender, major, phone number, email)\n- Search student information by fuzzy name\n- Check for duplicate student IDs\n2.2 Specific Business Functional Requirements\n2.2.1 Query Student Information by Conditions\nFunction 1: Open the student management page. If no query condition is entered, query all student information and display the first page of student information using pagination.\nFunction 2: Sort the displayed student list by student ID in ascending order.\nFunction 3: Dynamically retrieve the student's major from the major table.\nFunction 4: Perform a fuzzy search for student information based on the student's name.\n\n(Image 1)\nIf a query condition is entered, search for students with similar names and display them in the list.\n\n(Image 2)\n2.2.2 Add 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 "Return" to directly return to the original student information list.\n\n(Image 3)\nWhen a duplicate student ID is entered, display a prompt dialogue.\n\n2.3 Database Requirements\n2.3.1 Database Table Design Specifications\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 letters are not allowed\n2.3.2 Database Table Design Reference\n- The major table includes primary key, major name, and other fields.\n- The student table includes primary key, student name, student ID, gender, phone number, and email.\n3. Grading Criteria\nNumber\tAssessment Item\tPoints\n1\tCorrectly creating the database\t10\n2\tProgram connecting to the database\t10\n3\tAbility to display information on the page\t10\n4\tCorrect implementation of pagination functionality\t20\n5\tImplementation of fuzzy query functionality\t20\n5\tCorrect implementation of adding student information\t15\n7\tImplementation of checking for duplicate student IDs\t15\n8\tCorrect implementation of sorting\t5\n9\tNo exception handling\t-10\n10\tNot correctly using transactions\t-10\n11\tNot following the database table design specifications\t-10\n12\tNot following the code naming conventions\t-5\n14\tNot following the code formatting conventions\t-5\n15\tNot following the code commenting conventions\t-5