跳到主要内容

附录:类型映射

根据 Java 类型获取对应的 JDBC Type

JDBC 类型Java 类型
Types.BITjava.lang.Boolean, boolean
Types.TINYINTjava.lang.Byte, byte
Types.SMALLINTjava.lang.Short, short, java.time.Year, java.time.Month
Types.INTEGERjava.lang.Integer, int
Types.BIGINTjava.lang.Long, long, java.math.BigInteger
Types.FLOATjava.lang.Float, float
Types.DOUBLEjava.lang.Double, double
Types.CHARjava.lang.Character, char
Types.DATEjava.sql.Date, java.time.LocalDate, oracle.sql.DATE
Types.TIMEjava.sql.Time, java.time.LocalTime
Types.TIMESTAMPjava.util.Date, java.sql.Timestamp, java.time.Instant, java.time.LocalDateTime, java.time.chrono.JapaneseDate, oracle.sql.TIMESTAMP
Types.TIMESTAMP_WITH_TIMEZONEjava.time.OffsetDateTime, java.time.ZonedDateTime, oracle.sql.TIMESTAMPTZ, oracle.sql.TIMESTAMPLTZ
Types.TIME_WITH_TIMEZONEjava.time.OffsetTime
Types.VARCHARjava.lang.String, java.time.YearMonth
Types.DECIMALjava.math.BigDecimal
Types.CLOBjava.io.Reader, oracle.jdbc.OracleClob
Types.BLOBjava.io.InputStream, oracle.jdbc.OracleBlob
Types.VARBINARYjava.lang.Byte[], byte[]
Types.DATALINKjava.net.URL
Types.ARRAYjava.lang.Object[]
Types.JAVA_OBJECTjava.lang.Object
Types.BLOBoracle.jdbc.OracleBlob
Types.CLOBoracle.jdbc.OracleClob
Types.NCLOBoracle.jdbc.OracleNClob