Mybatis_resultMap

逃离我推掉我的手 2023-06-25 12:30 27阅读 0赞

*  resultMap主要用于查询一对多的关系条件下

<select id="selectByPoid" parameterType="long" resultMap="pomainResultMap">
      	select 
      		p1.*,
      		p2.num poitemnum,
      		p3.*
      	from 
      		pomain p1,poitem p2 ,product p3
    	where
    		p2.POID = p1.poid 
    	and 
    		p3.ProductCode = p2.ProductCode
    	and 
    		p1.POID = #{poid}
    </select>
      
     
     <resultMap type="com.test.model.Pomain" id="pomainResultMap">
     	
    
     	<id column="poid" property="poId"/>
     	<result column="venderCode" property="venderCode"/>
     	<result column="account" property="account"/>
     	<result column="createTime" property="createTime"/>
     	<result column="tipFee" property="tipFee"/>
     	<result column="productTotal" property="productTotal"/>
     	<result column="poTotal" property="poTotal"/>
     	
     	<collection property="poitems" ofType="com.test.model.Poitem">
     		<id column="poId" property="poId"/>
     		<id column="productCode" property="productCode"/>
     		<result column="unitPrice" property="unitPrice"/>
     		<result column="poitemnum" property="num"/>
     		<result column="unitName" property="unitName"/>
     		
     		<association property="product" javaType="com.test.model.Product">
     			<id column="productCode" property="productCode"/>
     			<result column="categoryId" property="categoryId"/>
     			<result column="name" property="name"/>
     		</association>
     	</collection>
     </resultMap>

Mybatis_resultMap

发表评论取消回复

还没有评论，来说两句吧...

相关阅读