springMVC+mybatis，如何实现批量多条件的查询？

Question

问题描述：比如有一张用户表，有以下字段：
id:主键
userName:用户名
userAge:用户年龄
userAddress:用户住址

我想根据id和userName两个条件构造出一个list入参，实现批量查询，我知道如何只有一个入参的list,可以使用类似下面的语句实现

public List<XXXBean> getXXXBeanList(List<String> list);
<select id="getXXXBeanList" resultType="XXBean">
select 字段... from XXX where id in
<foreach item="item" index="index" collection="list"
open="(" separator="," close=")"> 
#{item} 
</foreach> 
</select>

但是传入多个条件的list, 在mybatis中的xml怎么写？麻烦指导下。

Answer 1

http://chenzhou123520.iteye.c...

Answer 2

 select date_format(create_Time,'%Y-%m-%d %H:%i:%s') as createTime ,reason,operator,remarks,operation from refund_order_log
        where (order_no,channel) in
        <foreach collection="list" item="item" open="(" close=")" separator=",">
            (#{item.orderNo},#{item.channel})
        </foreach>
        and status =1 order by create_time  desc

参考mysql 查询in 多个字段

select * from user where (user_id,type) in ((568,6),(569,6),(600,8));