你的位置:首页 > 软件开发 > Java > SpringMVC4+MyBatis+SQL Server2014+druid 监控SQL运行情况

SpringMVC4+MyBatis+SQL Server2014+druid 监控SQL运行情况

发布时间:2017-03-22 00:01:07
前言 在基于SpringMVC+MyBatis的开发过程中,我们希望能看到自己手写SQL的执行情况,在开发阶段我们可以配置log4j在控制台里基于debug模式查看,那么上线后,在生产声我们想查看SQL的执行情况呢,这时候就该druid出场了,druid自带 ...

SpringMVC4+MyBatis+SQL Server2014+druid 监控SQL运行情况

前言

      在基于SpringMVC+MyBatis的开发过程中,我们希望能看到自己手写SQL的执行情况,在开发阶段我们可以配置log4j在控制台里基于debug模式查看,那么上线后,在生产声我们想查看SQL的执行情况呢,这时候就该druid出场了,druid自带一些监控界面,可以监控SQL、监控Web、监控URL。 

 

使用druid监控SQL

SpringMVC4+MyBatis+SQL Server2014+druid 监控SQL运行情况

SpringMVC4+MyBatis+SQL Server2014+druid 监控SQL运行情况

使用druid监控URI

SpringMVC4+MyBatis+SQL Server2014+druid 监控SQL运行情况

 

开发环境

   idea2016、SpringMVC4、Mybatis3、druid1.0.28

 

SSM整合

1、pom.SpringMVC4+MyBatis+SQL Server2014+druid 监控SQL运行情况SpringMVC4+MyBatis+SQL Server2014+druid 监控SQL运行情况

 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 (#换成@)。

可能感兴趣文章

我的浏览记录