mybatis in条件查询(foreach)

mybatis查询sql中in条件使用(foreach)

xml

<!-- 查询订单 -->    <select id="selectBankDayAlreadyPaidAmountByBankId" resultType="AlleywayBankDayAmountDto" parameterType="java.util.Set">        select alleyway_id,sum(order_amount) as order_amount from tb_order        where pay_status in ( 2, 3)        and DATE_FORMAT(resp_time, '%y-%m-%d') = DATE_FORMAT(NOW(), '%y-%m-%d')        and bank_id in        <foreach collection="bankIds" index="index" item="item" open="(" separator="," close=")">            #{item}        </foreach>        group by alleyway_id    </select>

java

List<AlleywayBankDayAmountDto> selectBankDayAlreadyPaidAmountByBankId(@Param("bankIds") Set<String> bankIds);