Druid连接池 加密 与解密

（spring_mybatis_druid）

加密

1.控制台加密密码

java -cp /Users/shutakaratakara/.m2/repository/com/alibaba/druid/1.1.2/druid-1.1.2.jar com.alibaba.druid.filter.config.ConfigTools 密码  

2.得到加密码后数据

privateKey:
publicKey:
password:

3.测试解码

 public void testCode(){
        String publicKey="加密后数据";
        String pwd = "加密后数据";
        try {
            String decryptword=ConfigTools.decrypt(publicKey,pwd);
            System.out.println(decryptword);
        }
         catch (Exception e) {
            e.printStackTrace();
        }
    }

4.Spring配置文件

<util:properties id="cfg" location="classpath:dbconfig.properties"/>
<!-- 阿里 druid 数据库连接池 -->
<bean id = "dataSource" class = "com.alibaba.druid.pool.DruidDataSource" destroy-method="close" >
...
    <!-- 数据库基本信息配置 -->
    <!-- config.decrypt=true -->
    <property name="filters" value="config" />
    <property name="connectionProperties" value="config.decrypt=true;config.decrypt.key=#{cfg.publicKey}" />
    ...
</bean>

5.dbconfig.properties(主要password，publicKey)

url=jdbc:mysql://localhost:3306/数据库
driverClassName=com.mysql.jdbc.Driver
username=root
password=加密后数据
publicKey=加密后数据
filters=stat
maxActive=20
initialSize=1
maxWait=60000
minIdle=10
maxIdle=15
timeBetweenEvictionRunsMillis=60000
minEvictableIdleTimeMillis=300000
validationQuery=SELECT'x'
testWhileIdle=true
testOnBorrow=false
testOnReturn=false
maxOpenPreparedStatements=20
removeAbandoned=true
removeAbandonedTimeout=1800
logAbandoned=true

druid参考配置

<!-- 阿里 druid 数据库连接池 -->
    <bean id = "dataSource" class = "com.alibaba.druid.pool.DruidDataSource" destroy-method="close" >
        <!-- 数据库基本信息配置 -->
        <property name = "url" value = "#{cfg.url}" />
        <property name = "username" value = "#{cfg.username}" />
        <property name = "password" value = "#{cfg.password}" />
        <!-- config.decrypt=true -->
        <property name="filters" value="config" />
        <property name="connectionProperties" value="config.decrypt=true;config.decrypt.key=#{cfg.publicKey}" />
        <property name = "driverClassName" value = "#{cfg.driverClassName}" />
        <!--<property name = "filters" value = "#{cfg.filters}" />-->
        <!-- 最大并发连接数 -->
        <property name = "maxActive" value = "#{cfg.maxActive}" />
        <!-- 初始化连接数量 -->
        <property name = "initialSize" value = "#{cfg.initialSize}" />
        <!-- 配置获取连接等待超时的时间 -->
        <property name = "maxWait" value = "#{cfg.maxWait}" />
        <!-- 最小空闲连接数 -->
        <property name = "minIdle" value = "#{cfg.minIdle}" />
        <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->
        <property name = "timeBetweenEvictionRunsMillis" value ="#{cfg.timeBetweenEvictionRunsMillis}" />
        <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->
        <property name = "minEvictableIdleTimeMillis" value ="#{cfg.minEvictableIdleTimeMillis}" />
        <property name = "validationQuery" value = "#{cfg.validationQuery}" />
        <property name = "testWhileIdle" value = "#{cfg.testWhileIdle}" />
        <property name = "testOnBorrow" value = "#{cfg.testOnBorrow}" />
        <property name = "testOnReturn" value = "#{cfg.testOnReturn}" />
        <property name = "maxOpenPreparedStatements" value ="#{cfg.maxOpenPreparedStatements}" />
        <!-- 打开 removeAbandoned 功能 -->
        <property name = "removeAbandoned" value = "#{cfg.removeAbandoned}" />
        <!-- 1800 秒，也就是 30 分钟 -->
        <property name = "removeAbandonedTimeout" value ="#{cfg.removeAbandonedTimeout}" />
        <!-- 关闭 abanded 连接时输出错误日志 -->
        <property name = "logAbandoned" value = "#{cfg.logAbandoned}" />
    </bean>