mybatis对象映射的问题

Question

user的groupID是group的主键
现在要求查询所有group及每个分组的user,封装成对象，现在我做的是把所有分组查出来后，在JAVA中用for循环查询每个组的所有user，能不能更简洁，不在JAVA里面处理，直接交给mybatis？mybatis用的时间不长，请各位赐教mybatis对象映射的问题

Answer 1

<?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.zxwl.drug.data.Province"> <resultMap type="Province" id="provinceResultMap">
<id property="id" column="ID"/>
<result property="code" column="CODE"/>
<result property="name" column="NAME"/>
<collection property="citys" column="CODE" select="searchCity"></collection>
</resultMap>
<resultMap type="City" id="cityResultMap">
<id property="id" column="ID"/>
<result property="provinceId" column="PROVINCEID"/>
<result property="code" column="CODE"/>
<result property="name" column="NAME"/>
<collection property="areas" column="CODE" select="searchArea"></collection>
</resultMap>
<resultMap type="Area" id="areaResultMap">
<id property="id" column="ID"/>
<result property="cityId" column="CITYID"/>
<result property="code" column="CODE"/>
<result property="name" column="NAME"/>
</resultMap>

<resultMap type="CityPoint" id="cityPointResultMap">
<id property="id" column="ID"/>
<result property="cityId" column="CITYID"/>
<result property="code" column="CODE"/>
<result property="name" column="NAME"/>
</resultMap>

<select id="searchProvince" resultMap="provinceResultMap">
<![CDATA[
SELECT ID,CODE,NAME FROM PROVINCE
]]>
</select>
<select id="searchCity" resultMap="cityResultMap" parameterType="java.lang.Integer">
<![CDATA[
SELECT ID,PROVINCEID,CODE,NAME FROM CITY WHERE PROVINCEID = #{CODE}
]]>
</select>
<select id="searchArea" resultMap="areaResultMap" parameterType="java.lang.Integer">
<![CDATA[
SELECT ID,CITYID,CODE,NAME FROM AREA WHERE CITYID = #{CODE}
]]>
</select>
   <select id="searchCityPoint" resultMap="cityPointResultMap">
<![CDATA[
SELECT CITYNAME,LAT,LNG FROM CITYPOINT
]]>
</select>
</mapper>

Answer 2

  <collection property="citys" column="CODE" select="searchCity"></collection>
 property="citys"和 column="CODE"分别是什么呀， 

Answer 3

真的搞定了，真牛B
  <collection property="citys" column="CODE" select="searchCity"></collection>
如果传两个值允许吗，要有两个过滤条件