mybatis 创建临时表_MyBatis的多表查询

teacher表

student表

多对一

结果嵌套

1：创建mybatis配置文件（mybatis-config.xml）

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
	<properties resource="db.properties"/>
	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="${driver}" />
				<property name="url" value="${url}" />
				<property name="username" value="${username}" />
				<property name="password" value="${password}" />
			</dataSource>
		</environment>
	</environments> 
	<mappers>
		<mapper resource="cn/sxt/entity/student-mapper.xml" />
	</mappers>
</configuration>

• 这里使用了properties文件，可以不使用

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/jdbc
username=root
password=1234

2：创建工具类（MybatisUtils.java）用于获取SqlSession对象

public class MybatisUtil {
    
	public static SqlSessionFactory getSqlSessionFactory() throws IOException{
    
		String resource = "mybatis-config.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
		return sqlSessionFactory;
	}
	public static SqlSession getSqlSession() throws IOException{
    
		SqlSession sqlsession = getSqlSessionFactory().openSession();
		return sqlsession;
	}
}

• String resource ="mybatis-config.xml" 为“包名+文件名”，此处mybatis配置文件直接放在src下，省略包名

3：创建实体类对象

public class Student {
    
	private int id;
	private String name;
	private int tid;
	private Teacher teacher;
	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 int getTid() {
    
		return tid;
	}
	public void setTid(int tid) {
    
		this.tid = tid;
	}
	public Teacher getTeacher() {
    
		return teacher;
	}
	public void setTeacher(Teacher teacher) {
    
		this.teacher = teacher;
	}
}