关于mybatis xml中用in、start with查询数据代码片段

mybatis xml如下：

<select id="queryChildDeptInfoByDid" parameterType="string" resultType="HashMap"> select a.dept_id,a.parent_id from sys_dept a where 1=1 start with a.dept_id = #{deptId} connect by prior a.dept_id = a.parent_id </select> <select id="queryDeptInfoList" resultType="HashMap" parameterType="HashMap"> select * from sys_dept A <where> <if test="deptIds != null and deptIds!=''"> AND A.DEPT_ID IN <foreach item="item" index="index" collection="deptIds" open="(" separator="," close=")"> #{item} </foreach> </if> </where> </select>

dao层：

@MyBatisDao public interface SysDeptDao extends CrudDao<SysDept> { ... //递归查询部门及子部门信息 List<HashMap<String,Object>> queryChildDeptInfoByDid(String deptId); //条件查询部门 List<HashMap<String,Object>> queryDeptInfoList(HashMap<String,Object> params); ... }

Service层：

@Service @Transactional(readOnly = true) public class SysDeptService extends CrudService<SysDeptDao, SysDept> { public Page findPage(Page page, HashMap<String, Object> paramsMap) { String deptId=paramsMap.get("deptId")==null?"":paramsMap.get("deptId").toString(); List<HashMap<String,Object>>resultList1=dao.queryChildDeptInfoByDid(deptId); String [] cIdArray = {"-1"}; List<String> deptList1=new ArrayList<String>(); if(!StringUtils.isBlank(deptId) && resultList1!=null && resultList1.size()>0){ for(HashMap<String,Object> m:resultList1){ deptList1.add(m.get("deptId").toString()); } cIdArray=deptList1.toArray(new String[deptList1.size()]); } paramsMap.put("deptIds",cIdArray); page.setRecords(dao.queryDeptInfoList(page,paramsMap)); return page; } }