iBatis映射

typeAlias alias="dbtableall" type="com.ufgov.app.pd.unitdata.model.DbTable" />

      resultMap id="dbtableMapAll" class="dbtableall">
            result column="ITEM_CODE" property="itemCode" jdbcType="VARCHAR" />
            result column="ITEM_NAME" property="itemName" jdbcType="VARCHAR" />
            result column="ITEM_TYPE" property="itemType" jdbcType="CHAR" />
            result column="REF_TABLE" property="refTable" jdbcType="VARCHAR" />
      /resultMap>

      select id="getAllTable" resultMap="dbtableMapAll" resultClass="dbtableall">
            SELECT * FROM db_table WHERE item_code IN (SELECT item_code FROM
            pd_base_maintain WHERE maintain_type='1' and product_code =#productCode#)
  /select>