student类
package com.test.hou.po;
public class Student {
private int sid;
private String sname;
private int sage;
public int getSid() {
return 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类
public String batchDeleteStudent(){
List<Student> studentslist=studentService.selectStudent();
studentService.batchDeleteStudent(studentslist);
return "batchinsertstudent";
}
3.StudentMapperXml类
<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>