阿里巴巴连接池durid数据库密码加密
刘振兴 代码分享 05月05日374暂无评论
先贴上本人durid 的配置
<!-- 阿里巴巴连接池--><bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"><property name="driverClassName" value="${jdbc.driverClass}"/><property name="url" value="${jdbc.url}"></property><property name="username" value="${jdbc.user}"/><property name="password" value="${jdbc.password}"/><!-- 最大并发连接数 --><property name="maxActive" value="${maxActive}" /><!-- 初始化连接数量 --><property name="initialSize" value="${initialSize}" /><!-- 配置获取连接等待超时的时间 --><property name="maxWait" value="${maxWait}" /><!-- 最小空闲连接数 --><property name="minIdle" value="${minIdle}" /><!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 --><property name="timeBetweenEvictionRunsMillis" value="${timeBetweenEvictionRunsMillis}" /><!-- 配置监控统计拦截的filters --><property name="connectionProperties" value="${jdbc.connectionProperties}" /><!--过滤器说明:config=密码解密,stat:监控,wall:防止sql注入--><property name="filters" value="config,stat,wall" /></bean>
//properties文件数据如下jdbc.driverClass=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/test?characterEncoding=UTF-8jdbc.user=root#jdbc.password=123456jdbc.password=sPllXgRX3e8EQFchXYYucOMa3ambUVcNGOkqdR7c5RP3JCy0TvfKpRqNxPLhWqQql44I2XpIZjkxbjBC6v8faQ==jdbc.connectionProperties=config.decrypt=true;config.decrypt.key=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAM4XSAUt1AyaWODsQURsU7NRDi3t9wHbajStN+VosTysss5lfo6LX0+vO8JeqdC0ZLKAesiR9+qjT6uu8H2ihisCAwEAAQ==maxActive=20initialSize=1maxWait=60000minIdle=10timeBetweenEvictionRunsMillis=60000
方法一：写个main方法进行测试
public static void main(String[] args) throws Exception {String[] str = new String[]{"youPassword"};com.alibaba.druid.filter.config.ConfigTools.main(str);}
方法二：使用cmd命令运行main方法
//先找到jar的位置，然后右键在此处打开命令窗口，或者手动cd到jar的位置java -cp druid-0.2.23.jar com.alibaba.druid.filter.config.ConfigTools youPassword
D:>java -cp druid-1.0.27.jar com.alibaba.druid.filter.config.ConfigTools root
得到以下数据
privateKey:MIIBVAIBADANBgkqhkiG9w0BAQEFAASCAT4wggE6AgEAAkEApHkcHIEWKEVLWY6zX1T74PAuZRQOquDPylDCUj39ALcn/XLnAudTz4ZdJOz0/ ukdcSnU0f7yD9BYubNPUv+JPQIDAQABAkEAhFhLzYf1y1vPAPZ50Ykx0NOTkZQtJUUXDuYjJ0hoEC0CW4Ojt4Ykmun2WuaUCJHYuyw/ChhFsX5hosjRTJ6nh QIhAPLcpv2baT4ho3sZKLod6FPZC2SMJWc59b/JcTE5sXRDAiEArV7dnWWteSqSAaE3XlDV+/bJLbspQipMAHlA+fNN9H8CIA/muJxUR6DEzRJrREpjWOnch S1xK6XFmryS8PFbKK5HAiBBisOtZWsXi4h3JUORXG4JO1sC9ua6JNNmunBeDiVCcQIgDDZN21jsq3Nx9BTbQY58n9Hw4BC1Lbv+uQJWk0LSIpQ=
publicKey:MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAKR5HByBFihFS1mOs19U++DwLmUUDqrgz8pQwlI9/QC3J/1y5wLnU8+GXSTs9P7pHXEp1NH+8g/QWL mzT1L/iT0CAwEAAQ==
password:jJeQPHF7qIga1njBksp1wsNq+V8p0qt4OqYTBBwBu5Zcnl8xhIyXH27zzuxKVurM2b5mQSInh9rTpZ/K2gHkGw==
password就填写上方加密后的password,connectionProperties填写publicKey
<property name="password" value="jJeQPHF7qIga1njBksp1wsNq+V8p0qt4OqYTBBwBu5Zcnl8xhIyXH27zzuxKVurM2b5mQSInh9rTpZ/K2gHkGw=="/><!-- 解密必须配置项 --><property name="connectionProperties" value="config.decrypt=true;config.decrypt.key=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAKR5HByBFihFS1mOs19U++DwLmUUDqrgz8pQwlI9/QC3J/1y5wLnU8+GXSTs9P7pHXEp1NH+8g/QWL mzT1L/iT0CAwEAAQ==" /><property name="filters" value="config" />
