废话不多说了、直接步入正题了。
1 、批量添加元素 session.insert(string string、object o)
public void batchinsertStudent(){list <sudtent> ls = new arraylist <sustent>(); for(int i = 5; i <8; i ++){desute student = new Student(); sudine.setid(i); setsname( "maoyuanjun" + i); sudints.setsex( "man" i); sudint.setAddress( "浙江省" + i); ls.add(sudent);} sqlsession session = sessionfactutil.getsqlsessionfactory() id = "batchinsertStudent" parametertype = "java.util.list"> inserting into student(id、name、sex、tel、address)value < >(#{item.id}、#{item.name}、#{item.sex}、#{item.tel}、#{item.address})</foreach> </insert>2 、批量修改セッション。挿入(文字列文字列、オブジェクトo)
实例1:
public void batchupdateStudent(){list <integer> ls = new arraylist <integer>(); sessionfactutil.getsqlsessionfactory(); session.insert( "mybatisdemo.domain.student.student.student.student.batchupdateStudent"、ls); session.commit(); session.close();} <update id = "batchupdateStudent" parametertype = "java.util.util.util.util.utipe"ここで<foreach collection = "list" item = "item" index = "index" open = "(" separator = "、" close = ")">#{iteach} </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>( "mmao789"); sqlsession session = sessionfactutil.getsqlsessionfactory()。opensession(); session.insert( "mybatisdemo.domain.student.batchupdatudentwithmap"、map); session.commit(); session.commiT(); parametertype = "java.util.map">更新学生セットname =#{name} where id in <foreach collection = "idlist" index = "oot" item = "item" open = "(" deparator = "、" close = ")"> {item 3 、批量删除SESSION.DELETE(String String、ObjectO)
public void batchdeletestudent(){list <integer> ls = new arraylist <integer>(); sessionfactutil.getsqlsessionfactory()。opensession(); session.delete( "mybatisdemo.domain.student.Student.batchdeleteStudent"、ls); session.commit(); session.close();} <delete id = "batchdeleteStudent" delteTudent "java in <foreach collection = "list" index = "index" item = "item" open = "(" separator = ")、" close = ")">#{item} </foreach> </delete>好了、本文到此结束、希望对大家有所帮助。