mybatis xml 一对多

1. <? xml   version = "1.0"   encoding = "UTF-8" ?>   
2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >   
3. < mapper   namespace = "com.test.dao.mapping.DepartmentMapping" >   
4.     < resultMap   type = "depModel"   id = "depModel" >   
5.         < id   column = "DEPID"   jdbcType = "INTEGER"   property = "depid"   javaType = "Integer"   />   
6.         < result   column = "DEPARTMENTNAME"   jdbcType = "VARCHAR"   property = "departmentName"   
7.             javaType = "String"   />   
8.         < result   column = "DESCRIPTION"   jdbcType = "VARCHAR"   property = "description"   
9.             javaType = "String"   />   
10.         < collection   property = "userList"   column = "DEPID"   select = "getUserByDepid"   
11.             ofType = "userModel"   />   
12.     </ resultMap >   
13.   
14.     < resultMap   type = "userModel"   id = "userModel" >   
15.         < id   column = "UID"   jdbcType = "INTEGER"   property = "uid"   javaType = "Integer"   />   
16.         < result   column = "DEPID"   jdbcType = "INTEGER"   property = "depid"   
17.             javaType = "Integer"   />   
18.         < result   column = "USER_NAME"   jdbcType = "VARCHAR"   property = "userName"   
19.             javaType = "String"   />   
20.         < result   column = "PASSWORD"   jdbcType = "VARCHAR"   property = "passWord"   
21.             javaType = "String"   />   
22.     </ resultMap >   
23.   
24.     < select   id = "getDepartmentById"   parameterType = "Integer"   
25.         resultMap = "depModel" >   
26.         SELECT DEPID,DEPARTMENTNAME,DESCRIPTION FROM DEPARTMENT  
27.         WHERE DEPID  = #{depid, jdbcType = INTEGER }  
28.     </ select >   
29.   
30.     < select   id = "getUserByDepid"   parameterType = "Integer"   resultMap = "userModel" >   
31.         SELECT UID,USER_NAME,PASSWORD FROM USER WHERE DEPID  =  
32.         #{depid,jdbcType = INTEGER }  
33.     </ select >   
34.   
35. </ mapper >