以下是一个简单的JSP+Servlet实现的大学生管理系统的代码示例：\n\n1. 数据库设计\n\n数据库名称：student_course\n\n表名：t_major\n列名：id（主键）、name（专业名称）\n\n表名：t_student\n列名：id（主键）、name（学生姓名）、student_number（学生学号）、gender（学生性别）、phone（学生手机号）、email（学生的email）\n\n2. JSP页面\n\nindex.jsp：\n```jsp\n<%@page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

学生管理系统

<table border="1">
    <tr>
        <th>学号</th>
        <th>姓名</th>
        <th>性别</th>
        <th>所属专业</th>
        <th>手机号码</th>
        <th>Email</th>
    </tr>
    <c:forEach var="student" items="${students}">
        <tr>
            <td>${student.studentNumber}</td>
            <td>${student.name}</td>
            <td>${student.gender}</td>
            <td>${student.major}</td>
            <td>${student.phone}</td>
            <td>${student.email}</td>
        </tr>
    </c:forEach>
</table>

<a href="addStudent.jsp">新增学生</a>

```\n\naddStudent.jsp：\n```jsp\n<%@page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

新增学生

姓名：
性别： 男 女
所属专业： ${major}
手机号码：
Email：

<a href="index.jsp">返回</a>

```\n\n3. Servlet代码\n\nStudentListServlet.java：\n```java\nimport java.io.IOException;\nimport java.sql.Connection;\nimport java.sql.DriverManager;\nimport java.sql.PreparedStatement;\nimport java.sql.ResultSet;\nimport java.sql.SQLException;\nimport java.util.ArrayList;\nimport java.util.List;\n\nimport javax.servlet.ServletException;\nimport javax.servlet.annotation.WebServlet;\nimport javax.servlet.http.HttpServlet;\nimport javax.servlet.http.HttpServletRequest;\nimport javax.servlet.http.HttpServletResponse;\n\n@WebServlet("/studentListServlet")\npublic class StudentListServlet extends HttpServlet {\n private static final long serialVersionUID = 1L;\n \n private static final String URL = "jdbc:mysql://localhost:3306/student_course?useUnicode=true&characterEncoding=utf8mb4";\n private static final String USERNAME = "root";\n private static final String PASSWORD = "password";\n \n protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {\n String name = request.getParameter("name");\n \n List students = new ArrayList<>();\n \n try (Connection conn = DriverManager.getConnection(URL, USERNAME, PASSWORD)) {\n String sql;\n if (name != null && !name.isEmpty()) {\n sql = "SELECT s.student_number, s.name, s.gender, m.name AS major, s.phone, s.email "\n + "FROM t_student s "\n + "INNER JOIN t_major m ON s.major_id = m.id "\n + "WHERE s.name LIKE ?";\n } else {\n sql = "SELECT s.student_number, s.name, s.gender, m.name AS major, s.phone, s.email "\n + "FROM t_student s "\n + "INNER JOIN t_major m ON s.major_id = m.id";\n }\n \n try (PreparedStatement stmt = conn.prepareStatement(sql)) {\n if (name != null && !name.isEmpty()) {\n stmt.setString(1, "%" + name + "%");\n }\n \n try (ResultSet rs = stmt.executeQuery()) {\n while (rs.next()) {\n Student student = new Student();\n student.setStudentNumber(rs.getString("student_number"));\n student.setName(rs.getString("name"));\n student.setGender(rs.getString("gender"));\n student.setMajor(rs.getString("major"));\n student.setPhone(rs.getString("phone"));\n student.setEmail(rs.getString("email"));\n students.add(student);\n }\n }\n }\n } catch (SQLException e) {\n e.printStackTrace();\n }\n \n request.setAttribute("students", students);\n request.getRequestDispatcher("index.jsp").forward(request, response);\n }\n}\n```\n\nAddStudentServlet.java：\n```java\nimport java.io.IOException;\nimport java.sql.Connection;\nimport java.sql.DriverManager;\nimport java.sql.PreparedStatement;\nimport java.sql.ResultSet;\nimport java.sql.SQLException;\nimport java.util.ArrayList;\nimport java.util.List;\n\nimport javax.servlet.ServletException;\nimport javax.servlet.annotation.WebServlet;\nimport javax.servlet.http.HttpServlet;\nimport javax.servlet.http.HttpServletRequest;\nimport javax.servlet.http.HttpServletResponse;\n\n@WebServlet("/addStudentServlet")\npublic class AddStudentServlet extends HttpServlet {\n private static final long serialVersionUID = 1L;\n \n private static final String URL = "jdbc:mysql://localhost:3306/student_course?useUnicode=true&characterEncoding=utf8mb4";\n private static final String USERNAME = "root";\n private static final String PASSWORD = "password";\n \n protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {\n String name = request.getParameter("name");\n String gender = request.getParameter("gender");\n String major = request.getParameter("major");\n String phone = request.getParameter("phone");\n String email = request.getParameter("email");\n \n try (Connection conn = DriverManager.getConnection(URL, USERNAME, PASSWORD)) {\n String sql = "INSERT INTO t_student (name, gender, major_id, phone, email) "\n + "VALUES (?, ?, (SELECT id FROM t_major WHERE name = ?), ?, ?)";\n \n try (PreparedStatement stmt = conn.prepareStatement(sql)) {\n stmt.setString(1, name);\n stmt.setString(2, gender);\n stmt.setString(3, major);\n stmt.setString(4, phone);\n stmt.setString(5, email);\n \n stmt.executeUpdate();\n }\n } catch (SQLException e) {\n e.printStackTrace();\n }\n \n response.sendRedirect("index.jsp");\n }\n}\n```\n\n4. 数据库连接配置\n\n在WEB-INF目录下创建一个web.xml文件，并添加以下配置：\n```xml\n\n student-management-system

<welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
</welcome-file-list>

<error-page>
    <error-code>404</error-code>
    <location>/error404.jsp</location>
</error-page>

<servlet>
    <servlet-name>default</servlet-name>
    <servlet-class>org.apache.catalina.servlets.DefaultServlet</servlet-class>
    <init-param>
        <param-name>listings</param-name>
        <param-value>false</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
</servlet>

<servlet>
    <servlet-name>studentListServlet</servlet-name>
    <servlet-class>com.example.StudentListServlet</servlet-class>
</servlet>

<servlet>
    <servlet-name>addStudentServlet</servlet-name>
    <servlet-class>com.example.AddStudentServlet</servlet-class>
</servlet>

<servlet-mapping>
    <servlet-name>studentListServlet</servlet-name>
    <url-pattern>/studentListServlet</url-pattern>
</servlet-mapping>

<servlet-mapping>
    <servlet-name>addStudentServlet</servlet-name>
    <url-pattern>/addStudentServlet</url-pattern>
</servlet-mapping>

```\n\n注意：将以上代码中的数据库连接URL、用户名和密码更改为实际的数据库配置。\n\n以上是一个简单的JSP+Servlet实现的大学生管理系统的代码示例。根据需求，通过分页查询学生信息和新增学生功能，实现了对学生信息的展示和管理。