废话不多说了 , 直接步入正题了。
1 、批量添加元素 session.insert (chaîne de chaîne , objet O)
public void batchInsertStudent () {list <Student> ls = new ArrayList <Student> (); for (int i = 5; i <8; i ++) {Student Student = new Student (); Student.setid (i); Student.SetName ("maoyuanjun" + i); Student.setsex ("man" + i); student.settel ("Tel" + i); student.setAddress ("浙江省" + i); ls.add (étudiant);} SqlSession Session = SessionFactoryUtil.getsqlSessionFactory (). OpenSession (); session.insert ("MyBatisDemo.Domain.Student.BatchInsertStudent", ls); Session.Commit (); session.close (); id = "BatchInssertStudent" ParameterType = "java.util.list"> Insérer dans l'élève (id, nom, sexe, tel, adresse) <foreach collection = "list" item = "item" index = "index" séparateur = "," > (# {item.id}, # {item.name}, # {item.sex}, # {item.tel}, # {item.address}) </forEach> </sert>2 、批量修改 Session. insert (chaîne de chaîne, objet O)
实例 1:
public void batchUpDateStudent () {list <Integer> ls = new ArrayList <Integer> (); for (int i = 2; i <8; i ++) {ls.add (i);} sqlSession Session = SessionFactoryUtil.getsqlSessionFactory (). OpenSession (); session.insert ("MyBatisDemo.Domain.Student.BatchUpDateStudent", ls); session.Commit (); Session.Close ();} <Update Id = "BatchUpDateStudent" ParametType = "Java.Utitil.Lis" "5566" où id dans <foreach collection = "list" item = "item" index = "index" open = "(" séparateur = "," close = ")"> # {item} </foreach> </ update>实例 2 :
public void batchUpDateStudentWithMap () {list <Integer> ls = new ArrayList <Integer> (); for (int i = 2; i <8; i ++) {ls.add (i);} map <string, object> map = new hashmap <string, object> (); map.put ("idlist", ls); map ("name", () "MMAO789"); SqlSession Session = SessionFactoryUtil.getsqlSessionFactory (). OpenSession (); session.insert ("MyBatisdemo.Domain.Student.BatchUpDateStudentWithMap", MAP); Session.Commit (); session.close (); ParameterType = "java.util.map"> Mise à jour de l'étudiant set name = # {name} où id dans <foreach collection = "idlist" index = "index" item = "item" open = "(" séparateur = "," close = ")"> # {item} </ foreach> </fated> 3 、批量删除 session.delete (chaîne de chaîne, objet O)
public void batchdeleTTudent () {list <nteger> ls = new ArrayList <Integer> (); for (int i = 4; i <8; i ++) {ls.add (i);} SQLSession Session = SessionFactoryUtil.getsqlSessionFactory (). OpenSession (); session.delete ("MyBatisDemo.Domain.Student.BatchdeleteStudent", LS); Session.Commit (); Session.Close ();} <Delete Id = "BatchdeleTestudent" ParamEterType = "Java.Ul.List"> Derete de <pour <For Id dans le <pour <pour <for-dans le cours de l'étudiant = "Java.Ul.List" collection = "list" index = "index" item = "item" open = "(" séparateur = "," close = ")"> # {item} </ foreach> </ delete>好了 , 本文到此结束 , 希望对大家有所帮助。