- 创建student、class、teacher三张表并插入数据
2、在bean包中创建student、teacher、class三个实体类
3、toString需要进行改变,因为没有建起类会报错,可以忽略
4、创建映射器配置文件
5、修改Mybati配置文件
6、创建接口
7、创建测试类
package net.sjl.mybatis.mapper;
import net.sjl.mybatis.bean.Clazz;
import net.sjl.mybatis.bean.Student;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import java.io.IOException;
import java.io.Reader;
import java.util.List;
public class TestClazzMapper {
private SqlSession sqlSession; // SQL会话
private ClazzMapper clazzMapper; // 班级映射器
@Before
public void init() {
try {
// 读取MyBatis配置文件作为字符输入流
Reader reader = Resources.getResourceAsReader("mybatis-config.xml");
// 基于MyBatis配置文件构建SQL会话工厂
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
// 利用SQL会话工厂获取SQL会话
sqlSession = factory.openSession();
// 利用SQL会话获取班级映射器对象
clazzMapper = sqlSession.getMapper(ClazzMapper.class);
} catch (IOException e) {
e.printStackTrace();
}
}
@Test
public void testFindById() {
int id = 1;
Clazz clazz = clazzMapper.findById(id);
System.out.println(clazz);
System.out.println("班级编号[" + id + "]的学生:");
List<Student> students = clazz.getStudents();
students.forEach(student -> System.out.println(student));
}
@Test
public void testFindAll() {
List<Clazz> clazzes = clazzMapper.findAll();
clazzes.forEach(clazz -> System.out.println(clazz));
}
@After
public void destroy() {
// 关闭SQL会话
sqlSession.close();
}
}
9、运行