iBatis多表查询

扫码查看
<typeAlias alias="Product" type="com.shopping.entity.Product"/>
<typeAlias alias="ProductType" type="com.shopping.entity.ProductType"/> <resultMap id="queryAllProduct" class="Product">
<result property="proId" column="proid"/>
<result property="proName" column="proname"/>
<result property="proDesc" column="prodesc"/>
<result property="price" column="price"/>
<result property="img" column="img"/>
<result property="proTime" column="protime"/>
<result property="size" column="size"/>
<result property="type" column="typeid" select="queryProductTypeById"/>
</resultMap> <select id="queryProductTypeById" parameterClass="int" resultClass="ProductType" >
select typeid,typename from producttype where typeid=#typeid#
<select> <select id="queryAllProducts" resultMap="queryAllProduct">
select proid,proname,prodesc,price,img,protime,size,typeid from product
<select>


04-26 17:45
查看更多