xml 一对一 ,一对多

一对多 xml

<resultMap id="CreateWarehouse" type="com.jeeplus.modules.template.entity.PluginDatabaseDisplay">
        <id column="id" property="id"/>
        <result column="attestation" property="attestation"/>
        <result column="parent_id" property="parentId"/>
        <result column="display" property="display"/>
        <result column="sort" property="sort"/>
        <collection property="pluginDatabaseDisplays"
                    ofType="com.jeeplus.modules.template.entity.PluginDatabaseDisplay">
            <id column="databaseId" property="id"/>
            <result column="databaseAttestation" property="attestation"/>
            <result column="databaseParentId" property="parentId"/>
            <result column="databaseDisplay" property="display"/>
            <result column="displaySort" property="sort"/>
            <collection property="pluginDatabaseDisplays" select="queryTables" column="{taskId=databaseId}"/>
        </collection>
    </resultMap>

<select id="departmentInfoList" resultMap="CreateWarehouse">
        select display.id,display.attestation,display.parent_id,display.display,display.sort,
        databaseDisplay.id databaseId,databaseDisplay.attestation databaseAttestation,databaseDisplay.parent_id
        databaseParentId,databaseDisplay.display databaseDisplay, databaseDisplay.sort displaySort
        from plugin_database_display display
        left join plugin_database_display databaseDisplay on display.id = databaseDisplay.parent_id
        <where>
            display.display = 1 and display.del_flag = 0 and  (databaseDisplay.del_flag = 0 or databaseDisplay.del_flag is null)
            <if test="attestation!=null and attestation!=''">
                and display.attestation like concat('%',#{attestation},'%') or
                databaseDisplay.attestation like concat('%',#{attestation},'%')
            </if>
        </where>
        ORDER BY display.sort,databaseDisplay.sort
    </select>

   <resultMap id="queryTableMap" type="com.jeeplus.modules.template.entity.PluginDatabaseDisplay">
        <id column="id" property="id"/>
        <result column="name" property="attestation"/>
        <result column="table_name" property="tableName"/>
        <result column="source" property="source"/>
    </resultMap>
    <select id="queryTables" resultMap="queryTableMap">
        select plug.id,plug.name,plug.table_name,plug.source from plugin_form_display dis join plugin_form plug on plug.id = dis.form_id where display_id=#{taskId} and dis.del_flag = 0
    </select>

xml 一对一

<resultMap type="com.mybatisstudy.model.Employee" id="emp">
   <id property="empId" column="empId" />
   <result property="empName" column="empName"/>
   <result property="empBirthDay" column="empBirthDay"/>
   <result property="empSex" column="empSex"/>
   <association property="dept" javaType="com.mybatisstudy.model.Department">    
	 <result property="deptId" column="deptId"/>
    </association>
</resultMap>