package com.controller.druid;
import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Primary;
import javax.sql.DataSource;
import java.sql.SQLException;
@ConfigurationProperties(prefix = "spring.druid")
public class DruidSource {
private String dbUrl;
private String username;
private String password;
private String driverClassName;
private int initialSize;
private int minIdle;
private int maxActive;
private int maxWait;
private int timeBetweenEvictionRunsMillis;
private int minEvictableIdleTimeMillis;
private String validationQuery;
private boolean testWhileIdle;
private boolean testOnBorrow;
private boolean testOnReturn;
private boolean poolPreparedStatements;
private int maxPoolPreparedStatementPerConnectionSize;
private String filters;
private String connectionProperties;
public String getDbUrl() {
return dbUrl;
}
public void setDbUrl(String dbUrl) {
this.dbUrl = dbUrl;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getDriverClassName() {
return driverClassName;
}
public void setDriverClassName(String driverClassName) {
this.driverClassName = driverClassName;
}
public int getInitialSize() {
return initialSize;
}
public void setInitialSize(int initialSize) {
this.initialSize = initialSize;
}
public int getMinIdle() {
return minIdle;
}
public void setMinIdle(int minIdle) {
this.minIdle = minIdle;
}
public int getMaxActive() {
return maxActive;
}
public void setMaxActive(int maxActive) {
this.maxActive = maxActive;
}
public int getMaxWait() {
return maxWait;
}
public void setMaxWait(int maxWait) {
this.maxWait = maxWait;
}
public int getTimeBetweenEvictionRunsMillis() {
return timeBetweenEvictionRunsMillis;
}
public void setTimeBetweenEvictionRunsMillis(int timeBetweenEvictionRunsMillis) {
this.timeBetweenEvictionRunsMillis = timeBetweenEvictionRunsMillis;
}
public int getMinEvictableIdleTimeMillis() {
return minEvictableIdleTimeMillis;
}
public void setMinEvictableIdleTimeMillis(int minEvictableIdleTimeMillis) {
this.minEvictableIdleTimeMillis = minEvictableIdleTimeMillis;
}
public String getValidationQuery() {
return validationQuery;
}
public void setValidationQuery(String validationQuery) {
this.validationQuery = validationQuery;
}
public boolean isTestWhileIdle() {
return testWhileIdle;
}
public void setTestWhileIdle(boolean testWhileIdle) {
this.testWhileIdle = testWhileIdle;
}
public boolean isTestOnBorrow() {
return testOnBorrow;
}
public void setTestOnBorrow(boolean testOnBorrow) {
this.testOnBorrow = testOnBorrow;
}
public boolean isTestOnReturn() {
return testOnReturn;
}
public void setTestOnReturn(boolean testOnReturn) {
this.testOnReturn = testOnReturn;
}
public boolean isPoolPreparedStatements() {
return poolPreparedStatements;
}
public void setPoolPreparedStatements(boolean poolPreparedStatements) {
this.poolPreparedStatements = poolPreparedStatements;
}
public int getMaxPoolPreparedStatementPerConnectionSize() {
return maxPoolPreparedStatementPerConnectionSize;
}
public void setMaxPoolPreparedStatementPerConnectionSize(int maxPoolPreparedStatementPerConnectionSize) {
this.maxPoolPreparedStatementPerConnectionSize = maxPoolPreparedStatementPerConnectionSize;
}
public String getFilters() {
return filters;
}
public void setFilters(String filters) {
this.filters = filters;
}
public String getConnectionProperties() {
return connectionProperties;
}
public void setConnectionProperties(String connectionProperties) {
this.connectionProperties = connectionProperties;
}
@Bean //声明其为Bean实例
@Primary //在同样的DataSource中,首先使用被标注的DataSource
public DataSource dataSource() throws SQLException {
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);
datasource.setFilters(filters);
return datasource;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
springboot+mybatis+druid+mysql
共61个文件
java:19个
class:19个
xml:13个
5星 · 超过95%的资源 需积分: 10 21 下载量 107 浏览量
2018-04-16
10:32:46
上传
评论
收藏 89KB ZIP 举报
温馨提示
boot入门级,版本2.0.1,其中包含少部分cloud注解,和cloud的依赖和配置,直接忽略即可
资源推荐
资源详情
资源评论
收起资源包目录
client.zip (61个子文件)
client
mvnw.cmd 5KB
mvnw 6KB
src
test
java
com
joymeter
main
resources
application.properties 2KB
mybatis
mapper
RolePermissionMapper.xml 2KB
UserMapper.xml 3KB
PermissionMapper.xml 3KB
RoleMapper.xml 3KB
UserRoleMapper.xml 1KB
mybatis-config.xml 587B
templates
index.html 216B
static
java
com
controller
ClientController.java 521B
druid
DruidConfig.java 2KB
DruidStatFilter.java 469B
DruidStatViewServlet.java 952B
DruidSource.java 6KB
ClientApplication.java 580B
joymeter
service
serviceimp
DemoServiceImp.java 402B
controller
DemoController.java 683B
DemoController2.java 550B
dao
UserMapper.java 344B
RolePermissionMapper.java 269B
PermissionMapper.java 386B
RoleMapper.java 344B
UserRoleMapper.java 239B
bean
User.java 1KB
Role.java 846B
UserRoleKey.java 405B
RolePermissionKey.java 453B
Permission.java 900B
client.iml 195B
target
generated-sources
annotations
classes
application.properties 2KB
com
ClientApplication.class 901B
controller
druid
DruidConfig.class 2KB
DruidStatViewServlet.class 811B
DruidStatFilter.class 640B
DruidSource.class 5KB
ClientController.class 1KB
joymeter
serviceimp
DemoServiceImp.class 779B
controller
DemoController.class 1KB
DemoController2.class 1KB
dao
UserMapper.class 383B
PermissionMapper.class 407B
UserRoleMapper.class 235B
RolePermissionMapper.class 253B
RoleMapper.class 383B
bean
User.class 2KB
Permission.class 1KB
UserRoleKey.class 732B
RolePermissionKey.class 768B
Role.class 1KB
mybatis
mapper
RolePermissionMapper.xml 2KB
UserMapper.xml 3KB
PermissionMapper.xml 3KB
RoleMapper.xml 3KB
UserRoleMapper.xml 1KB
mybatis-config.xml 587B
templates
index.html 216B
.mvn
wrapper
maven-wrapper.jar 46KB
maven-wrapper.properties 110B
pom.xml 4KB
.gitignore 268B
共 61 条
- 1
资源评论
- LiC_070931282018-08-31资源不错,有帮助
地上打滚的猪
- 粉丝: 5
- 资源: 9
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功