如何在没有 JDBC 4.2 驱动程序的情况下从 java.sql.Timestamp 获取 java.time 对象? [英] How to get a java.time object from a java.sql.Timestamp without a JDBC 4.2 driver?

问题描述

检索 java.sql.Timestamp 时通过 JDBC 4.1 或更早版本从数据库中获取/转换为 java.time 对象?

When retrieving a java.sql.Timestamp from a database via JDBC 4.1 or earlier, how does one obtain/convert to a java.time object?

Postgres 的开源 JDBC 驱动程序均不符合 JDBC 4.2，因此我正在寻找一种将 java.time 与 JDBC 4.1 结合使用的方法.

Neither of the open-source JDBC drivers for Postgres is JDBC 4.2 compliant yet, so I'm looking for a way to use use java.time with JDBC 4.1.

推荐答案

旧类的新方法

通过在 Java 8 及更高版本中使用驱动程序，您应该会自动在您的 java.sql.Timestamp 对象免费.java.sql.Time 和java.sql.Date 有类似的转换方法.

New Methods On Old Classes

By using the driver with Java 8 and later, you should automatically pick up some methods on your java.sql.Timestamp object for free. Both java.sql.Time and java.sql.Date have similar conversion methods.

即，从 java.sql 转换为 java.time 你正在寻找:

Namely, to convert from java.sql to java.time you are looking for:

• Timestamp::toInstant()
• Timestamp::toLocalDateTime()
• Date::toLocalDate()
• Time::toLocalTime()

相反，从 java.time 到 java.sql，使用新的静态方法:

To go the other direction, from java.time to java.sql, use the new static methods:

• Timestamp.from(即时)
• Timestamp.valueOf(localDateTime)
• Date.valueOf(localDate)
• Time.valueOf(localTime)

示例:

preparedStatement.setTimestamp( 2, Timestamp.from(instant) );

这篇关于如何在没有 JDBC 4.2 驱动程序的情况下从 java.sql.Timestamp 获取 java.time 对象?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！