如何从没有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(instant)
Timestamp.valueOf(localDateTime)
Date.valueOf(localDate)
Time.valueOf(localTime)
示例:
preparedStatement.setTimestamp( 2, Timestamp.from(instant) );
这篇关于如何从没有JDBC 4.2驱动程序的java.sql.Timestamp中获取java.time对象?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!