MyBatis中的jdbcType

139 阅读 0 评论 92 点赞

我是靠谱客的博主沉静方盒，这篇文章主要介绍MyBatis中的jdbcType，现在分享给大家，希望可以做个参考。

MyBatis中常用的jdbcType

复制代码

1
2
3
4
5
6
7
8
9
10
BIT         FLOAT      CHAR           TIMESTAMP       OTHER       UNDEFINED

TINYINT     REAL       VARCHAR        BINARY          BLOB        NVARCHAR

SMALLINT    DOUBLE     LONGVARCHAR    VARBINARY       CLOB        NCHAR

INTEGER     NUMERIC    DATE           LONGVARBINARY   BOOLEAN     NCLOB

BIGINT      DECIMAL    TIME           NULL            CURSOR

Mybatis中javaType和jdbcType的对应关系

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
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]

示例

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
<resultMap type="java.util.Map" id="demo">  
  <result property="FLD_NUMBER" column="FLD_NUMBER"  javaType="double" jdbcType="NUMERIC"/>  
  <result property="FLD_VARCHAR" column="FLD_VARCHAR" javaType="string" jdbcType="VARCHAR"/>  
  <result property="FLD_DATE" column="FLD_DATE" javaType="java.sql.Date" jdbcType="DATE"/>  
  <result property="FLD_INTEGER" column="FLD_INTEGER"  javaType="int" jdbcType="INTEGER"/>  
  <result property="FLD_DOUBLE" column="FLD_DOUBLE"  javaType="double" jdbcType="DOUBLE"/>  
  <result property="FLD_LONG" column="FLD_LONG"  javaType="long" jdbcType="INTEGER"/>  
  <result property="FLD_CHAR" column="FLD_CHAR"  javaType="string" jdbcType="CHAR"/>  
  <result property="FLD_BLOB" column="FLD_BLOB"  javaType="[B" jdbcType="BLOB" />  
  <result property="FLD_CLOB" column="FLD_CLOB"  javaType="string" jdbcType="CLOB"/>  
  <result property="FLD_FLOAT" column="FLD_FLOAT"  javaType="float" jdbcType="FLOAT"/>  
  <result property="FLD_TIMESTAMP" column="FLD_TIMESTAMP"  javaType="java.sql.Timestamp" jdbcType="TIMESTAMP"/>  
 </resultMap>