mybatis的自关联关系查询——多对一——查询本栏目及父辈栏目

1、class NewsLabel

package com.beans;

import java.io.Serializable;
import java.util.Set;

public class NewsLabel implements Serializable {
	private Integer id;
	private String name;
	private NewsLabel parent;

2、INewsLabel

package com.dao;

import java.util.List;

import com.beans.NewsLabel;

public interface INewsLabel {
	
	NewsLabel selectParent(Integer id);

}

3、mapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.dao.INewsLabel">
	
	<resultMap type="com.beans.NewsLabel" id="selectParent">
		<id column="id" property="id"/>
		<result column="name" property="name"/>
		<association property="parent" javaType="com.beans.NewsLabel"
		 select="selectParent" column="pid"/>
	</resultMap>
	
	<select id="selectParent" resultMap="selectParent">
		SELECT ID, NAME, PID FROM NEWSLABEL WHERE ID = #{ID}
	</select>
	
</mapper>

4、MyTest

package com.test;



import java.util.List;
import java.util.Map;

import org.apache.ibatis.session.SqlSession;
import org.junit.After;
import org.junit.Test;

import com.beans.NewsLabel;
import com.dao.INewsLabel;
import com.utils.SqlSessionUtils;

public class MyTest {
	
	private INewsLabel dao;
	private SqlSession sqlSession;
	
	@org.junit.Before
	public void before() {
		sqlSession = SqlSessionUtils.getSqlSession();
		dao = sqlSession.getMapper(INewsLabel.class);
	}
	
	@After
	public void After() {
		if (sqlSession != null) {
			sqlSession.close();
		}
	}
	
	
	@Test
	public void test01() {
		NewsLabel newsLabel = dao.selectParent(7);
		System.out.println(newsLabel);
	}

}