mybatis的jdbcType和javaType、oracle，MySQL的对应类型

来源：互联网发布：生死狙击刷矩阵技巧编辑：程序博客网时间：2024/06/06 19:01

Mybatis中jdbcType和javaType的对应关系

 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    MySqlJdbcType    ARRAY        JdbcType    BIGINT               BIGINTJdbcType    BINARY        JdbcType    BIT        BITJdbcType    BLOB       BLOB      BLOBJdbcType    BOOLEAN        JdbcType    CHAR       CHAR      CHARJdbcType    CLOB       CLOB      CLOBJdbcType    CURSOR        JdbcType    DATE       DATE      DATEJdbcType    DECIMAL    DECIMAL   DECIMALJdbcType    DOUBLE     NUMBER    DOUBLEJdbcType    FLOAT      FLOAT     FLOATJdbcType    INTEGER    INTEGER   INTEGERJdbcType    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       REALJdbcType    SMALLINT   SMALLINT   SMALLINTJdbcType    STRUCT        JdbcType    TIME       TIMEJdbcType    TIMESTAMP  TIMESTAMP  TIMESTAMP/DATETIMEJdbcType    TINYINT    TINYINTJdbcType    UNDEFINED        JdbcType    VARBINARY        JdbcType    VARCHAR    VARCHAR    VARCHAR
原文地址：http://www.cnblogs.com/pianai-shu/p/6349183.html

阅读全文

0 0