try (ResultSet rs = stmt.executeQuery("SELECT * FROM time_table")) {
    while (rs.next()) {
        LocalDate date = rs.getObject("date_column", LocalDate.class);
        LocalTime time = rs.getObject("time_column", LocalTime.class);
        LocalDateTime dateTime = rs.getObject("datetime_column", LocalDateTime.class);
        Instant timestamp = rs.getObject("ts_column", Instant.class);
    }
}

PreparedStatement ps = conn.prepareStatement(
    "INSERT INTO time_table (date_column, time_column, datetime_column, ts_column) " +
    "VALUES (?, ?, ?, ?)");
    
ps.setObject(1, LocalDate.now());
ps.setObject(2, LocalTime.now());
ps.setObject(3, LocalDateTime.now());
ps.setObject(4, Instant.now());

ps.executeUpdate();

// Java 端處理微秒（MySQL DATETIME(6)）
LocalDateTime ldt = LocalDateTime.now()
    .withNano(456000000); // 456毫秒

// MySQL 創(chuàng)建表
CREATE TABLE events (
    event_time DATETIME(6) // 支持微秒級(jí)精度
);

// 寫入統(tǒng)一使用 UTC 時(shí)間
ps.setObject(4, Instant.now()); // UTC 時(shí)間戳

// 讀取時(shí)轉(zhuǎn)換為本地時(shí)間
Instant dbTime = rs.getObject("event_time", Instant.class);
ZonedDateTime localTime = dbTime.atZone(ZoneId.systemDefault());

-- 檢查時(shí)區(qū)設(shè)置
SELECT @@global.time_zone, @@session.time_zone;

-- 推薦設(shè)置為 UTC
SET GLOBAL time_zone = '+00:00';

LocalDate start = LocalDate.of(2023, 1, 1);
LocalDate end = LocalDate.of(2023, 12, 31);

PreparedStatement ps = conn.prepareStatement(
    "SELECT * FROM orders WHERE order_date BETWEEN ? AND ?");
    
ps.setObject(1, start);
ps.setObject(2, end);

Instant startInstant = ZonedDateTime.of(
    2023, 5, 1, 0, 0, 0, 0, 
    ZoneId.of("Asia/Shanghai")).toInstant();

PreparedStatement ps = conn.prepareStatement(
    "SELECT * FROM transactions WHERE create_time >= ?");
    
ps.setObject(1, startInstant);

LocalDateTime orderTime = rs.getObject("order_time", LocalDateTime.class);
LocalDateTime deliveryTime = rs.getObject("delivery_time", LocalDateTime.class);

Duration interval = Duration.between(orderTime, deliveryTime);
System.out.printf("配送耗時(shí): %.1f小時(shí)", interval.toMinutes() / 60.0);

// 傳統(tǒng)轉(zhuǎn)現(xiàn)代
Timestamp ts = rs.getTimestamp("create_time");
LocalDateTime ldt = ts.toLocalDateTime();

// 現(xiàn)代轉(zhuǎn)傳統(tǒng)
LocalDateTime now = LocalDateTime.now();
Timestamp ts = Timestamp.valueOf(now);

graph LR
    A[業(yè)務(wù)系統(tǒng)時(shí)間\nLocalDateTime] -->|應(yīng)用時(shí)區(qū)| B[JVM 默認(rèn)時(shí)區(qū)]
    B -->|轉(zhuǎn)換為UTC| C[Instant/UTC時(shí)間]
    C -->|存儲(chǔ)至MySQL| D[TIMESTAMP列]
    D -->|讀取為Instant| E[Java Instant類型]
    E -->|轉(zhuǎn)換至目標(biāo)時(shí)區(qū)| F[用戶時(shí)區(qū)顯示]