mybatis 查询sql中in条件用法详解(foreach)

< select id= "findBy" resultMap= "RfCustomerMemMap" parameterType= "java.util.Map" >

   SELECT

   <include refid= "Column" />

   FROM rfl_customer_mem a LEFT JOIN rfl_loan b ON a.member_no = b.loan_member_no

   WHERE a.member_no = #{memberNo} AND b.status IN

   <foreach collection= "status" index = "index" item= "item" open = "(" separator= "," close = ")" >

    #{item}

   </foreach>

   <if test= "name != null and name != ''" >

    AND name = #{ name }

   </if>

   <if test= "idNumber != null and idNumber != ''" >

    AND id_number = #{idNumber}

   </if>

   <if test= "mobileNo != null and mobileNo != ''" >

    AND mobile_no = #{mobileNo}

   </if>

   <if test= "loanNo != null and loanNo != ''" >

    AND loan_no = #{loanNo}

   </if>

   order by a.id DESC

   <if test= "offset > -1 and rows > -1" >

    limit #{offset},#{limit}

   </if>

  </ select >

public List<LoanMerchantMemEntity> findMerchantMemBy(String merchantName, String merchantNo, String socialCreditCode, String loanNo, int offset, int limit) {

   List<LoanMerchantMemEntity> list = new ArrayList<LoanMerchantMemEntity>();

   Map<String, Object> filter = new HashMap<String, Object>();

   filter.put( "merchantName" , merchantName);

   filter.put( "socialCreditCode" , socialCreditCode);

   filter.put( "status" , statsList());

   filter.put( "loanNo" , loanNo);

   filter.put( "offset" , offset);

   filter.put( "limit" , limit);

   filter.put( "merchantNo" , merchantNo);

   try {

    List<LoanMerchantMemEntity> row = loanMerchantMemDao.findBy(filter);

   } catch (Exception e) {

    LOGGER.error(filter, "查询企业会员信息异常" , e);

   }

   return list;

  }

  static List<String> statsList(){

   List<String> statusList = new ArrayList<String>();

   statusList.add( "SUCCESS" );

   statusList.add( "DUE" );

   statusList.add( "OVER" );

   return statusList;

  }

String name =(String) params.get( "name" );

String[] hiddens = name .split( "," );

params.put( "name" , hiddens);

<foreach collection= "name" index = "index" item= "item" open = "(" separator= "," close = ")" >

    #{item}

   </foreach>