Druid监控Mybatis不显示SQL问题

﹏ヽ暗。殇╰゛Y 2022-09-25 12:17 226阅读 0赞

一、Web.xml增加如下配置：  
1、DruidWebStatFilter。如果没有配置filter信息。session监控，web监控等不可用。没有配置

Xml代码   ![收藏代码][icon_star.png]

1.  <filter>  
2.          <filter-name>DruidWebStatFilter</filter-name>  
3.          <filter-class>com.alibaba.druid.support.http.WebStatFilter</filter-class>  
4.          <init-param>  
5.              <param-name>exclusions</param-name>  
6.              <param-value>/static/\*,\*.js,\*.gif,\*.jpg,\*.png,\*.css,\*.ico,/druid/\*</param-value>  
7.          </init-param>  
8.      </filter>  
9.      <filter-mapping>  
10.         <filter-name>DruidWebStatFilter</filter-name>  
11.         <url-pattern>/\*</url-pattern>  
12.     </filter-mapping>

2、DruidStatView。如果没有servlet，无法通过web页面查看监控数据。

Java代码   ![收藏代码][icon_star.png]

1.  <servlet>  
2.          <servlet-name>DruidStatView</servlet-name>  
3.          <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>  
4.      </servlet>  
5.      <servlet-mapping>  
6.          <servlet-name>DruidStatView</servlet-name>  
7.          <url-pattern>/druid/\*</url-pattern>  
8.      </servlet-mapping>

二、在Spring中声明Druid数据源，

Java代码   ![收藏代码][icon_star.png]

1.  <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"  
2.          init-method="init" destroy-method="close">  
3.          <property name="driverClassName" value="$\{jdbc.driverClassName\}" />  
4.          <property name="url" value="$\{jdbc.url\}" />  
5.          <property name="username" value="$\{jdbc.username\}" />  
6.          <property name="password" value="$\{jdbc.password\}" />  
7.          <property name="maxActive" value="$\{db.maxActive\}" />  
8.          <property name="initialSize" value="$\{db.initialSize\}" />  
9.          <property name="maxWait" value="$\{db.maxWait\}" />  
10.         <property name="minIdle" value="$\{db.minIdle\}" />  
11.         <property name="timeBetweenEvictionRunsMillis" value="$\{db.timeBetweenEvictionRunsMillis\}" />  
12.         <property name="minEvictableIdleTimeMillis" value="$\{db.minEvictableIdleTimeMillis\}" />  
13.         <property name="testWhileIdle" value="$\{db.testWhileIdle\}" />  
14.         <property name="testOnBorrow" value="$\{db.testOnBorrow\}" />  
15.         <property name="testOnReturn" value="$\{db.testOnReturn\}" />  
16.         <property name="poolPreparedStatements" value="$\{db.poolPreparedStatements\}" />  
17.         <property name="maxPoolPreparedStatementPerConnectionSize" value="$\{db.maxPoolPreparedStatementPerConnectionSize\}" />  
18.         <property name="filters" value="stat" />  
19.     </bean>

注意： **<property name="filters" value="stat" />**属性，不然无法显示SQL检测信息。

[icon_star.png]: /images/20220717/7eab9df90b5042f0affd5dc0badba0fe.png