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