批量插入数据
<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>
当需要查询返回 List<String>
<select id="getByIds" parameterType="java.lang.String" resultType="java.util.List">
SELECT l.label_name FROM label l WHERE l.id IN(#{labelIds})
</select>