废话不多说了 , 直接步入正题了。
1 、批量添加元素 sesi.insert (string string , objek 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 (siswa);} SQLSESSION SESION = sessionfactoryutil.getsqlSessionFactory (). OpenSession (); session.insert ("mybatisdemo.domain.student.batchsertSertStudent", ls); oDomose. ID = "BatchInSertStudent" ParameTerType = "java.util.list"> masukkan ke siswa (id, nama, seks, tel, alamat) nilai <foreach collection = "list" item = "item" index = "index" pemisah = "," > (#{item.id},#{item.name},#{item.sex},#{item.tel},#{item.address}) </foreach> </insert>2 、批量修改 sesi. masukkan (string string, objek o)
实例 1 :
public void BatchUpdAteStudent () {List <Integer> ls = ArrayList baru <Integer> (); for (int i = 2; i <8; i ++) {ls.add (i);} sesi SQLSession = Sessionfactoryutil.getSqlSessionFactory (). Opensession (); session.insert ("mybatisdemo.domain.student.batchupdatestudent", ls); session.commit (); sesion. "5566" di mana ID di <freeach collection = "list" item = "item" index = "index" open = "(" sparator = "," close = ")">#{item} </tandingeach> </update>实例 2 :
public void BatchUpDATeStudentWithMap () {Daftar <Integer> ls = ArrayList baru <Integer> (); for (int i = 2; i <8; i ++) {ls.add (i);} peta <string, object> peta = hashmap baru <string, object> (); peta.put. "MMAO789"); SQLSession Session = sessionfactoryutil.getSqlSessionFactory (). Opensession (); session.insert ("mybatisdemo.domain.student.batchupdateDentwithmap", peta); sesion.commit (); —bosePlose () <)}}}}}; ParameterType = "java.util.map"> Perbarui siswa set siswa = #{name} di mana id di <freeach collection = "idList" index = "index" item = "item" open = "(" sparator = "," tutup = ")"> #{item} </ foreach> </update> 3 、批量删除 session.delete (String String, Object O)
public void batchDeleteStudent () {list <integer> ls = new ArrayList <Integer> (); for (int i = 4; i <8; i ++) {ls.add (i);} sesi SQLSession = Sessionfactoryutil.getSqlSessionFactory (). Opensession (); session.delete ("mybatisdemo.domain.student.batchdeletestudent", ls); session.commit (); close. collection = "list" index = "index" item = "item" open = "(" sparator = "," close = ")"> #{item} </foreach> </delete>好了 , 本文到此结束 , 希望对大家有所帮助。