SpringBoot整合Mybatis-Plus

一、整体思想：

 1）、导入依赖
             <dependency>
                 <groupId>com.baomidou</groupId>
                 <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>3.2.0</version>
             </dependency>
 2）、配置
       1、配置数据源
              1)、导入数据库mysql驱动
                 <dependency>
                       <groupId>mysql</groupId>
                       <artifactId>mysql-connector-java</artifactId>
                       <version>8.0.17</version>     
                  </dependency>
               2)、在application.yml配置数据源相关信息

               spring:
                  datasource:
                       driver-class-name: com.mysql.cj.jdbc.Driver
                       url: jdbc:mysql://localhost/cloud_user?serverTimezone=UTC
                       username: root
                       password: 123456
        2、配置Mybatis-plus
             1）、使用@MapperScan
            2)、告诉Mybatis-plus，sql映射文件位置
                    mybatis-plus:
                       mapper-locations: classpath:/mapper/**/*.xml

二、详细步骤

1、导入依赖和数据库驱动

 <!--mybatisplus依赖-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.2.0</version>
        </dependency>
<!--        数据库启动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.17</version>
        </dependency>

2、在application.yml配置数据源相关信息

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost/cloud_user?serverTimezone=UTC
    username: root
    password: 123456
    #配置Druid
    #type: com.alibaba.druid.pool.DruidDataSource  

mybatis-plus:
  configuration:
    #在映射实体或者属性时，的下划线将数据库中表名和字段名中去掉，按照驼峰命名法映射  例：address_book----->AddressBook
    map-underscore-to-camel-case: true
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  global-config:
    db-config:
      id-type: auto
      table-prefix: tb_   #去掉数据库表前缀tb_

3、定义实体类（User）

public class User implements Serializable {
    private int id;
    private String username;
    private String address;

    public User(int id, String username, String address) {
        this.id = id;
        this.username = username;
        this.address = address;
    }

    public int getId() {
        return id;
    }

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

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", address='" + address + '\'' +
                '}';
    }
}

4、定义数据接口，继承 BaseMapper<User>

@Mapper //如果不加@Mapper就要在启动类（application）中加上@MapperScan("xxxxx"),如果都不加就会报错
public interface UserMapper extends BaseMapper<User> {
}

5、编写服务类继承IService<User>

public interface UserService extends IService<User> {
}

6、编写实现类继承ServiceImpl<UserMapper, User>和实现服务类接口UserService

@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {
}

7、MybatisPlus整合完成。在测试类中导入UserService服务类，调用方法即可

@SpringBootTest
class MybatisplusApplicationTests {


    @Autowired
    private UserService userService;


    @Test
    void contextLoads() {
        List<User> list = userService.list();
        for (User i :list){
            System.out.println(i);
        }

    }

}