实体类中Enterprise含有:List<EnterprisePersion> persionList;
<!-- 企业信息详情 -->
<resultMap type="com.cci.market.security.domain.Enterprise" id="enterpriseBean">
<id column="id" property="id"/>
<result column="oranizeId" property="oranizeId"/>
<result column="address" property="address"/>
<result column="linkman" property="linkman"/>
<result column="phone" property="phone"/>
<result column="files" property="files"/>
<result column="lastUpdateDate" property="lastUpdateDate"/>
<result column="divisionname" property="divisionName"/>
<result column="valid" property="valid"/>
<result column="trial" property="trial"/>
<result column="scale" property="scale"/>
<result column="creditCode" property="creditCode"/>
<result column="houseCode" property="houseCode"/>
<result column="enterpriseType" property="enterpriseType"/>
<result column="industryType" property="industryType"/>
<result column="establishDate" property="establishDate"/>
<result column="manageScope" property="manageScope"/>
<result column="startDate" property="startDate"/>
<result column="endDate" property="endDate"/>
<result column="registterCapital" property="registterCapital"/>
<result column="registrationAuthority" property="registrationAuthority"/>
<result column="checkDate" property="checkDate"/>
<result column="businessStatus" property="businessStatus"/>
<result column="regulated" property="regulated"/>
<result column="staffNum" property="staffNum"/>
<result column="hazardous" property="hazardous"/>
<result column="securityName" property="securityName"/>
<result column="contactInfo" property="contactInfo"/>
<result column="safeType" property="safeType"/>
<result column="createDate" property="createDate"/>
<!-- 一对多的关系 -->
<!-- property: 指的是集合属性的值, ofType:指的是集合中元素的类型 -->
<collection property="persionList" ofType="com.cci.market.security.domain.EnterprisePersion">
<id column="persionId" property="persionId"/>
<result column="legalname" property="legalname"/>
<result column="legalnationality" property="legalnationality"/>
<result column="leagalcardType" property="leagalcardType"/>
<result column="leagalcardNum" property="leagalcardNum"/>
<result column="leagalmobilePhone" property="leagalmobilePhone"/>
</collection>
</resultMap>
<select id="getEnterpriseDetail" resultMap="enterpriseBean">
SELECT
v.id AS "id",
a.id AS "oranizeId",
p.id AS "persionId",
a.name AS "name",
a.address AS "address",
a.linkman AS "linkman",
a.phone AS "phone",
v.Files as "files",
v.lastupdatedate AS "lastUpdateDate",
a.divisionname as "divisionname",
v.valid as "valid",
v.trial as "trial",
v.Scale as "scale",
v.credit_code as "creditCode",
v.house_code as "houseCode",
d1.name as "enterpriseType",
d2.name as "industryType",
v.establish_date as "establishDate",
v.manage_scope as "manageScope",
v.start_date as "startDate",
v.end_date as "endDate",
v.registter_capital as "registterCapital",
d3.name as "currency",
v.registration_authority as "registrationAuthority",
v.check_date as "checkDate",
d4.name as "businessStatus",
p.name as "legalname",
d5.name as "legalnationality",
d6.name as "leagalcardType",
p.card_num as "leagalcardNum",
p.mobile_phone as "leagalmobilePhone",
t.regulated as "regulated",
d7.name as "staffNum",
t.hazardous as "hazardous",
t.security_name as "securityName",
t.contact_info as "contactInfo",
d8.name as "safeType",
v.Create_Date as "createDate"
FROM v_enterprise v
inner join z_enterprise a on v.credit_code= a.credit_code
LEFT JOIN security.v_enterprise_persion p on p.enterprise_id = v.id
LEFT JOIN security.v_enterprise_attribute t on t.enterprise_id = v.id
LEFT JOIN v_security_dict d1 on v.enterprise_type = d1.code AND d1.laberType="enterpriseType"
LEFT JOIN v_security_dict d2 on v.industry_type = d2.code AND d2.laberType="industryType"
LEFT JOIN v_security_dict d3 on v.currency = d3.code AND d3.laberType="currenType"
LEFT JOIN v_security_dict d4 on v.business_status = d4.code AND d4.laberType="businessStatusType"
LEFT JOIN v_security_dict d5 on p.nationality = d5.code AND d5.laberType="nationalType"
LEFT JOIN v_security_dict d6 on p.card_type = d6.code AND d6.laberType="cardType"
LEFT JOIN v_security_dict d7 on t.staff_num = d7.code AND d7.laberType="staffNumType"
LEFT JOIN v_security_dict d8 on t.safe_type = d8.code AND d8.laberType="safeType"
WHERE v.id =#{id}
</select>