Java与数据库类型对照表

数据库类型	Java类型
INTEGER	int or java.lang.Integer
BIGINT	long or java.lang.Long
SMALLINT	short or java.lang.Short
FLOAT	float or java.lang.Float
DOUBLE	double or java.lang.Double
NUMERIC	java.math.BigDecimal
CHAR	java.lang.String
VARCHAR	java.lang.String
TINYINT	byte or java.lang.Byte
BIT	boolean or java.lang.Boolean
DATE	java.util.Date or java.sql.Date
TIME	java.util.Date or java.sql.Time
TIMESTAMP	java.util.Date or java.sql.Timestamp
TIMESTAMP	java.util.Calendar
DATE	java.util.Calendar
VARBINARY (or BLOB)	byte[]
CLOB	java.lang.String
VARBINARY (or BLOB)	any Java class that implements java.io.Serializable
CLOB	java.sql.Clob
BLOB	java.sql.Blob

转载于:https://www.cnblogs.com/kagome2014/p/5619677.html