jsp更新mysql

<%@ page import="java.sql.*" %>
<%
    String url = "jdbc:mysql://localhost:3306/mydatabase";
    String username = "root";
    String password = "password";
    
    Connection conn = null;
    PreparedStatement pstmt = null;
    
    try {
        // 加载JDBC驱动
        Class.forName("com.mysql.jdbc.Driver");
        
        // 建立数据库连接
        conn = DriverManager.getConnection(url, username, password);
        
        // 编写SQL更新语句
        String sql = "UPDATE users SET name = ? WHERE id = ?";
        pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, "New Name");
        pstmt.setInt(2, 1);
        
        // 执行SQL更新语句
        int result = pstmt.executeUpdate();
        
        if (result > 0) {
            out.println("更新成功！");
        } else {
            out.println("更新失败！");
        }
    } catch (Exception e) {
        out.println("数据库操作异常：" + e.getMessage());
    } finally {
        // 关闭资源
        if (pstmt != null) pstmt.close();
        if (conn != null) conn.close();
    }
%>