Mybatis中jdbcType和javaType的对应关系代码语言:javascript复制JDBC Type Java Type

CHAR String

VARCHAR String

LONGVARCHAR String

NUMERIC java.math.BigDecimal

DECIMAL java.math.BigDecimal

BIT boolean

BOOLEAN boolean

TINYINT byte

SMALLINT short

INTEGER int

BIGINT long

REAL float

FLOAT double

DOUBLE double

BINARY byte[]

VARBINARY byte[]

LONGVARBINARY byte[]

DATE java.sql.Date

TIME java.sql.Time

TIMESTAMP java.sql.Timestamp

CLOB Clob

BLOB Blob

ARRAY Array

DISTINCT mapping of underlying type

STRUCT Struct

REF Ref

DATALINK java.net.URL[color=red][/color]Mybatis JdbcType与Oracle、MySql数据类型对应列表代码语言:javascript复制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本文参与 腾讯云自媒体同步曝光计划,分享自作者个人站点/博客。 原始发表:2018-12-12,如有侵权请联系 cloudcommunity@tencent.com 删除前往查看mybatis本文分享自 作者个人站点/博客 前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体同步曝光计划 ,欢迎热爱写作的你一起参与!

mybatis