mysql mybatis分表查询_Mybatis 分表处理

项目到后期遇到分表查询处理，但是项目已经快要开发完了而且使用通用mapper不想在改，想了一个办法在mybatis与mysql数据库连接时处理sql语句 替换相关表。

第一步，springboot采用注解开发，添加相关配置监听mybatis.

import org.apache.ibatis.session.SqlSessionFactory;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

@Configuration

public class MybatisInterceptorConfig {

@Bean

public String myInterceptor(SqlSessionFactory sqlSessionFactory) {

sqlSessionFactory.getConfiguration().addInterceptor(new MybatisSqlInterceptor());

return "interceptor";

}

}

第二步，mybatis在执行sql语句前处理代码

/***

* mybatis 执行前 sql处理

*

*/

import java.sql.SQLException;

import java.util.List;

import java.util.Map;

import java.util.Properties;

import javax.annotation.PostConstruct;

import org.apache.commons.lang3.StringUtils;

import org.apache.ibatis.executor.Executor;

import org.apache.ibatis.mapping.BoundSql;

import org.apache.ibatis.mapping.MappedStatement;

import org.apache.ibatis.mapping.SqlCommandType;

import org.apache.ibatis.mapping.SqlSource;

import org.apache.ibatis.plugin.Interceptor;

import org.apache.ibatis.plugin.Intercepts;

import org.apache.ibatis.plugin.Invocation;

import org.apache.ibatis.plugin.Plugin;

import org.apache.ibatis.plugin.Signature;

import org.apache.ibatis.reflection.DefaultReflectorFactory;

import org.apache.ibatis.reflection.MetaObject;

import org.apache.ibatis.reflection.factory.DefaultObjectFactory;

import org.apache.ibatis.reflection.wrapper.DefaultObjectWrapperFactory;

import org.apache.ibatis.session.ResultHandler;

import org.apache.ibatis.session.RowBounds;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Component;

@Intercepts({

@Signature(type=Executor.class,method="update",args={MappedStatement.class,Object.class}),

@Signature(type = Executor.class, method = "query",

args = {MappedStatement.class, Object.class, RowB