iBatis映射

最新推荐文章于 2023-03-10 18:16:35 发布

原创最新推荐文章于 2023-03-10 18:16:35 发布 · 305 阅读

0 ·

CC 4.0 BY-SA版权

ibatis 专栏收录该内容

4 篇文章

订阅专栏

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>