从 JDBC 类型映射到 Java 类型

从 JDBC 类型映射到 Java 类型

JDBC 类型	Java 类型
CHAR	String
VARCHAR	String
LONGVARCHAR	String
NUMERIC	java.math.BigDecimal
DECIMAL	java.math.BigDecimal
BIT	boolean
TINYINT	byte
SMALLINT	short
INTEGER	int
BIGINT	long
REAL	float
FLOAT	double
DOUBLE	double
BINARY	byte[]
VARBINARY	byte[]
LONGVARBINARY	byte[]
DATE	java.sql.Date
TIME	java.sql.Time
TIMESTAMP	java.sql.Timestamp

从 Java 类型映射到 JDBC 类型

Java 类型	JDBC 类型
String	VARCHAR 或 LONGVARCHAR
java.math.BigDecimal	NUMERIC
boolean	BIT
byte	TINYINT
short	SMALLINT
int	INTEGER
long	BIGINT
float	REAL
double	DOUBLE
byte[]	VARBINARY 或 LONGVARBINARY
java.sql.Date	DATE
java.sql.Time	TIME
java.sql.Timestamp	TIMESTAMP

从 JDBC 类型到 Java Object 类型的映射

JDBC 类型	Java Object 类型
CHAR	String
VARCHAR	String
LONGVARCHAR	String
NUMERIC	java.math.BigDecimal
DECIMAL	java.math.BigDecimal
BIT	Boolean
TINYINT	Integer
SMALLINT	Integer
INTEGER	Integer
BIGINT	Long
REAL	Float
FLOAT	Double
DOUBLE	Double
BINARY	byte[]
VARBINARY	byte[]
LONGVARBINARY	byte[]
DATE	java.sql.Date
TIME	java.sql.Time
TIMESTAMP	java.sql.Timestamp

 Java Object 类型映射到 JDBC 类型

Java Object 类型	JDBC 类型
String	VARCHAR 或 LONGVARCHAR
java.math.BigDecimal	NUMERIC
Boolean	BIT
Integer	INTEGER
Long	BIGINT
Float	REAL
Double	DOUBLE
byte[]	VARBINARY 或 LONGVARBINARY
java.sql.Date	DATE
java.sql.Time	TIME
java.sql.Timestamp	TIMESTAMP

各数据库JDBC类型Java类型映射

	java.sql.Types 值	Java 类型	IBM DB2	Oracle	Sybase	SQL	Informix	IBM Content Manager
	BIGINT	java.lang.long	BIGINT	NUMBER (38, 0)	BIGINT	BIGINT	INT8	DK_CM_BIGINT
	BINARY	byte[]	CHAR FOR BIT DATA	RAW	BINARY	IMAGE	BYTE	DK_CM_BLOB
	BIT	java.lang.Boolean	N/A	BIT	BIT	BIT	BIT	DK_CM_SMALLINT
	BLOB	byte[]	BLOB	BLOB	BLOB	BLOB	BLOB	DK_CM_BLOB
	CHAR	java.lang.String	CHAR, GRAPHIC	CHAR	CHAR	CHAR	CHAR	DK_CM_CHAR
	CLOB	java.lang.String	CLOB, DBCLOB	CLOB	CLOB	CLOB	CLOB	DK_CM_CLOB
	DATE	java.sql.Date	DATE	DATE	DATE	DATE	DATE	DK_CM_DATE
	DECIMAL	java.math.BigDecimal	DECIMAL	NUMBER	DECIMAL, MONEY, SMALLMONEY	DECIMAL	DECIMAL	DK_CM_DECIMAL
	DOUBLE	java.lang.Double	DOUBLE	DOUBLE PRECISION	DOUBLE PRECISION	DOUBLE PRECISION	DOUBLE PRECISION	DK_CM_DOUBLE
	FLOAT	java.lang.Double	FLOAT	FLOAT	FLOAT	FLOAT	FLOAT	DK_CM_DOUBLE
	INTEGER	java.lang.Integer	INTEGER	INTEGER	INT	INTEGER	INTEGER	DK_CM_INTEGER
	JAVA_OBJECT	java.lang.Object	JAVA_OBJECT	JAVA_OBJECT	JAVA_OBJECT	JAVA_OBJECT	OPAQUE	N/A
	LONGVARBINARY	byte[]	LONG VARCHAR FOR BIT DATA	LONG RAW	IMAGE	IMAGE	BYTE	DK_CM_BLOB
	LONGVARCHAR	java.lang.String	LONG VARCHAR, LONG VARGRAPHIC	LONG	TEXT	TEXT	TEXT	DK_CM_VARCHAR(3500)
	NUMERIC	java.math.BigDecimal	NUMERIC	NUMBER	NUMERIC	NUMERIC	NUMERIC	DK_CM_DECIMAL
	OTHER	java.lang.Object	OTHER	OTHER	OTHER	OTHER	OTHER	N/A
	REAL	java.lang.Float	REAL	REAL	REAL	REAL	REAL	DK_CM_DOUBLE
	SMALLINT	java.lang.Integer	SMALLINT	SMALLINT	SMALLINT	SMALLINT	SMALLINT	DK_CM_INTEGER
	TIME	java.sql.Time	TIME	DATE	TIME	TIME	DATETIME HOUR TO SECOND	DK_CM_TIME
	TIMESTAMP	java.sql.Timestamp	TIMESTAMP	DATE	DATETIME, SMALLDATETIME	DATETIME	DATETIME YEAR TO FRACTION (5)	DK_CM_TIMESTAMP
	TINYINT	java.lang.Bute	SMALLINT	TINYINT	TINYINT	TINYINT	TINYINT	DK_CM_INTEGER
	VARBINARY	byte[]	VARCHAR FOR BIT DATA	RAW	VARBINARY	IMAGE	BYTE	DK_CM_BLOB
	VARCHAR	java.lang.String	VARCHAR, VARGRAPHIC	VARCHAR	VARCHAR	VARCHAR	VARCHAR	DK_CM_VARCHAR