datetime类型的处置
datetime类型的处理
以处理错误日志为例:
<?xml version= "1.0" encoding ="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="core.dao.StatErrorDao" >
<insert id= "batchSaveStatErrorHourly" >
insert into stat_error (err_date, cid, err_id, osid , versionid, deviceid, num , update_time)
values
<foreach collection="list" item="item" index= "index"
separator="," >
(#{item.errDate,jdbcType=DATE}, #{item.cid}, #{item.errId},
#{item.osid}, #{item.versionid}, #{item.deviceid}, #{item.num},
#{item.updateTime, jdbcType=TIMESTAMP,javaType=java.sql.Timestamp})
</foreach>
</insert>
</mapper>
注释:mysql中的datetime类型字段,使用java.sql.Timestamp 类型
#{item.updateTime, jdbcType=TIMESTAMP,javaType=java.sql.Timestamp}
date类型处理办法如下:
#{item.errDate,jdbcType=DATE}