log4j的Maven配置和输出SQL语句

最新推荐文章于 2021-02-12 08:49:18 发布

子厚_

最新推荐文章于 2021-02-12 08:49:18 发布

阅读量667

点赞数 1

CC 4.0 BY-SA版权

分类专栏：工具配置

本文链接：https://blog.youkuaiyun.com/yxw908186797/article/details/92066528

工具配置专栏收录该内容

19 篇文章

订阅专栏

本文介绍了如何在Maven项目中配置log4j，通过修改POM文件、log4j.properties及MyBatis的配置文件，实现SQL执行信息在控制台的显示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、配置POM文件

<!--log4j2配置 -->
		<!--日志 start -->
		<dependency>
			<groupId>log4j</groupId>
			<artifactId>log4j</artifactId>
			<version>1.2.17</version>
		</dependency>
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-api</artifactId>
			<version>1.7.25</version>
		</dependency>
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-log4j12</artifactId>
			<version>1.7.25</version>
			<scope>test</scope>
		</dependency>
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-simple</artifactId>
			<version>1.7.25</version>
			<scope>test</scope>
		</dependency>
		<!--日志end -->

2、配置log4j.properties文件

将下面的代码复制进去

# MyBatis logging configuration...
log4j.logger.com.dao=DEBUG
log4j.logger.com.mybatis=DEBUG  
log4j.logger.com.mybatis.common.jdbc.SimpleDataSource=DEBUG  
log4j.logger.com.mybatis.common.jdbc.ScriptRunner=DEBUG  
log4j.logger.com.mybatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG  
log4j.logger.java.sql.Connection=DEBUG  
log4j.logger.java.sql.Statement=DEBUG  
log4j.logger.java.sql.PreparedStatement=DEBUG</strong>

3、MyBatis的配置文件

在settings中加入

		<setting name="logImpl" value="STDOUT_LOGGING" />

如下

<configuration>
	<settings>
		<setting name="mapUnderscoreToCamelCase" value="true" />
		<setting name="logImpl" value="STDOUT_LOGGING" />
	</settings>
	..................略
</configuration>

然后就能在控制台看到SQL执行信息了。

Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@59818d0c] was not registered for synchronization because synchronization is not active
JDBC Connection [1464236108, URL=jdbc:mysql://localhost:3306/second_classroom?characterEncoding=utf8&useSSL=true, UserName=root@localhost, MySQL Connector Java] will not be managed by Spring
==>  Preparing: SELECT `course`.`course_id`, `course`.`course_name`, `course`.`teacher_id`, `course`.`describe`, `course`.`teacher_name` FROM `second_classroom`.`course` WHERE course_name like concat(?,'%') AND state = 1; 
==> Parameters: 晓伟(String)
<==    Columns: course_id, course_name, teacher_id, describe, teacher_name
<==        Row: 31619113171013, 晓伟的课, 3161911317, <<BLOB>>, pitt
<==      Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@59818d0c]