jsp操作mysql修改密码

<%@ page import="java.sql.*" %>
<%
    String url = "jdbc:mysql://localhost:3306/mydatabase";
    String username = "dbuser";
    String password = "dbpass";
    String userId = request.getParameter("userId");
    String newPassword = request.getParameter("newPassword");

    try {
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection(url, username, password);
        String sql = "UPDATE users SET password = ? WHERE id = ?";
        PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, newPassword);
        pstmt.setInt(2, Integer.parseInt(userId));
        int rowsUpdated = pstmt.executeUpdate();
        if (rowsUpdated > 0) {
            out.println("Password updated successfully.");
        } else {
            out.println("No user found with the given ID.");
        }
        pstmt.close();
        conn.close();
    } catch (ClassNotFoundException | SQLException e) {
        out.println("Error: " + e.getMessage());
    }
%>