让你的 Ibatis2 也支持Annotation

<sqlMap namespace="WEB_SHOP_NEWS" >
  <resultMap id="abatorgenerated_WebShopNewsResult" class="com.aaaa.data.object.shop.WebShopNews" >
    <result column="SHOP_NEWS_ID" property="shopNewsId" jdbcType="DECIMAL" />
    <result column="REGID" property="regid" jdbcType="DECIMAL" />
    <result column="SHOP_NEWS_NAME" property="shopNewsName" jdbcType="VARCHAR" />
    <result column="SHOP_NEWS_KIND" property="shopNewsKind" jdbcType="VARCHAR" />
    <result column="SHOP_NEWS_DATE" property="shopNewsDate" jdbcType="DATE" />
    <result column="SHOP_NEWS_CLICK" property="shopNewsClick" jdbcType="DECIMAL" />
    <result column="SHOP_NEWS_BIGKIND" property="shopNewsBigkind" jdbcType="DECIMAL" />
    <result column="SHOP_NEWS_SMALLKIND" property="shopNewsSmallkind" jdbcType="DECIMAL" />
    <result column="SHOP_NEWS_KEY" property="shopNewsKey" jdbcType="VARCHAR" />
  </resultMap>
 
  <resultMap id="abatorgenerated_WebShopNewsResultWithBLOBs" class="com. aaaa.data.object.shop.WebShopNews" extends="WEB_SHOP_NEWS.abatorgenerated_WebShopNewsResult" >
    <result column="SHOP_NEWS_CONTENT" property="shopNewsContent" jdbcType="BLOB" />
  </resultMap>

  <select id="select" resultMap="abatorgenerated_WebShopNewsResultWithBLOBs" parameterClass="com. aaaa.data.object.shop.WebShopNews" >
    select SHOP_NEWS_ID, REGID, SHOP_NEWS_NAME, SHOP_NEWS_KIND, SHOP_NEWS_DATE, SHOP_NEWS_CLICK,
      SHOP_NEWS_CONTENT, SHOP_NEWS_BIGKIND, SHOP_NEWS_SMALLKIND, SHOP_NEWS_KEY
    from WEB_SHOP_NEWS
    <dynamic prepend="where">
      <isNotEmpty prepend="and" property="shopNewsId" >
        SHOP_NEWS_ID = #shopNewsId:DECIMAL#
      </isNotEmpty>
      <isNotEmpty prepend="and" property="regid" >
        REGID = #regid:DECIMAL#
      </isNotEmpty>
      <isNotEmpty prepend="and" property="shopNewsName" >
        SHOP_NEWS_NAME = #shopNewsName:VARCHAR#
      </isNotEmpty>
      <isNotEmpty prepend="and" property="shopNewsKind" >
        SHOP_NEWS_KIND = #shopNewsKind:VARCHAR#
      </isNotEmpty>
      <isNotEmpty prepend="and" property="shopNewsBigkind" >
        SHOP_NEWS_BIGKIND = #shopNewsBigkind:DECIMAL#
      </isNotEmpty>
      <isNotEmpty prepend="and" property="shopNewsSmallkind" >
        SHOP_NEWS_SMALLKIND = #shopNewsSmallkind:DECIMAL#
      </isNotEmpty>
      <isNotEmpty prepend="and" property="shopNewsKey" >
        SHOP_NEWS_KEY = #shopNewsKey:VARCHAR#
      </isNotEmpty>
    </dynamic>
  </select>

好恐怖啊.....这样写还有使用ibatis的意义么?

呵呵，请教一下，使用Ibatis的意义是？会因为换种方式来定义sql而恐怖吗？那未出笼的Ibatis3如果真的提供了annotation的实现岂不是自毁前程？