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






Java Object TypeJDBC Type
java.lang.StringCHAR, VARCHAR, or LONGVARCHAR
java.math.BigDecimalNUMERIC
java.lang.BooleanBIT
java.lang.IntegerINTEGER
java.lang.LongBIGINT
java.lang.FloatREAL
java.lang.DoubleDOUBLE
byte[]BINARY, VARBINARY, or LONGVARBINARY
java.sql.DateDATE
java.sql.TimeTIME
java.sql.TimestampTIMESTAMP
java.sql.ClobCLOB
java.sql.BlobBLOB
java.sql.ArrayARRAY
java.sql.StructSTRUCT
java.sql.RefREF
Java classJAVA_OBJECT










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.