Mapping Between Java to JDBC SQL Types : SQL Data Type Java Data Type « Database « Java Tutorial






  1. Java Tutorial
  2. Database
  3. SQL Data Type Java Data Type
JDBC TypeJava Type
CHARjava.lang.String
VARCHARjava.lang.String
LONGVARCHARjava.lang.String
NUMERICjava.math.BigDecimal
DECIMALjava.math.BigDecimal
BITboolean
TINYINTbyte
SMALLINTshort
INTEGERint
BIGINTlong
REALfloat
FLOATdouble
DOUBLEdouble
BINARYbyte[]
VARBINARYbyte[]
LONGVARBINARYbyte[]
DATEjava.sql.Date
TIMEjava.sql.Time
TIMESTAMPjava.sql.Timestamp
CLOBjava.sql.Clob
BLOBjava.sql.Blob
ARRAYjava.sql.Array
DISTINCTMapping of underlying type
STRUCTjava.sql.Struct
REFjava.sql.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.