mybatis使用foreach循环语句查询数据

mybatis使用foreach循环语句查询数据

        if (session.getAttribute("user") != null) {
            Object user = session.getAttribute("user");
            ObjectMapper objectMapper = new ObjectMapper();
            Users users = objectMapper.convertValue(user, Users.class);
            List> deptGroupDetailed = users.getUser().getDeptGroupDetailed();
            List codeList = deptGroupDetailed.stream().map(i -> i.get("DEPT_CODE")).distinct().collect(Collectors.toList());
            blPageBean.setUserCodeList(codeList);
        }

首先取出来数据，然后存到实体类中。

    private List userCodeList;

实体类格式

    
        SELECT DEPT_CODE as "deptCode" ,DEPT_NAME as "deptName"
        FROM TB_FEEMON_DIC_DEPARTMENT
        
            WHERe TB_FEEMON_DIC_DEPARTMENT.DEPT_CODE in
            
                #{item}
            
        
	

然后在xml中写sql语句即可。 userCodeList 对应为实体类字段名称。