MybatisjdbcTypejavaType的对应关系

复制代码
 1 JDBC Type           Java Type   
 2 CHAR                String   
 3 VARCHAR             String   
 4 LONGVARCHAR         String   
 5 NUMERIC             java.math.BigDecimal   
 6 DECIMAL             java.math.BigDecimal   
 7 BIT                 boolean   
 8 BOOLEAN             boolean   
 9 TINYINT             byte   
10 SMALLINT            short   
11 INTEGER             int   
12 BIGINT              long   
13 REAL                float   
14 FLOAT               double   
15 DOUBLE              double   
16 BINARY              byte[]   
17 VARBINARY           byte[]   
18 LONGVARBINARY               byte[]   
19 DATE                java.sql.Date   
20 TIME                java.sql.Time   
21 TIMESTAMP           java.sql.Timestamp   
22 CLOB                Clob   
23 BLOB                Blob   
24 ARRAY               Array   
25 DISTINCT            mapping of underlying type   
26 STRUCT              Struct   
27 REF                         Ref   
28 DATALINK            java.net.URL[color=red][/color]  
复制代码

Mybatis JdbcType与Oracle、MySql数据类型对应列表

复制代码
Mybatis    JdbcType    Oracle    MySql 
JdbcType    ARRAY         
JdbcType    BIGINT               BIGINT 
JdbcType    BINARY         
JdbcType    BIT        BIT 
JdbcType    BLOB       BLOB      BLOB 
JdbcType    BOOLEAN         
JdbcType    CHAR       CHAR      CHAR 
JdbcType    CLOB       CLOB      CLOB 
JdbcType    CURSOR         
JdbcType    DATE       DATE      DATE 
JdbcType    DECIMAL    DECIMAL   DECIMAL 
JdbcType    DOUBLE     NUMBER    DOUBLE 
JdbcType    FLOAT      FLOAT     FLOAT 
JdbcType    INTEGER    INTEGER   INTEGER 
JdbcType    LONGVARBINARY         
JdbcType    LONGVARCHAR  LONG    VARCHAR     
JdbcType    NCHAR      NCHAR     
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
复制代码

发布评论
IT序号网

微信公众号号:IT虾米 (左侧二维码扫一扫)欢迎添加!

mysql 创建表格 AUTO_INCREMENT知识解答
你是第一个吃螃蟹的人
发表评论

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。