OracleType | JavaType | JdbcType |
---|---|---|
VARCHAR2() | String(java.lang) | VARCHAR |
NVARCHAR2 | String (java.lang) | VARCHAR |
INTEGER | Integer(java.lang) | INTEGER |
NUMBER(1) | Boolean (java.lang) | |
NUMBER(2) | Byte (java.lang) | |
NUMBER(1,4) | Short (java.lang) | Short |
NUMBER(5,9) | Integer(java.lang) | Integer |
NUMBER(10,18) | Long (java.lang) | Long |
NUMBER(18,+) | BigDecimal(java.math) | NUMERIC |
CLOB | String (java.lang) | CLOB |
DATE | Date(java.util) | TIMESTAMP |
JdbcType=DATE:增删改会导致只有yyyyMMdd,丢失HH:ss:mm