ibatis union oracle（第四章bean）

9tgq8p00pe

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>