mybatis中的jdbcType配置
1. 可以配置的jdbcType类型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 ARRAY
其中常用的jdbcType如下：CHAR、VARCHAR、INTEGER、NUMERIC、DECIMAL、DATE、TIMESTAMP 2.javaType和jdbcType对应关系
CHARString
VARCHARString
LONGVARCHARString
NUMERICjava.math.BigDecimal
DECIMALjava.math.BigDecimal
BIT boolean
BOOLEANboolean
TINYINTbyte
SMALLINTshort
INTEGERint
BIGINTlong
REALfloat
FLOATdouble
DOUBLEdouble
BINARYbyte[]
VARBINARYbyte[]
LONGVARBINARYbyte[]
DATEjava.sql.Date
TIMEjava.sql.Time
TIMESTAMPjava.sql.Timestamp
CLOBClob
BLOBBlob
ARRAYArray
DISTINCTmapping of underlying type
STRUCTStruct
REF Ref
DATALINKjava.net.URL
3. 示例
<resultMap id="memberMap" type="com.test.pojo.Member">
<result column="USERNAME" jdbcType="VARCHAR" property="userName" />
</resultMap>
页:
[1]