ibatis 在只想查询部分字段时,resultMap如何配???
<resultMap id="cardSortResult" class="com.wulidou.bean.dictionary.transfer.CardSort" >
<!--
WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
This element was generated on Wed Nov 04 15:33:25 CST 2009.
-->
<result column="id" property="id" jdbcType="INTEGER" />
<result column="named" property="named" jdbcType="VARCHAR" />
<result column="rank" property="rank" jdbcType="INTEGER" />
<result column="isShow" property="isShow" jdbcType="CHAR" />
</resultMap>
<resultMap id="cardSortResultAAAA" class="com.wulidou.bean.dictionary.transfer.CardSort" >
<!--
WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
This element was generated on Wed Nov 04 15:33:25 CST 2009.
-->
<result column="id" property="id" jdbcType="INTEGER" />
<result column="named" property="named" jdbcType="VARCHAR" />
</resultMap>
<select id="queryAll" resultMap="cardSortResultAAAA">
select id, named from cardsort where isShow = '1' order by rank
</select>
----------------
我有一个CardSort表,有四个字段。
如上配置,当我只想查询id 和 named 两个字段时候,经实验测试,必须得配置只有两个字段的resultMap才行,如果用原来的那个 id="cardSortResult" 则会报错说其余两个字段找不见什么的。
显然,这样非常麻烦,那么,怎么觉得这个问题呢? 这个resultMap难道不能通用吗? 请告诉解决办法。