@PheonixHkbxoic
2017-04-23T09:41:21.000000Z
字数 1328
阅读 2295
Mybatis
目录 :
| jdbcType类型 | |||
|---|---|---|---|
| BIT | FLOAT | CHAR | TIMESTAMP |
| OTHER | UNDEFINED | TINYINT | REAL |
| BINARY | BLOB | NVARCHARSMALLINT | DOUBLE |
| LONGVARCHAR | VARBINARY | CLOB | NCHAR |
| INTEGER | NUMERIC | DATE | LONGVARBINARY |
| BOOLEAN | NCLOB | BIGINT | DECIMAL |
| TIME | NULL | CURSOR | VARCHAR |
这些都是myBatis支持的类型 你可以这么写 #{id,jdbcType=INTEGER}
| Mybatis | JdbcType | Oracle | MySql | Java类型 |
|---|---|---|---|---|
| JdbcType | ARRAY | |||
| JdbcType | BIGINT | BIGINT | java.lag.Long | |
| JdbcType | BINARY | byte[] | ||
| JdbcType | BIT | BIT | java.lang.Boolean | |
| JdbcType | BLOB | BLOB | BLOB | byte[] |
| JdbcType | BOOLEAN | java.lang.Boolean | ||
| JdbcType | CHAR | CHAR | CHAR | java.lang.String |
| JdbcType | CLOB | CLOB | CLOB | java.lang.String |
| JdbcType | CURSOR | |||
| JdbcType | DATE | DATE | DATE | java.sql.Date |
| JdbcType | DECIMAL | DECIMAL | DECIMAL | java.math.BigDecimal |
| JdbcType | DOUBLE | NUMBER | DOUBLE | java.lang.Double |
| JdbcType | FLOAT | FLOAT | FLOAT | java.lang.Double |
| JdbcType | INTEGER | INTEGER | INTEGER | java.lang.Integer |
| JdbcType | LONGVARBINARY | byte[] | ||
| JdbcType | LONGVARCHAR | LONG | VARCHAR | java.lang.String |
| JdbcType | NCHAR | NCHAR | java.lang.String | |
| JdbcType | NCLOB | NCLOB | ||
| JdbcType | NULL | |||
| JdbcType | NUMERIC | NUMERIC/ | NUMBER | NUMERIC/ |
| JdbcType | NVARCHAR | |||
| JdbcType | OTHER | |||
| JdbcType | REAL | REAL | REAL | |
| JdbcType | SMALLINT | SMALLINT | SMALLINT | |
| JdbcType | STRUCT | |||
| JdbcType | TIME | TIME | ||
| JdbcType | TIMESTAMP | TIMESTAMP | TIMESTAMP/ | DATETIME |
| JdbcType | TINYINT | TINYINT | ||
| JdbcType | UNDEFINED | |||
| JdbcType | VARBINARY | |||
| JdbcType | VARCHAR | VARCHAR | VARCHAR |