1 files changed, 125 insertions, 0 deletions
diff --git a/src/main/java/com/mesasoft/cn/sketch/config/SketchDatabaseConfig.java b/src/main/java/com/mesasoft/cn/sketch/config/SketchDatabaseConfig.java
new file mode 100644
index 0000000..dc69bbd
--- /dev/null
+++ b/src/main/java/com/mesasoft/cn/sketch/config/SketchDatabaseConfig.java
@@ -0,0 +1,125 @@
+//package com.zhazhapan.efo.sketch.config;
+//
+//import com.alibaba.druid.pool.DruidDataSource;
+//import lombok.Data;
+//import org.apache.ibatis.session.SqlSessionFactory;
+//import org.mybatis.spring.SqlSessionFactoryBean;
+//import org.mybatis.spring.annotation.MapperScan;
+//import org.springframework.beans.factory.annotation.Qualifier;
+//import org.springframework.beans.factory.annotation.Value;
+//import org.springframework.boot.context.properties.ConfigurationProperties;
+//import org.springframework.context.annotation.Bean;
+//import org.springframework.context.annotation.Configuration;
+//import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
+//import org.springframework.jdbc.datasource.DataSourceTransactionManager;
+//
+//import javax.sql.DataSource;
+//import java.sql.SQLException;
+//
+///**
+// * @ProjectName
+// * @Description: 后台数据源配置类
+// */
+//@Data
+//@Configuration
+//@ConfigurationProperties(prefix = "sketch.datasource.druid")
+//@MapperScan(basePackages = SketchDatabaseConfig.PACKAGE, sqlSessionFactoryRef = "sketchSqlSessionFactory")
+//public class SketchDatabaseConfig {
+//    /**
+//     * dao层的包路径
+//     */
+//    static final String PACKAGE = "com.mao.mysqlhive.demomh.mapper.sketch";
+//
+//    /**
+//     * mapper文件的相对路径
+//     */
+//    private static final String MAPPER_LOCATION = "classpath:mappers/sketch/*Mapper.xml";
+//
+//    @Value("${sketch.datasource.druid.filters}")
+//    private String filters;
+//    @Value("${sketch.datasource.druid.driverClassName}")
+//    private String url;
+//    @Value("${sketch.datasource.druid.url}")
+//    private String username;
+//    @Value("${sketch.datasource.druid.username}")
+//    private String password;
+//    @Value("${sketch.datasource.druid.password}")
+//    private String driverClassName;
+//    @Value("${sketch.datasource.druid.initialSize}")
+//    private int initialSize;
+//    @Value("${sketch.datasource.druid.minIdle}")
+//    private int minIdle;
+//    @Value("${sketch.datasource.druid.maxActive}")
+//    private int maxActive;
+//    @Value("${sketch.datasource.druid.maxWait}")
+//    private long maxWait;
+//    @Value("${sketch.datasource.druid.timeBetweenEvictionRunsMillis}")
+//    private long timeBetweenEvictionRunsMillis;
+//    @Value("${sketch.datasource.druid.minEvictableIdleTimeMillis}")
+//    private long minEvictableIdleTimeMillis;
+//    @Value("${sketch.datasource.druid.validationQuery}")
+//    private String validationQuery;
+//    @Value("${sketch.datasource.druid.testWhileIdle}")
+//    private boolean testWhileIdle;
+//    @Value("${sketch.datasource.druid.testOnBorrow}")
+//    private boolean testOnBorrow;
+//    @Value("${sketch.datasource.druid.testOnReturn}")
+//    private boolean testOnReturn;
+//    @Value("${sketch.datasource.druid.poolPreparedStatements}")
+//    private boolean poolPreparedStatements;
+//    @Value("${sketch.datasource.druid.maxPoolPreparedStatementPerConnectionSize}")
+//    private int maxPoolPreparedStatementPerConnectionSize;
+//
+//
+//    @Bean(name = "sketchDataSource")
+//    public DataSource sketchDataSource() throws SQLException {
+//        DruidDataSource druid = new DruidDataSource();
+//        // 监控统计拦截的filters
+//        druid.setFilters(filters);
+//
+//        // 配置基本属性
+//        druid.setDriverClassName(driverClassName);
+//        druid.setUsername(username);
+//        druid.setPassword(password);
+//        druid.setUrl(url);
+//
+//        //初始化时建立物理连接的个数
+//        druid.setInitialSize(initialSize);
+//        //最大连接池数量
+//        druid.setMaxActive(maxActive);
+//        //最小连接池数量
+//        druid.setMinIdle(minIdle);
+//        //获取连接时最大等待时间，单位毫秒。
+//        druid.setMaxWait(maxWait);
+//        //间隔多久进行一次检测，检测需要关闭的空闲连接
+//        druid.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
+//        //一个连接在池中最小生存的时间
+//        druid.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
+//        //用来检测连接是否有效的sql
+//        druid.setValidationQuery(validationQuery);
+//        //建议配置为true，不影响性能，并且保证安全性。
+//        druid.setTestWhileIdle(testWhileIdle);
+//        //申请连接时执行validationQuery检测连接是否有效
+//        druid.setTestOnBorrow(testOnBorrow);
+//        druid.setTestOnReturn(testOnReturn);
+//        //是否缓存preparedStatement，也就是PSCache，oracle设为true，mysql设为false。分库分表较多推荐设置为false
+//        druid.setPoolPreparedStatements(poolPreparedStatements);
+//        // 打开PSCache时，指定每个连接上PSCache的大小
+//        druid.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);
+//        return druid;
+//    }
+//
+//    @Bean(name = "sketchTransactionManager")
+//    public DataSourceTransactionManager sketchTransactionManager() throws SQLException {
+//        return new DataSourceTransactionManager(sketchDataSource());
+//    }
+//
+//    @Bean(name = "sketchSqlSessionFactory")
+//    public SqlSessionFactory sketchSqlSessionFactory(@Qualifier("sketchDataSource") DataSource sketchDataSource) throws Exception {
+//        final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
+//        sessionFactory.setDataSource(sketchDataSource);
+//        sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(SketchDatabaseConfig.MAPPER_LOCATION));
+//
+//        return sessionFactory.getObject();
+//    }
+//}