springboot druid数据库密码加密

淡淡的烟草味﹌ 2023-02-14 06:44 3阅读 0赞

参考文章：[springboot druid数据库密码加密][springboot druid]

# pom.xml引入jar #

<dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid-spring-boot-starter</artifactId>
      <version>1.1.14</version>
    </dependency>

# 生成加密密码 #

输入命令

java -cp D:\Repositories\ricet\com\alibaba\druid\1.1.14\druid-1.1.14.jar \
    com.alibaba.druid.filter.config.ConfigTools 123456

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NzZG41NjU5NzM4NTA_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NzZG41NjU5NzM4NTA_size_16_color_FFFFFF_t_70 1][]

其中：publicKey 为公钥 ， password为加密后密码，privateKey为私钥

# 配置数据库文件 application.yml #

# 数据源配置
    spring:
      datasource:
        type: com.alibaba.druid.pool.DruidDataSource
        driverClassName: com.mysql.cj.jdbc.Driver
        druid:
          # 主库数据源
          master:
            url: jdbc:mysql://dbmast.confedu.com:3306/da_edu_springboss?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
            username: root
            password: D/PR8jte+cXJVj74bavRpkqWbH/d1f/NlYliAyTafXDk5f8qKW7ITPdXskJ8Y3wz8zIM4on3zw+rCXD+
            connect-properties:
              config.decrypt: true
              config.decrypt.key: MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAIeliL/0EAtp/R9ow+LXx59I4PpWjlYCG6jyf7SAoagdscRCBSi916x9Vg6zbOMKWH8ZtvdNE54Lj8
          # 从库数据源
          slave:
            # 从数据源开关/默认关闭
            enabled: false
            url:
            username:
            password:
          # 初始连接数
          initialSize: 5
          # 最小连接池数量
          minIdle: 10
          # 最大连接池数量
          maxActive: 20
          # 配置获取连接等待超时的时间
          maxWait: 60000
          # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
          timeBetweenEvictionRunsMillis: 60000
          # 配置一个连接在池中最小生存的时间，单位是毫秒
          minEvictableIdleTimeMillis: 300000
          # 配置一个连接在池中最大生存的时间，单位是毫秒
          maxEvictableIdleTimeMillis: 900000
          # 配置检测连接是否有效
          validationQuery: SELECT 1 FROM DUAL
          testWhileIdle: true
          testOnBorrow: false
          testOnReturn: false
          webStatFilter:
            enabled: true
          statViewServlet:
            enabled: true
            # 设置白名单，不填则允许所有访问
            allow:
            url-pattern: /monitor/druid/*
          filter:
            stat:
              enabled: true
              # 慢SQL记录
              log-slow-sql: true
              slow-sql-millis: 1000
              merge-sql: true
            wall:
              config:
                multi-statement-allow: true
            #数据库过滤器
            config:
              enabled: true

# 工具类 #

package com.ruoyi.common.utils;
    
    import com.alibaba.druid.filter.config.ConfigTools;
    
    /**
     * @author： dongao
     * @create: 2019/7/22
     * 数据库密码加密工具类
     */
    public class DataSourcePasswordUtils {
        /**
         * 加密
         * @param cipherText
         * @return
         * @throws Exception
         */
        public static String encrypt(String cipherText) throws Exception {
            String encrypt = ConfigTools.encrypt(cipherText);
            return encrypt;
        }
    
        /**
         * 解密
         * @param cipherText
         * @return
         * @throws Exception
         */
        public static String decrypt(String cipherText) throws Exception {
            String decrypt = ConfigTools.decrypt(cipherText);
            return decrypt;
        }
    
        public static void main(String[] args) throws Exception {
            String password = "123456";
            String encrypt = encrypt(password);
            System.out.println(encrypt);
            String decrypt = decrypt(encrypt);
            System.out.println(decrypt);
    
        }
    }

# application.properties 数据库配置如下： #

# 数据源配置
    spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
    spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
    #spring.datasource.driverClassName=com.mysql.jdbc.Driver
    
    # 主库数据源
    spring.datasource.druid.master.url=jdbc:mysql://ei.appcommunity.mysql1.com:3306/app_community?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
    spring.datasource.druid.master.username=new_app
    spring.datasource.druid.master.password=Z/+M30mrTBcleSMHt3+Xq4z+DgImbaCV54+0//Uh80PUxFOXYS0JEd5GHwmC3wXKFPQfnzL6Ok1+3
    spring.datasource.druid.master.connect-properties.config.decrypt=true
    spring.datasource.druid.master.connect-properties.config.decrypt.key=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAK+6BeVD3laS7C1iHWwyA1IiT8JKh7LpCxhvvdrCPZhSYbID3NwLpGH4ECSM+WluOT7Bdq4CP3T7CUC
    
    # 从库数据源
    spring.datasource.druid.slave.url=jdbc:mysql://ei.appcommunity.mysql1.com:3306/app_community?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
    spring.datasource.druid.slave.username=new_app
    spring.datasource.druid.slave.password=Z/+M30mrTBcleSMHt3+Xq4z+DgImbaCV54+0//Uh80PUxFOXYS0JEd5GHwmC3wXKFPQfnzL6Ok1+3Fy
    spring.datasource.druid.slave.connect-properties.config.decrypt=true
    spring.datasource.druid.slave.connect-properties.config.decrypt.key=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAK+6BeVD3laS7C1iHWwyA1IiT8JKh7LpCxhvvdrCPZhSYbID3NwLpGH4ECSM+WluOT7Bdq4CP3T7CUC
    
    # 初始连接数
    spring.datasource.druid.initialSize=5
    
    # 最小连接池数量
    spring.datasource.druid.minIdle=10
    
    # 最大连接池数量
    spring.datasource.druid.maxActive=20
    
    # 配置获取连接等待超时的时间
    spring.datasource.druid.maxWait=60000
    
    # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
    spring.datasource.druid.timeBetweenEvictionRunsMillis=60000
    
    # 配置一个连接在池中最小生存的时间，单位是毫秒
    spring.datasource.druid.minEvictableIdleTimeMillis=300000
    
    # 配置一个连接在池中最大生存的时间，单位是毫秒
    spring.datasource.druid.maxEvictableIdleTimeMillis=900000
    
    # 配置检测连接是否有效
    spring.datasource.druid.validationQuery=SELECT 1 FROM DUAL
    spring.datasource.druid.testWhileIdle=true
    spring.datasource.druid.testOnBorrow=false
    spring.datasource.druid.testOnReturn=false
    spring.datasource.druid.web-stat-filter.enabled=true
    spring.datasource.druid.stat-view-servlet.enabled=true
    
    # 设置白名单，不填则允许所有访问
    spring.datasource.druid.stat-view-servlet.allow=
    spring.datasource.druid.stat-view-servlet.url-pattern=/monitor/druid/*
    spring.datasource.druid.filter.stat.enabled=true
    
    # 慢SQL记录
    spring.datasource.druid.filter.stat.log-slow-sql=true
    spring.datasource.druid.filter.stat.slow-sql-millis=1000
    spring.datasource.druid.filter.stat.merge-sql=true
    spring.datasource.druid.filter.wall.config.multi-statement-allow=true
    
    #数据库过滤器
    spring.datasource.druid.filter.config.enabled=true

[springboot druid]: https://blog.csdn.net/csdn565973850/article/details/96997262
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NzZG41NjU5NzM4NTA_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190723151451193.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NzZG41NjU5NzM4NTA=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NzZG41NjU5NzM4NTA_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20190723151536416.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NzZG41NjU5NzM4NTA=,size_16,color_FFFFFF,t_70