mybatis的collection的使用

ゞ浴缸里的玫瑰 2022-05-30 07:15 336阅读 0赞

**现象：**  
mybatis的collection的使用

**方法：**  
1：主查询返回的map：  
![这里写图片描述][70]  
2：子查询返回对象的map  
![这里写图片描述][70 1]  
3：主查询sql语句  
![这里写图片描述][70 2]  
4：子查询语句  
![这里写图片描述][70 3]  
5：使用主查询返回的结果作为子查询的条件字段去子查询查询  
![这里写图片描述][70 4]  
6：接收数据对象，主对象中包含子对象中的集合  
![这里写图片描述][70 5]

代码样例：

<resultMap type="com.oig.bean.SumDocuments" id="sumDocument">
            <result property="cid" column="cid"/>
            <result property="subscribedate" column="subscribedate"/>
            <result property="contractno" column="contractno"/>
            <result property="originplace" column="originplace"/>
            <result property="gnamedesc2" column="gnamedesc2"/>
            <result property="header" column="header"/>
            <result property="factoryno" column="factoryno"/>
            <result property="linkccode" column="linkccode"/>
            <result property="ccodetrust" column="ccodetrust"/>
            <result property="cname" column="cname"/>
            <result property="wname" column="wname"/>
            <result property="cpname" column="cpname"/>
            <result property="ordicode" column="ordicode"/>
            <collection property="list" column="{cid=cid,ordicode=ordicode}" javaType="ArrayList"  ofType="com.oig.bean.Documents" select="findDocumentByCid"/>
        </resultMap>
        <resultMap type="com.oig.bean.Documents" id="DocumentsMap">
            <result property="subscribedate" column="subscribedate"/>
                    <result property="contractno" column="contractno"/>
                    <result property="originplace" column="originplace"/>
                    <result property="gnamedesc2" column="gnamedesc2"/>
                    <result property="header" column="header"/>
                    <result property="factoryno" column="factoryno"/>
                    <result property="linkccode" column="linkccode"/>
                    <result property="ccodetrust" column="ccodetrust"/>
                    <result property="cname" column="cname"/>
                    <result property="wname" column="wname"/>
                    <result property="cpname" column="cpname"/>
                    <result property="ordicode" column="ordicode"/>
        </resultMap>
        <select id="findsumDocumentBySql" parameterType="java.lang.String" resultMap="sumDocument">
            select 
                SUBSTRING(convert(varchar(100),max(subscribedate),20),1,10) as subscribedate,
                cid as cid,
                MAX(contractno) as contractno,
                MAX(originplace) as originplace,
                MAX(gnamedesc2) as gnamedesc2,
                MAX(header) as header,
                MAX(factoryno) as factoryno,
                MAX(linkccode) as linkccode,
                MAX(cname) as cname,
                MAX(wname) as wname,
                ordicode as ordicode,
                MAX(ccodetrust) as ccodetrust,
                MAX(cpname) as cpname
            from v_documents where 1=1 ${else_if} group by cid,ordicode
        </select>
        <select id="findDocumentByCid" parameterType="java.util.Map" resultMap="DocumentsMap">
            select * from v_documents where 1=1
             <choose>
            <when test="cid==null">
                and cid is null
            </when>
            <otherwise>
                and cid=#{cid}
            </otherwise>
            </choose>
             and ordicode=#{ordicode}
        </select>

[70]: /images/20220530/c6ebbf49a28648d08cf558ba1f913682.png
[70 1]: /images/20220530/64404d8158e44229bf5e35ab5b5c04e4.png
[70 2]: /images/20220530/fc629fcb95bf49949ccc45195c12c49a.png
[70 3]: /images/20220530/7313e74eb2d94b50bbecb2fd561bbf63.png
[70 4]: /images/20220530/b888f3d665504f24a72dfd1971fa9c59.png
[70 5]: /images/20220530/47d83b2cc4fb4488b9a345d7a73d3fb5.png