mybatis xml 一对多

QQ叫紫珊

　　


<?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" >
<mapper namespace="com.test.dao.mapping.DepartmentMapping">
<resultMap type="depModel" id="depModel">
<id column="DEPID" jdbcType="INTEGER" property="depid" javaType="Integer" />
<result column="DEPARTMENTNAME" jdbcType="VARCHAR" property="departmentName"
javaType="String" />
<result column="DESCRIPTION" jdbcType="VARCHAR" property="description"
javaType="String" />
<collection property="userList" column="DEPID" select="getUserByDepid"
ofType="userModel" />
</resultMap>
<resultMap type="userModel" id="userModel">
<id column="UID" jdbcType="INTEGER" property="uid" javaType="Integer" />
<result column="DEPID" jdbcType="INTEGER" property="depid"
javaType="Integer" />
<result column="USER_NAME" jdbcType="VARCHAR" property="userName"
javaType="String" />
<result column="PASSWORD" jdbcType="VARCHAR" property="passWord"
javaType="String" />
</resultMap>
<select id="getDepartmentById" parameterType="Integer"
resultMap="depModel">
SELECT DEPID,DEPARTMENTNAME,DESCRIPTION FROM DEPARTMENT
WHERE DEPID = #{depid,jdbcType=INTEGER}
</select>
<select id="getUserByDepid" parameterType="Integer" resultMap="userModel">
SELECT UID,USER_NAME,PASSWORD FROM USER WHERE DEPID =
#{depid,jdbcType=INTEGER}
</select>
</mapper>