1. mybatis 传入Array
<!-- int delByIds(@Param("ids") String[] idArr); -->
<delete id="delByIds" >
delete from sys_config where id in
<foreach item="iditem" collection="ids" open="(" separator="," close=")">
#{iditem}
</foreach>
</delete>
<!-- ***************************************************************** -->
<!-- public int delByIds(String[] idArr); -->
<delete id="delByIds" >
delete from sys_config where id in
<foreach item="iditem" collection="array" open="(" separator="," close=")">
#{iditem}
</foreach>
</delete>
2. mybatis 传入list
<!-- int delByIds(@Param("ids") List<String> idArr); -->
<delete id="delByIds">
delete from sys_config where id in
<foreach item="iditem" collection="ids" open="(" separator="," close=")">
#{iditem}
</foreach>
</delete>
<!-- ***************************************************************** -->
<!-- int delByIds(List<String> idArr); -->
<delete id="delByIds">
delete from sys_config where id in
<foreach item="iditem" collection="list" open="(" separator="," close=")">
#{iditem}
</foreach>
</delete>
2. mabatis 传入list<JSON>或list<Map>,数组同理
传入数据：
[{id:"1",state:"1"},{id:"2",state:"1"},{id:"3",state:"2"}]
字段判空：<if test="item !=null and item.id !=null and item.id !='' "></if>
注意：这里的foreach 分割符为or，open和close为( )
<foreach item="item" collection="confObjList" open="(" separator="or" close=")">
<!-- int delByIds(@Param("confObjList") List<JSONObject> confObjList); -->
<!-- int delByIds(@Param("confObjList") List<Map<String,Object>> confObjList); -->
<delete id="delByIds">
delete from sys_config where
<foreach item="item" collection="confObjList" open="(" separator="or" close=")">
id = #{item.id} and status = #{item.state}
</foreach>
</delete>
<!-- ↓↓↓ 最终的sql ↓↓↓
delete from sys_config where (id='1' and status='1')
or (id='2' and status='1')
or (id='3' and status='2')
-->
4. mybatis 传入二维数组或双层list 使用下标获取数组数据
list<String[]>或list<ArrayList<String>>或list<ArrayList<JSONObject>>,数组同理
传入数据：[ ["1","aaa"], ["2","bbb"], ["3"] ]
注意这里用${}替换#{},用$需要自己拼接单引号，这儿有可能存在sql注入问题
===> 数组用.length,List用.size()
<!-- int delByIds(@Param("confObjList") List<String[]> confObjList); -->
<delete id="delByIds">
delete from sys_config where
<foreach collection="confObjList" item="items" open="(" separator="or" close=")">
<if test="items!=null and items.length == 1">
id='${items[0]}'
</if>
<if test="items !=null and items.length == 2">
( id='${items[0]}' and name='${items[1]}')
</if>
</foreach>
</delete>
<!-- int delByIds(@Param("confObjList") List<Map<String,Object>> confObjList); -->
<delete id="delByIds">
delete from sys_config where
<foreach collection="confObjList" item="items" open="(" separator="or" close=")">
<if test="items!=null and items.size() == 1">
id='${items[0]}'
</if>
<if test="items !=null and items.size()== 2">
( id='${items[0]}' and name='${items[1]}')
</if>
</foreach>
</delete>
<!-- ↓↓↓ 最终的sql ↓↓↓
delete from sys_config where (id='1' and name='1')
or (id='2' and name='1')
or (id='3' )
-->
3. mybatis 传入二维数组或双层list
list<String[]>或list<ArrayList<String>>或list<ArrayList<JSONObject>>,数组同理
传入数据：[ ["1","aaa"], ["2","bbb"] ]
注意这里用${}替换#{}, ===> 数组用.length,List用.size()
<!-- int delByIds(@Param("confObjList") List<String[]> confObjList); -->
<delete id="delByIds">
delete from sys_config where
<foreach collection="confObjList" item="item1" open="(" separator="or" close=")">
<foreach collection="item1" item="item2" open="(" separator="and" close=")">
name =#{item2}
</foreach>
</foreach>
</delete>
<!-- ↓↓↓ 最终的sql ↓↓↓
delete from sys_config where (name='1' and name='aaa')
or (name='2' and name='bbb')
-->
