一. 引入依赖
org.springframework.boot
spring-boot-starter-web
mysql
mysql-connector-java
runtime
org.springframework.boot
spring-boot-starter-jdbc
com.alibaba
druid-spring-boot-starter
1.1.21
org.nutz
nutz
1.r.62
org.projectlombok
lombok
1.18.0
org.jasypt
jasypt
1.9.3
compile
二. application.yml配置文件
spring:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
druid:
main:
url: jdbc:mysql://127.0.0.1:3306/data_hn?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8
username: root
password: +7kwXYHUt9V4btttYVr3MOr/71O/ZIL7
salt: gxmh
subo:
url: jdbc:mysql://127.0.0.1:3306/data_gs?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8
username: root
password: +7kwXYHUt9V4btttYVr3MOr/71O/ZIL7
salt: gxmh
initial-size: 5 # 初始化连接大小 默认0
max-active: 20 # 最大连接数 默认8
min-idle: 5 # 最小空闲连接数 默认0
# 监控页面的用户名密码及页面地址
stat-view-servlet:
login-username: admin
login-password: 123456
enabled: true
url-pattern: /druid/*
max-wait: 60000 # 获取连接等待超时的时间(毫秒) 默认：-1
query-timeout: 90 # 查询超时时间
validation-query: SELECT 1 FROM DUAL
test-on-borrow: false # 申请连接时检测连接可用性 默认：false
test-on-return: false # 归还连接检测 默认false
test-while-idle: true # 超时是否检测连接可用性
time-between-eviction-runs-millis: 60000 # 配置空闲多久检测需要配置的空闲连接(毫秒)
min-evictable-idle-time-millis: 300000 # 配置一个连接在池中最小生存时间 默认30分钟
filters: config,stat,wall,slf4j # 通过别名的方式配置扩展插件，常用的插件有：监控统计用的filter:stat；日志用的filter:log4j；防御sql注入的filter:wall
filter:
stat:
log-slow-sql: true # 慢SQL记录
slow-sql-millis: 2000
db-type: mysql
merge-sql: false # SQL合并 默认false
wall:
config: #是否允许delete和drop表语句
delete-allow: true
drop-table-allow: false
enabled: true
db-type: mysql
pool-prepared-statements: false # 是否缓存PreparedStatement. PSCache对支持游标的数据库性能提升巨大，比如说oracle.在mysql下建议关闭.
max-pool-prepared-statement-per-connection-size: 20 # 每个连接上的PSCache的大小
use-global-data-source-stat: true # 合并多个DataSource的监控数据
server:
port: 8181
三. 数据源配置类DataSourceConfig
import com.alibaba.druid.pool.DruidDataSource;
import com.example.demo.utils.JasyptUtils;
import org.nutz.dao.Dao;
import org.nutz.dao.impl.NutDao;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.context.properties.bind.Binder;
import org.springframework.context.EnvironmentAware;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.env.Environment;
import javax.sql.DataSource;
/**
* @program: demo
* @description: 数据源配置类
* @author: guoxu
* @create: -12-19 14:56
*/
/**
* 1.当存在多个数据源时，最好加上@Primary注解，这样默认使用这个连接。
* 2.使用Qualifier注解说明使用某个连接。
*/
@Configuration
public class DataSourceConfig implements EnvironmentAware {
@Value("${spring.datasource.druid.main.salt}")
private String salt;
private Environment environment;
private DataSource defaultDataSource;
@Override
public void setEnvironment(Environment environment) {
this.environment = environment;
}
//配置主数据源
@Primary
@Bean
public DataSource initDataSource(){
Binder binder = Binder.get(environment);
defaultDataSource = binder.bind("spring.datasource.druid.main", DruidDataSource.class).get();
String password = ((DruidDataSource) defaultDataSource).getPassword();
((DruidDataSource) defaultDataSource).setPassword(JasyptUtils.strEnDecrypt(password, salt, 1));
return defaultDataSource;
}
//配置从数据源
@Bean(name = "sds")
public DataSource initSDataSource(){
Binder binder = Binder.get(environment);
defaultDataSource = binder.bind("spring.datasource.druid.subo", DruidDataSource.class).get();
String password = ((DruidDataSource) defaultDataSource).getPassword();
((DruidDataSource) defaultDataSource).setPassword(JasyptUtils.strEnDecrypt(password, salt, 1));
return defaultDataSource;
}
//主数据源绑定Nutz
@Primary
@Bean
public Dao initNutzDao(DataSource dataSource){
return new NutDao(dataSource);
}
//从数据源绑定Nutz
@Bean(name = "sdao")
public Dao initSNutzDao(@Qualifier("sds") DataSource dataSource){
return new NutDao(dataSource);
}
}
四. Nutz使用
@Autowired
Dao dao;
@Autowired
@Qualifier("sdao")
Dao sdao;
五. Jasypt加密工具类
package com.example.demo.utils;
import org.jasypt.encryption.pbe.StandardPBEStringEncryptor;
import org.jasypt.encryption.pbe.config.EnvironmentStringPBEConfig;
/**
* @program: gxww-frame-cloud
* @description: Jasypt加密解密工具类
* @author: guoxu
* @create: -12-16 14:57
*/
public class JasyptUtils {
public static void main(String[] args) {
String encrypt = strEnDecrypt("7j41Gq3M!@#", "gxmh", 0);
System.out.println("encrypt:"+encrypt);
String decrypt = strEnDecrypt(encrypt, "gxmh", 1);
System.out.println("decrypt:"+decrypt);
}
/**
* @Description: 字符串加密解密
* @Param: [plainText, salt, type]
* salt 加密盐
* type 0 加密 1或其他为 解密
* @return: java.lang.String
* @Author: guoxu
* @Date: /12/16
*/
public static String strEnDecrypt(String plainText, String salt,int type){
String resultStr = "";
//加密工具
StandardPBEStringEncryptor encryptor = new StandardPBEStringEncryptor();
//加密配置
EnvironmentStringPBEConfig config = new EnvironmentStringPBEConfig();
//加密方式，默认PBEWithMD5AndDES，可改PBEWithMD5AndTripleDES
config.setAlgorithm("PBEWithMD5AndDES");
//加密所需的salt(盐)
config.setPassword(salt);
//应用配置
encryptor.setConfig(config);
if (type == 0){
resultStr = encryptor.encrypt(plainText);
} else {
resultStr = encryptor.decrypt(plainText);
}
return resultStr;
}
}
六. 不加密数据库密码时的另一种数据源配置类
package com.example.demo.config;
import com.alibaba.druid.pool.DruidDataSource;
import org.nutz.dao.Dao;
import org.nutz.dao.impl.NutDao;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Primary;
import javax.sql.DataSource;
import java.sql.SQLException;
/**
* @program: demo
* @description: 多数据源配置类
* @author: guoxu
* @create: -12-19 14:56
*/
@Configuration
public class DataSourceConfig {
/**
* 当存在多个数据源时，最好加上@Primary注解，这样默认使用这个连接。
* 不需要使用Qualifier注解说明使用某个连接。
* @return
* @throws SQLException
*/
@Primary
@Bean
@ConfigurationProperties(prefix = "spring.datasource.druid.main")
public DataSource initMainDataSource() throws SQLException {
DruidDataSource mainDataSource = DataSourceBuilder.create().type(DruidDataSource.class).build();
return mainDataSource;
}
@Bean(name = "sds")
@ConfigurationProperties(prefix = "spring.datasource.druid.subo")
public DataSource initSuboDataSource() throws SQLException {
DruidDataSource suboDataSource = DataSourceBuilder.create().type(DruidDataSource.class).build();
return suboDataSource;
}
@Primary
@Bean
public Dao initNutzDao(DataSource dataSource){
return new NutDao(dataSource);
}
@Bean(name = "sdao")
public Dao initsNutzDao(@Qualifier("sds") DataSource dataSource){
return new NutDao(dataSource);
}
}
来源：oschina
链接：/u/4148675/blog/3145442
