1、引入依赖
<!-- 数据库加密 -->
<dependency>
<groupId>com.github.ulisesbocchio</groupId>
<artifactId>jasypt-spring-boot-starter</artifactId>
<version>2.1.0</version>
</dependency>
2、配置加密密钥 (非数据库密码)
jasypt:
encryptor:
password: 12345
3、得到加密后的字符串
@Autowired
StringEncryptor stringEncryptor;
@GetMapping("getEncWord")
JsonResult getEncWord(String pwd) throws Exception {
String encWord =stringEncryptor.encrypt(pwd);
return JsonResult.success(encWord);
}
4、写入数据库配置文件
url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=XXX
password: ENC(ZLSBl2nyits3eEM+BUrhN/a+2swPEy)
driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
username: xx
type: com.alibaba.druid.pool.DruidDataSource
加密后的字符串用ENC()包裹在括号里