代码11

。

录入个人信息

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;
import java.time.LocalDate;
import java.time.format.DateTimeFormatter;
import java.time.format.DateTimeParseException;

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

String name = request.getParameter("name");
String sex = request.getParameter("sex");
String birthdayStr = request.getParameter("birthday");

// 验证输入参数
String errorMessage = null;
if (name == null || name.trim().isEmpty()) {
errorMessage = "姓名不能为空";
} else if (sex == null || (!sex.equals("男") && !sex.equals("女"))) {
errorMessage = "性别必须为“男”或“女”";
} else {
try {
LocalDate.parse(birthdayStr, DateTimeFormatter.ofPattern("yyyy-MM-dd"));
} catch (DateTimeParseException e) {
errorMessage = "生日格式不正确，应为 yyyy-MM-dd";
}
}

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

try (Connection connection = Database.getConnection();
PreparedStatement statement = connection.prepareStatement("update zhiyuan set sex=?, birthday=? where name=?")) {

statement.setString(1, sex);
statement.setDate(2, java.sql.Date.valueOf(LocalDate.parse(birthdayStr, DateTimeFormatter.ofPattern("yyyy-MM-dd"))));
statement.setString(3, name);

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