Mybatis-oracle (SSI2) Bulk Delete

1. Student class

Package Com.test.hou.po;public class Student {private int sid;private String sname;private int sage;public int GetSID () {R Eturn SID;} public void Setsid (int sid) {this.sid = SID;} Public String Getsname () {return sname;} public void Setsname (String sname) {this.sname = sname;} public int getsage () {return sage;} public void setsage (int sage) {this.sage = sage;}}

2.StudentAction class

Public String batchdeletestudent () {list<student> studentslist=studentservice.selectstudent (); Studentservice.batchdeletestudent (studentslist); return "Batchinsertstudent";}

3.StudentMapperXml class

<delete id= "batchdeletestudent" parametertype= "Java.util.List" >delete from student <where><foreach collection= "List" open= "(" separator= "or" close= ")" item= "item" index= "index" >sid =#{item.sid}</foreach> </where></delete>

This article is from the "Big Talk Program" blog, please be sure to keep this source http://houqida.blog.51cto.com/8877896/1562453

Mybatis-oracle (SSI2) Bulk Delete