一、批量查询
①单条件批量查询
dao 层
public List<String>bindingDriver_update_select(List<BindingDriver> list);
xml文件
<select id="bindingDriver_update_select" resultType="java.lang.String">
SELECT z_driver.username FROM z_binding
INNER JOIN z_driver ON z_driver.ucardid = z_binding.ucardid
where z_binding.ucardid in
<foreach collection="list" index="index" item="item" open="(" separator="," close=")">
#{item.ucardid}
</foreach>
</select>
②多条件批量查询
dao 层
public List<String>bindingDriver_update_select(List<BindingDriver> list);
xml文件
<select id="bindingDriver_update_select" resultType="java.lang.String">
<foreach collection="list" index="index" item="item" open="" close="" separator=";">
SELECT z_driver.username FROM z_binding INNER JOIN z_driver ON z_driver.ucardid = z_binding.ucardid
where z_binding.ucardid = #{item.ucardid} and z_binding.fiapper_num !=#{item.fiapper_num}
</foreach>
</select>
注意:单条件和多条件查询,foreach标签的open、close、separator属性不同,单条件separator是逗号“,”,多条件时separator是分号“;”
二、批量修改
①单条件修改
dao层
public void administrative_unit_update(List<TranspotyCar> list);
xml文件
<update id="administrative_unit_update" parameterType="java.util.List">
update z_transpotycar
set administrative_unit=#{item.administrative_unit}
where fiapper_num in
<foreach collection ="list" item="item" index= "index" open="(" separator="," close=")">
#{item.fiapper_num}
</foreach>
</update>
②多条件修改
dao层
public void administrative_unit_update(List<TranspotyCar> list);
xml文件
<update id="administrative_unit_update" parameterType="java.util.List">
<foreach collection ="list" item="item" index= "index" separator =";">
update z_transpotycar
<set>
administrative_unit=#{item.administrative_unit}
</set>
where fiapper_num=#{item.fiapper_num} and transpotyComId=#{item.transpotyComId}
</foreach>
</update>
三、批量insert
dao层
public void bindingDriver_update_insert(List<BindingDriver> list);
xml文件
<!-- 批量增加操作 -->
<insert id="bindingDriver_update_insert" parameterType="java.util.List">
insert into z_binding(transpotyComId,fiapper_num,ucardid) values
<foreach collection="list" item="item" index="index" separator=",">
(#{item.transpotyComId},#{item.fiapper_num},#{item.ucardid})
</foreach>
</insert>