Mybatis 多条件批量查询

一、Mysql 多条件查询语法

?

1	SELECT * FROM merchant_settlement_summary WHERE (F_merchant_id,F_settle_amount) IN (('9012514015',7467230000),('8012514015',8467230000),(7012514015,9467230000));

 

二、Mybatis 语法

?

1 2 3 4 5 6 7 8

<select id="queryAlreadyExistSettleSummaryRecordByBatch"         resultType="com.model.MerchantSettlementSummary">     select * from merchant_settlement_summary     where (F_merchant_id,F_date) in     <foreach collection="batchList" item="item" index="item" open="(" separator="," close=")">         (#{item.fMerchantId},#{item.fDate})     </foreach> </select>