SpringBoot2.x整合Mybatis + Druid

1.引入依赖

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.1.3</version>
</dependency>

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

<!-- https://mvnrepository.com/artifact/com.alibaba/druid-spring-boot-starter -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.1.10</version>
</dependency>

2.application.yml配置

# mybatis
mybatis:
  type-aliases-package: com.zsd.demo.domain # 实体类包的路径
  configuration:
    map-underscore-to-camel-case: true # 将下划线转为驼峰命名
    default-fetch-size: 100
    default-statement-timeout: 3000
  mapper-locations: classpath:com/zsd/demo/dao/*.xml # mapper xml配置文件文件路径
# 打印sql
logging:
  level:
    com.zsd.demo.dao : debug
# 数据库
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/o2o?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false&serverTimezone=UTC
    username: root
    password:
    driver-class-name: com.mysql.cj.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource
    # druid
    druid:
      initialSize: 1
      filters: stat
      maxActive: 2
      maxWait: 60000
      minIdle: 1
      timeBetweenEvictionRunsMillis: 60000
      minEvictableIdleTimeMillis: 300000
      validationQuery: select 'x'
      testWhileIdle: true
      testOnBorrow: false
      testOnReturn: false
      poolPreparedStatements: true
      maxOpenPreparedStatements: 20

3.目录结构

4.测试

创建user表并插入测试数据记录

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

INSERT INTO `user` VALUES ('1', '东哥');

UserController:控制器类

package com.zsd.demo.controller;

import com.zsd.demo.domain.User;
import com.zsd.demo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * @Author zhoushaodong
 * @Description
 * @Date 2020/6/7 12:46
 */
@RestController
@RequestMapping("/user")
public class UserController {

    @Autowired
    private UserService userService;

    @GetMapping("/userinfo")
    public String userinfo() {
        User user = userService.getUserById(1);
        return user.getId()+" "+ user.getUserName();
    }
}

UserDao：持久层类

package com.zsd.demo.dao;

import com.zsd.demo.domain.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Mapper
@Repository // 不添加这个service层 autowired注入该bean会报红，但其实不影响程序正常运行，如果想将报红去掉，可以添加@Repository注解
public interface UserDao {
    @Select("select * from user where id=#{id}")
    User getUerById(@Param("id") int id);
}

User：实体类

package com.zsd.demo.domain;

import java.util.Date;

/**
 * @Author zhoushaodong
 * @Description
 * @Date 2020/6/7 12:48
 */
public class User {
    private Integer id;
    private String userName;
 
    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }
}

UserService：接口类

package com.zsd.demo.service;

import com.zsd.demo.domain.User;

public interface UserService {
    public User getUserById(int id);
}

UserServiceImpl:UserService接口的实现类

package com.zsd.demo.service.impl;

import com.zsd.demo.dao.UserDao;
import com.zsd.demo.domain.User;
import com.zsd.demo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * @Author zhoushaodong
 * @Description
 * @Date 2020/6/7 12:58
 */

@Service
public class UserServiceImpl implements UserService {
    @Autowired
    UserDao userDao;

    @Override
    public User getUserById(int id) {
        return userDao.getUerById(id);
    }
}

SpringBoot启动类

package com.zsd.demo;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

/**
 * @Author zhoushaodong
 * @Description
 * @Date 2020/6/7 11:52
 */

@SpringBootApplication
//@MapperScan("com.zsd.demo.dao")
public class MainApplication {
    public static void main(String[] args) {
        SpringApplication.run(MainApplication.class, args);
    }
}

测试结果：

5.注意事项

关于mybatis接口类找不到的情况：

1. 可以在接口类上使用@Mapper,将它交给mybatis管理
   

2. 在Spring Boot启动类上添加@MapperScan注解，自动扫描dao接口类，值为需要dao接口类包的全路径

关于mybatis配置完idea在service中引入dao接口类，idea报红的情况：

1. 其实该报红可以忽略，不影响程序的正常运行。
   
   
2. 如果真的强迫症，不喜欢个这报红，可以在dao接口类上添加@Repository注解，这样service的报红就会消失。