MySql和Java数据类型映射关系

bolb: 一般用于对图片的数据库存储，原理是把图片打成二进制，然后进行的一种存储方式,在java中对应byte［］

当前列	ClassName	ColumnType	DisplaySize	TypeName
0:	java.lang.Integer	ColumnType:4	11	INTEGER
1:	java.lang.Integer	ColumnType:-6	4	TINYINT
2:	java.lang.String	ColumnType:12	0	UNKNOWN
3:	java.lang.Boolean	ColumnType:-7	1	TINYINT
4:	java.lang.Integer	ColumnType:5	6	SMALLINT
5:	java.lang.Integer	ColumnType:4	9	MEDIUMINT
6:	java.lang.Integer	ColumnType:4	11	INTEGER
7:	java.lang.Long	ColumnType:-5	20	BIGINT
8:	java.lang.Double	ColumnType:8	22	DOUBLE
9:	java.lang.Double	ColumnType:8	22	DOUBLE
10:	java.lang.Float	ColumnType:7	12	FLOAT
11:	java.lang.String	ColumnType:12	11	UNKNOWN
12:	java.lang.String	ColumnType:12	11	UNKNOWN
13:	java.lang.String	ColumnType:1	300	CHAR
14:	java.lang.String	ColumnType:12	300	VARCHAR
15:	java.sql.Date	ColumnType:91	10	DATE
16:	java.sql.Time	ColumnType:92	8	TIME
17:	java.sql.Date	ColumnType:91	4	YEAR
18:	java.sql.Timestamp	ColumnType:93	19	TIMESTAMP
19:	java.sql.Timestamp	ColumnType:93	19	DATETIME
20:	[B	ColumnType:-3	255	TINYBLOB
21:	[B	ColumnType:-4	65535	BLOB
22:	[B	ColumnType:-4	16777215	MEDIUMBLOB
23:	[B	ColumnType:-4	-1	BLOB
24:	java.lang.String	ColumnType:12	255	TINYBLOB
25:	java.lang.String	ColumnType:-1	65535	TEXT
26:	java.lang.String	ColumnType:-1	16777215	MEDIUMBLOB
27:	java.lang.String	ColumnType:-1	-1	TEXT
28:	java.lang.String	ColumnType:1	3	CHAR
29:	java.lang.String	ColumnType:1	3	CHAR