<?xml version="1.0" encoding="UTF-8"?><!DOCTYPEmapperPUBLIC"-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="cn.js.Mapper.DepartmentMapper"><resultMapid="DepartmentMapper"type="cn.js.domain.Department"><idcolumn="id"property="id"/><resultcolumn="name"property="name"/><collectionproperty="employees"ofType="cn.js.domain.Employee"columnPrefix="e"><idcolumn="id"property="id"/><resultcolumn="name"property="name"/><resultcolumn="pid"property="pid"/></collection></resultMap><selectid="getOneortwo"resultMap="DepartmentMapper">
SELECT d.name ,d.id ,e.id eid ,e.name ename, e.pid epid
FROM department d JOIN employee e on
d.id=e.pid
</select></mapper>
<selectid="all"resultType="cn.js.domain.Employee">
SELECT e.id,e.name ,e.pid
FROM employee e where e.pid=#{id} //id-->是部门id作为参数,也就是条件
</select>
第二步在部门mapp.xml文件中:编写写查询语句:
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPEmapperPUBLIC"-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="cn.js.Mapper.DepartmentMapper"><!--+++++++++++++++++++额外SQl+++++++++++++++++--><resultMapid="Department"type="cn.js.domain.Department"><idcolumn="id"property="id"/><resultcolumn="name"property="name"/><collectionselect="cn.js.Mapper.EmployeeMapper.all"column="id"property="employees"/></resultMap><selectid="getOneortwoll"resultMap="Department">
SELECT d.name ,d.id
FROM department d
</select></mapper>
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPEmapperPUBLIC"-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="cn.js.Mapper.DepartmentMapper"><!--一对多 对多--><resultMapid="DepartmentMappers"type="cn.js.domain.Department"><idcolumn="id"property="id"/><resultcolumn="name"property="name"/><collectionproperty="employees"ofType="cn.js.domain.Employee"columnPrefix="e"><idcolumn="id"property="id"/><resultcolumn="name"property="name"/></collection><collectionproperty="firms"ofType="cn.js.domain.Firm"columnPrefix="f"><idcolumn="id"property="id"/><resultcolumn="name"property="name"/><resultcolumn="fid"property="fid"/></collection></resultMap><selectid="getTwoortwoll"resultMap="DepartmentMappers">
SELECT d.name,d.id, e.name ename,e.id eid,e.pid epid,f.id fid,f.name fname,f.fid ffid
FROM
department d join
employee e ON d.id=e.pid
JOIN firm f ON d.id=f.fid
</select></mapper>