代码3

database.java

package cn.edu.tyut.demo13;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Database {
//连接数据库
public static Connection getConnection() throws SQLException, ClassNotFoundException {
String driver = "com.mysql.cj.jdbc.Driver";
String url = "jdbc:mysql://kaoqin@localhost/kaoqin";
String user = "root";
String password = "Shlock36127";
Class.forName(driver);
Connection connection = DriverManager.getConnection(url, user, password);

    return connection;
}

}

身体健康程度的参考

package cn.edu.tyut.demo13;

//新添部门基本信息

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

@WebServlet("/departmentaddservlet")
public class departmentaddservlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
request.setCharacterEncoding("utf-8");
String departmentid = request.getParameter("departmentid");
String department = request.getParameter("department");

    // 验证输入参数
    String errorMessage = null;
    if (departmentid == null || !departmentid.matches("01|02|03")) {
        errorMessage = "部门编码必须为 01、02 或 03";
    } else if (department == null || department.trim().isEmpty()) {
        errorMessage = "部门名称不能为空";
    }

    if (errorMessage != null) {
        request.setAttribute("errorMessage", errorMessage);
        request.getRequestDispatcher("departmentadd.jsp").forward(request, response);
        return;
    }

    try (Connection connection = Database.getConnection();
         PreparedStatement statement = connection.prepareStatement("INSERT INTO department (departmentid, department) VALUES (?, ?)")) {
        statement.setString(1, departmentid);
        statement.setString(2, department);

        int rowsAffected = statement.executeUpdate();
        if (rowsAffected > 0) {
            // 提示录入成功
            response.sendRedirect("guanliyuan.jsp");
        } else {
            errorMessage = "插入数据失败";
            request.setAttribute("errorMessage", errorMessage);
            request.getRequestDispatcher("departmentadd.jsp").forward(request, response);
        }
    } catch (SQLException | ClassNotFoundException e) {
        errorMessage = "数据库操作失败";
        request.setAttribute("errorMessage", errorMessage);
        request.getRequestDispatcher("departmentadd.jsp").forward(request, response);
    }
}

}