1.引入所需jar包
druid-1.0.15.jar
2.配置数据源,在spring配置文件中声明DruidDataSourceBean
<bean id="jdbcSourceUsmart" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
<property name="url" value="jdbc:mysql://10.47.202.105:3307/usmart" />
<property name="username" value="root" />
<property name="password" value="db10$ZTE" />
<property name="maxActive" value="20" />
<property name="initialSize" value="1" />
<property name="maxWait" value="60000" />
<property name="minIdle" value="1" />
<property name="timeBetweenEvictionRunsMillis" value="3000" />
<property name="minEvictableIdleTimeMillis" value="300000" />
<property name="validationQuery" value="SELECT 'x' FROM DUAL" />
<property name="testWhileIdle" value="true" />
<property name="testOnBorrow" value="false" />
<property name="testOnReturn" value="false" />
<property name="filters" value="stat" /> //使用内置监控页面,需要配置拦截器
</bean>
3.如果要使用监控功能,则需要在web.xml中配置servlet拦截druid相关请求
<servlet>
<servlet-name>druidServlet</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>admin</param-value>
</init-param>
<init-param>
<!-- 密码 -->
<param-name>loginPassword</param-name>
<param-value>zte@1234</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>druidServlet</servlet-name>
<url-pattern>/druid/*</url-pattern>
</servlet-mapping>
druid-1.0.15.jar
2.配置数据源,在spring配置文件中声明DruidDataSourceBean
<bean id="jdbcSourceUsmart" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
<property name="url" value="jdbc:mysql://10.47.202.105:3307/usmart" />
<property name="username" value="root" />
<property name="password" value="db10$ZTE" />
<property name="maxActive" value="20" />
<property name="initialSize" value="1" />
<property name="maxWait" value="60000" />
<property name="minIdle" value="1" />
<property name="timeBetweenEvictionRunsMillis" value="3000" />
<property name="minEvictableIdleTimeMillis" value="300000" />
<property name="validationQuery" value="SELECT 'x' FROM DUAL" />
<property name="testWhileIdle" value="true" />
<property name="testOnBorrow" value="false" />
<property name="testOnReturn" value="false" />
<property name="filters" value="stat" /> //使用内置监控页面,需要配置拦截器
</bean>
3.如果要使用监控功能,则需要在web.xml中配置servlet拦截druid相关请求
<servlet>
<servlet-name>druidServlet</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>admin</param-value>
</init-param>
<init-param>
<!-- 密码 -->
<param-name>loginPassword</param-name>
<param-value>zte@1234</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>druidServlet</servlet-name>
<url-pattern>/druid/*</url-pattern>
</servlet-mapping>