如何在控制台日志看到mybatis生成的sql

1.在sqlmap-config.xml中的configuration标签中添加，要添加在enviroments标签之前

<settings> <setting name="logImpl" value="LOG4J"/> </settings>

2.在项目中加入log4j.jar

3.在src下创建log4j.properties，添加内容

### set log levels ### log4j.rootLogger = DEBUG,Console,File ### 输出到控制台 ### log4j.appender.Console=org.apache.log4j.ConsoleAppender log4j.appender.Console.Target=System.out log4j.appender.Console.layout=org.apache.log4j.PatternLayout log4j.appender.Console.layout.ConversionPattern= %d{ABSOLUTE} %5p %c{1}:%L - %m%n ### 输出到日志文件 ### log4j.appender.File=org.apache.log4j.RollingFileAppender log4j.appender.File.File=${project}/WEB-INF/logs/app.log log4j.appender.File.DatePattern=_yyyyMMdd'.log' log4j.appender.File.MaxFileSize=10MB log4j.appender.File.Threshold=ALL log4j.appender.File.layout=org.apache.log4j.PatternLayout log4j.appender.File.layout.ConversionPattern=[%p][%d{yyyy-MM-dd HH\:mm\:ss,SSS}][%c]%m%n

即可