<insert id="uploadData" parameterType="cn.com.guanfang.courtmaintain.device.entity.DeviceStandingBook">
insert into t_s_device_standing_book
( id,
create_user,
create_time,
update_user,
update_time,
delflag
)
values
<foreach collection="list" item="item" separator="," open="" close="">
(
#{item.id,jdbcType=VARCHAR},
#{item.createUser,jdbcType=VARCHAR},
#{item.createTime,jdbcType=TIMESTAMP},
#{item.updateUser,jdbcType=VARCHAR},
#{item.updateTime,jdbcType=TIMESTAMP},
#{item.delflag,jdbcType=INTEGER}
)
</foreach>
</insert>
Dao层
int uploadData(@Param("list")List<DeviceStandingBook> list);
mybatis循环新增注意:1、mybatis的parameterType的值是你的对象,不要写成list了。2、insert values的时候 记住要用item属性里面的值去点你的对象属性,比如 #{ item.id , jdbcType=VARCHAR}