使用Java在Postgresql中输入Date值

   <groupId>org.postgresql</groupId>
   <artifactId>postgresql</artifactId>
   <version>42.2.23</version>
</dependency>

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.time.LocalDate;

public class Main {
    public static void main(String[] args) {
        String url = "jdbc:postgresql://localhost:5432/my_database";
        String user = "my_user";
        String password = "my_password";

        try {
            // 加载驱动
            Class.forName("org.postgresql.Driver");

            // 建立连接
            Connection conn = DriverManager.getConnection(url, user, password);

            // 创建插入语句
            String sql = "INSERT INTO my_table (date_column) VALUES (?)";
            PreparedStatement pstmt = conn.prepareStatement(sql);

            // 设置Date值
            LocalDate dateValue = LocalDate.of(2022, 1, 1);
            pstmt.setDate(1, java.sql.Date.valueOf(dateValue));

            // 执行插入
            pstmt.executeUpdate();

            // 关闭连接
            pstmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}