批量操作数据库数据mybatis.xml

批量插入数据

<insert id="equipment_Add" parameterType="cn.wtsr.core.web.dao.vo.equipment.Equipment_AddAVo">
INSERT INTO `tablename`
( `fieldname1` , fieldname2)
VALUES
<foreach collection="listname" item="item" index="index" separator="," >
(#{item.类中属性名1},#{item.类中属性名2})
</foreach>
</insert>