废话不多说了 直接步入正题了。 直接步入正题了。
1 、批量添加元素 session.insert (cadena de cadena, objeto o)
public void batchInsertStudent () {list <diel student> ls = new ArrayList <deude> (); para (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 (estudiante);} sqlSession session = sessionFactoryUtil.getSqlSessionFactory (). Opensession (); session.insert ("myBatisDemo.domain.Student.BatchinSertStudent", ls); session.Commit (); session.clase ();} id = "batchinsertstudent" parametertype = "java.util.list"> Insertar en el estudiante (id, nombre, sexo, tele, valores) Valores <foreach Collection = "list" item = "item" index = "index" separator = ",", ",", ", > (#{item.id},#{item.name},#{item.sex},#{item.tel},#{item.address}) </foreach> </sert>2 、批量修改 Sesión. insertar (cadena de cadena, objeto 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" parameterType = "java.utililia" list "> uptine name =" 556666 " ID en <foreach Collection = "list" item = "item" index = "index" Open = "(" separator = "," close = ")">#{item} </stideach> </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 = newmap <string, object> (); map.put ("iDlist", ls); map.put ("name", "nombre", "nombre", "nombre", "nombre", "nombre", "nombre", "nombre", "nombre", "nombre". "mmao789"); sqlSession session = sessionFactoryUl.getSqlSessionFactory (). OpenSession (); session.insert ("myBatisDemo.domain.student.batchUpDateStudentWithMap", map); session.commit (); session.close (); parametertype = "java.util.map"> Actualizar el set de set name = #{name} donde id en <foreach Collection = "idlist" index = "index" item = "item" Open = "(" separator = "," Close = ")"> #{item} </foreach> </palate> 3 、批量删除 session.delete (cadena de cadena, objeto o)
public void batchDeletEntudent () {list <integer> ls = new ArrayList <Integer> (); for (int i = 4; i <8; i ++) {ls.add (i);} sqlsession session = SessionFactoryUtil.getSqlSessionFactory (). OpenSession (); session.delete ("myBatisDemo.domain.student.batchDeletEntudent", ls); session.commit (); session.close ();} <delete id = "batchdeletudent" parametertype = "java.utilil.list" list " colección = "list" index = "index" item = "item" Open = "(" separator = "," Close = ")"> #{item} </FOREACH> </elelete>好了 , 本文到此结束 希望对大家有所帮助。 希望对大家有所帮助。