foreach循環遍歷list集合，mybatis多個foreach_mybatis的foreach 刪除多條使用匯總

@Test //刪除多條-數組

foreach循環遍歷list集合、public void testDeleteByArray(){

SqlSession session = factory.openSession();

int[] ids = {4,6};

session.delete(“cn.qq.mapper.PersonMapper.deleteArray”, ids);

session.commit();

}

@Test //刪除多條-LIST

public void testDeleteByList(){

SqlSession session = factory.openSession();

List _list = new ArrayList();

_list.add(4);

_list.add(6);

session.delete(“cn.qq.mapper.PersonMapper.deleteList”, _list);

session.commit();

}

@Test //刪除多條 MAP

public void testDeleteByMap(){

SqlSession session = factory.openSession();

Map paraMap = new HashMap();

int[] ids = {4,6};

paraMap.put(“ids”, ids);

session.delete(“cn.qq.mapper.PersonMapper.deleteMap”, paraMap);

session.commit();

}

delete from person

where id in

(

#{id}

)

delete from person

where id in

#{id}

delete from person

where id in

#{id}