批量操作数据库数据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>

 

当需要查询返回 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>