【SpringBoot】整合MyBatis

参考文章：
狂神说SpringBoot09：整合MyBatis

结构搭建

新建项目 new -》

代码准备

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.5.6</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.example</groupId>
    <artifactId>demo4mybatis</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>demo4mybatis</name>
    <description>Demo project for Spring Boot</description>
    <properties>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>

<!--    Web场景启动器    -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

<!--SpringBoot单元测试-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

<!--     MyBatis所需依赖   -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.1</version>
        </dependency>
<!--        数据库连接  -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <!-- 注意版本问题，本地安装的是5.几的版本，而springboot默认导入的是最新的，需要手动指定版本号-->
            <version>5.1.46</version>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>

    </dependencies>

    <build>
        <plugins>
            <!-- 打包插件 -->
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>


        <!-- maven配置资源过滤问题

             exclude结点：满足此规则的不会被打包
             include结点：满足此条件会被打包

             filtering：maven的占位符取值表达式的使用场合默认在pom文件范围内活动，
                默认值为false
                若要扩大使用范围，必须指定需要扩大到哪些文件，然后指定filtering为true

                -->
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>

</project>

application.properties

1. 配置数据来源
2. 配置mybatis文件位置

#数据库连接信息
spring.datasource.username=root
spring.datasource.password=
spring.datasource.url=jdbc:mysql://localhost:3306/springboot?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
spring.datasource.driver-class-name=com.mysql.jdbc.Driver



#mybatis xml文件位置
mybatis.mapper-locations=classpath*:/mybatisMapper/*.xml

实体类 Department.java

package com.example.demo4mybatis.pojo;

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

/**
 * @Description 实体类
 */
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Department {
    private Integer id;
    private String departmentName;
}

mapper

1. DepartmentMapper.java

package com.example.demo4mybatis.mapper;

import com.example.demo4mybatis.pojo.Department;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

/**
 * @Description
 */

@Mapper
@Repository
public interface DepartmentMapper {

    /**
     * 获取所有信息
     * @return
     */
    List<Department> getAll();

    /**
     * 通过id获取
     * @param param
     * @return
     */
    Department getDepartmentById(Map<String,Object> param);

}

2. DepartmentMapper.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.example.demo4mybatis.mapper.DepartmentMapper">

    <select id="getAll" resultType="com.example.demo4mybatis.pojo.Department">
        select *
        from
        department
    </select>

    <select id="getDepartmentById" resultType="com.example.demo4mybatis.pojo.Department">
        select *
        from
        department
        where id = #{id}
    </select>
</mapper>

Controller.java

package com.example.demo4mybatis.controller;

import com.example.demo4mybatis.mapper.DepartmentMapper;
import com.example.demo4mybatis.pojo.Department;
import com.example.demo4mybatis.service.DepartmentService;
import org.apache.ibatis.annotations.Param;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * @Description Controller测试
 */
@RestController
@RequestMapping("/test")
public class DepartmentController {
    @Autowired
    DepartmentMapper departmentMapper;

    @GetMapping("/getAll")
    public List<Department> getAll(){
        return departmentMapper.getAll();
    }

    /**
     * 根据id获取
     * @param id
     * @return
     */
    @GetMapping("/getById")
    public Department getDepartmentById(@Param("id") Integer id){
        Map<String,Object> param = new HashMap<>();
        param.put("id","" + id);
        return departmentMapper.getDepartmentById(param);
    }
    /**
     * 根据id获取
     * @param id
     * @return
     */
    @GetMapping("/getById2/{id}")
    public Department getDepartmentById2(@PathVariable("id") Integer id){
        Map<String,Object> param = new HashMap<>();
        param.put("id","" + id);
        return departmentMapper.getDepartmentById(param);
    }
}

PathVariable
PathVariable : 直接翻译是 path：路径 ，variable ： 变量

1. 这个注解修饰的参数和url有关系 是 URL 绑定的占位符 所以当使用这个注解修饰变量 路径没有加上这个变量就会出现这个问题
2. 通过 @PathVariable 可以将 URL 中占位符参数绑定到控制器处理方法的入参中：URL 中的 {xxx} 占位符可以通过@PathVariable(“xxx“) 绑定到操作方法的入参中
   当使用这个注解接受参数的时候就要注意路径的处理

运行结果

bug探究

Required URI template variable ‘id‘ for method parameter type Integer is not present

由@PathVariable引起
参考文章：Required URI …

Invalid bound statement (not found)

未在properties中配置mybatis文件路径：mybatis.mapper-locations
参考文章：Invalid bound statement (not found): 各种原因
mybatis.mapper-locations 配置多个mapper路径