MyBatis基础-10-自关联多对一查询

EmployeeMapper.xml

	
	
		
		
	
	
	
		select id,name,job,mgr
		from t_employee
		where id=#{id}
	

EmployeeDao.java

package com.monkey1024.dao;

import java.util.List;

import com.monkey1024.bean.Employee;

public interface EmployeeDao {
	Employee selectLeaderByPid(int mgr);
}

EmployeeTest01.java

package com.monkey1024.test;

import java.util.List;

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

import com.monkey1024.bean.Employee;
import com.monkey1024.dao.EmployeeDao;
import com.monkey1024.util.MyBatisUtil;

public class EmployeeTest01 {
	private SqlSession sqlSession;
	private EmployeeDao employeeDao;
	@Before
	public void init(){
		sqlSession = MyBatisUtil.getSqlSession();
		employeeDao = sqlSession.getMapper(EmployeeDao.class);
		
	}
	@After
	public void closeSession(){
		if(sqlSession!=null){
			sqlSession.close();
		}
	}
	
	@Test
	public void selectLeaderByPid(){
		Employee employee = employeeDao.selectLeaderByPid(1005);
		System.out.println(employee);
	}
}