mybatis-oracle(ssi2)批量删除
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>
本文出自 “大话程序” 博客,请务必保留此出处http://houqida.blog.51cto.com/8877896/1562453
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。