Java存mysql时间

LocalDateTime now = LocalDateTime.now();
String sql = "INSERT INTO your_table (datetime_column) VALUES (?)";
try (PreparedStatement pstmt = connection.prepareStatement(sql)) {
    pstmt.setObject(1, now);
    pstmt.executeUpdate();
} catch (SQLException e) {
    e.printStackTrace();
}

String sql = "SELECT datetime_column FROM your_table WHERE id = ?";
try (PreparedStatement pstmt = connection.prepareStatement(sql)) {
    pstmt.setInt(1, yourId);
    try (ResultSet rs = pstmt.executeQuery()) {
        if (rs.next()) {
            LocalDateTime dateTime = rs.getObject("datetime_column", LocalDateTime.class);
            System.out.println(dateTime);
        }
    }
} catch (SQLException e) {
    e.printStackTrace();
}

ZonedDateTime now = ZonedDateTime.now(ZoneId.of("UTC"));
// 存储和读取时同样需要考虑时区