spingboot连接数据库加密

妖狐艹你老母 2022-12-04 15:58 188阅读 0赞

> ### 一、pom ###
> 
>     
>             <dependency>
>                 <groupId>com.github.ulisesbocchio</groupId>
>                 <artifactId>jasypt-spring-boot-starter</artifactId>
>                 <version>2.1.2</version>
>             </dependency>
> 
> ### 二、yml密钥 ###
> 
>     #jasypt加密的密匙（写到启动参数里面）
>     jasypt:
>       encryptor:
>         password: xxx
>         algorithm: PBEWithMD5AndDES
> 
> ### 三、demo生成密文 ###
> 
>     package com.god.demo;
>     
>     import org.jasypt.encryption.StringEncryptor;
>     import org.jasypt.encryption.pbe.StandardPBEStringEncryptor;
>     import org.junit.jupiter.api.Test;
>     import org.springframework.beans.factory.annotation.Autowired;
>     import org.springframework.boot.test.context.SpringBootTest;
>     
>     @SpringBootTest
>     class DemoApplicationTests {
>     
>         private static final String ALGORITHM_INFO = "PBEWithMD5AndDES";
>     
>         private static final String PASSWORD_INFO = "xxx";
>     
>         @Test
>         void contextLoads() {
>         }
>     
>         @Autowired
>         StringEncryptor stringEncryptor;
>     
>         @Test
>         public void encryptPwd() {
>             StandardPBEStringEncryptor standardPBEStringEncryptor = new StandardPBEStringEncryptor();
>             /*配置文件中配置如下的算法*/
>             standardPBEStringEncryptor.setAlgorithm(ALGORITHM_INFO);
>             /*配置文件中配置的password*/
>             standardPBEStringEncryptor.setPassword(PASSWORD_INFO);
>             /*要加密的文本*/
>             String name = standardPBEStringEncryptor.encrypt("root");
>             String password = standardPBEStringEncryptor.encrypt("root");
>             /*将加密的文本写到配置文件中*/
>             System.out.println("name=" + name);
>             System.out.println("password=" + password);
>     
>             /*要解密的文本*/
>             String name2 = standardPBEStringEncryptor.decrypt("FarrmxSQX5uwtH/NZRxy+g==");
>             String password2 = standardPBEStringEncryptor.decrypt("vhiaYB1gl9zPj16yu7uMkA==");
>             /*解密后的文本*/
>             System.out.println("name2=" + name2);
>             System.out.println("password2=" + password2);
>         }
>     
>     }
> 
> ### 四、yml配置 ###
> 
>     spring:
>       datasource:
>         url: jdbc:mysql://127.0.0.1:3306/demo?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8
>         username: ENC(OM1oXbZoe7LbBDkGbv7StA==)
>         password: ENC(3ME4chn+k8bK8f2fUastWQ==)
> 
> ### 五、常见问题 ###
> 
> **[Failed to bind properties under ‘spring.datasource.password‘ to java.lang.String: Reason: Fail][Failed to bind properties under _spring.datasource.password_ to java.lang.String_ Reason_ Fail]**
> 
> ### 六、参数启动 ###
> 
>     #启动springboot的jar包，指定程序参数
>     java -jar demo.jar --jasypt.encryptor.password=123456
>     
>     #启动springboot的jar包，指定JVM参数
>     java  -Djasypt.encryptor.password=123456 -jar demo.jar
> 
>  
> 
>  
> 
>

[Failed to bind properties under _spring.datasource.password_ to java.lang.String_ Reason_ Fail]: https://libusi.blog.csdn.net/article/details/108465034