<resultMap type="BidEnterpriseBidding" id="BidEnterpriseBiddingResult">
<result property="id" column="id" />
<result property="enterpriseId" column="enterprise_id" />
<result property="bidId" column="bid_id" />
<result property="createBy" column="create_by" />
<result property="createTime" column="create_time" />
<result property="updateBy" column="update_by" />
<result property="updateTime" column="update_time" />
<result property="remark" column="remark" />
<result property="status" column="status" />
<association property="enterprise" column="enterprise_id" javaType="BidEnterprise" select="getBidEnterprise"/>
<association property="bidBidding" column="bid_id" javaType="BidBidding" select="getBidBidding"/>
<collection property="filesList" column="id" javaType="java.util.List" ofType="BidEnterpriseBidfile"
select="getEnterpriseBidFiles"/>
</resultMap>
在dao里存在private List<BidEnterpriseBidfile> filesList;并指定类型,所以可以查询集合类型的
<collection property="filesList" column="id" javaType="java.util.List" ofType="BidEnterpriseBidfile"
select="getEnterpriseBidFiles"/>
<select id="getEnterpriseBidFiles" resultMap="BidEnterpriseBidfileResult" >
select id, enterprise_bid_id, file_name, file_path, create_time, update_by, update_time, remark from bid_enterprise_bidfile
where enterprise_bid_id=#{id}
</select>
在dao里是 private BidBidding bidBidding;,所一一行数据
<association property="enterprise" column="enterprise_id" javaType="BidEnterprise" select="getBidEnterprise"/>
<select id="getBidEnterprise" resultMap="BidEnterpriseResult" >
select id, user_name, affiliation, password, salt, mobile, name, short_name, addr, bank, account, tax_no, contact, contact_tel, usci, address, enterprise_nature, doe, corpn, corpn_idcard, contact_address, business_scope, profile, business_license_image, business_license_gp, corpn_idcard_image, registration_phone, contact_addr, registered_capital, paidin_capital, account_licence, create_by, create_time, update_by, update_time, remark from bid_enterprise
where id=#{enterpriseId}
</select>