mybatis查询xml多个list查询条件

mybatis查询xml多个list查询条件

1.新建一个bean，查询条件放入多个list；

2.xml方法名称使用bean中名称。

3.查询结果用于条件查询，sql使用SUBSTR(t.no,5,5)截取5位。

java:

QryBindCardBean bean = new QryBindCardBean();
bean.setCustSeqList(custSeqList);
bean.setBrandCardBinList(walmBrandList);
List<CustPurseDTO> mCustPurseList = custPurseDTOMapper.queryullCrandList(bean);

Mapper：
 

public List<CustPurseDTO> queryFullCrandList(@Param("lists")QryBindCardBean bean);

 xml:

<select id="queryFullCrandList"  resultMap="com.cul.culsite.dao.MCustPurseDTOMapper.BaseResultMap">
		SELECT 
		<include refid="Base_Column_List"/>
  		FROM CUST_PURSE T
 		WHERE  T.STATUS = 'Y'
 		AND T.TYPE = 'CARD'
 		AND T.CUST_SEQ in 
 		<foreach collection="lists.custSeqList" index="index" item="item" open="(" separator="," close=")">
 			#{item}   
 		</foreach>
 		AND SUBSTR(t.no,5,5) in 
 		<foreach collection="lists.brandCardBinList" index="index" item="item" open="(" separator="," close=")">
 			#{item}   
 		</foreach>
 		ORDER BY CARD_LEVER asc, MCP_END_DATE asc
	</select>