/mybatis-spring

MyBatis整合Spring并使用log4jdbc或者p6spy输出真实的sql语句

Primary LanguageJava

#Spring整合MyBatis

####在控制台记录真实的sql语句

####使用log4jdbc的配置

######1、添加log4jdbc的jar

<dependency>
		<groupId>log4jdbc</groupId>
		<artifactId>log4jdbc4</artifactId>
		<version>1.2</version>
</dependency>
<dependency>
		<groupId>log4jdbc</groupId>
		<artifactId>log4jdbc4</artifactId>
		<version>1.2</version>
</dependency>
<dependency>
		<groupId>org.slf4j</groupId>
		<artifactId>slf4j-api</artifactId>
		<version>1.6.6</version>
</dependency>
<dependency>
		<groupId>org.slf4j</groupId>
		<artifactId>slf4j-log4j12</artifactId>
		<version>1.6.6</version>
</dependency>
<dependency>
		<groupId>org.slf4j</groupId>
		<artifactId>slf4j-jdk14</artifactId>
		<version>1.5.8</version>
</dependency>

######2、参考src/main/resources/log4j.properties配置文件

######3、修改jdbc的driver和jdbc url（参考src/main/resources/applicationContext.xml）

<property name="driverClassName" value="net.sf.log4jdbc.DriverSpy"></property>
<property name="url" value="jdbc:log4jdbc:mysql://localhost:3306/mybatis"></property>

####使用p6spy的配置

######1、添加p6spy的jar

<dependency>
	<groupId>p6spy</groupId>
	<artifactId>p6spy</artifactId>
	<version>1.3</version>
</dependency>

######2、参考src/main/resources/spy.properties

######3、添加配置文件信息

<property name="driverClassName" value="com.p6spy.engine.spy.P6SpyDriver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/mybatis"></property>