package com.gk.firework.Config.DataSource; import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor; import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor; import com.baomidou.mybatisplus.extension.plugins.handler.TableNameHandler; import com.baomidou.mybatisplus.extension.plugins.inner.DynamicTableNameInnerInterceptor; import com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean; import org.apache.ibatis.plugin.Interceptor; import org.apache.ibatis.session.SqlSessionFactory; import org.mybatis.spring.SqlSessionTemplate; import org.mybatis.spring.annotation.MapperScan; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Qualifier; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.core.io.Resource; import org.springframework.core.io.support.PathMatchingResourcePatternResolver; import org.springframework.core.io.support.ResourcePatternResolver; import org.springframework.stereotype.Repository; import javax.sql.DataSource; import java.io.IOException; import java.util.ArrayList; import java.util.Arrays; import java.util.HashMap; import java.util.List; @Configuration @MapperScan(value = "com.gk.firework.Mapper",sqlSessionFactoryRef = "sqlSessionFactoryBean1" ,annotationClass = Repository.class) public class MyBatisConfigOne { @Autowired @Qualifier("dsOne") DataSource dsOne; @Autowired private PaginationInterceptor paginationInterceptor; @Autowired private MybatisPlusInterceptor mybatisPlusInterceptor; @Bean SqlSessionFactory sqlSessionFactoryBean1() throws Exception { MybatisSqlSessionFactoryBean factoryBean = new MybatisSqlSessionFactoryBean(); factoryBean.setDataSource(dsOne); factoryBean.setMapperLocations(resolveMapperLocations()); paginationInterceptor.setLimit(100000); //关键代码 设置 MyBatis-Plus 分页插件 Interceptor[] plugins = {paginationInterceptor,mybatisPlusInterceptor}; factoryBean.setPlugins(plugins); return factoryBean.getObject(); } public Resource[] resolveMapperLocations() { ResourcePatternResolver resourceResolver = new PathMatchingResourcePatternResolver(); List mapperLocations = new ArrayList<>(); mapperLocations.add("classpath*:com/gk/firework/Mapper/mybatis/*.xml"); List resources = new ArrayList(); if (mapperLocations != null) { for (String mapperLocation : mapperLocations) { try { Resource[] mappers = resourceResolver.getResources(mapperLocation); resources.addAll(Arrays.asList(mappers)); } catch (IOException e) { // ignore } } } return resources.toArray(new Resource[resources.size()]); } @Bean SqlSessionTemplate sqlSessionTemplate1() throws Exception{ return new SqlSessionTemplate(sqlSessionFactoryBean1()); } }