mybatis foreach 循环遍历 list对象
<insert id="saveBatch"
parameterType="cn.net.polyinfo.entity.websitemanage.websiteWhite.TSiteWhiteEntity">
insert into t_site_white
(
`listid`,
`url`,
`name`,
`department`,
`position`,
`telephone`,
`email`,
`remark`,
`createtime`,
`modifytime`
)
values
<foreach collection="list" item="item" index="index"
separator=",">
(
#{item.listid},
#{item.url},
#{item.name},
#{item.department},
#{item.position},
#{item.telephone},
#{item.email},
#{item.remark},
#{item.createtime},
#{item.modifytime}
)
</foreach>
</insert>
版权声明:本文为chenzhenguo123原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
THE END