代码4

。。

某指标的删除

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.ResultSet;
import java.sql.SQLException;

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

    try (Connection connection = Database.getConnection()) {
        // 检查部门是否有员工
        String checkSql = "SELECT COUNT(*) FROM zhiyuan WHERE department= ?";
        try (PreparedStatement checkStatement = connection.prepareStatement(checkSql)) {
            checkStatement.setString(1, department);
            ResultSet resultSet = checkStatement.executeQuery();
            resultSet.next();
            int employeeCount = resultSet.getInt(1);

            if (employeeCount > 0) {
                // 部门有员工，不能删除
                request.setAttribute("errorMessage", "该部门有员工，无法删除");
                request.getRequestDispatcher("departmentdelete.jsp").forward(request, response);
                return;
            }
        }

        // 执行删除操作
        String deleteSql = "DELETE FROM department WHERE department = ?";
        try (PreparedStatement deleteStatement = connection.prepareStatement(deleteSql)) {
            deleteStatement.setString(1, department);

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

}

身体指标各成绩相加

package cn.edu.tyut.demo13;

public class departmentpojo {
private int departmentid;
private String departmentname;

public int getDepartmentid() {
    return departmentid;
}

public void setDepartmentid(int departmentid) {
    this.departmentid = departmentid;
}

public String getDepartmentname() {
    return departmentname;
}

public void setDepartmentname(String departmentname) {
    this.departmentname = departmentname;
}

@Override
public String toString() {
    return "departmentpojo{" +
            "departmentid=" + departmentid +
            ", departmentname='" + departmentname + '\'' +
            '}';
}

}