mybatis 实现批量多条件的查询【案例+代码】

复杂写法可以留言，JavaPub

SQL:

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

MyBatis XML:

    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

我是 JavaPub，三观很正，乐于创业，喜欢烹饪。今年已近年中，各位小伙伴一定已经拿到自己心仪的offer，但是不要忘记进步，共勉！pub哥的2020文章清单！