druid数据源-监控

基于阿里巴巴的数据库连接池druid的中间件，我们们可以通过配置druid的数据监控配置，实现对sql数据操作的监控

引人spring-mybatis.xml的配置

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tx="http://www.springframework.org/schema/tx"
	   xmlns:aop="http://www.springframework.org/schema/aop"
	   xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/tx
       http://www.springframework.org/schema/tx/spring-tx.xsd
       http://www.springframework.org/schema/aop
       http://www.springframework.org/schema/aop/spring-aop.xsd">
	<!-- 配置数据源 -->
	<bean name="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
		  init-method="init" destroy-method="close">

		<property name="url" value="${jdbc_url}" />
		<property name="username" value="${jdbc_username}" />
		<property name="password" value="${jdbc_password}" />
		<property name="filters" value="stat" />
		<property name="maxActive" value="300" />
		<property name="initialSize" value="10" />
		<property name="maxWait" value="30000" />
		<property name="minIdle" value="10" />
		<property name="timeBetweenEvictionRunsMillis" value="3000" />
		<property name="minEvictableIdleTimeMillis" value="300000" />
		<property name="testWhileIdle" value="true" />
		<property name="testOnBorrow" value="false" />
		<property name="testOnReturn" value="false" />
		<property name="poolPreparedStatements" value="true" />
		<property name="maxOpenPreparedStatements" value="20" />
	</bean>
	<!--查看日志 所有Statement发生异常的日志 -->
	<bean id="log-filter" class="com.alibaba.druid.filter.logging.Log4jFilter">
		<property name="resultSetLogEnabled" value="false" />
		<property name="statementExecutableSqlLogEnable" value="true" />
	</bean>
	<!-- Spring整合Mybatis -->
	<bean id="sqlSessionFactory"
		  class="com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<property name="mapperLocations" value="classpath*:mapper/*.xml" />
		<property name="configLocation"
				  value="classpath:/mybatis-starter-conf/mybatis-starter-config.xml" />
		<property name="typeAliasesPackage" value="com.wangyong.**.entity" />
		<property name="plugins">
			<array>
				<!-- 分页插件配置 -->
				<bean id="paginationInterceptor"
					  class="com.baomidou.mybatisplus.plugins.PaginationInterceptor" />
				<!-- 乐观锁插件
				<bean id="optimisticLockerInterceptor"
					class="com.baomidou.mybatisplus.plugins.OptimisticLockerInterceptor" />-->
				<!-- 性能拦截器，兼打印sql，不建议生产环境配置-->
				<bean id="performanceInterceptor"
					class="com.baomidou.mybatisplus.plugins.PerformanceInterceptor" />
			</array>
		</property>
		<!-- 全局配置注入 -->
		<property name="globalConfig" ref="globalConfig" />
	</bean>
	<bean id="globalConfig" class="com.baomidou.mybatisplus.entity.GlobalConfiguration">
		<property name="idType" value="1" />
	</bean>

	<!-- MyBatis 动态扫描 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.wangyong.*.mapper" />
	</bean>

	<!-- 配置事务管理 -->
	<bean name="transactionManager"
		  class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource" />
	</bean>

	<!-- 声明式事务管理 -->
	<tx:advice id="transactionAdvice" transaction-manager="transactionManager">
		<tx:attributes>
			<tx:method name="add*" propagation="REQUIRED" rollback-for="Exception"/>
			<tx:method name="save*" propagation="REQUIRED" rollback-for="Exception"/>
			<tx:method name="update*" propagation="REQUIRED" rollback-for="Exception"/>
			<tx:method name="modify*" propagation="REQUIRED" rollback-for="Exception"/>
			<tx:method name="edit*" propagation="REQUIRED" rollback-for="Exception"/>
			<tx:method name="insert*" propagation="REQUIRED" rollback-for="Exception"/>
			<tx:method name="delete*" propagation="REQUIRED" rollback-for="Exception"/>
			<tx:method name="del*" propagation="REQUIRED" rollback-for="Exception"/>
			<tx:method name="remove*" propagation="REQUIRED" rollback-for="Exception" />
		</tx:attributes>
	</tx:advice>

	<!-- 配置切面 -->
	<aop:config>
		<aop:pointcut id="transactionPointcut" expression="execution(* com.wangyong.*.dservice.*.*(..))" />
		<aop:advisor pointcut-ref="transactionPointcut" advice-ref="transactionAdvice" />
	</aop:config>

	<!-- 注解式事务管理 ，使用@Transactional后方法命名可以随便 -->
	<tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true" />
	<bean id="druid-stat-interceptor"
		  class="com.alibaba.druid.support.spring.stat.DruidStatInterceptor">
	</bean>

	<!--阿里巴巴数据操作监控 配置start-->
	<bean id="druid-stat-pointcut" class="org.springframework.aop.support.JdkRegexpMethodPointcut"
		  scope="prototype">
		<property name="patterns">
			<list>
				<!--//代表拦截分析com.wlt下面的所有方法-->
				<value>com.wlt.*</value>
			</list>
		</property>
	</bean>
	<aop:config>
		<aop:advisor advice-ref="druid-stat-interceptor" pointcut-ref="druid-stat-pointcut"/>
	</aop:config>
	<!--阿里巴巴数据操作监控 配置end-->
</beans>

配置web.xml配置

<!-- Spring MVC -->
	<servlet>
		<servlet-name>SpringMVC<rvlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet<rvlet-class>
		<init-param>
			<description>SpringMVC</description>
			<param-name>contextConfigLocation</param-name>
			<param-value></param-value>
			<!-- param-value>classpath:spring-starter-conf/spring-mvc.xml</param-value-->
		</init-param>
		<load-on-startup>1</load-on-startup>
	<rvlet>
	<servlet-mapping>
		<servlet-name>SpringMVC<rvlet-name>
		<url-pattern>/</url-pattern>
	<rvlet-mapping>

	<servlet>
		<servlet-name>DruidStatView<rvlet-name>
		<servlet-class>com.alibaba.druid.support.http.StatViewServlet<rvlet-class>
		<init-param>
			<!-- 用户名 -->
			<param-name>loginUsername</param-name>
			<param-value>druid</param-value>
		</init-param>
		<init-param>
			<!-- 密码 -->
			<param-name>loginPassword</param-name>
			<param-value>dream</param-value>
		</init-param>
	<rvlet>
	<servlet-mapping>
		<servlet-name>DruidStatView<rvlet-name>
		<url-pattern>/druid/*</url-pattern>
	<rvlet-mapping>

	<filter>

		<filter-name>DruidWebStatFilter</filter-name>

		<filter-class>com.alibaba.druid.support.http.WebStatFilter</filter-class>

		<init-param>

			<param-name>exclusions</param-name>

			<param-value>*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*</param-value>

		</init-param>

	</filter>

	<filter-mapping>

		<filter-name>DruidWebStatFilter</filter-name>

		<url-pattern>/*</url-pattern>

	</filter-mapping>

启动你的项目，确保项目已经起来了，这个时候访问：http://ip:port/applicationname/druid/,其中ip,port,applicationname根据项目做更改，druid是固定写法。

druid-monitor的登陆账号以及名称为配置web.xml的账号与密码