java-Mysql-SQLServer数据类型匹配速查表
转自（http://hi.baidu.com/hemes1314/blog/item/c4bc1aca6cf3318cc917688e.htmls）
Mysql ************************************
当前列 ClassName ColumnType DisplaySize TypeName
0: ｊａｖａ.lang.Integer ColumnType:4 11 INTEGER
1: ｊａｖａ.lang.Integer ColumnType:-6 4 TINYINT
2: ｊａｖａ.lang.String ColumnType:12 0 UNKNOWN
3: ｊａｖａ.lang.Boolean ColumnType:-7 1 TINYINT
4: ｊａｖａ.lang.Integer ColumnType:5 6 SMALLINT
5: ｊａｖａ.lang.Integer ColumnType:4 9 MEDIUMINT
6: ｊａｖａ.lang.Integer ColumnType:4 11 INTEGER
7: ｊａｖａ.lang.Long ColumnType:-5 20 BIGINT
8: ｊａｖａ.lang.Double ColumnType:8 22 DOUBLE
9: ｊａｖａ.lang.Double ColumnType:8 22 DOUBLE
10: ｊａｖａ.lang.Float ColumnType:7 12 FLOAT
11: ｊａｖａ.lang.String ColumnType:12 11 UNKNOWN
12: ｊａｖａ.lang.String ColumnType:12 11 UNKNOWN
13: ｊａｖａ.lang.String ColumnType:1 300 CHAR
14: ｊａｖａ.lang.String ColumnType:12 300 VARCHAR
15: ｊａｖａ.sql.Date ColumnType:91 10 DATE
16: ｊａｖａ.sql.Time ColumnType:92 8 TIME
17: ｊａｖａ.sql.Date ColumnType:91 4 YEAR
18: ｊａｖａ.sql.Timestamp ColumnType:93 19 TIMESTAMP
19: ｊａｖａ.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: ｊａｖａ.lang.String ColumnType:12 255 TINYBLOB
25: ｊａｖａ.lang.String ColumnType:-1 65535 TEXT
26: ｊａｖａ.lang.String ColumnType:-1 16777215 MEDIUMBLOB
27: ｊａｖａ.lang.String ColumnType:-1 -1 TEXT
28: ｊａｖａ.lang.String ColumnType:1 3 CHAR
29: ｊａｖａ.lang.String ColumnType:1 3 CHAR
SQLServer ***********************************
0: ｊａｖａ.lang.Integer ColumnType:4 11 int identity
1: ｊａｖａ.lang.Long ColumnType:-5 20 bigint
2: byte[] ColumnType:-2 100 binary
3: ｊａｖａ.lang.Boolean ColumnType:-7 1 bit
4: ｊａｖａ.lang.String ColumnType:1 10 char
5: ｊａｖａ.sql.Timestamp ColumnType:93 23 datetime
6: ｊａｖａ.sql.Timestamp ColumnType:93 23 datetime
7: ｊａｖａ.math.BigDecimal ColumnType:3 20 decimal
8: ｊａｖａ.lang.Double ColumnType:6 22 float
9: byte[] ColumnType:-4 2147483647 image
10: ｊａｖａ.math.BigDecimal ColumnType:3 21 money
11: ｊａｖａ.lang.String ColumnType:1 10 nchar
12: ｊａｖａ.lang.String ColumnType:-1 1073741823 ntext
13: ｊａｖａ.math.BigDecimal ColumnType:2 20 numeric
14: ｊａｖａ.lang.String ColumnType:12 50 nvarchar
15: ｊａｖａ.lang.Float ColumnType:7 13 real
16: ｊａｖａ.sql.Timestamp ColumnType:93 16 smalldatetime
17: ｊａｖａ.lang.Integer ColumnType:5 6 smallint
18: ｊａｖａ.math.BigDecimal ColumnType:3 12 smallmoney
19: ｊａｖａ.lang.String ColumnType:12 8000 sql_variant
20: ｊａｖａ.lang.String ColumnType:-1 2147483647 text
21: byte[] ColumnType:-2 16 timestamp
22: ｊａｖａ.lang.Integer ColumnType:-6 3 tinyint
23: ｊａｖａ.lang.String ColumnType:1 36 uniqueidentifier
24: byte[] ColumnType:-3 100 varbinary
25: ｊａｖａ.lang.String ColumnType:12 50 varchar
