整合Mapper

1.添加依赖

<dependency>
     <groupId>mysql</groupId>
     <artifactId>mysql-connector-java</artifactId>
 </dependency>
 <dependency>
     <groupId>org.mybatis.spring.boot</groupId>
     <artifactId>mybatis-spring-boot-starter</artifactId>
     <version>1.3.1</version>
 </dependency>

2.环境配置(放在application.yml)

spring:
 datasource:
   url: jdbc:mysql://localhost:3306/user?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
   driver-class-name: com.mysql.cj.jdbc.Driver
   username: root
   password: ok
mybatis:
 mapper-locations: classpath:mapper/*.xml
 configuration:
   auto-mapping-behavior: full
 type-aliases-package: com.example.demo5.pojo

3.创建Mapper映射

<?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.mybatis.mapper.TestMapper">
     <select id="getCount" resultType="int">
         SELECT COUNT(1) FROM users
     </select>
 </mapper>

4.创建接口

 package com.example.mybatis.mapper;
 import org.apache.ibatis.annotations.Mapper;
 import org.apache.ibatis.annotations.Param;
 @Mapper
 public interface TestMapper {
     Integer getCount();
 }

5.创建controller

 package com.example.mybatis.controller;
 import com.example.mybatis.mapper.TestMapper;
 import org.springframework.web.bind.annotation.RequestMapping;
 import org.springframework.web.bind.annotation.RestController;
 import javax.annotation.Resource;
 @RestController
 public class TestController {
     @Resource
     private TestMapper test;
     @RequestMapping("/")
     public Integer test(){
         return testMapper.getCount();
     }
 }