如何使用Payara Micro将LocalDate保存到Postgres

import org.postgresql.ds.PGSimpleDataSource;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.time.LocalDate;

public void saveLocalDate(LocalDate localDate) {
    try {
        // 创建PostgreSQL数据源
        PGSimpleDataSource dataSource = new PGSimpleDataSource();
        dataSource.setServerName("localhost");
        dataSource.setPortNumber(5432);
        dataSource.setDatabaseName("your_database_name");
        dataSource.setUser("your_username");
        dataSource.setPassword("your_password");

        // 获取数据库连接
        Connection connection = dataSource.getConnection();

        // 创建SQL语句
        String sql = "INSERT INTO your_table_name (date_column) VALUES (?)";

        // 创建预编译语句
        PreparedStatement statement = connection.prepareStatement(sql);

        // 设置参数
        statement.setObject(1, localDate);

        // 执行SQL语句
        statement.executeUpdate();

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