MyBatis实现一对一，一对多关联查询，Java开发快速学习

新建Spring Boot项目

---

在pom.xml文件中添加如下依赖

---

org.springframework.boot

spring-boot-starter-web

org.mybatis.spring.boot

mybatis-spring-boot-starter

2.1.0

mysql

mysql-connector-java

runtime

org.projectlombok

lombok

true

org.springframework.boot

spring-boot-starter-test

test

在application.yml文件中进行数据库和mybatis配置

---

spring配置

spring:

数据库配置

datasource:

type: com.zaxxer.hikari.HikariDataSource

url: jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&allowMu

《一线大厂Java面试题解析+后端开发学习笔记+最新架构讲解视频+实战项目源码讲义》

【docs.qq.com/doc/DSmxTbFJ1cmN1R2dB】 完整内容开源分享

ltiQueries=true&useSSL=false&tinyInt1isBit=false&serverTimezone=GMT%2B8

driverClassName: com.mysql.cj.jdbc.Driver

username: root

password: root

mybatis配置

mybatis:

给实体类配置别名

type-aliases-package: com.jourwon.*.pojo

加载mybatis的mapper配置文件

mapper-locations: classpath:mybatis/mapper/**/*Mapper.xml

configuration:

开发环境控制台打印sql语句

log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

开启驼峰规则自动映射字段属性值；如字段为user_name的可以映射到userName属性中

map-underscore-to-camel-case: true

设置sql执行超时时间,以秒为单位的全局sql超时时间设置,当超出了设置的超时时间时,会抛出SQLTimeoutException

default-statement-timeout: 30

解决查询返回结果含null没有对应字段值问题

call-setters-on-nulls: true

新建老师类Teacher

---

@Data

public class Teacher {

private int id;

private String name;

}

新建班级类Classes

---

@Data

public class Classes {

private int id;

private String name;

private Teacher teacher;

private List studentList;

}

新建学生类Student

---

@Data

public class Student {

private int id;

private String name;

}

新建ClassesMapper.xml映射文件

---

<?xml version="1.0" encoding="UTF-8"?>

select * from classes c,teacher t where c.teacher_id=t.t_id and c.c_id=#{id}

select * from classes c,teacher t,student s where c.teacher_id=t.t_id and c.c_id=s.class_id and c.c_id=#{id}

Application类

---

@MapperScan(basePackages = {“com.jourwon.mybatis.**.mapper”})

@SpringBootApplication

public class Application {

public static void main(String[] args) {

SpringApplication.run(Application.class, args);

}

}

测试类

---

@RunWith(SpringRunner.class)

@SpringBootTest

public class ApplicationTests {

@Autowired

private ClassesMapper classesMapper;

/**

• Description: 测试班级与老师一对一关联关系

• @author JourWon

• @date 2019/9/24 23:18

• @param

• @return void

*/

@Test

public void test01() {

List classes = classesMapper.listClasses(1);

for (Classes aClass : classes) {

System.out.println(classes);

}

}

/**

• Description: 测试班级与学生一对多关联关系

• @author JourWon

• @date 2019/9/24 23:19

• @param

• @return void

*/

@Test

public void test02() {

List classes = classesMapper.listClasses2(1);

for (Classes aClass : classes) {

System.out.println(classes);

}

}

}

测试结果

---

test01()测试结果输出

==> Preparing: select * from classes c,teacher t where c.teacher_id=t.t_id and c.c_id=?

==> Parameters: 1(Integer)

<== Columns: c_id, c_name, teacher_id, t_id, t_name

<== Row: 1, 高三2班, 1, 1, 老师张三

<== Total: 1

Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@140d1230]

[Classes(id=1, name=高三2班, teacher=Teacher(id=1, name=老师张三), studentList=null)]