在SQLite数据库中插入LocalDate

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

public class SQLiteExample {
    public static void main(String[] args) {
        String url = "jdbc:sqlite:/path/to/database.db";
        String sql = "INSERT INTO my_table (date_column) VALUES (?)";

        try (Connection conn = DriverManager.getConnection(url);
             PreparedStatement pstmt = conn.prepareStatement(sql)) {

            LocalDate date = LocalDate.now();
            pstmt.setDate(1, java.sql.Date.valueOf(date));
            pstmt.executeUpdate();

            System.out.println("Data inserted successfully.");

        } catch (SQLException e) {
            System.out.println(e.getMessage());
        }
    }
}