public class Page<T> implements Serializable{ private int pageNo = 1;//页码,默认是第一页 private int pageSize = 20;//每页显示的记录数,默认是20 private int totalRecord;//总记录数 private int totalPage;//总页数 private List<T> results;//对应的当前页记录 private Map<String, Object> params = new HashMap<String, Object>();//其他的参数我们把它分装成一个Map对象
}
map中嵌套list
map.put("spIds", new ArrayList("1"));
1、通过index方式
<select id="queryPages" parameterType="page" resultType="modelSku"> SELECT * FROM model_sku m WHERE yn=1 <if test="params.spIds != null and params.spIds.size() > 0" > AND s.spId in <foreach collection="params.spIds" index="index" open="(" separator="," close=")" item="name"> #{params.spIds[${index}],jdbcType=INTEGER} </foreach> </if> order by updateTime desc </select>