1、Ibatis批量添加(注意:传入参数class的list即可)
<insert id="Add" resultMap="SelfDefinedResultMap" parameterClass="java.util.List">
insert all
<iterate conjunction="">
into SYS_TABLE
(id,Category,Name,Code,Status)
values(#[].Id#,#[].Category#,#[].Name#,
#[].Code#,#[].Status#)
</iterate>
<!--下面这句必须加,不然会提示找不到SELECT-->
select * from dual
</insert>
2、Ibatis批量删除(传入ID字符串的list即可)
<delete id="Del" resultMap="SelfDefinedResultMap" parameterClass="java.util.List">
delete
from SYS_TABLE
where id in
<iterate conjunction="," open="(" close=")">
#[]#
</iterate>
</delete>
3、Ibatis批量修改(传入class的list即可)
<update id="Update" resultMap="SelfDefinedResultMap" parameterClass="java.util.List">
begin
<iterate conjunction="">
update SYS_TABLE set
Category=#[].Category#,
Name =#[].Name#,
Code =#[].Code#,
Status =#[].Status#
where id = #[].Id#;
</iterate>
end;
</update>
4、Ibatis查询
<select id="SelectConfig" parameterClass="java.util.List" resultMap="SelfDefinedResultMap">
SELECT
all
FROM SYS_TABLE
WHERE id IN
<iterate conjunction="," open="(" close=")">#[]#</iterate>
</select>
如果parameterClass 是 Java.util.List,则可以写成下面的样子:参考https://blog.csdn.net/chenkeqin_2012/article/details/39640769
// List<String> statusList = ...
// Map<String, Object> param = new HashMap<>();
// param.put("statusList", statusList);
<select id="SelectConfig" parameterClass="java.util.Map" resultMap="SelfDefinedResultMap">
SELECT
all
FROM SYS_TABLE
WHERE status IN
<iterate conjunction="," open="(" close=")" property="statusList">#statusList[]#</iterate>
</select>
另一种批量查询,比如,根据 user_id 查询用户信息,给你一个user_id 列表,一次性查询:mysql语句如下:
SELECT * FROM `am_user_info_config` WHERE user_id in ('user_id1','user_id2','user_id3')