部門頁面的回顯

• 首先查詢出當前用戶的資料，然后在查詢出所有的部門

DeptControl

@Controller
@RequestMapping("/dept")
public class DeptControl {

    @Autowired
    IDeptService iDeptService;
    private static  final Logger l = LoggerFactory.getLogger(DeptControl.class);
    @RequestMapping(path="/toList",method ={ RequestMethod.GET, RequestMethod.POST})
    public String toList(Model model, Integer curr, Integer pageSize, String companyId){
        l.info("toList curr = "+curr);
        l.info("toList pageSize = "+pageSize);
        l.info("toList companyId = "+companyId);
        //查詢一個分頁
        if (curr==null){
            curr=1;
        }
        if (pageSize==null){
            pageSize=10;
        }
        PageInfo<Dept> pi = iDeptService.findByPage(curr, pageSize, companyId);
        l.info("toList pi = "+pi);
        model.addAttribute("pi",pi);
        return "system/dept/dept-list";
    }
    // ${path}/system/dept/toUpdate.do?deptId=${dept.deptId}
    @RequestMapping(path="/toUpdate",method ={ RequestMethod.GET, RequestMethod.POST})
    public String toUpdate(Model model, String deptId){

        String companyId = "1";
        l.info("toUpdate deptId="+deptId);

        //查詢部門
        Dept dept = iDeptService.findById(deptId);
        l.info("toUpdate dept="+dept);
        List<Dept> list = iDeptService.findAll(companyId);
        model.addAttribute("dept",dept);
        model.addAttribute("list",list);

        return "system/dept/dept-update";
    }



}

IDeptService

public interface IDeptService {
    PageInfo<Dept> findByPage(int curr, int pageSize, String companyId);
    Dept findById(String deptId);
    List<Dept> findAll(String companyId);
}

DeptServiceImpl

@Service
public class DeptServiceImpl implements IDeptService {
    @Autowired
    IDeptDao iDeptDao;

    public PageInfo<Dept> findByPage(int curr, int pageSize, String companyId) {
        //呼叫dao查詢所有的記錄
        //select * from dept;
        //select count(*) from dept;
        //select * from dept limit 0,20;
        PageHelper.startPage(curr,pageSize);
        List<Dept> list =  iDeptDao.findDept();
        return new PageInfo<Dept>(list);
    }

    public Dept findById(String deptId) {
        return iDeptDao.findDeptById(deptId);
    }

    public List<Dept> findAll(String companyId) {
        List<Dept> list =  iDeptDao.findAllByDept(companyId);
        return list;
    }
}

IDeptDao

public interface IDeptDao {
    //查詢所有的部門記錄
    List<Dept> findDept();
    Dept findDeptById(String id);
    List<Dept> findAllByDept(String companyId);//查詢所有的部門名字
}

IDeptDao.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<!--namespace: 需要映射的Dao介面型別-->
<mapper namespace="com.wlj.dao.dept.IDeptDao">
    <!--將查詢結果映射到成員變數-->
    <resultMap id="findOneMap" type="dept">
        <id column="dept_id" property="deptId"/>
        <result column="dept_name" property="deptName"/>
        <result column="company_id" property="companyId"/>
        <result column="company_name" property="companyName"/>
        <!-- 將parent_id 映射Dept型別-->
        <association property="parent"  column="parent_id" javaType="dept" select="findDeptById">
        </association>
    </resultMap>
    <select id="findDept" resultMap="findOneMap">
            select * from pe_dept
    </select>

    <select id="findDeptById" parameterType="string" resultMap="findOneMap">
        select  * from  pe_dept where dept_id = #{id}
    </select>
    <select id="findAllByDept" parameterType="string" resultMap="findOneMap">
        select dept_name from pe_dept where company_id=#{companyId}
    </select>
</mapper>