ibatis级联查询

ibatis 级联查询的配置：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
	"http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="login">

	<resultMap class="Login" id="login-result">
		<result property="email" column="email" />
		<result property="password" column="password" />
		<result property="loginID" column="login_ID" />
		<result property="user" column="user_ID" select="login.queryUserByID" />
		<result property="lastLoginTime" column="lastLoginTime" />
		<result property="lastLoginIP" column="lastLoginIP" />
	</resultMap>
	<select id="validateLogin" parameterClass="hashmap" resultMap="login-result">

		select email,
		password,
		login_ID,
		user_ID,
		lastLoginTime,
		lastLoginIP
		from login
		where email = #email# and password = #password#;	
	</select>

	<resultMap class="User" id="user-result">
		<result property="phone" column="phone"/>
		<result property="name" column="name"/>
		<result property="qq" column="qq"/>
		<result property="address" column="address"/>
		<result property="level" column="level"/>
		<result property="point" column="point"/>
		<result property="userID" column="User_ID"/>
		<result property="activation" column="activation"/>
		<result property="role" select="login.queryRoleByUser"/>
	</resultMap>
	<select id="queryUserByID" parameterClass="int"
		resultMap="user-result">
		select *
		from Users where user_id = #userID#
	</select>
	<select id="queryRoleByUser" parameterClass="int" resultClass="set">
		select Role_ID
		from roleuser where User_ID = #userID#
	</select>
</sqlMap>