2024/4/8

<%@ page import="java.sql.*" %>
<%@ page import="java.io.PrintWriter" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
String url= "jdbc:mysql://localhost:3306/fish?serverTimezone=UTC&useSSL=false&characterEncoding=UTF-8";
String user="root";
String password="123456";

String jobid = (String) session.getAttribute("jobid");
String oldPassword = request.getParameter("oldPassword");
String newPassword = request.getParameter("newPassword");

try {
Class.forName("com.mysql.cj.jdbc.Driver");
Connection conn = DriverManager.getConnection(url, user, password);
String sql = "UPDATE message1 SET password=? WHERE jobid=? AND password=?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, newPassword);
pstmt.setString(2, jobid);
pstmt.setString(3, oldPassword);
int rowsUpdated = pstmt.executeUpdate();
if (rowsUpdated > 0) {
out.println("修改成功");
} else {
out.println("修改失败");
}
} catch (Exception e) {
out.println("有个错误: " + e.getMessage());
}
%>