2021.11.15 工作问题总结

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如何添加任务？