1. myabtis的mapper方法如果有List或者Map类型参数,如何在mapper.xml文件中判断该集合是否为空?
// mapper.java方法声明
public List<?> getUserByNoList(@param("noList") List<Integer> noList);
<select returnType = "com.zkh360.pms.supplier.business.dto.SupplierQualificationPageResult">
select * from users
<where>
<if test = "noList != null and noList.size() > 0">
and user_no in
<foreach collection = "noList" item = "userNo" index = "index" open = "(" close = ")" separator = ",">
#{userNo}
</foreach>
</if>
</where>
2. 查询结果分页如何实现?
3. xxl-job如何添加任务?