Mybatis 传参数 List Array

两个类

 
//
public class ShopBean{
private Integer shopId;

private List<BaseBean> shopList;

private String[]  shopArray;

//get  method

//set  method


} 

//基类
public  class BaseBean{

private Integer shopId;

private Integer shopName;

private String shopAddress;

//get  method

//set  method


}

当传入参数为 ShopBean,foreach 访问 List ，
需要设置 collection="shopList"，与ShopBean中参数名对应。
遍历每一个 BaseBean ,设置item="item"，这里可以任意，
表示遍历的当前BaseBean对象，要访问BaseBean 中的对象 直接  item.shopId

<select id="searchMaxSaleProduct" resultType="ShopBean" parameterType="ShopBean" >
  		 SELECT TOP 1 
			T1.shopId AS ShopId
		FROM
		     dbo.T_Sale T1
		WHERE
		 	ShopId  IN
		 <foreach collection="shopList" item="item" open="(" separator="," close=")">
		 	#{item.shopId}
		 </foreach>
		 
		
		
  </select>

遍历 Array

<select id="searchMaxSaleProduct" resultType="ShopBean" parameterType="ShopBean" >
  		 SELECT TOP 1 
			T1.shopId AS ShopId
		FROM
		     dbo.T_Sale T1
		WHERE
		 	ShopId  IN
		 <foreach collection="shopArray" item="item" open="(" separator="," close=")">
		 	#{item}
		 </foreach>
		 
		
		
  </select>