@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}
版权声明:本站所有资料均为网友推荐收集整理而来,仅供学习和研究交流使用。
工作时间:8:00-18:00
客服电话
电子邮件
admin@qq.com
扫码二维码
获取最新动态