mybatis 默认插入当前时间

<insert id="importSickTree" parameterType="list" >
insert into tb_sick_tree (treeCode,projectID,
lat, lon, distCode, distName,
identifyTime,processed,year)
VALUES
<foreach collection="list" item="sickTree" separator=",">
( #{sickTree.treecode,jdbcType=VARCHAR},#{sickTree.projectid,jdbcType=INTEGER},
#{sickTree.lat,jdbcType=DOUBLE}, #{sickTree.lon,jdbcType=DOUBLE},
#{sickTree.distcode,jdbcType=VARCHAR}, #{sickTree.distname,jdbcType=VARCHAR},
#{sickTree.identifytime,jdbcType=TIMESTAMP}, #{sickTree.processed,jdbcType=INTEGER},
SUBSTR(NOW(),1,4) )
</foreach>
</insert>
posted @ 2021-01-08 10:48  菜鸟也想飞上天  阅读(8049)  评论(0编辑  收藏  举报