druid 密码加密配置

使用druid 的spring boot starter 配置

• application.yml

spring:
  datasource:
    druid:
      url: jdbc:postgresql://127.0.0.1:5432/test
      username: test
      password: l7LrIhkDLct9BTd6eVVS3tsAwDYkwX4+e/zVGTk2Nbu110JN1Laa7Yv5/632N6zGlXhVTVynt4xnIS0+GsxWl1==
      driver-class-name: org.postgresql.Driver
      maxActive: 10
      minIdle: 1
      initialSize: 3
      connection-properties: config.decrypt=true;config.decrypt.key=${spring.datasource.druid.filter.config.public-key}
      filter:
        config:
          enabled: true
          public-key: MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAMsftVrO3eWNi/uXUkmUkqwmr86SjSbBDDi9NBoyfS+PlP2vuMsg62wTW2xGxg8csmOQsPHFbZKSfh99UJlyYtUCAwEAAQ==

• 需要注意的点
  • connection-properties 配置,durid 使用的set 方法配置的

    	public void setConnectionProperties(String connectionProperties) {
        if (connectionProperties == null || connectionProperties.trim().length() == 0) {
            setConnectProperties(null);
            return;
        }
    
        String[] entries = connectionProperties.split(";");
        Properties properties = new Properties();
        for (int i = 0; i < entries.length; i++) {
            String entry = entries[i];
            if (entry.length() > 0) {
                int index = entry.indexOf('=');
                if (index > 0) {
                    String name = entry.substring(0, index);
                    String value = entry.substring(index + 1);
                    properties.setProperty(name, value);
                } else {
                    // no value is empty string which is how java.util.Properties works
                    properties.setProperty(entry, "");
                }
            }
        }
    
        setConnectProperties(properties);
    }
    

  • 生成密码java -cp druid-1.1.10.jar com.alibaba.druid.filter.config.ConfigTools xxx