Mybatis中javaType和jdbcType类型对应
来源:互联网 发布:js循环语句 编辑:程序博客网 时间:2024/06/05 23:08
备忘用
<resultMap type="java.util.Map" id="resultjcm"> <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>
MySQL / JDBC/ JAVA之间的类型转换表格
MySQL数据类型JDBC类型(getColumnTypeName) 默认返回的Java类型(getColumnClassName)
BIT(1)
(new in MySQL-5.0)BIT
java.lang.Boolean
BIT( > 1)
(new in MySQL-5.0)BIT
byte[]
TINYINT
TINYINT
java.lang.Boolean
if the configuration property tinyInt1isBit
is set to true
(the default) and the storage size is 1, or java.lang.Integer
if not.BOOL
, BOOLEAN
TINYINT
See TINYINT
, above as these are aliases for TINYINT(1)
, currently.SMALLINT[(M)] [UNSIGNED]
SMALLINT [UNSIGNED]
java.lang.Integer
(regardless of whether it is UNSIGNED
or not)MEDIUMINT[(M)] [UNSIGNED]
MEDIUMINT [UNSIGNED]
java.lang.Integer
(regardless of whether it is UNSIGNED
or not)INT,INTEGER[(M)] [UNSIGNED]
INTEGER [UNSIGNED]
java.lang.Integer
, if UNSIGNED
java.lang.Long
BIGINT[(M)] [UNSIGNED]
BIGINT [UNSIGNED]
java.lang.Long
, if UNSIGNED java.math.BigInteger
FLOAT[(M,D)]
FLOAT
java.lang.Float
DOUBLE[(M,B)]
DOUBLE
java.lang.Double
DECIMAL[(M[,D])]
DECIMAL
java.math.BigDecimal
DATE
DATE
java.sql.Date
DATETIME
DATETIME
java.sql.Timestamp
TIMESTAMP[(M)]
TIMESTAMP
java.sql.Timestamp
TIME
TIME
java.sql.Time
YEAR[(2|4)]
YEAR
If yearIsDateType
configuration property is set to false
, then the returned object type is java.sql.Short
. If set to true
(the default), then the returned object is of type java.sql.Date
with the date set to January 1st, at midnight.CHAR(M)
CHAR
java.lang.String
(unless the character set for the column is BINARY
, then byte[]
is returned.VARCHAR(M) [BINARY]
VARCHAR
java.lang.String
(unless the character set for the column is BINARY
, then byte[]
is returned.BINARY(M)
BINARY
byte[]
VARBINARY(M)
VARBINARY
byte[]
TINYBLOB
TINYBLOB
byte[]
TINYTEXT
VARCHAR
java.lang.String
BLOB
BLOB
byte[]
TEXT
VARCHAR
java.lang.String
MEDIUMBLOB
MEDIUMBLOB
byte[]
MEDIUMTEXT
VARCHAR
java.lang.String
LONGBLOB
LONGBLOB
byte[]
LONGTEXT
VARCHAR
java.lang.String
ENUM('value1','value2',...)
CHAR
java.lang.String
SET('value1','value2',...)
CHAR
java.lang.String
阅读全文
0 0
- Mybatis中javaType和jdbcType类型对应
- mybatis 中常用javaType 和jdbcType 对应的类型
- Mybatis中javaType和jdbcType对应
- Mybatis中javaType和jdbcType对应关系
- Mybatis中javaType和jdbcType对应关系
- Mybatis中javaType和jdbcType对应关系
- Mybatis中javaType和jdbcType对应关系
- Mybatis中javaType和jdbcType对应关系
- Mybatis中javaType和jdbcType对应关系
- Mybatis中javaType和jdbcType对应关系
- Mybatis中javaType和jdbcType对应关系
- Mybatis中javaType和jdbcType对应关系
- Mybatis中javaType和jdbcType对应关系
- Mybatis中javaType和jdbcType对应关系
- Mybatis中javaType和jdbcType对应关系
- Mybatis中javaType和jdbcType对应关系
- Mybatis中javaType和jdbcType对应关系
- Mybatis中javaType和jdbcType对应关系
- WPF 异步编程需要注意的点
- 小程序初始
- Pstore dmesg 注册篇
- MySQL 向上递归查询树节点
- 下载的app不生成桌面图标,只有主app图标
- Mybatis中javaType和jdbcType类型对应
- 【数据结构】存储二叉树节点的栈 C language
- Android学习笔记---使用TimePickerDialog打造时间选择器
- ionic 在优化页的时候,ionic cordova build android --prod 报错 Module not found: Error: Can't resolve './app.mo
- python3 爬去公司内部的ppt资料
- 牛客网PAT题目——锤头剪刀布(Java)
- diji_1
- 7-12 找鞍点(20 分)
- Uncaught SyntaxError: Unexpected identifier