mybatis 一对一查询

要求：根据班级id查询班级信息(带老师的信息)

数据表：

CREATE TABLE teacher(
	t_id INT PRIMARY KEY AUTO_INCREMENT, 
	t_name VARCHAR(20)
);
CREATE TABLE class(
	c_id INT PRIMARY KEY AUTO_INCREMENT, 
	c_name VARCHAR(20), 
	teacher_id INT
);
ALTER TABLE class ADD CONSTRAINT fk_teacher_id FOREIGN KEY (teacher_id) REFERENCES teacher(t_id);	

INSERT INTO teacher(t_name) VALUES('LS1');
INSERT INTO teacher(t_name) VALUES('LS2');

INSERT INTO class(c_name, teacher_id) VALUES('bj_a', 1);
INSERT INTO class(c_name, teacher_id) VALUES('bj_b', 2);

Classes.java

package com.lx.bean;

import java.util.List;

public class Classes {

	private int id;
	private String name;
	private Teacher teacher;
	private List<Student> list;
	public Classes(int id, String name, Teacher teacher) {
		super();
		this.id = id;
		this.name = name;
		this.teacher = teacher;
	}
	
	public Classes(int id, String name, Teacher teacher, List<Student> list) {
		super();
		this.id = id;
		this.name = name;
		this.teacher = teacher;
		this.list = list;
	}

	public Classes() {
		super();
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public Teacher getTeacher() {
		return teacher;
	}
	public void setTeacher(Teacher teacher) {
		this.teacher = teacher;
	}
	
	public List<Student> getList() {
		return list;
	}

	public void setList(List<Student> list) {
		this.list = list;
	}

	@Override
	public String toString() {
		return "Classes [id=" + id + ", name=" + name + ", teacher=" + teacher
				+ ", list=" + list + "]";
	}

	
}

Teacher.java

package com.lx.bean;

public class Teacher {

	private int id;
	private String name;
	public Teacher(int id, String name) {
		super();
		this.id = id;
		this.name = name;
	}
	public Teacher() {
		super();
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	@Override
	public String toString() {
		return "Teacher [id=" + id + ", name=" + name + "]";
	}
	
}

ClassMapper.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.lx.test4.ClassMapper"> 
         
          <!-- 
                                 一对一查询操作：方式一
          -->
         
         <select id="getClass" parameterType="int" resultMap="getClassMap">
            select * from class c,teacher t where c.teacher_id = t.t_id and c.c_id=#{id}  
         </select>
         
         <resultMap type="Classes" id="getClassMap">
            <id property="id" column="c_id"/>
            <result property="name" column="c_name"/>
            <association property="teacher" javaType="Teacher">
                <id property="id" column="t_id"/>
                <result property="name" column="t_name"/>
            </association>
         </resultMap>
         
         
         <!-- 
                                 一对一查询操作：方式二
          -->
         <!--  <select id="getClass2" parameterType="int" resultMap="getClass2Map">
            select * from class where c_id=#{id}         
         </select>
          <select id="getTeacher" parameterType="int" resultType="Teacher">
            select t_id id,t_name name  from teacher where t_id=#{id}         
         </select>
          <resultMap type="Classes" id="getClass2Map">
            
            <id property="id" column="c_id"/>
            <result property="name" column="c_name"/>
            
             <association property="teacher" column="teacher_id" select="getTeacher">
             </association>
            
         </resultMap> -->
         
         <select id="getClass2" parameterType="int" resultMap="getClass2Map">
            select * from class where c_id = #{id}
         </select>
         <select id="getTeacher" parameterType="int" resultType="Teacher">
            select t_id id,t_name name from teacher where t_id=#{id} 
         </select>
         
         <resultMap type="Classes" id="getClass2Map">
          <id property="id" column="c_id"/>
            <result property="name" column="c_name"/>
            <association property="teacher" column="teacher_id" select="getTeacher">
            </association>
         </resultMap> 
             
	</mapper>

测试类：

package com.lx.test4;

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

import com.lx.bean.Classes;
import com.lx.utils.FactoryUtil;

public class Test4 {

	@Test
	public void test1()
	{
		SqlSessionFactory factory = FactoryUtil.getFactory();
		
		SqlSession session = factory.openSession();
	
		String statement = "com.lx.test4.ClassMapper.getClass";
		
		Classes classes = session.selectOne(statement, 1);
		
		System.out.println(classes);
		
		session.close();
	}
	
	@Test
	public void test2()
	{
		SqlSessionFactory factory = FactoryUtil.getFactory();
		
		SqlSession session = factory.openSession();
	
		String statement = "com.lx.test4.ClassMapper.getClass2";
		
		Classes classes = session.selectOne(statement, 1);
		
		System.out.println(classes);
		
		session.close();
	}
}

注意：要将映射文件注册到conf.xml中