mysql 与java 常用数据类型转换

sql类型                                              jdbc 类型                               返回类型

BIT(1)  bit(n)                                     getboolean getBytes()               Boolean byte[]

TINYINT                                            getByte()                                   Byte

Smallint                                             getShort()                                  Short

Int                                                      getInt()                                      Int

BigInt                                                 getLong()                                  Long

CHAR ,VARCHAR,LONGVARCHAR  getString()                               String

Text(clob) Blob                                  getClob  getBlob()                     Clob Blob

DATE                                                getDate()                                    java.sql.Date

TIME                                                getTime()                                     java.sql.Time

TIMEstamp                                      getTimestamp()                          java.sql.TimeStamp

二，MySQL修改数据库编码和表的编码后，字段依然是