从long转换为Insert into DB的时间戳

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

public class TimestampConversionExample {
    public static void main(String[] args) {
        long timestamp = 1634567890000L; // 示例long类型的时间戳

        // 将long类型的时间戳转换为日期时间格式
        Date date = new Date(timestamp);

        // 将日期时间格式的时间戳转换为MySQL支持的时间戳格式
        java.sql.Timestamp sqlTimestamp = new java.sql.Timestamp(date.getTime());

        // 连接到MySQL数据库
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "root";
        String password = "password";
        try (Connection connection = DriverManager.getConnection(url, username, password)) {
            // 插入时间戳到数据库表中
            String sql = "INSERT INTO mytable (timestamp_column) VALUES (?)";
            PreparedStatement statement = connection.prepareStatement(sql);
            statement.setTimestamp(1, sqlTimestamp);
            statement.executeUpdate();
            System.out.println("时间戳插入成功！");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}