application.properties中加入如下配置
#mysql驱动包
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
#jdbc数据库地址
spring.datasource.url=jdbc:mysql://192.168.237.134:3306/mybatis_plus?characterEncoding=UTF-8
#数据库用户名
spring.datasource.username=root
#数据库密码
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;
}
}