druid连接池

连接池种类较多，例如BoneCP、C3P0、DBCP、Proxool、Druid，C3P0、DBCP、Proxool通过最佳实践已经淘汰了，Druid号称是最好的数据库连接池，阿里连接池调研结果，通过这链接也不见得阿里的Druid的好到那里去，因为线程数超过2的情况，这份报告中指示对DBCP和Druid进行了比对，而没有再做BoneCP的对比了。不知道是不是阿里自己不自信，还是怎地。
不过国人做的开源连接池，这种精神值得肯定，我不是测试，也不想研究是不是第一，姑且用之，反正我写不出来。
1 spring-dao.xml

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    xmlns:tx="http://www.springframework.org/schema/tx"    xsi:schemaLocation="    http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd    http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">    <!-- 数据源配置, 使用druid连接池 -->    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">        <property name="driverClassName" value="${jdbc.driver}" />        <property name="url" value="${jdbc.url}" />        <property name="username" value="${jdbc.username}" />        <property name="password" value="${jdbc.password}" />        <!-- 配置监控统计拦截的filters -->        <property name="filters" value="${druid.filters}" />        <property name="connectionProperties" value="${druid.connectionProperties}" />        <!-- 配置初始化大小、最小、最大 -->        <property name="initialSize" value="${druid.initialSize}"/>        <property name="minIdle" value="${druid.minIdle}"/>        <property name="maxActive" value="${druid.maxActive}"/>        <!-- 配置获取连接等待超时的时间 -->        <property name="maxWait" value="${druid.maxWait}"/>        <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->        <property name="timeBetweenEvictionRunsMillis" value="${druid.timeBetweenEvictionRunsMillis}" />        <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->        <property name="minEvictableIdleTimeMillis" value="${druid.minEvictableIdleTimeMillis}" />        <property name="validationQuery" value="${druid.validationQuery}" />        <property name="testWhileIdle" value="${druid.testWhileIdle}" />        <property name="testOnBorrow" value="${druid.testOnBorrow}" />        <property name="testOnReturn" value="${druid.testOnReturn}" />        <!-- 打开PSCache，并且指定每个连接上PSCache的大小  如果用Oracle，则把poolPreparedStatements配置为true，mysql可以配置为false。-->        <property name="poolPreparedStatements" value="${druid.poolPreparedStatements}" />        <property name="maxPoolPreparedStatementPerConnectionSize" value="${druid.maxPoolPreparedStatementPerConnectionSize}" />    </bean>    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">        <property name="dataSource">            <ref bean="dataSource" />        </property>        <property name="mapperLocations" value="classpath*:com/dzmsoft/ucs/**/mapping/*.xml" />        <property name="plugins">            <list>                <bean                    class="com.github.miemiedev.mybatis.paginator.OffsetLimitInterceptor">                    <property name="dialectClass"                        value="com.github.miemiedev.mybatis.paginator.dialect.MySQLDialect"></property>                </bean>            </list>        </property>    </bean>    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">          <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>          <property name="basePackage" value="com.dzmsoft.ucs.*.dao" />      </bean>      <!--ucs 数据连接事务 -->    <bean id="transactionManager"        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">        <property name="dataSource" ref="dataSource" />    </bean>    <!--ucs 连接事务的注解配置 -->    <tx:annotation-driven transaction-manager="transactionManager" /></beans>

2 jdbc.properties

jdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/walle?useUnicode=true&characterEncoding=utf-8jdbc.username=ucsjdbc.password=Ha817hs0cVYMMtSIzjhE+AzhxND9I8bSn+uKY8kgj9rTyIh9wEJ5fyUGgDxQUNEEQHJAxegdipejFW68qYBzSA==#druid connection pool settingsdruid.initialSize=10druid.minIdle=10druid.maxActive=50druid.maxWait=60000druid.timeBetweenEvictionRunsMillis=60000druid.minEvictableIdleTimeMillis=300000druid.validationQuery=SELECT 'x'druid.testWhileIdle=truedruid.testOnBorrow=falsedruid.testOnReturn=falsedruid.poolPreparedStatements=truedruid.maxPoolPreparedStatementPerConnectionSize=20druid.filters=configdruid.connectionProperties=config.decrypt=true;config.decrypt.key=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAIqxlQlRFdLoir1dYf7l4ktd5wRtJLG0AcyEd7MqJzkEGyy+2KO5XfNifpvc8snBNBjYSr01y2Ox7lN86qcwWZECAwEAAQ==

3 druid密码加密
阿里写的连接池，可以通过下面的命令执行，

java -cp D:/Program Files (x86)/apache-maven-3.1.1/com/alibaba/druid/1.0.16/druid-1.0.16.jar com.alibaba.druid.filter.config.ConfigTools 用户名/密码

但是如果每次这么做，就很麻烦，所以可以考虑下面，对这个命令进行封装

import java.io.BufferedReader;import java.io.InputStreamReader;/** * Copyright (C) dzmsoft Co., Ltd. * 签名 * @author dzm */public class ExportCertFormKeystore {    public void execCommand(String[] arstringCommand) {          for (int i = 0; i < arstringCommand.length; i++) {              System.out.print(arstringCommand[i] + " ");          }          try {              Runtime.getRuntime().exec(arstringCommand);          } catch (Exception e) {              System.out.println(e.getMessage());          }      }      public void execCommand(String arstringCommand) {          try {              Runtime.getRuntime().exec(arstringCommand);          } catch (Exception e) {              System.out.println(e.getMessage());          }      }      /**      * 生成密钥      */      public void genkey(String keystorePath,String password) {          String[] arstringCommand = new String[] {          "cmd ", "/k",                  "start", // cmd Shell命令                  "keytool",                  "-genkey", // -genkey表示生成密钥                  "-validity", // -validity指定证书有效期(单位：天)，这里是36000天                  "36500",                  "-keysize",//     指定密钥长度                  "1024",                  "-alias", // -alias指定别名，这里是ss                  "ss",                  "-keyalg", // -keyalg 指定密钥的算法 (如 RSA DSA（如果不指定默认采用DSA）)                  "RSA",                  "-keystore", // -keystore指定存储位置，这里是d:/demo.keystore                  keystorePath,                  "-dname",// CN=(名字与姓氏), OU=(组织单位名称), O=(组织名称), L=(城市或区域名称),                              // ST=(州或省份名称), C=(单位的两字母国家代码)"                  "CN=(dengjun), OU=(dzmsoft), O=(dzmsoft), L=(wuhan), ST=(hubei), C=(CN)",                  "-storepass", // 指定密钥库的密码(获取keystore信息所需的密码)                  password,                   "-keypass",// 指定别名条目的密码(私钥的密码)                  password,                   "-v"// -v 显示密钥库中的证书详细信息          };          execCommand(arstringCommand);      }      /**      * 导出证书文件      */      public void export(String keystorePath, String cerPath, String password) {          String[] arstringCommand = new String[] {          "cmd ", "/k",                  "start", // cmd Shell命令                  "keytool",                  "-export", // - export指定为导出操作                   "-keystore", // -keystore指定keystore文件，这里是d:/demo.keystore                  keystorePath,                  "-alias", // -alias指定别名，这里是ss                  "ss",                  "-file",//-file指向导出路径                  cerPath,                  "-storepass",// 指定密钥库的密码                  password          };          execCommand(arstringCommand);      }      /**     * 生成数据库密码     * @param password     */    public void genDruidPwd(String password, String jarPath){        String[] arstringCommand = new String[] {                  "cmd ", "/k",  //                        "start", // cmd Shell命令                          "java",                        "-cp",                        jarPath,                        "com.alibaba.druid.filter.config.ConfigTools",                        password                };          execAndExportCommand(arstringCommand);      }    private void execAndExportCommand(String[] arstringCommand){        for (int i = 0; i < arstringCommand.length; i++) {              System.out.print(arstringCommand[i] + " ");          }          BufferedReader br = null;        try {              Process p = Runtime.getRuntime().exec(arstringCommand);              br = new BufferedReader(new InputStreamReader(p.getInputStream()));            String line = null;            while ((line = br.readLine()) != null) {                System.out.println(line);            }        } catch (Exception e) {              System.out.println(e.getMessage());          }  finally {            if (br != null) {                try {                    br.close();                } catch (Exception e) {                    e.printStackTrace();                }            }        }    }}

下面运行的结果如下：

@Test    public void genPassword_test(){        String userpwd = "root";        String jarPath = "D:/Program Files (x86)/apache-maven-3.1.1/repository/com/alibaba/druid/1.0.16/druid-1.0.16.jar";        new ExportCertFormKeystore().genDruidPwd(userpwd,jarPath);    }

运行结果如下：

cmd  /k java -cp D:/Program Files (x86)/apache-maven-3.1.1/repository/com/alibaba/druid/1.0.16/druid-1.0.16.jar com.alibaba.druid.filter.config.ConfigTools root privateKey:MIIBVAIBADANBgkqhkiG9w0BAQEFAASCAT4wggE6AgEAAkEAjounhWVTU5zFVRQzu1Wy7CZCZRwkIyfZYieMeOZTC19jVpmcSIlPlCP4gEcepFoB/t+L/pGDKgRLDxlRoBDYXwIDAQABAkA13Ej5G3cnwbXCVvbREymfFznBMKfq7LSz5NOsHwND6TrGRTxk3lh6R1/xUi5dSV+6r0h5m6TaFfqSUQsV2by5AiEA95hCHptCBIHvnU27eTcw/Pgl6wA0aLSjdwgxHWKeBRUCIQCTYnUc3udSbOF0GDFQ40EDlA5LpOhfSAmZhWrMx0QsowIgJBgsO24C18lhdxsn42nqWFaMoI+tFD6RPf8RuejwhGkCICUv+ozGUWeiwWAhmo/mR0k32kOL4HXqH0H1P/VbcgAxAiEAqQRzIkWr6m3MVI8hk4EO9MdXRi/6efmWjYl3UTaQpL8=publicKey:MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAI6Lp4VlU1OcxVUUM7tVsuwmQmUcJCMn2WInjHjmUwtfY1aZnEiJT5Qj+IBHHqRaAf7fi/6RgyoESw8ZUaAQ2F8CAwEAAQ==password:YB7JKAxaK5ACn3TOqJcjlu7uL2aC//xFyaOV6tIkAOXT/X7TMI9ljNpP2zI0dSu3GhgZKJ/u5rK8VAnlE0WPqA==