十一、日志

最新推荐文章于 2024-03-01 16:25:41 发布

飞过秋天

最新推荐文章于 2024-03-01 16:25:41 发布

阅读量167

点赞数 1

分类专栏： MyBatis学习笔记文章标签： mybatis mysql

本文链接：https://blog.csdn.net/qq_35028612/article/details/110380898

版权

MyBatis学习笔记专栏收录该内容

28 篇文章 0 订阅

订阅专栏

本文介绍了如何在MyBatis中配置和使用日志，从简单的STDOUT_LOGGING到更强大的LOG4J。通过设置logImpl属性，可以切换日志实现。STDOUT_LOGGING将日志输出到控制台，而LOG4J则提供了更详细的日志管理和输出目的地，如控制台和文件。示例展示了LOG4J配置文件的内容以及日志输出的效果，包括数据库操作的详细步骤。

摘要由CSDN通过智能技术生成

狂神说Java：https://www.bilibili.com/video/BV1NE411Q7Nx

如果数据库操作出现异常，需要排错。日志就是最好的助手！

曾经：sout、debug。

现在：日志工厂。

1、日志工厂

设置名	描述	有效值	默认值
logImpl	指定 MyBatis 所用日志的具体实现，未指定时将自动查找。	SLF4J \| LOG4J \| LOG4J2 \| JDK_LOGGING \| COMMONS_LOGGING \| STDOUT_LOGGING \| NO_LOGGING	未设置

在Mybatis具体使用哪一个日志实现，在设置中设定！在mybatis核心配置文件中配置！

2、STDOUT_LOGGING

<!--设置-->
<settings>
    <setting name="logImpl" value="STDOUT_LOGGING"/>
</settings>

测试结果：

Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter.
Class not found: org.jboss.vfs.VFS
JBoss 6 VFS API is not available in this environment.
Class not found: org.jboss.vfs.VirtualFile
VFS implementation org.apache.ibatis.io.JBoss6VFS is not valid in this environment.
Using VFS adapter org.apache.ibatis.io.DefaultVFS
Find JAR URL: file:/E:/code/Java/mybatis-study/mybatis-03/target/classes/com/kuang/pojo
Not a JAR: file:/E:/code/Java/mybatis-study/mybatis-03/target/classes/com/kuang/pojo
Reader entry: User.class
Listing file:/E:/code/Java/mybatis-study/mybatis-03/target/classes/com/kuang/pojo
Find JAR URL: file:/E:/code/Java/mybatis-study/mybatis-03/target/classes/com/kuang/pojo/User.class
Not a JAR: file:/E:/code/Java/mybatis-study/mybatis-03/target/classes/com/kuang/pojo/User.class
Reader entry: ����   1 <
Checking to see if class com.kuang.pojo.User matches criteria [is assignable to Object]
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
Opening JDBC Connection
Created connection 1762902523.
Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@6913c1fb]
==>  Preparing: select * from user 
==> Parameters: 
<==    Columns: id, name, pwd
<==        Row: 1, 狂神, 123456
<==        Row: 2, 法外狂徒张三, 333333
<==        Row: 3, 李四, 666666
<==        Row: 5, 李五, 5555555
<==        Row: 666, map传值, mmmmmm
<==        Row: 777, map传值, mmmmmm
<==      Total: 6
User{id=1, name='狂神', password='123456'}
User{id=2, name='法外狂徒张三', password='333333'}
User{id=3, name='李四', password='666666'}
User{id=5, name='李五', password='5555555'}
User{id=666, name='map传值', password='mmmmmm'}
User{id=777, name='map传值', password='mmmmmm'}
Resetting autocommit to true on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@6913c1fb]
Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@6913c1fb]
Returned connection 1762902523 to pool.

Process finished with exit code 0

3、LOG4J

Log4j是Apache的一个开源项目，通过使用Log4j，我们可以控制日志信息输送的目的地是控制台、文件、GUI组件，甚至是套接口服务器、NT的事件记录器、UNIX Syslog守护进程等；我们也可以控制每一条日志的输出格式；通过定义每一条日志信息的级别，我们能够更加细致地控制日志的生成过程。最令人感兴趣的就是，这些可以通过一个配置文件来灵活地进行配置，而不需要修改应用的代码。

依赖

<dependencies>
    <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>1.2.17</version>
    </dependency>
</dependencies>

log4j.properties

#将等级为DEBUG的日志信息输出到console和file这两个目的地，console和file的定义在下面的代码
log4j.rootLogger=DEBUG,console,file

#控制台输出的相关设置
log4j.appender.console = org.apache.log4j.ConsoleAppender
log4j.appender.console.Target = System.out
log4j.appender.console.Threshold=DEBUG
log4j.appender.console.layout = org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=[%c]-%m%n

#文件输出的相关设置
log4j.appender.file = org.apache.log4j.RollingFileAppender
log4j.appender.file.File=./log/kuang.log
log4j.appender.file.MaxFileSize=10mb
log4j.appender.file.Threshold=DEBUG
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=[%p][%d{yy-MM-dd}][%c]%m%n

#日志输出级别
log4j.logger.org.mybatis=DEBUG
log4j.logger.java.sql=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG

mybatis核心配置文件配置log4j实现

<!--设置-->
<settings>
    <setting name="logImpl" value="LOG4J"/>
</settings>

测试使用

控制台

[org.apache.ibatis.logging.LogFactory]-Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
[org.apache.ibatis.logging.LogFactory]-Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
[org.apache.ibatis.io.VFS]-Class not found: org.jboss.vfs.VFS
[org.apache.ibatis.io.JBoss6VFS]-JBoss 6 VFS API is not available in this environment.
[org.apache.ibatis.io.VFS]-Class not found: org.jboss.vfs.VirtualFile
[org.apache.ibatis.io.VFS]-VFS implementation org.apache.ibatis.io.JBoss6VFS is not valid in this environment.
[org.apache.ibatis.io.VFS]-Using VFS adapter org.apache.ibatis.io.DefaultVFS
[org.apache.ibatis.io.DefaultVFS]-Find JAR URL: file:/E:/code/Java/mybatis-study/mybatis-03/target/classes/com/kuang/pojo
[org.apache.ibatis.io.DefaultVFS]-Not a JAR: file:/E:/code/Java/mybatis-study/mybatis-03/target/classes/com/kuang/pojo
[org.apache.ibatis.io.DefaultVFS]-Reader entry: User.class
[org.apache.ibatis.io.DefaultVFS]-Listing file:/E:/code/Java/mybatis-study/mybatis-03/target/classes/com/kuang/pojo
[org.apache.ibatis.io.DefaultVFS]-Find JAR URL: file:/E:/code/Java/mybatis-study/mybatis-03/target/classes/com/kuang/pojo/User.class
[org.apache.ibatis.io.DefaultVFS]-Not a JAR: file:/E:/code/Java/mybatis-study/mybatis-03/target/classes/com/kuang/pojo/User.class
[org.apache.ibatis.io.DefaultVFS]-Reader entry: ����   1 <
[org.apache.ibatis.io.ResolverUtil]-Checking to see if class com.kuang.pojo.User matches criteria [is assignable to Object]
[org.apache.ibatis.datasource.pooled.PooledDataSource]-PooledDataSource forcefully closed/removed all connections.
[org.apache.ibatis.datasource.pooled.PooledDataSource]-PooledDataSource forcefully closed/removed all connections.
[org.apache.ibatis.datasource.pooled.PooledDataSource]-PooledDataSource forcefully closed/removed all connections.
[org.apache.ibatis.datasource.pooled.PooledDataSource]-PooledDataSource forcefully closed/removed all connections.
[org.apache.ibatis.transaction.jdbc.JdbcTransaction]-Opening JDBC Connection
[org.apache.ibatis.datasource.pooled.PooledDataSource]-Created connection 195381554.
[org.apache.ibatis.transaction.jdbc.JdbcTransaction]-Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@ba54932]
[com.kuang.dao.UserMapper.getUserList]-==>  Preparing: select * from user 
[com.kuang.dao.UserMapper.getUserList]-==> Parameters: 
[com.kuang.dao.UserMapper.getUserList]-<==      Total: 6
User{id=1, name='狂神', password='123456'}
User{id=2, name='法外狂徒张三', password='333333'}
User{id=3, name='李四', password='666666'}
User{id=5, name='李五', password='5555555'}
User{id=666, name='map传值', password='mmmmmm'}
User{id=777, name='map传值', password='mmmmmm'}
[org.apache.ibatis.transaction.jdbc.JdbcTransaction]-Resetting autocommit to true on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@ba54932]
[org.apache.ibatis.transaction.jdbc.JdbcTransaction]-Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@ba54932]
[org.apache.ibatis.datasource.pooled.PooledDataSource]-Returned connection 195381554 to pool.

Process finished with exit code 0

文件

/log/kuang.log

[DEBUG][20-11-26][org.apache.ibatis.logging.LogFactory]Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
[DEBUG][20-11-26][org.apache.ibatis.logging.LogFactory]Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
[DEBUG][20-11-26][org.apache.ibatis.io.VFS]Class not found: org.jboss.vfs.VFS
[DEBUG][20-11-26][org.apache.ibatis.io.JBoss6VFS]JBoss 6 VFS API is not available in this environment.
[DEBUG][20-11-26][org.apache.ibatis.io.VFS]Class not found: org.jboss.vfs.VirtualFile
[DEBUG][20-11-26][org.apache.ibatis.io.VFS]VFS implementation org.apache.ibatis.io.JBoss6VFS is not valid in this environment.
[DEBUG][20-11-26][org.apache.ibatis.io.VFS]Using VFS adapter org.apache.ibatis.io.DefaultVFS
[DEBUG][20-11-26][org.apache.ibatis.io.DefaultVFS]Find JAR URL: file:/E:/code/Java/mybatis-study/mybatis-03/target/classes/com/kuang/pojo
[DEBUG][20-11-26][org.apache.ibatis.io.DefaultVFS]Not a JAR: file:/E:/code/Java/mybatis-study/mybatis-03/target/classes/com/kuang/pojo
[DEBUG][20-11-26][org.apache.ibatis.io.DefaultVFS]Reader entry: User.class
[DEBUG][20-11-26][org.apache.ibatis.io.DefaultVFS]Listing file:/E:/code/Java/mybatis-study/mybatis-03/target/classes/com/kuang/pojo
[DEBUG][20-11-26][org.apache.ibatis.io.DefaultVFS]Find JAR URL: file:/E:/code/Java/mybatis-study/mybatis-03/target/classes/com/kuang/pojo/User.class
[DEBUG][20-11-26][org.apache.ibatis.io.DefaultVFS]Not a JAR: file:/E:/code/Java/mybatis-study/mybatis-03/target/classes/com/kuang/pojo/User.class
[DEBUG][20-11-26][org.apache.ibatis.io.DefaultVFS]Reader entry: ����   1 <
[DEBUG][20-11-26][org.apache.ibatis.io.ResolverUtil]Checking to see if class com.kuang.pojo.User matches criteria [is assignable to Object]
[DEBUG][20-11-26][org.apache.ibatis.datasource.pooled.PooledDataSource]PooledDataSource forcefully closed/removed all connections.
[DEBUG][20-11-26][org.apache.ibatis.datasource.pooled.PooledDataSource]PooledDataSource forcefully closed/removed all connections.
[DEBUG][20-11-26][org.apache.ibatis.datasource.pooled.PooledDataSource]PooledDataSource forcefully closed/removed all connections.
[DEBUG][20-11-26][org.apache.ibatis.datasource.pooled.PooledDataSource]PooledDataSource forcefully closed/removed all connections.
[DEBUG][20-11-26][org.apache.ibatis.transaction.jdbc.JdbcTransaction]Opening JDBC Connection
[DEBUG][20-11-26][org.apache.ibatis.datasource.pooled.PooledDataSource]Created connection 195381554.
[DEBUG][20-11-26][org.apache.ibatis.transaction.jdbc.JdbcTransaction]Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@ba54932]
[DEBUG][20-11-26][com.kuang.dao.UserMapper.getUserList]==>  Preparing: select * from user 
[DEBUG][20-11-26][com.kuang.dao.UserMapper.getUserList]==> Parameters: 
[DEBUG][20-11-26][com.kuang.dao.UserMapper.getUserList]<==      Total: 6
[DEBUG][20-11-26][org.apache.ibatis.transaction.jdbc.JdbcTransaction]Resetting autocommit to true on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@ba54932]
[DEBUG][20-11-26][org.apache.ibatis.transaction.jdbc.JdbcTransaction]Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@ba54932]
[DEBUG][20-11-26][org.apache.ibatis.datasource.pooled.PooledDataSource]Returned connection 195381554 to pool.

简单使用

在要使用的类中导入包

import org.apache.log4j.Logger;

日志对象，参数为当前类的class。

static Logger logger = Logger.getLogger(UserMapperTest.class);

测试

@Test
public void testLog4J(){

    logger.info("info：进入testLog4J");
    logger.debug("debug：进入testLog4J");
    logger.error("error：进入testLog4J");

}

结果

[com.kuang.dao.UserMapperTest]-info：进入testLog4J
[com.kuang.dao.UserMapperTest]-debug：进入testLog4J
[com.kuang.dao.UserMapperTest]-error：进入testLog4J

Process finished with exit code 0

飞过秋天

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
1
评论
十一、日志

狂神说Java：https://www.bilibili.com/video/BV1NE411Q7Nx如果数据库操作出现异常，需要排错。日志就是最好的助手！曾经：sout、debug。现在：日志工厂。1、日志工厂设置名描述有效值默认值logImpl指定 MyBatis 所用日志的具体实现，未指定时将自动查找。SLF4J | LOG4J | LOG4J2 | JDK_LOGGING | COMMONS_LOGGING | STDOUT_LOGGING | NO_LOG.
复制链接

扫一扫

专栏目录