使用的数据源为：阿里的Druid数据源，mysql-connect版本是8.x.x，在查询上使用的是MyBatis，并配置了：PageHelper（分页拦截器）、通用Mapper。

需要配置jdbc.properties文件：

jdbc.driverClass=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/schema?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai&useSSL=false&nullCatalogMeansCurrent=true
jdbc.username=root
jdbc.password=root

注：在使用mysql-connect 8.+以上版本的时候需要添加nullCatalogMeansCurrent=true参数，否则在使用mybatis-generator生成表对应的xml等时会扫描整个服务器里面的全部数据库中的表，而不是扫描对应数据库的表。

JAVA配置类:

@Configuration
@EnableTransactionManagement
@ComponentScan("cn.virens.database.serviceimpl")
public class SpringDataSourceConfig {
    @Value("${jdbc.url}")
    private String jdbcUrl;

    @Value("${jdbc.username}")
    private String jdbcUsername;

    @Value("${jdbc.password}")
    private String jdbcPassword;

    @Value("${jdbc.driverClass}")
    private String jdbcDriverClass;

    /**
     * mysql事务管理
     * 
     * @return
     */
    @Bean(name = "txManager")
    public PlatformTransactionManager txManager(@Qualifier("druidDataSource") DruidDataSource druidDataSource) {
        return new DataSourceTransactionManager(druidDataSource);
    }

    @Bean(name = "txExecute")
    public TransactionExecute txExecute(@Qualifier("txManager") PlatformTransactionManager manager) {
        return new TransactionExecute(manager);
    }

    /**
     * MyBatis 数据连接地址池配置
     * 
     * @throws IOException
     * @throws SQLException
     */
    @Bean(name = "druidDataSource", destroyMethod = "close")
    public DruidDataSource druidDataSource(Environment env) throws SQLException {
        DruidDataSource dataSource = new DruidDataSource();
        dataSource.setUrl(jdbcUrl);
        dataSource.setUsername(jdbcUsername);
        dataSource.setPassword(jdbcPassword);
        dataSource.setDriverClassName(jdbcDriverClass);
        // 配置初始化大小、最小、最大
        dataSource.setInitialSize(1);
        dataSource.setMinIdle(1);
        dataSource.setMaxActive(20);
        dataSource.setMaxWait(60000);// 配置获取连接等待超时的时间

        dataSource.setTimeBetweenEvictionRunsMillis(60000);// 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
        dataSource.setMinEvictableIdleTimeMillis(300000);// 配置一个连接在池中最小生存的时间，单位是毫秒
        dataSource.setDefaultAutoCommit(false);// 禁止自动提交，实现事务管理

        dataSource.setValidationQuery("SELECT 1;");
        dataSource.setValidationQueryTimeout(30000);

        dataSource.setTestWhileIdle(true);
        dataSource.setTestOnBorrow(false);
        dataSource.setTestOnReturn(false);

        dataSource.setPoolPreparedStatements(true);
        dataSource.setMaxPoolPreparedStatementPerConnectionSize(50);

        // 拦截配置
        dataSource.setFilters("stat,wall");

        return dataSource;
    }

    /**
     * MyBatis配置 :配置sqlSessionFactory
     * 
     * @return
     * @throws Exception
     */
    @Bean("sqlSessionFactoryBean")
    public SqlSessionFactoryBean sqlSessionFactoryBean(DruidDataSource druidDataSource) throws Exception {
        // 分页拦截器
        PageInterceptor interceptor = new PageInterceptor();
        Properties properties = new Properties();
        properties.put("helperDialect", "mysql");

        interceptor.setProperties(properties);

        // 创建SqlSession工厂
        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(druidDataSource);
        sqlSessionFactoryBean.setPlugins(new Interceptor[] { interceptor });
        sqlSessionFactoryBean.setMapperLocations(ResourceUtil.getResources("classpath:mysql/**/*.xml"));

        return sqlSessionFactoryBean;
    }

    @Bean
    public static MapperScannerConfigurer mapperScannerConfigurer() {
        MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer();
        mapperScannerConfigurer.setSqlSessionFactoryBeanName("sqlSessionFactoryBean");
        mapperScannerConfigurer.setBasePackage("cn.virens.database.mysql.mapper");
        mapperScannerConfigurer.getMapperHelper().getConfig().setIDENTITY("MYSQL");
        mapperScannerConfigurer.getMapperHelper().getConfig().setStyle(Style.normal);
        mapperScannerConfigurer.getMapperHelper().getConfig().setWrapKeyword("`{0}`");

        return mapperScannerConfigurer;
    }
}