问题记录---打印ibatis日志

谁借莪１个温暖的怀抱￠ 2021-09-27 18:00 389阅读 0赞

用ibatis搭了一个测试用的小项目，却发现打印不出日志信息。网上找了好多.properties形式的配置文件，也是不好用。最后从别的项目里找了一个log4j.xml形式的配置文件，放到src目录下，终于好用了。

![在这里插入图片描述][20181109135741382.png]

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
    <log4j:configuration xmlns:log4j='http://jakarta.apache.org/log4j/'>
    
    	<appender name="console" class="org.apache.log4j.ConsoleAppender">
    		<layout class="org.apache.log4j.PatternLayout">
    			<param name="ConversionPattern" value="[%p] %d{yyyy-MM-dd HH:mm:ss} %l: %m%n" />
    		</layout>
    	</appender>
    
    	<appender name="rootLogger" class="org.apache.log4j.DailyRollingFileAppender">
    		<param name="File" value="../logs/rootLogger.log" />
    		<param name="Append" value="true" />
    		<param name="DatePattern" value="'.'yyyy-MM-dd" />
    		<layout class="org.apache.log4j.PatternLayout">
    			<param name="ConversionPattern" value="[%p] %d{yyyy-MM-dd HH:mm:ss} %l: %m%n" />
    		</layout>
    	</appender>
    
    	<logger name="com.ibatis" additivity="true">
    		<level value="debug" />
    	</logger>
    
    	<logger name="java.sql.Connection" additivity="true">
    		<level value="debug" />
    	</logger>
    
    	<logger name="java.sql.Statement" additivity="true">
    		<level value="debug" />
    	</logger>
    	
    	<logger name="java.sql.PreparedStatement" additivity="true">
    		<level value="DEBUG" />
    	</logger>
    	
    	<logger name="java.sql.ResultSet" additivity="true">
    		<level value="DEBUG" />
    	</logger>
    	
    	<root>
    		<level value="info" />
    		<appender-ref ref="console" />
    		<appender-ref ref="rootLogger" />
    	</root>
    </log4j:configuration>

[20181109135741382.png]: /images/20210923/e6355837b436469a9fa46bb0bbdb246a.png