引入阿里Druid数据库连接池(maven ssm框架)

超、凢脫俗 2022-01-15 23:53 250阅读 0赞

Druid

Druid是阿里巴巴开源平台上的一个项目，整个项目由数据库连接池、插件框架和SQL解析器组成。该项目主要是为了扩展JDBC的一些限制，可以让程序员实现一些特殊的需求，比如向密钥服务请求凭证、统计SQL信息、SQL性能收集、SQL注入检查、SQL翻译等，程序员可以通过定制来实现自己需要的功能。

Maven引入jar包

<dependency>  
               <groupId>com.alibaba</groupId>  
               <artifactId>druid</artifactId>  
               <version>1.0.9</version>  
            </dependency>
    
            <dependency>
                <groupId>org.aspectj</groupId>
                <artifactId>aspectjweaver</artifactId>
                <version>1.8.8</version>
            </dependency>

配置数据库连接池在ApplicationContext.xml文件中添加下列配置

配置数据库
    
    
        <context:property-placeholder location="classpath:mysql.properties" />
          
        <bean id = "dataSource" class = "com.alibaba.druid.pool.DruidDataSource" destroy-method = "close" >    
             
           <property name = "url" value = "jdbc:mysql://${mysql.host}:${mysql.port}/${mysql.dbname}?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull" />    
           <property name = "username" value = "${mysql.username}" />    
           <property name = "password" value = "${mysql.password}" />    
           <property name = "driverClassName" value = "${driverClassName}" />    
           <property name = "filters" value = "${filters}" />    
              
           <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}" />  
             
           <property name = "minEvictableIdleTimeMillis" value ="${minEvictableIdleTimeMillis}" />    
    
           <property name = "testWhileIdle" value = "${testWhileIdle}" />    
           <property name = "testOnBorrow" value = "${testOnBorrow}" />    
           <property name = "testOnReturn" value = "${testOnReturn}" />    
           <property name = "maxOpenPreparedStatements" value ="${maxOpenPreparedStatements}" />  
             
           <property name = "removeAbandoned" value = "${removeAbandoned}" />  
             
           <property name = "removeAbandonedTimeout" value ="${removeAbandonedTimeout}" />  
                
           <property name = "logAbandoned" value = "${logAbandoned}" /> 
           <property name="proxyFilters">
                <list>
                    <ref bean="wall-filter"/>
                    <ref bean="stat-filter"/>
                    <ref bean="log-filter"/>
                </list>
            </property>
        </bean>  
    
    
        
        <bean id="stat-filter" class="com.alibaba.druid.filter.stat.StatFilter">
            
            <property name="slowSqlMillis" value="2000"/>
            <property name="logSlowSql" value="true"/>
        </bean>
    
        <bean id="log-filter" class="com.alibaba.druid.filter.logging.Log4jFilter">
            <property name="dataSourceLogEnabled" value="true" />
            <property name="statementExecutableSqlLogEnable" value="true" />
        </bean>
    
        
        <bean id="wall-filter" class="com.alibaba.druid.wall.WallFilter">  
            <property name="config" ref="wall-config" />  
            <property name="logViolation" value="true" />  
    
        </bean>  
    
        <bean id="wall-config" class="com.alibaba.druid.wall.WallConfig">  
            <property name="deleteAllow" value="false" />  
            <property name="truncateAllow" value="false" />  
            <property name="dropTableAllow" value="false" />  
            <property name="alterTableAllow" value="false" />  
            <property name="deleteWhereNoneCheck" value="false" />  
            <property name="updateWhereNoneCheck" value="false" />  
    
        </bean> 
    
        
        <bean id="druid-stat-interceptor"
              class="com.alibaba.druid.support.spring.stat.DruidStatInterceptor">
        </bean>
    
        <bean id="druid-stat-pointcut" class="org.springframework.aop.support.JdkRegexpMethodPointcut"
              scope="prototype">
            <property name="patterns">
                <list>
                    <value>com.dekscom.db.dao.*</value>
                </list>
            </property>
        </bean>
    
    
        
        <aop:config proxy-target-class="true">
            <aop:advisor advice-ref="druid-stat-interceptor" pointcut-ref="druid-stat-pointcut" />
        </aop:config>

mysql.properties属性文件
    
    mysql.host=localhost
    mysql.port=3306
    mysql.dbname=mysqldb
    mysql.username=root
    mysql.password=root
    driverClassName: com.mysql.jdbc.Driver  
    filters: wall,stat  
    maxActive: 20  
    initialSize: 3  
    maxWait: 5000  
    minIdle: 3  
    maxIdle: 15  
    timeBetweenEvictionRunsMillis: 60000  
    minEvictableIdleTimeMillis: 300000  
    validationQuery: SELECT 'x'  
    testWhileIdle: true  
    testOnBorrow: false  
    testOnReturn: false  
    maxOpenPreparedStatements: 20  
    removeAbandoned: true  
    removeAbandonedTimeout: 1800  
    logAbandoned: true

在web.xml文件中添加下列配置

<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>*.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>  
          <servlet>  
            <servlet-name>DruidStatView </servlet-name>  
            <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>  
            <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>

结果   
http://localhost:80/项目/druid/index.html

首页

![这里写图片描述][SouthEast]  
web监控

![这里写图片描述][SouthEast 1]  
spring监控

![这里写图片描述][SouthEast 2]

[SouthEast]: /images/20220115/3dd94518f8c64c5ea998fe01c761725e.png
[SouthEast 1]: /images/20220115/ca4e32571caf42f48cd28b2fd43c2d56.png
[SouthEast 2]: /images/20220115/90fc1547356a4958b85e4470cadd20d8.png