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>
iBatis映射
最新推荐文章于 2023-03-10 18:16:35 发布