在使用java.time.LocalDateTime时如何将脚本中的日期和时间插入PostgreSQL数据库

LocalDateTime dateTime = LocalDateTime.now();

String url = "jdbc:postgresql://localhost:5432/mydatabase";
String username = "myusername";
String password = "mypassword";

Connection connection = null;
PreparedStatement statement = null;

try {
    connection = DriverManager.getConnection(url, username, password);
    
    // 创建插入语句
    String sql = "INSERT INTO mytable (datetime_column) VALUES (?)";
    statement = connection.prepareStatement(sql);
    
    // 设置参数
    statement.setObject(1, dateTime);
    
    // 执行插入语句
    statement.executeUpdate();
    
    System.out.println("数据插入成功！");
} catch (SQLException e) {
    e.printStackTrace();
} finally {
    // 关闭连接和语句
    try {
        if (statement != null) {
            statement.close();
        }
        if (connection != null) {
            connection.close();
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}