MySQL 字段类型和JAVA类型对照表

MySQL 字段类型和JAVA类型对照表

类型名称	显示长度	数据库类型	JAVA类型	JDBC类型索引(int)
varchar	l+n	varchar	java.long.String	12
char	n	char	java.long.String	1
blob	l+n	blob	java.long.byte[]	-4
text	65535	varchar	java.long.String	-1
integer	4	integer unsigned	java.long.Long	4
tinyint	3	tinyint unsigned	java.long.Integer	-6
smallint	5	smallint unsigned	java.long.Integer	5
mediumint	8	mediumint unsigned	java.long.Integer	4
bit	1	bit	java.long.Boolean	-7
bigint	20	bigint unsigned	java.math.BigInteger	-5
float	4+8	float	java.long.Float	7
double	22	double	java.long.Double	8
decimal	11	decimal	java.math.Bigdecimal	3
boolean	1	同tinyint
id	11	PK(integer unsigned)	java.long.Long	4
date	10	date	java.sql.Date	91
time	8	time	java.sql.Date	92
datetime	19	datetime	java.sql.Timestamp	93
timestamp	19	timestamp	java.sql.Timestamp	93
year	4	year	java.sql.Date	91