阿里巴巴连接池durid数据库密码加密
先贴上本人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.Driver jdbc.url=jdbc:mysql://localhost:3306/test?characterEncoding=UTF-8 jdbc.user=root #jdbc.password=123456 jdbc.password=sPllXgRX3e8EQFchXYYucOMa3ambUVcNGOkqdR7c5RP3JCy0TvfKpRqNxPLhWqQql44I2XpIZjkxbjBC6v8faQ== jdbc.connectionProperties=config.decrypt=true;config.decrypt.key=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAM4XSAUt1AyaWODsQURsU7NRDi3t9wHbajStN+VosTysss5lfo6LX0+vO8JeqdC0ZLKAesiR9+qjT6uu8H2ihisCAwEAAQ== maxActive=20 initialSize=1 maxWait=60000 minIdle=10 timeBetweenEvictionRunsMillis=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" />
- 版权申明:此文如未标注转载均为本站原创,自由转载请表明出处《IT技术宅》。
- 本文网址:https://www.ilt.me/dmfx/115.html
- 上篇文章:java 数据验证工具类
- 下篇文章:IDEA更改maven下载源为阿里云 解决jar下载慢问题