前言 在基于SpringMVC+MyBatis的开发过程中,我们希望能看到自己手写SQL的执行情况,在开发阶段我们可以配置log4j在控制台里基于debug模式查看,那么上线后,在生产声我们想查看SQL的执行情况呢,这时候就该druid出场了,druid自带 ...
前言
在基于SpringMVC+MyBatis的开发过程中,我们希望能看到自己手写SQL的执行情况,在开发阶段我们可以配置log4j在控制台里基于debug模式查看,那么上线后,在生产声我们想查看SQL的执行情况呢,这时候就该druid出场了,druid自带一些监控界面,可以监控SQL、监控Web、监控URL。
使用druid监控SQL
使用druid监控URI
开发环境
idea2016、SpringMVC4、Mybatis3、druid1.0.28
SSM整合
1、pom.
1 <project ="http://maven.apache.org/POM/4.0.0" ="http://www.w3.org/2001/ 2 xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> 3 <modelVersion>4.0.0</modelVersion> 4 <groupId>com.autohome</groupId> 5 <artifactId>SpringMVC3</artifactId> 6 <packaging>war</packaging> 7 <version>1.0-SNAPSHOT</version> 8 <name>SpringMVC3</name> 9 <url>http://maven.apache.org</url> 10 <dependencies> 11 <dependency> 12 <groupId>junit</groupId> 13 <artifactId>junit</artifactId> 14 <version>4.10</version> 15 </dependency> 16 <dependency> 17 <groupId>org.springframework</groupId> 18 <artifactId>spring-core</artifactId> 19 <version>4.3.6.RELEASE</version> 20 </dependency> 21 <dependency> 22 <groupId>org.springframework</groupId> 23 <artifactId>spring-beans</artifactId> 24 <version>4.3.6.RELEASE</version> 25 </dependency> 26 <dependency> 27 <groupId>org.springframework</groupId> 28 <artifactId>spring-context</artifactId> 29 <version>4.3.6.RELEASE</version> 30 </dependency> 31 <dependency> 32 <groupId>org.springframework</groupId> 33 <artifactId>spring-web</artifactId> 34 <version>4.3.6.RELEASE</version> 35 </dependency> 36 <dependency> 37 <groupId>org.springframework</groupId> 38 <artifactId>spring-context-support</artifactId> 39 <version>4.3.6.RELEASE</version> 40 </dependency> 41 <dependency> 42 <groupId>org.springframework</groupId> 43 <artifactId>spring-webmvc</artifactId> 44 <version>4.3.6.RELEASE</version> 45 </dependency> 46 <dependency> 47 <groupId>org.springframework</groupId> 48 <artifactId>spring-jdbc</artifactId> 49 <version>4.3.6.RELEASE</version> 50 </dependency> 51 <dependency> 52 <groupId>org.apache.velocity</groupId> 53 <artifactId>velocity</artifactId> 54 <version>1.6.2</version> 55 </dependency> 56 <dependency> 57 <groupId>org.apache.velocity</groupId> 58 <artifactId>velocity-tools</artifactId> 59 <version>2.0</version> 60 </dependency> 61 <dependency> 62 <groupId>org.mybatis</groupId> 63 <artifactId>mybatis</artifactId> 64 <version>3.4.2</version> 65 </dependency> 66 <dependency> 67 <groupId>org.mybatis</groupId> 68 <artifactId>mybatis-spring</artifactId> 69 <version>1.3.0</version> 70 </dependency> 71 <dependency> 72 <groupId>com.microsoft.sqlserver</groupId> 73 <artifactId>sqljdbc4</artifactId> 74 <version>4.0</version> 75 </dependency> 76 <dependency> 77 <groupId>commons-dbcp</groupId> 78 <artifactId>commons-dbcp</artifactId> 79 <version>1.4</version> 80 </dependency> 81 <dependency> 82 <groupId>javax.servlet</groupId> 83 <artifactId>javax.servlet-api</artifactId> 84 <version>3.1.0</version> 85 </dependency> 86 <dependency> 87 <groupId>com.alibaba</groupId> 88 <artifactId>druid</artifactId> 89 <version>1.0.28</version> 90 </dependency> 91 <dependency> 92 <groupId>log4j</groupId> 93 <artifactId>log4j</artifactId> 94 <version>1.2.17</version> 95 </dependency> 96 </dependencies> 97 <build> 98 <finalName>SpringMVC3</finalName> 99 </build>100 </project>
原标题:SpringMVC4+MyBatis+SQL Server2014+druid 监控SQL运行情况
关键词:Spring
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。