jdbcType与javaType的对应关系
时间:2021-07-01 10:21:17
帮助过:13人阅读
| Java 类型 |
IBM DB2 |
Oracle |
Sybase |
SQL |
Informix |
IBM Content Manager |
| |
BIGINT |
java.lang.long |
BIGINT |
NUMBER (38, 0) |
BIGINT |
BIGINT |
INT8 |
DK_CM_BIGINT |
| |
BINARY |
byte[] |
CHAR FOR BIT DATA |
RAW |
BINARY |
IMAGE |
BYTE |
DK_CM_BLOB |
| |
BIT |
java.lang.Boolean |
N/A |
BIT |
BIT |
BIT |
BIT |
DK_CM_SMALLINT |
| |
BLOB |
byte[] |
BLOB |
BLOB |
BLOB |
BLOB |
BLOB |
DK_CM_BLOB |
| |
CHAR |
java.lang.String |
CHAR, GRAPHIC |
CHAR |
CHAR |
CHAR |
CHAR |
DK_CM_CHAR |
| |
CLOB |
java.lang.String |
CLOB, DBCLOB |
CLOB |
CLOB |
CLOB |
CLOB |
DK_CM_CLOB |
| |
DATE |
java.sql.Date |
DATE |
DATE |
DATE |
DATE |
DATE |
DK_CM_DATE |
| |
DECIMAL |
java.math.BigDecimal |
DECIMAL |
NUMBER |
DECIMAL, MONEY, SMALLMONEY |
DECIMAL |
DECIMAL |
DK_CM_DECIMAL |
| |
DOUBLE |
java.lang.Double |
DOUBLE |
DOUBLE PRECISION |
DOUBLE PRECISION |
DOUBLE PRECISION |
DOUBLE PRECISION |
DK_CM_DOUBLE |
| |
FLOAT |
java.lang.Double |
FLOAT |
FLOAT |
FLOAT |
FLOAT |
FLOAT |
DK_CM_DOUBLE |
| |
INTEGER |
java.lang.Integer |
INTEGER |
INTEGER |
INT |
INTEGER |
INTEGER |
DK_CM_INTEGER |
| |
JAVA_OBJECT |
java.lang.Object |
JAVA_OBJECT |
JAVA_OBJECT |
JAVA_OBJECT |
JAVA_OBJECT |
OPAQUE |
N/A |
| |
LONGVARBINARY |
byte[] |
LONG VARCHAR FOR BIT DATA |
LONG RAW |
IMAGE |
IMAGE |
BYTE |
DK_CM_BLOB |
| |
LONGVARCHAR |
java.lang.String |
LONG VARCHAR, LONG VARGRAPHIC |
LONG |
TEXT |
TEXT |
TEXT |
DK_CM_VARCHAR(3500) |
| |
NUMERIC |
java.math.BigDecimal |
NUMERIC |
NUMBER |
NUMERIC |
NUMERIC |
NUMERIC |
DK_CM_DECIMAL |
| |
OTHER |
java.lang.Object |
OTHER |
OTHER |
OTHER |
OTHER |
OTHER |
N/A |
| |
REAL |
java.lang.Float |
REAL |
REAL |
REAL |
REAL |
REAL |
DK_CM_DOUBLE |
| |
SMALLINT |
java.lang.Integer |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
DK_CM_INTEGER |
| |
TIME |
java.sql.Time |
TIME |
DATE |
TIME |
TIME |
DATETIME HOUR TO SECOND |
DK_CM_TIME |
| |
TIMESTAMP |
java.sql.Timestamp |
TIMESTAMP |
DATE |
DATETIME, SMALLDATETIME |
DATETIME |
DATETIME YEAR TO FRACTION (5) |
DK_CM_TIMESTAMP |
| |
TINYINT |
java.lang.Bute |
SMALLINT |
TINYINT
|
TINYINT
|
TINYINT |
TINYINT |
DK_CM_INTEGER |
| |
VARBINARY |
byte[] |
VARCHAR FOR BIT DATA |
RAW |
VARBINARY |
IMAGE |
BYTE |
DK_CM_BLOB |
| |
VARCHAR |
java.lang.String |
VARCHAR, VARGRAPHIC |
VARCHAR |
VARCHAR |
VARCHAR |
VARCHAR |
DK_CM_VARCHAR
|
jdbcType与javaType的对应关系
标签:man nbsp body orm net style info http db2