springboot整合mybatis 多对一以及一对多的处理

1.导入依赖

<dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
        </dependency>

        <!-- 加载mybatis整合springboot -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.1</version>
        </dependency>

        <!-- MySQL的jdbc驱动包 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

        <!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.16.10</version>
        </dependency>
		
		<!-- 移除boot中自带的日志依赖-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
            <exclusions>
                <exclusion>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-starter-logging</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>

2.数据库

student表

CREATE TABLE `student` (
  `id` int(10) NOT NULL,
  `name` varchar(30) DEFAULT NULL,
  `tid` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fktid` (`tid`),
  CONSTRAINT `fktid` FOREIGN KEY (`tid`) REFERENCES `teacher` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

teacher表

CREATE TABLE `teacher` (
  `id` int(10) NOT NULL,
  `name` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

3.数据库配置以及log4j.properties

application.properties

server.port=8080
server.servlet.context-path=/
#配置MyBatis的Mapper.xml文件所在位置：
mybatis.mapper-locations=classpath:com/lwg/mybatis/mapper/*.xml
#打印sql语句
mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
#配置数据源信息
spring.datasource.username=root
spring.datasource.password=109837
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=false

log4j.properties

#将等级为DEBUG的日志信息输出到console和file这两个目的地，console和file的定义在下面的代码


log4j.rootLogger=DEBUG,console,file

#控制台输出的相关设置
log4j.appender.console = org.apache.log4j.ConsoleAppender
log4j.appender.console.Target = System.out
log4j.appender.console.Threshold=DEBUG
log4j.appender.console.layout = org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=[%c]-%m%n

#文件输出的相关设置
log4j.appender.file = org.apache.log4j.RollingFileAppender
log4j.appender.file.File=./log/lwg.log
log4j.appender.file.MaxFileSize=10mb
log4j.appender.file.Threshold=DEBUG
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=[%p][%d{yy-MM-dd}][%c]%m%n

#日志输出级别
log4j.logger.org.mybatis=DEBUG
log4j.logger.java.sql=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
log4j.logger.com.lwg.mybatis.mapper=DEBUG

4.pojo文件

Student实体类

package com.lwg.mybatis.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Student {
    private int id;
    private String name;

    private Teacher teacher;
}

Teacher实体类

package com.lwg.mybatis.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Teacher {
    private int id;
    private String name;
}

多对一的情况

5.StudentMapper； UserMapper.xml文件 TeacherMapper Teacher,xml文件

StudentMapper

package com.lwg.mybatis.mapper;

import com.lwg.mybatis.pojo.Student;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface StudentMapper {

    public List<Student> getAllStudents();
}

StudentMapper.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.lwg.mybatis.mapper.StudentMapper">
<!--此为多对一的情况  站在学生的角度  多个学生对应一个老师-->
    <!--column所表示的是数据库中的字段名称，也就是下方sql语句中，搜多到的sql语句 as后面
    的名称 比如 s.id sid,中的sid(在此的as被省略掉了)-->

    <!--property对应的是实体类中的属性名-->
    <resultMap id="StudentTeacher" type="com.lwg.mybatis.pojo.Student">
        <id column="sid"  property="id"/>
        <result column="sname"  property="name"/>

        <association property="teacher" javaType="com.lwg.mybatis.pojo.Teacher">
            <id column="tid"  property="id"/>
            <result column="tname"  property="name"/>
        </association>
    </resultMap>

    <!--此resultMap对应的上面的id-->
    <select id="getAllStudents" resultMap="StudentTeacher">
        select s.id sid,s.name sname,t.name tname
        from student s,teacher t
        where s.tid=t.id
    </select>


</mapper>

TeacherMapper

package com.lwg.mybatis.mapper;

import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface TeacherMapper {
}

TeacherMapper.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.lwg.mybatis.mapper.TeacherMapper">

</mapper>

6.对 ~~ 多对一 ~~ 下的测试

package com.lwg.mybatis;

import com.lwg.mybatis.mapper.StudentMapper;
import com.lwg.mybatis.pojo.Student;
import org.apache.log4j.Logger;
import org.junit.jupiter.api.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import java.util.List;


@RunWith(SpringJUnit4ClassRunner.class)
@SpringBootTest
class MybatisApplicationTests {

    static Logger logger = Logger.getLogger(MybatisApplicationTests.class);


    @Autowired
    private StudentMapper studentMapper;


    @Test
    void contextLoads() {
    }

    @Test
    public void test(){
    
        List<Student> allStudents = studentMapper.getAllStudents();
        for (Student allStudent : allStudents) {
            System.out.println(allStudent);
        }
    }

}

测试结果

7.一对多

需要修改的文件

Student

package com.lwg.mybatis.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Student {
    private int id;
    private String name;

    private Teacher teacher;

    private int tid;
}

Teacher

package com.lwg.mybatis.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.util.List;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Teacher {
    private int id;
    private String name;

    private List<Student> students;
}

TeacherMapper

package com.lwg.mybatis.mapper;

import com.lwg.mybatis.pojo.Teacher;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;


@Mapper
public interface TeacherMapper {
    public Teacher getTeacher(@Param("tid") int id);
}

TeacherMapper.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.lwg.mybatis.mapper.TeacherMapper">
  <!--
   1. 集合的话，使用collection！
           JavaType和ofType都是用来指定对象类型的
           JavaType是用来指定pojo中属性的类型
           ofType指定的是映射到list集合属性中pojo的类型。
   -->

    <resultMap id="TeacherStudent" type="com.lwg.mybatis.pojo.Teacher">
        <result property="name" column="tname"/>

        <collection property="students" ofType="com.lwg.mybatis.pojo.Student">
            <result property="id" column="sid" />
            <result property="name" column="sname" />
            <result property="tid" column="tid" />
        </collection>
    </resultMap>

    <select id="getTeacher" resultMap="TeacherStudent">
        select s.id sid,s.name sname,t.name tname,t.id tid from student s,teacher t
        where s.tid=t.id and t.id=#{tid}
    </select>
</mapper>

测试方法

@Test
    public void test1(){

        Teacher teacher = teacherMapper.getTeacher(1);
        System.out.println(teacher.getName());
        System.out.println(teacher.getStudents());
    }

测试结果