mybatis遍历集合List、Array、Map

一、遍历集合

1.不用注解

public void insertList(List<User> users);
<insert id="insertList" parameterType="java.util.List" >
insert into user (id,name,password,sex,age)
values 
<foreach collection="list" open="(" close=")" separator="," item="item">
    (#{item.id,jdbcType=INTEGER}, #{item.name,jdbcType=VARCHAR}, 
    #{item.password,jdbcType=VARCHAR}, #{item.sex,jdbcType=TINYINT}, 
    #{item.age,jdbcType=INTEGER})
</foreach>
</insert>

2.使用@Param注解

public void insertList(@Param("list") List<User> users);
<insert id="insertList">
insert into user (id,name,password,sex,age)
values 
<foreach collection="users" open="(" close=")" separator="," item="item">
    (#{item.id,jdbcType=INTEGER}, #{item.name,jdbcType=VARCHAR}, 
    #{item.password,jdbcType=VARCHAR}, #{item.sex,jdbcType=TINYINT}, 
    #{item.age,jdbcType=INTEGER})
</foreach>
</insert>

二、遍历数组Array

1.不用注解

public List<User> selectAllUsers(Integer[] ids);
<select id="selectAllUsers" parameterType="java.util.Array" >
select * from user where id in
<foreach collection="array" open="(" close=")" separator="," item="item">
       #{item,jdbcType=INTEGER}
</foreach>
</select

2.使用@Param注解

public List<User> selectAllUsers(@Param("ids") Integer[] ids);
<select id="selectAllUsers" parameterType="java.util.Array" >
select * from user where id in
<foreach collection="ids" open="(" close=")" separator="," item="item">
       #{item,jdbcType=INTEGER}
</foreach>
</select

三、遍历两个集合

List<SubOrgDetail> selectSubOrgDetail(@Param("params") Map<String, Object>;
<select id="selectSubOrgDetail" resultMap="BaseResultMapDetail">
SELECT org.org_id,org.org_name,t.goods_id,t.num,`user`.user_pic 
FROM 
organization org 
INNER JOIN 
    (SELECT belong_org,num,goods_id 
    FROM
    org_goods
    WHERE
    now_org = 1 AND
    belong_org in
    <foreach close=")" collection="params.orgIds" index="index" item="id" open="(" separator=",">
        #{id}
    </foreach>
    AND goods_id in         
    <foreach close=")" collection="params.goodIds" index="index" item="id" open="(" separator=",">
        #{id}
    </foreach>) t
ON
org.org_id=t.belong_org
INNER JOIN
`user`
ON
`user`.org_id=t.belong_org
</select>

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值