ibatis union oracle（第四章bean）

ibatis中使用联合查询，com.hzmc.capaa.domain.persistence.asset.CuidBean这个Bean没有对应的表，是个虚拟表。由下面的联合查询得来，ibatis也支持。

<resultMap id="cuidListMap" class="com.hzmc.capaa.domain.persistence.asset.CuidBean">
<result property="cuId" column="cuid"/>
<result property="proValue" column="proValue"/>
</resultMap>

<select id="getCuidList" resultMap="cuidListMap">
<![CDATA[ select cuid as cuId, username as proValue from mc$$lg_dbuser
union select cuid as cuId, ip_address from
mc$$lg_ipaddr union select cuid as cuId, app_name
from mc$$lg_application union select cuid as cuId, logon_time
from mc$$lg_calc ]]>
</select>