JDBC Types Mapped to Java Object Types : SQL Data Type Java Data Type « Database « Java Tutorial






  1. Java Tutorial
  2. Database
  3. SQL Data Type Java Data Type
JDBC TypeJava Object Type
CHARjava.lang.String
VARCHARjava.lang.String
LONGVARCHARjava.lang.String
NUMERICjava.math.BigDecimal
DECIMALjava.math.BigDecimal
BITjava.lang.Boolean
TINYINTjava.lang.Integer
SMALLINTjava.lang.Integer
INTEGERjava.lang.Integer
BIGINTjava.lang.Long
REALjava.lang.Float
FLOATjava.lang.Double
DOUBLEjava.lang.Double
BINARYbyte[]
VARBINARYbyte[]
LONGVARBINARYbyte[]
DATEjava.sql.Date
TIMEjava.sql.Time
TIMESTAMPjava.sql.Timestamp
DISTINCTObject type of underlying type
CLOBjava.lang.Clob
BLOBjava.lang.Blob
ARRAYjava.lang.Array
STRUCTjava.lang.Struct or java.lang.SQLData
REFjava.lang.Ref
JAVA_OBJECTUnderlying Java class










20.19.SQL Data Type Java Data Type
20.19.1.Mapping Between Java to JDBC SQL Types
20.19.2.Java Types Mapped to JDBC Types
20.19.3.JDBC Types Mapped to Java Object Types
20.19.4.Java Object Types Mapped to JDBC Types
20.19.5.Getting the Name of a JDBC Type
20.19.6.Get the database-specific type name
20.19.7.Get the java.sql.Types type to which this database-specific type is mapped
20.19.8.Retrieve type info from the result set
20.19.9.converting a java.sql.Types integer value into a printable name
20.19.10.uses reflection to get all the field names from java.sql.Types.