mabits批量insert、update、select
来源:互联网 发布:mac os 清理 编辑:程序博客网 时间:2024/06/03 09:44
一、批量查询
①单条件批量查询
dao 层
public List<String>bindingDriver_update_select(List<BindingDriver> list);
xml文件
<select id="bindingDriver_update_select" resultType="java.lang.String">
SELECT z_driver.username FROM z_binding
INNER JOIN z_driver ON z_driver.ucardid = z_binding.ucardid
where z_binding.ucardid in
<foreach collection="list" index="index" item="item" open="(" separator="," close=")">
#{item.ucardid}
</foreach>
</select>
②多条件批量查询
dao 层
public List<String>bindingDriver_update_select(List<BindingDriver> list);
xml文件
<select id="bindingDriver_update_select" resultType="java.lang.String">
<foreach collection="list" index="index" item="item" open="" close="" separator=";">
SELECT z_driver.username FROM z_binding INNER JOIN z_driver ON z_driver.ucardid = z_binding.ucardid
where z_binding.ucardid = #{item.ucardid} and z_binding.fiapper_num !=#{item.fiapper_num}
</foreach>
</select>
注意:单条件和多条件查询,foreach标签的open、close、separator属性不同,单条件separator是逗号“,”,多条件时separator是分号“;”
二、批量修改
①单条件修改
dao层
public void administrative_unit_update(List<TranspotyCar> list);
xml文件
<update id="administrative_unit_update" parameterType="java.util.List">
update z_transpotycar
set administrative_unit=#{item.administrative_unit}
where fiapper_num in
<foreach collection ="list" item="item" index= "index" open="(" separator="," close=")">
#{item.fiapper_num}
</foreach>
</update>
②多条件修改
dao层
public void administrative_unit_update(List<TranspotyCar> list);
xml文件
<update id="administrative_unit_update" parameterType="java.util.List">
<foreach collection ="list" item="item" index= "index" separator =";">
update z_transpotycar
<set>
administrative_unit=#{item.administrative_unit}
</set>
where fiapper_num=#{item.fiapper_num} and transpotyComId=#{item.transpotyComId}
</foreach>
</update>
三、批量insert
dao层
public void bindingDriver_update_insert(List<BindingDriver> list);
xml文件
<!-- 批量增加操作 -->
<insert id="bindingDriver_update_insert" parameterType="java.util.List">
insert into z_binding(transpotyComId,fiapper_num,ucardid) values
<foreach collection="list" item="item" index="index" separator=",">
(#{item.transpotyComId},#{item.fiapper_num},#{item.ucardid})
</foreach>
</insert>
- mabits批量insert、update、select
- 根据select结果批量insert或update
- mybatis 批量insert,update
- mybatis 批量insert , update
- Insert Update Delete Select
- Update Select批量更新
- mysql 批量 insert 和 update
- mybaits批量insert和update
- mybatis批量update,insert,delete
- SQL INSERT / UPDATE WITH SELECT
- insert into select 堵塞update
- mybatis+oracle+批量insert批量update
- sqlserver的insert select 和update select
- Mysql insert select批量插入
- mabits
- SQL语句:update---select,insert---select,select---into
- Android Sqlite 批量 insert/update 提高效率
- MyBatis oracle 批量 insert update 新增 更新
- MyBatis 通过包含的jdbcType类型
- python
- HDU1032
- 排序算法(二):希尔排序(最小增量排序)
- TCP/IP、HTTP协议的区别
- mabits批量insert、update、select
- Android Convenient无限轮播
- python、Jmeter接口自动化框架、支付测试
- Spark---性能优化之开发篇
- 在lnmp上运行和搭建laravel项目
- 深度优先搜索和广度优先搜索的区别
- 数据库学习——排序
- Splunk-SDK-Python学习
- CSS控制文字只显示一行,超出部分显示省略号