mybatis一对多

 

<collection property="orderList" ofType="cn.java.entity.Order">

字段

</collection>

 

 

<resultMap id="baseResultMap" type="com.foen.cloud.entity.SeriesDataEntity">
<result property="number" javaType="String" column="lbno"/>
<result property="name" javaType="String" column="lbname"/>
<result property="documentStatus" javaType="String" column="if_qy"/>
<collection property="modelNumberList" ofType="com.foen.cloud.entity.ManoEntity">
<result property="modelNumber" jdbcType="VARCHAR" column="mano"/>
</collection>
</resultMap>

<select id="findByNumberBean" resultMap="baseResultMap">
select 
from zd_madatalb a left JOIN zd_madatalb_detail b on b.LBNO=a.LBNO
where a.LBNO=#{number}
</select>