Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to realize the batch update of oracle in mybatis. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Student class

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 class

Public String batchUpdateStudent () {List studentslist=new ArrayList (); for (int I = 0; I < 10; iTunes +) {Student student=new Student (); student.setSid (I); student.setSname ("cc" + I); student.setSage (iTun10) Studentslist.add (student);} studentService.batchUpdateStudent (studentslist); return "batchinsertstudent";}

3.

Update student set sname = # {item.sname}, sage = # {item.sage} where sid = # {item.sid}

Note: oracle batch updates open= "begin" end= "end;" sql ends with a semicolon

This is the end of this article on "how to achieve batch oracle updates in mybatis". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.