使用SQL语句通过Java更新文档中的r_creation_name

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class UpdateDocument {
    public static void main(String[] args) {
        // 数据库连接信息
        String url = "jdbc:mysql://localhost:3306/database_name";
        String username = "username";
        String password = "password";

        // SQL语句
        String sql = "UPDATE document_table SET r_creation_name = ? WHERE document_id = ?";

        try {
            // 连接数据库
            Connection connection = DriverManager.getConnection(url, username, password);

            // 创建PreparedStatement对象
            PreparedStatement statement = connection.prepareStatement(sql);

            // 设置参数
            statement.setString(1, "new_value");
            statement.setInt(2, documentId);

            // 执行SQL语句
            int rowsAffected = statement.executeUpdate();
            System.out.println("更新了 " + rowsAffected + " 行数据。");

            // 关闭连接
            statement.close();
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}