数据库连接池调整为druid

邮件 ***数据库连接池调整为druid ，修改的代码
update 
fstock/fstock-front/src/main/java/com/hundsun/fstock/front/action/trade/personal/PersonalAction.java
fstock/fstock-front/src/main/resources/conf/spring/jresplus-dao-beans.xml
fstock/fstock-front/src/main/resources/ares-app-config.xml
fstock/fstock-front/src/main/webapp/WEB-INF/web.xml
fstock/fstock-front/pom.xml
    Updated to revision 10780.
    ===== File Statistics: =====

    Updated: 5

jresplus-dao-beans.xml修改的内容：

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">

修改为：

<bean id="dataSource"  class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">

并在该bean下添加：

<!-- 配置监控统计拦截的filters -->
<property name="filters" value="stat" />

ares-app-config.xml修改的内容：

<args threadCount="3" queueSize="30" debug="false"/>

修改为：

<args threadCount="3" queueSize="30" debug="false">
<monitor port="8012" key="123456" enable="false" />
</args>

web.xml修改的内容：

添加：

<!-- druid配置 -->
<filter>
    <filter-name>DruidWebStatFilter</filter-name>
    <filter-class>com.alibaba.druid.support.http.WebStatFilter</filter-class>
    <init-param>
        <param-name>exclusions</param-name>
        <param-value>/static/*,*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*</param-value>
    </init-param>
</filter>
<filter-mapping>
    <filter-name>DruidWebStatFilter</filter-name>
    <url-pattern>/*</url-pattern>
</filter-mapping>
<!-- druid监控 -->
<servlet>
    <servlet-name>DruidStatView</servlet-name>
    <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>
        <init-param>
    <!-- 允许清空统计数据 -->
    <param-name>resetEnable</param-name>
    <param-value>true</param-value>
    </init-param>
    <init-param>
    <!-- 用户名 -->
    <param-name>loginUsername</param-name>
    <param-value>druid</param-value>
    </init-param>
    <init-param>
    <!-- 密码 -->
    <param-name>loginPassword</param-name>
    <param-value>druid</param-value>
    </init-param>
</servlet>
<servlet-mapping>
    <servlet-name>DruidStatView</servlet-name>
    <url-pattern>/druid/*</url-pattern>
</servlet-mapping>

修改：

<filter-mapping>
    <filter-name>CacheFilter</filter-name>
    <url-pattern>/*</url-pattern>
</filter-mapping>

修改为：

<filter-mapping>
    <filter-name>CacheFilter</filter-name>
    <url-pattern>/fstock/*</url-pattern>
</filter-mapping>

pom.xml修改的内容：

添加内容：

<!-- 加入druid数据源依赖包 -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.0.7</version>
</dependency>

最后监控：

    开发环境druid监控地址:

     http://****:8080/****/druid/login.html  

    账号密码: druid/druid