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<String> mapperLocations = new ArrayList<>();
|
mapperLocations.add("classpath*:com/gk/firework/Mapper/mybatis/*.xml");
|
List<Resource> 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());
|
}
|
|
|
|
}
|
