jsp连接mysql更新数据库代码

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.27</version>
</dependency>

<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>

<%
// 定义数据库连接信息
String url = "jdbc:mysql://localhost:3306/mydatabase";
String username = "root";
String password = "password";

Connection connection = null;
PreparedStatement statement = null;

try {
    // 创建数据库连接
    Class.forName("com.mysql.cj.jdbc.Driver");
    connection = DriverManager.getConnection(url, username, password);

    // 定义更新语句
    String sql = "UPDATE users SET name = ? WHERE id = ?";

    // 创建PreparedStatement对象
    statement = connection.prepareStatement(sql);
    statement.setString(1, "John"); // 设置更新后的姓名
    statement.setInt(2, 1); // 设置更新条件，假设用户ID为1

    // 执行更新操作
    int rowsUpdated = statement.executeUpdate();
    
    out.println("成功更新了 " + rowsUpdated + " 行数据！");
} catch (Exception e) {
    out.println("更新数据时发生错误: " + e.getMessage());
} finally {
    // 关闭连接和释放资源
    if (statement != null) {
        statement.close();
    }
    if (connection != null) {
        connection.close();
    }
}
%>