1、maven 项目的 pom.xml,引入依赖p6spy3.0
<!-- https://mvnrepository.com/artifact/p6spy/p6spy --> <dependency> <groupId>p6spy</groupId> <artifactId>p6spy</artifactId> <version>3.0.0</version> </dependency>
2、在spring的配置文件如spring.xml中,将原有的数据源定义包裹一层,将dataSource改dataSourceTarget,再创建一个dataSource,class为com.p6spy.engine.spy.P6DataSource,详情如下:
原:
<!--数据源定义--> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="com.mysql.jdbc.Driver"></property> <property name="url" value="jdbc:mysql://IP:3306/datadeal?useUnicode=true&characterEncoding=utf8"></property> <property name="username" value="ruank"></property> <property name="password" value="ruank_123"></property> <!-- 连接池启动时的初始值 --> <property name="initialSize" value="10" /> <!-- 连接池的最大值 --> <property name="maxActive" value="30" /> <!-- 最大空闲值. --> <property name="maxIdle" value="20" /> <!-- 最小空闲值.当空闲的连接数少于阀值时,连接池就会预申请去一些连接,以免洪峰来时来不及申请 --> <property name="minIdle" value="10" /> </bean>修改后:
<!--数据源定义--> <bean id="dataSourceTarget" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="com.mysql.jdbc.Driver"></property> <property name="url" value="jdbc:mysql://IP:3306/datadeal?useUnicode=true&characterEncoding=utf8"></property> <property name="username" value="ruank"></property>