Druid基本使用

心已赠人 2022-06-10 03:28 209阅读 0赞

**1.相关地址**

项目地址 : [https://github.com/alibaba/druid][https_github.com_alibaba_druid]

下载地址 : [http://central.maven.org/maven2/com/alibaba/druid/][http_central.maven.org_maven2_com_alibaba_druid]

wiki : [https://github.com/alibaba/druid/wiki][https_github.com_alibaba_druid_wiki]

**2.maven**

[http://www.mvnrepository.com/artifact/com.alibaba/druid][http_www.mvnrepository.com_artifact_com.alibaba_druid]

**3.参考配置**

<context:property-placeholder ignore-unresolvable="true" location="classpath:cfg.properties" />
    
    <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}" />
    
            
            <property name="initialSize" value="${jdbc.pool.init}" />
            <property name="minIdle" value="${jdbc.pool.minIdle}" /> 
            <property name="maxActive" value="${jdbc.pool.maxActive}" />
    
            
            <property name="maxWait" value="60000" />
    
            
            <property name="timeBetweenEvictionRunsMillis" value="60000" />
    
            
            <property name="minEvictableIdleTimeMillis" value="300000" />
    
            <property name="validationQuery" value="${jdbc.testSql}" />
            <property name="testWhileIdle" value="true" />
            <property name="testOnBorrow" value="false" />
            <property name="testOnReturn" value="false" />
    
            
    
            
            <property name="filters" value="stat" /> 
        </bean>

#cfg.properties
    
    #mysql database setting
    jdbc.type=mysql
    jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8
    jdbc.username=root
    jdbc.password=root
    
    #pool settings
    jdbc.pool.init=1
    jdbc.pool.minIdle=3
    jdbc.pool.maxActive=20
    
    #jdbc.testSql=SELECT 'x'
    jdbc.testSql=SELECT 'x'

**4.StatViewServlet配置**

Druid内置提供了一个StatViewServlet用于展示Druid的统计信息。

这个StatViewServlet的用途包括：

*  提供监控信息展示的html页面
 *  提供监控信息的JSON API

**注意：**使用StatViewServlet，建议使用`druid 0.2.6`以上版本。

**(1) 配置web.xml**

StatViewServlet是一个标准的`javax.servlet.http.HttpServlet`，需要配置在你web应用中的WEB-INF/web.xml中。

<servlet>
          <servlet-name>DruidStatView</servlet-name>
          <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>
      </servlet>
      <servlet-mapping>
          <servlet-name>DruidStatView</servlet-name>
          <url-pattern>/druid/*</url-pattern>
      </servlet-mapping>

根据配置中的url-pattern来访问内置监控页面，如果是上面的配置，内置监控页面的首页是/druid/index.html

例如：  
[http://localhost:8080/druid/index.html][http_localhost_8080_druid_index.html]

**(2) 配置监控页面访问密码**

需要配置Servlet的 `loginUsername` 和 `loginPassword` 这两个初始参数。

示例如下:

<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>

**(3) 配置allow和deny**

StatViewSerlvet展示出来的监控信息比较敏感，是系统运行的内部情况，如果你需要做访问控制，可以配置`allow`和`deny`这两个参数。比如：

<servlet>
          <servlet-name>DruidStatView</servlet-name>
          <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>
        <init-param>
            <param-name>allow</param-name>
            <param-value>127.0.0.1</param-value>
        </init-param>
        <init-param>
            <param-name>deny</param-name>
            <param-value>128.242.127.4</param-value>
        </init-param>
      </servlet>

**判断规则：** deny优先于allow，如果在deny列表中，就算在allow列表中，也会被拒绝。如果allow没有配置或者为空，则允许所有访问。

**注意：** 由于匹配规则不支持IPV6，配置了allow或者deny之后，会导致IPV6无法访问。

**(4) 配置resetEnable**

在StatViewSerlvet输出的html页面中，有一个功能是Reset All，执行这个操作之后，会导致所有计数器清零，重新计数。你可以通过配置参数关闭它。

**5.根据URL自动识别DriverClass**

<table> 
 <thead> 
  <tr> 
   <th>前缀</th> 
   <th align="center">DriverCLass</th> 
   <th align="right">描述信息</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>jdbc:odps</td> 
   <td align="center">com.aliyun.odps.jdbc.OdpsDriver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:derby</td> 
   <td align="center">org.apache.derby.jdbc.EmbeddedDriver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:mysql</td> 
   <td align="center">com.mysql.jdbc.Driver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:oracle</td> 
   <td align="center">oracle.jdbc.driver.OracleDriver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:microsoft</td> 
   <td align="center">com.microsoft.jdbc.sqlserver.SQLServerDriver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:sybase:Tds</td> 
   <td align="center">com.sybase.jdbc2.jdbc.SybDriver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:jtds</td> 
   <td align="center">net.sourceforge.jtds.jdbc.Driver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:postgresql</td> 
   <td align="center">org.postgresql.Driver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:fake</td> 
   <td align="center">com.alibaba.druid.mock.MockDriver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:mock</td> 
   <td align="center">com.alibaba.druid.mock.MockDriver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:hsqldb</td> 
   <td align="center">org.hsqldb.jdbcDriver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:db2</td> 
   <td align="center">COM.ibm.db2.jdbc.app.DB2Driver</td> 
   <td align="right">DB2的JDBC Driver十分混乱，这个匹配不一定对</td> 
  </tr> 
  <tr> 
   <td>jdbc:sqlite</td> 
   <td align="center">org.sqlite.JDBC</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:ingres</td> 
   <td align="center">com.ingres.jdbc.IngresDriver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:h2</td> 
   <td align="center">org.h2.Driver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:mckoi</td> 
   <td align="center">com.mckoi.JDBCDriver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:cloudscape</td> 
   <td align="center">com.cloudscape.core.JDBCDriver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:informix-sqli</td> 
   <td align="center">com.informix.jdbc.IfxDriver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:timesten</td> 
   <td align="center">com.timesten.jdbc.TimesTenDriver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:as400</td> 
   <td align="center">com.ibm.as400.access.AS400JDBCDriver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:sapdb</td> 
   <td align="center">com.sap.dbtech.jdbc.DriverSapDB</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:JSQLConnect</td> 
   <td align="center">com.jnetdirect.jsql.JSQLDriver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:JTurbo</td> 
   <td align="center">com.newatlanta.jturbo.driver.Driver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:firebirdsql</td> 
   <td align="center">org.firebirdsql.jdbc.FBDriver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:interbase</td> 
   <td align="center">interbase.interclient.Driver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:pointbase</td> 
   <td align="center">com.pointbase.jdbc.jdbcUniversalDriver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:edbc</td> 
   <td align="center">ca.edbc.jdbc.EdbcDriver</td> 
   <td align="right"></td> 
  </tr> 
  <tr> 
   <td>jdbc:mimer:multi1</td> 
   <td align="center">com.mimer.jdbc.Driver</td> 
   <td align="right"></td> 
  </tr> 
 </tbody> 
</table>

[https_github.com_alibaba_druid]: https://github.com/alibaba/druid
[http_central.maven.org_maven2_com_alibaba_druid]: http://central.maven.org/maven2/com/alibaba/druid/
[https_github.com_alibaba_druid_wiki]: https://github.com/alibaba/druid/wiki
[http_www.mvnrepository.com_artifact_com.alibaba_druid]: http://www.mvnrepository.com/artifact/com.alibaba/druid
[http_localhost_8080_druid_index.html]: http://localhost:8080/druid/index.html