代码6

对身体各项成绩的增删改查

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.*;

@WebServlet("/demo9/departmentupdateservlet")
public class departmentupdateservlet extends HttpServlet {
private static final long serialVersionUID = 1L;

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String departmentId = request.getParameter("departmentid");
String newDepartmentName = request.getParameter("department");

// 检查部门名称格式（这里简单示例，实际可能需要更复杂的正则表达式）
if (!isValidDepartmentName(newDepartmentName)) {
request.setAttribute("error", "部门名称格式不正确");
request.getRequestDispatcher("departmentupdate.jsp").forward(request, response);
return;
}

// 检查部门名称是否与现有名称冲突
try {
if (isDepartmentNameExists(newDepartmentName)) {
request.setAttribute("error", "部门名称已存在");
request.getRequestDispatcher("departmentupdate.jsp").forward(request, response);
return;
}
} catch (SQLException e) {
throw new RuntimeException(e);
}

// 如果验证通过，执行更新操作
try {
Connection con = getConnection();
String sql = "UPDATE department SET name=? WHERE id=?";
PreparedStatement pst = con.prepareStatement(sql);
pst.setString(1, newDepartmentName);
pst.setString(2, departmentId);
pst.executeUpdate();
pst.close();
con.close();
// 重定向或转发到成功页面
response.sendRedirect("guanliyuan.jsp");
} catch (SQLException e) {
e.printStackTrace();
request.setAttribute("error", "更新失败");
request.getRequestDispatcher("departmentupdate.jsp").forward(request, response);
}
}

private boolean isValidDepartmentName(String departmentName) {
// 这里简单示例，实际可能需要更复杂的正则表达式
return departmentName.matches("[a-zA-Z0-9_ ]+");
}

private boolean isDepartmentNameExists(String departmentName) throws SQLException {
Connection con = getConnection();
String sql = "SELECT * FROM department WHERE name=?";
PreparedStatement pst = con.prepareStatement(sql);
pst.setString(1, departmentName);
ResultSet rs = pst.executeQuery();
boolean exists = rs.next();
rs.close();
pst.close();
con.close();
return exists;
}

private Connection getConnection() throws SQLException {
// 这里假设你有一个获取数据库连接的方法，需要根据实际情况修改
return DriverManager.getConnection("jdbc:mysql://kaoqin@localhost/kaoqin", "username", "password");
}
}