application.properties中加入如下配置

#mysql驅(qū)動包
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
#jdbc數(shù)據(jù)庫地址
spring.datasource.url=jdbc:mysql://192.168.237.134:3306/mybatis_plus?characterEncoding=UTF-8
#數(shù)據(jù)庫用戶名
spring.datasource.username=root
#數(shù)據(jù)庫密碼
spring.datasource.password=root

#xml中用于存放sql語句
mybatis-plus.mapper-locations=classpath:/mapper/*Mapper.xml
#使控制臺能打印sql
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

mybatisplus接口掃描及分頁插件配置

package com.xbb.mybatisplus.tutorial;

import java.util.ArrayList;
import java.util.List;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.InnerInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;

@Configuration
@MapperScan("com.xbb.mybatisplus.tutorial.mapper")
public class MybatisPlusConfig {

    /**
     * mybatis plus分頁插件配置
     * @return
     */
    @Bean
    public MybatisPlusInterceptor paginationInterceptor() {
        MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
        PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor();
        paginationInnerInterceptor.setDbType(DbType.MYSQL);
        List<InnerInterceptor> innerInterceptors = new ArrayList<>();
        innerInterceptors.add(paginationInnerInterceptor);
        mybatisPlusInterceptor.setInterceptors(innerInterceptors);
        return mybatisPlusInterceptor;
    }

}