MyBatis的日志工廠 | MyBatis系列
前言
在實(shí)際開發(fā)中，項(xiàng)目上線之后，如果發(fā)生問題，我們定位問題不可能一直去看控制臺(tái)日志（即nohup文件），正確的做法當(dāng)然是看日志啦！
logImpl 指定 MyBatis 所用日志的具體實(shí)現(xiàn)，未指定時(shí)將自動(dòng)查找。 SLF4J | LOG4J | LOG4J2 | JDK_LOGGING | COMMONS_LOGGING | STDOUT_LOGGING | NO_LOGGING 未設(shè)置 MyBatis支持多種日志工廠：
SLF4J
LOG4J 【重點(diǎn)】
LOG4J2
JDK_LOGGING
COMMONS_LOGGING
STDOUT_LOGGING 【重點(diǎn)】
NO_LOGGING
在這里只介紹
LOG4J和STDOUT_LOGGING其他的工作中用的少，有興趣的同學(xué)可以自行研究一下！
一、STDOUT_LOGGING 日志
這個(gè)比較簡單，無需引入jar包啥的，內(nèi)置的日志工廠！
我們先看下，不加日志工廠的話控制臺(tái)會(huì)輸出哪些內(nèi)容：
位置不要放錯(cuò)哦~ 還記得上一篇的位置吧，哈哈
具體代碼如下：
<settings>
<setting name="logImpl" value="STDOUT_LOGGING"/>
</settings>
復(fù)制代碼再次運(yùn)行結(jié)果如下：
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:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/pojo
Not a JAR: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/pojo
Reader entry: User.class
Listing file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/pojo
Find JAR URL: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/pojo/User.class
Not a JAR: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/pojo/User.class
Reader entry: ???? 4 m
Checking to see if class com.dy.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.
Find JAR URL: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/mapper
Not a JAR: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/mapper
Reader entry: UserMapper.class
Reader entry: UserMapper.xml
Listing file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/mapper
Find JAR URL: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/mapper/UserMapper.class
Not a JAR: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/mapper/UserMapper.class
Reader entry: ???? 4
Find JAR URL: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/mapper/UserMapper.xml
Not a JAR: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/mapper/UserMapper.xml
Reader entry: <?xml version="1.0" encoding="UTF-8" ?>
Checking to see if class com.dy.mapper.UserMapper matches criteria [is assignable to Object]
Opening JDBC Connection
Created connection 1159114532.
Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@4516af24]
==> Preparing: select * from user
==> Parameters:
<== Columns: id, name, age, like
<== Row: 30, 丁大大, 23, 釣魚
<== Row: 31, 面條, 22, 王者榮耀
<== Row: 32, 面條, 50, 王者榮耀
<== Total: 3
User(id=30, name=丁大大, age=23, like=釣魚)
User(id=31, name=面條, age=22, like=王者榮耀)
User(id=32, name=面條, age=50, like=王者榮耀)
Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@4516af24]
Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@4516af24]
Returned connection 1159114532 to pool.
Process finished with exit code 0
復(fù)制代碼主要看以下內(nèi)容：
Opening JDBC Connection //打開一個(gè)JDBC鏈接
Created connection 1159114532. //創(chuàng)建鏈接
Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@4516af24]
//在JDBC Connection上將自動(dòng)提交設(shè)置為false
==> Preparing: select * from user //查詢語句
==> Parameters: //查詢參數(shù)
<== Columns: id, name, age, like
//下面是結(jié)果
<== Row: 30, 丁大大, 23, 釣魚
<== Row: 31, 面條, 22, 王者榮耀
<== Row: 32, 面條, 50, 王者榮耀
<== Total: 3
復(fù)制代碼現(xiàn)在我們練習(xí)的項(xiàng)目很小，sql啥的比較少，出問題很容易找到。
但是在實(shí)際開發(fā)過程中，項(xiàng)目大，sql多，不看日志定位問題的話比較耗時(shí)耗力！
所以推薦大家從一開始就要養(yǎng)成配置日志工廠的習(xí)慣！這對(duì)我們定位問題有很大的幫助！！！
二、LOG4J 日志
①、MyBatis中使用
什么是Log4j？
有問題不懂找百度 百度百科
Log4j是Apache的一個(gè)開源項(xiàng)目，通過使用Log4j，我們可以控制日志信息輸送的目的地是控制臺(tái)、文件、GUI組件
我們也可以控制每一條日志的輸出格式
通過定義每一條日志信息的級(jí)別，我們能夠更加細(xì)致地控制日志的生成過程
通過一個(gè)配置文件來靈活地進(jìn)行配置，而不需要修改應(yīng)用的代碼。
這個(gè)就不是內(nèi)置的日志了，先導(dǎo)包：
<!-- https://mvnrepository.com/artifact/log4j/log4j -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
復(fù)制代碼更改核心配置文件
<settings>
<setting name="logImpl" value="LOG4J"/>
</settings>
復(fù)制代碼新增log4j.properties配置文件
首頁可以發(fā)現(xiàn)，我們的項(xiàng)目中出現(xiàn)了一個(gè)新的目錄：
log,目錄下的就是我們的日志文件dayu.log
打開瞅瞅里面是啥？
[DEBUG][21-07-08][org.apache.ibatis.logging.LogFactory]Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
[DEBUG][21-07-08][org.apache.ibatis.logging.LogFactory]Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
[DEBUG][21-07-08][org.apache.ibatis.io.VFS]Class not found: org.jboss.vfs.VFS
[DEBUG][21-07-08][org.apache.ibatis.io.JBoss6VFS]JBoss 6 VFS API is not available in this environment.
[DEBUG][21-07-08][org.apache.ibatis.io.VFS]Class not found: org.jboss.vfs.VirtualFile
[DEBUG][21-07-08][org.apache.ibatis.io.VFS]VFS implementation org.apache.ibatis.io.JBoss6VFS is not valid in this environment.
[DEBUG][21-07-08][org.apache.ibatis.io.VFS]Using VFS adapter org.apache.ibatis.io.DefaultVFS
[DEBUG][21-07-08][org.apache.ibatis.io.DefaultVFS]Find JAR URL: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/pojo
[DEBUG][21-07-08][org.apache.ibatis.io.DefaultVFS]Not a JAR: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/pojo
[DEBUG][21-07-08][org.apache.ibatis.io.DefaultVFS]Reader entry: User.class
[DEBUG][21-07-08][org.apache.ibatis.io.DefaultVFS]Listing file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/pojo
[DEBUG][21-07-08][org.apache.ibatis.io.DefaultVFS]Find JAR URL: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/pojo/User.class
[DEBUG][21-07-08][org.apache.ibatis.io.DefaultVFS]Not a JAR: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/pojo/User.class
[DEBUG][21-07-08][org.apache.ibatis.io.DefaultVFS]Reader entry: ???? 4 m
[DEBUG][21-07-08][org.apache.ibatis.io.ResolverUtil]Checking to see if class com.dy.pojo.User matches criteria [is assignable to Object]
[DEBUG][21-07-08][org.apache.ibatis.datasource.pooled.PooledDataSource]PooledDataSource forcefully closed/removed all connections.
[DEBUG][21-07-08][org.apache.ibatis.datasource.pooled.PooledDataSource]PooledDataSource forcefully closed/removed all connections.
[DEBUG][21-07-08][org.apache.ibatis.datasource.pooled.PooledDataSource]PooledDataSource forcefully closed/removed all connections.
[DEBUG][21-07-08][org.apache.ibatis.datasource.pooled.PooledDataSource]PooledDataSource forcefully closed/removed all connections.
[DEBUG][21-07-08][org.apache.ibatis.io.DefaultVFS]Find JAR URL: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/mapper
[DEBUG][21-07-08][org.apache.ibatis.io.DefaultVFS]Not a JAR: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/mapper
[DEBUG][21-07-08][org.apache.ibatis.io.DefaultVFS]Reader entry: UserMapper.class
[DEBUG][21-07-08][org.apache.ibatis.io.DefaultVFS]Reader entry: UserMapper.xml
[DEBUG][21-07-08][org.apache.ibatis.io.DefaultVFS]Listing file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/mapper
[DEBUG][21-07-08][org.apache.ibatis.io.DefaultVFS]Find JAR URL: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/mapper/UserMapper.class
[DEBUG][21-07-08][org.apache.ibatis.io.DefaultVFS]Not a JAR: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/mapper/UserMapper.class
[DEBUG][21-07-08][org.apache.ibatis.io.DefaultVFS]Reader entry: ???? 4
[DEBUG][21-07-08][org.apache.ibatis.io.DefaultVFS]Find JAR URL: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/mapper/UserMapper.xml
[DEBUG][21-07-08][org.apache.ibatis.io.DefaultVFS]Not a JAR: file:/D:/workSpace/dyj-MyBatis-Project/MyBatis-01-properties/target/classes/com/dy/mapper/UserMapper.xml
[DEBUG][21-07-08][org.apache.ibatis.io.DefaultVFS]Reader entry: <?xml version="1.0" encoding="UTF-8" ?>
[DEBUG][21-07-08][org.apache.ibatis.io.ResolverUtil]Checking to see if class com.dy.mapper.UserMapper matches criteria [is assignable to Object]
[DEBUG][21-07-08][org.apache.ibatis.transaction.jdbc.JdbcTransaction]Opening JDBC Connection
[DEBUG][21-07-08][org.apache.ibatis.datasource.pooled.PooledDataSource]Created connection 624271064.
[DEBUG][21-07-08][org.apache.ibatis.transaction.jdbc.JdbcTransaction]Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@25359ed8]
[DEBUG][21-07-08][com.dy.mapper.UserMapper.getUserInfo]==> Preparing: select * from user
[DEBUG][21-07-08][com.dy.mapper.UserMapper.getUserInfo]==> Parameters:
[DEBUG][21-07-08][com.dy.mapper.UserMapper.getUserInfo]<== Total: 3
[DEBUG][21-07-08][org.apache.ibatis.transaction.jdbc.JdbcTransaction]Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@25359ed8]
[DEBUG][21-07-08][org.apache.ibatis.transaction.jdbc.JdbcTransaction]Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@25359ed8]
[DEBUG][21-07-08][org.apache.ibatis.datasource.pooled.PooledDataSource]Returned connection 624271064 to pool.
復(fù)制代碼再看控制臺(tái)輸出的：這里只截取了重點(diǎn)日志信息。
[org.apache.ibatis.transaction.jdbc.JdbcTransaction]-Opening JDBC Connection
[org.apache.ibatis.datasource.pooled.PooledDataSource]-Created connection 624271064.
[org.apache.ibatis.transaction.jdbc.JdbcTransaction]-Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@25359ed8]
[com.dy.mapper.UserMapper.getUserInfo]-==> Preparing: select * from user
[com.dy.mapper.UserMapper.getUserInfo]-==> Parameters:
[com.dy.mapper.UserMapper.getUserInfo]-<== Total: 3
User(id=30, name=丁大大, age=23, like=釣魚)
User(id=31, name=面條, age=22, like=王者榮耀)
User(id=32, name=面條, age=50, like=王者榮耀)
[org.apache.ibatis.transaction.jdbc.JdbcTransaction]-Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@25359ed8]
[org.apache.ibatis.transaction.jdbc.JdbcTransaction]-Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@25359ed8]
[org.apache.ibatis.datasource.pooled.PooledDataSource]-Returned connection 624271064 to pool.
Process finished with exit code 0
復(fù)制代碼#將等級(jí)為DEBUG的日志信息輸出到console和file這兩個(gè)目的地，console和file的定義在下面的代碼
log4j.rootLogger=DEBUG,console,file
#控制臺(tái)輸出的相關(guān)設(shè)置
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
#文件輸出的相關(guān)設(shè)置
log4j.appender.file = org.apache.log4j.RollingFileAppender
log4j.appender.file.File=./log/dayu.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
#日志輸出級(jí)別
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
復(fù)制代碼執(zhí)行看結(jié)果：
清清爽爽，一目了然！程序的所有執(zhí)行信息都成功打印出來了！
②、正常項(xiàng)目中業(yè)務(wù)層使用
先使用靜態(tài)引入包
static Logger logger = Logger.getLogger(MyTest.class); //這個(gè)MyTest.class要和當(dāng)前所在類名稱保持一致！
復(fù)制代碼
注意，這里導(dǎo)包不要導(dǎo)錯(cuò)了，一定要是
import org.apache.log4j.Logger;，看圖說話業(yè)務(wù)層：
@Test
public void selectUser1() {
logger.info("我是info日志");
logger.error("我是error日志");
logger.debug("我是debug日志");
}
復(fù)制代碼執(zhí)行瞅瞅結(jié)果：
控制臺(tái)輸出：
日志文件追加：
哪里需要打日志可以直接打出來，方便后面出問題好定位！比我們debug排查問題要快很多吧！哈哈哈！
③、log4j.properties配置文件配置詳細(xì)解釋
這些網(wǎng)絡(luò)上都能找到，而且特別雜，我們不可能記住所有的內(nèi)容。
只需要記住一些重點(diǎn)的東西！然后將其記到自己的小本本上，后面哪里需要用到直接capy過來即可。因?yàn)槎际枪潭ǖ母袷降模?/p>
這里只提供一個(gè)通用的簡單模板，具體需要配置啥自己去log4j百度百科自行查找，上面解釋的很詳細(xì)！
模板：
#設(shè)置日志級(jí)別，設(shè)定日志記錄的最低級(jí)別，可設(shè)的值有OFF、FATAL、ERROR、WARN、INFO、DEBUG、ALL或者自定義組別，Log4j建議只使用中間四個(gè)級(jí)別。
log4j.rootLogger=DEBUG,console,file
######### 輸出到控制臺(tái) ####################
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/dayu.log
log4j.appender.file.MaxFileSize=10mb
##輸出DEBUG級(jí)別以上的日志
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
#日志輸出級(jí)別
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
復(fù)制代碼
作者：大魚丶
鏈接：https://juejin.cn/post/6986451654765707295
來源：掘金
著作權(quán)歸作者所有。商業(yè)轉(zhuǎn)載請(qǐng)聯(lián)系作者獲得授權(quán)，非商業(yè)轉(zhuǎn)載請(qǐng)注明出處。
評(píng)論
圖片
表情