package com.project.myo2o.config.druid;
import java.sql.SQLException;
import javax.sql.DataSource;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import com.alibaba.druid.pool.DruidDataSource;
@Configuration
public class DruidDBConfig {
private Logger logger = LoggerFactory.getLogger(DruidDBConfig.class);
@Value("${spring.datasource.url}")
private String dbUrl;
@Value("${spring.datasource.username}")
private String username;
@Value("${spring.datasource.password}")
private String password;
@Value("${spring.datasource.driverClassName}")
private String driverClassName;
@Value("${spring.datasource.initialSize}")
private int initialSize;
@Value("${spring.datasource.minIdle}")
private int minIdle;
@Value("${spring.datasource.maxActive}")
private int maxActive;
@Value("${spring.datasource.maxWait}")
private int maxWait;
@Value("${spring.datasource.timeBetweenEvictionRunsMillis}")
private int timeBetweenEvictionRunsMillis;
@Value("${spring.datasource.minEvictableIdleTimeMillis}")
private int minEvictableIdleTimeMillis;
@Value("${spring.datasource.validationQuery}")
private String validationQuery;
@Value("${spring.datasource.testWhileIdle}")
private boolean testWhileIdle;
@Value("${spring.datasource.testOnBorrow}")
private boolean testOnBorrow;
@Value("${spring.datasource.testOnReturn}")
private boolean testOnReturn;
@Value("${spring.datasource.poolPreparedStatements}")
private boolean poolPreparedStatements;
@Value("${spring.datasource.maxPoolPreparedStatementPerConnectionSize}")
private int maxPoolPreparedStatementPerConnectionSize;
@Value("${spring.datasource.filters}")
private String filters;
@Value("{spring.datasource.connectionProperties}")
private String connectionProperties;
@Bean //声明其为Bean实例
@Primary //在同样的DataSource中,首先使用被标注的DataSource
public DataSource dataSource(){
DruidDataSource datasource = new DruidDataSource();
datasource.setUrl(this.dbUrl);
datasource.setUsername(username);
datasource.setPassword(password);
datasource.setDriverClassName(driverClassName);
//configuration
datasource.setInitialSize(initialSize);
datasource.setMinIdle(minIdle);
datasource.setMaxActive(maxActive);
datasource.setMaxWait(maxWait);
datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
datasource.setValidationQuery(validationQuery);
datasource.setTestWhileIdle(testWhileIdle);
datasource.setTestOnBorrow(testOnBorrow);
datasource.setTestOnReturn(testOnReturn);
datasource.setPoolPreparedStatements(poolPreparedStatements);
datasource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);
try {
datasource.setFilters(filters);
} catch (SQLException e) {
logger.error("druid configuration initialization filter", e);
}
datasource.setConnectionProperties(connectionProperties);
return datasource;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
springboot+ mybatis+druid连接池(带监控)
共126个文件
xml:81个
class:26个
java:11个
3星 · 超过75%的资源 需积分: 45 47 下载量 52 浏览量
2018-05-09
11:35:45
上传
评论
收藏 103KB RAR 举报
温馨提示
springboot+ mybatis+druid连接池(带监控),创建数据库之后可以直接运行,可以当做脚手架直接使用
资源推荐
资源详情
资源评论
收起资源包目录
springboot+ mybatis+druid连接池(带监控) (126个子文件)
Area.class 4KB
DruidDBConfig.class 4KB
AreaController.class 1KB
AreaServiceImpl.class 974B
Product.class 942B
Shop.class 939B
Myo2oApplication.class 866B
DruidStatViewServlet.class 789B
UserAwardMap.class 739B
UserProductMap.class 713B
AreaServiceImplTest.class 679B
UserShopMap.class 678B
ShopAuthMap.class 674B
DruidStatFilter.class 660B
PersonInfo.class 641B
ConstantForSuperAdmin.class 628B
Myo2oApplicationTests.class 627B
Award.class 588B
ShopCategory.class 579B
ProductCategory.class 569B
LocalAuth.class 543B
HeadLine.class 539B
ProductImg.class 505B
WechatAuth.class 503B
AreaMapper.class 348B
AreaService.class 239B
.gitignore 268B
myo2o.iml 9KB
maven-wrapper.jar 46KB
DruidDBConfig.java 4KB
DruidStatViewServlet.java 896B
AreaController.java 660B
AreaServiceImplTest.java 612B
AreaServiceImpl.java 574B
Myo2oApplicationTests.java 507B
Myo2oApplication.java 484B
DruidStatFilter.java 469B
AreaMapper.java 283B
Area.java 263B
AreaService.java 166B
log4j.properties 547B
log4j.properties 547B
maven-wrapper.properties 110B
workspace.xml 64KB
uiDesigner.xml 9KB
logback-spring.xml 2KB
logback-spring.xml 2KB
pom.xml 2KB
mybatis-config.xml 1KB
AreaMapper.xml 1KB
AreaMapper.xml 1KB
Maven__org_springframework_boot_spring_boot_test_autoconfigure_2_0_1_RELEASE.xml 769B
Maven__org_springframework_boot_spring_boot_starter_logging_2_0_1_RELEASE.xml 748B
Maven__org_springframework_boot_spring_boot_starter_tomcat_2_0_1_RELEASE.xml 741B
Maven__org_springframework_boot_spring_boot_autoconfigure_2_0_1_RELEASE.xml 734B
Maven__org_mybatis_spring_boot_mybatis_spring_boot_autoconfigure_1_3_2.xml 730B
Maven__com_fasterxml_jackson_module_jackson_module_parameter_names_2_9_5.xml 729B
Maven__org_springframework_boot_spring_boot_starter_test_2_0_1_RELEASE.xml 727B
Maven__org_springframework_boot_spring_boot_starter_json_2_0_1_RELEASE.xml 727B
Maven__org_springframework_boot_spring_boot_starter_jdbc_2_0_1_RELEASE.xml 727B
Maven__org_springframework_boot_spring_boot_starter_web_2_0_1_RELEASE.xml 720B
Maven__com_vaadin_external_google_android_json_0_0_20131108_vaadin1.xml 700B
Maven__org_springframework_boot_spring_boot_starter_2_0_1_RELEASE.xml 692B
Maven__org_mybatis_spring_boot_mybatis_spring_boot_starter_1_3_2.xml 688B
Maven__com_fasterxml_jackson_datatype_jackson_datatype_jsr310_2_9_5.xml 688B
mybatis-config.xml 688B
Maven__org_hibernate_validator_hibernate_validator_6_0_9_Final.xml 674B
Maven__com_fasterxml_jackson_datatype_jackson_datatype_jdk8_2_9_5.xml 674B
Maven__org_springframework_boot_spring_boot_test_2_0_1_RELEASE.xml 671B
Maven__org_apache_tomcat_embed_tomcat_embed_websocket_8_5_29.xml 660B
Maven__org_springframework_spring_expression_5_0_5_RELEASE.xml 658B
Maven__com_fasterxml_jackson_core_jackson_annotations_2_9_0.xml 644B
Maven__org_springframework_spring_context_5_0_5_RELEASE.xml 637B
Maven__org_springframework_boot_spring_boot_2_0_1_RELEASE.xml 636B
Maven__org_springframework_spring_webmvc_5_0_5_RELEASE.xml 630B
Maven__org_apache_tomcat_embed_tomcat_embed_core_8_5_29.xml 625B
Maven__org_springframework_spring_beans_5_0_5_RELEASE.xml 623B
Maven__com_fasterxml_jackson_core_jackson_databind_2_9_5.xml 623B
compiler.xml 622B
Maven__org_springframework_spring_test_5_0_5_RELEASE.xml 616B
Maven__org_springframework_spring_core_5_0_5_RELEASE.xml 616B
Maven__org_springframework_spring_jdbc_5_0_5_RELEASE.xml 616B
Maven__org_apache_tomcat_embed_tomcat_embed_el_8_5_29.xml 611B
Maven__javax_validation_validation_api_2_0_1_Final.xml 611B
Maven__javax_annotation_javax_annotation_api_1_3_2.xml 611B
Maven__org_springframework_spring_jcl_5_0_5_RELEASE.xml 609B
Maven__org_springframework_spring_aop_5_0_5_RELEASE.xml 609B
Maven__org_springframework_spring_web_5_0_5_RELEASE.xml 609B
Maven__org_apache_logging_log4j_log4j_to_slf4j_2_10_0.xml 608B
Maven__org_jboss_logging_jboss_logging_3_3_2_Final.xml 608B
Maven__com_alibaba_druid_1_0_28.xml 602B
Maven__org_springframework_spring_tx_5_0_5_RELEASE.xml 602B
Maven__com_fasterxml_jackson_core_jackson_core_2_9_5.xml 595B
Maven__net_bytebuddy_byte_buddy_agent_1_7_11.xml 578B
Maven__mysql_mysql_connector_java_5_1_46.xml 574B
Maven__org_apache_logging_log4j_log4j_api_2_10_0.xml 573B
Maven__ch_qos_logback_logback_classic_1_2_3.xml 568B
Maven__org_hamcrest_hamcrest_library_1_3.xml 553B
Maven__org_mybatis_mybatis_spring_1_3_2.xml 549B
Maven__ch_qos_logback_logback_core_1_2_3.xml 547B
共 126 条
- 1
- 2
资源评论
- 欲说还休,却道天凉好个秋2021-03-26监控呢??
- 这路我走过2019-12-19生成数据库设计文档很好,进一步如果能把索引等其他信息也输出出来就好了。非常感谢
- hi飞扬2020-01-07very nice,thanks for sharing.
qq_36784299
- 粉丝: 1
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功