废话不多说了，直接步入正题了。
1、批量添加元素session.insert(string string，object 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(student);
}
sqlsession session = sessionfactoryutil.getsqlsessionfactory().opensession();
session.insert("mybatisdemo.domain.student.batchinsertstudent", ls);
session.commit();
session.close();
}
<insert id="batchinsertstudent" parametertype="java.util.list">
insert into student (id,name,sex,tel,address)
values
<foreach collection="list" item="item" index="index" separator="," >
(#{item.id},#{item.name},#{item.sex},#{item.tel},#{item.address})
</foreach>
</insert>
2、批量修改session. insert (string string,object 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.util.list">
update student set name = "5566" where id in
<foreach collection="list" item="item" index="index" open="(" separator="," 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.put("name", "mmao789");
sqlsession session = sessionfactoryutil.getsqlsessionfactory().opensession();
session.insert("mybatisdemo.domain.student.batchupdatestudentwithmap",map);
session.commit();
session.close();
}
<update id="batchupdatestudentwithmap" parametertype="java.util.map" >
update student set name = #{name} where id in
<foreach collection="idlist" index="index" item="item" open="(" separator="," close=")">
#{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);
}
sqlsession session = sessionfactoryutil.getsqlsessionfactory().opensession();
session.delete("mybatisdemo.domain.student.batchdeletestudent",ls);
session.commit();
session.close();
}
<delete id="batchdeletestudent" parametertype="java.util.list">
delete from student where id in
<foreach collection="list" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</delete>
好了，本文到此结束，希望对大家有所帮助。
如对本文有疑问， 点击进行留言回复！！
第三次学JAVA再学不好就吃翔(part88)--ArrayList嵌套ArrayList
使用ffmpeg视频切片并加密和视频AES-128加密后播放
JAVA程序设计：最长重复子串（LeetCode：1044）
LiveGBS国标GB/T28181云端录像分布式录像存储自动清理时移回看录像下载播放
网友评论