MyBatis --关联查询--自关联（查询指定父节点的所有子节点）

左手的ㄟ右手 2023-10-10 10:43 46阅读 0赞

Mapper.java 接口定义

List<***> selectAllWrapper(Map<String, Object> paramter);

Mapper.xml 配置文件

<resultMap id="BaseResultMap" type="SysDataArch">
        <id column="sid" jdbcType="VARCHAR" property="sid" />
        <result column="assort_no" jdbcType="VARCHAR" property="assortNo" />
        <result column="assort_name" jdbcType="VARCHAR" property="assortName" />
        <result column="psid" jdbcType="VARCHAR" property="psid" />
        <result column="security_level_code" jdbcType="VARCHAR" property="securityLevelCode" />
        <result column="storage_type_code" jdbcType="VARCHAR" property="storageTypeCode" />
      </resultMap>
      
      <resultMap id="BaseResultMapWrapper" type="SysDataArchWrapper" extends="BaseResultMap">
        	<collection property="children" ofType="SysDataArchAssort" select="selectChildrenByParent" column="sid"/>
      </resultMap>
    
     <select id="selectChildrenByParent" parameterType="java.lang.String" resultMap="BaseResultMapWrapper">
      		select 
      			<include refid="Base_Column_List" />
      		from sys_data_arch
      		where psid = #{sid,jdbcType=VARCHAR}
      </select>
      
      <select id="selectAllWrapper" parameterType="map" resultMap="BaseResultMapWrapper">
      		select 
      			<include refid="Base_Column_List" />
      		from sys_data_arch
      		where 1 = 1
      		<include refid="condition" />
      </select>

Service.java 接口定义

List<SysDataArchAssortWrapper> selectAllWrapper(Map<String, Object> paramter);

ServiceImpl.java 类实现

@Override
    	public List<SysDataArchWrapper> selectAllWrapper(Map<String, Object> paramter) {
    		// TODO Auto-generated method stub
    		return mapper.selectAllWrapper(paramter);
    	}

实体定义和拓展对象：

@Setter
    @Getter
    public class SysDataArch extends BaseModel {
        private String sid;
    
        private String assortNo;
    
        private String assortName;
    
        private String psid;
    
        private String securityLevelCode;
    
        private String storageTypeCode;
    }

@Setter
    @Getter
    public class SysDataArchWrapper extends SysDataArch{
    	
    	private List<SysDataArch> children;
    }