一对多:用collection
public class AchPatentExportExt extends SrmAchPatent{
private List<SrmAchPatentAuthor> patentAuthors;
}
<resultMap id="AchPatentExportExtNewResultMap" type="com.pinde.sci.model.srm.AchPatentExportExt"
extends="com.pinde.sci.dao.base.SrmAchPatentMapper.BaseResultMap">
<!-- 一对多-->
<collection property="patentAuthors" ofType="com.pinde.sci.model.mo.SrmAchPatentAuthor" column="PATENT_FLOW">
<id column="AUTHOR_FLOW" jdbcType="VARCHAR" property="authorFlow"/>
<id column="AUTHOR_NAME" jdbcType="VARCHAR" property="authorName"/>
<result column="TYPE_NAME" jdbcType="VARCHAR" property="typeName"/>
<result column="TYPE_ID" jdbcType="VARCHAR" property="typeId"/>
</collection>
</resultMap>
<select id="searchAchPatentExt" parameterType="java.util.Map" resultMap="AchPatentExportExtNewResultMap">
select sapa.**Patent_flow**,ROW_NUMBER() over(ORDER by sap.authorize_year DESC,sap.patent_name,sapa.type_name) as NUM,sap.authorize_year,sap.authorize_Code,sapa.user_flow,sapa.author_name,sap.dept_flow,sap.dept_name,
sap.patent_name,sap.type_name,sapa.BRANCH_ID,sapa.BRANCH_NAME,
sap.AUTHORIZE_DATE,sap.PATENTEE,sap.OPER_STATUS_NAME,sap.APPLY_USER_NAME
from srm_ach_Patent_author sapa inner join srm_ach_patent sap on sapa.Patent_flow = sap.patent_flow
</select>
特别注意:两个表做关联的字段一定要在sql里写出来,否则一对多的效果不会实现。例如上面 关联的字段是 patent_flow。我当时没有写出这个字段,查出的数据总是一条,导致我找了半个多小时的时间,还以为一对多配置写错了,最后才发现是这个原因。
一对一:用association