jsp操作mysql修改

<%@ page import="java.sql.*" %>
<%
    String url = "jdbc:mysql://localhost:3306/mydatabase";
    String username = "root";
    String password = "password";

    try {
        // 加载MySQL JDBC驱动
        Class.forName("com.mysql.cj.jdbc.Driver");

        // 建立数据库连接
        Connection conn = DriverManager.getConnection(url, username, password);

        // 创建SQL语句
        String sql = "UPDATE users SET email = ? WHERE id = ?";
        PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, "newemail@example.com");
        pstmt.setInt(2, 1);

        // 执行更新操作
        int rowsUpdated = pstmt.executeUpdate();

        // 关闭资源
        pstmt.close();
        conn.close();

        out.println("Rows updated: " + rowsUpdated);
    } catch (ClassNotFoundException | SQLException e) {
        out.println("Error: " + e.getMessage());
    }
%>