First of all, the project must have slf4j-log4j12-1.7.12.jar this bag, otherwise it will not come out
Then the "log4j.properties" file in the project is as follows:
log4j.appender.stdout=org.apache.log4j.consoleappenderlog4j.appender.stdout.target= system.outlog4j.appender.stdout.layout= ORG.APACHE.LOG4J.PATTERNLAYOUTLOG4J.APPENDER.STDOUT.LAYOUT.CONVERSIONPATTERN=%D{HH:MM:SS}%-5p%-20.30c{1}[%M-%L ]-%m%nlog4j.appender.infofile=org.apache.log4j.rollingfileappenderlog4j.appender.infofile.file=wf_ Info.loglog4j.appender.infofile.append=truelog4j.appender.infofile.maxfilesize= 10mblog4j.appender.infofile.maxbackupindex=10log4j.appender.infofile.layout= Org.apache.log4j.patternlayoutlog4j.appender.infofile.layout.conversionpattern=%d{yyyy-mm-dd HH:mm:ss}:%p%c{1}: [%m-%l]-%m%nlog4j.appender.infofile.filter.my= org.apache.log4j.varia.levelrangefilterlog4j.appender.infofile.filter.my.levelmin= Infolog4j.appender.infofile.filter.my.levelmax=warnlog4j.appender.infofile.filter.my.acceptonmatch= Truelog4j.appender.errorfile=org.apache.log4j.rollingfileappenderlog4j.appender.errorfile.file=wf_ Error.loglog4j.appender.errorfile.append=truelog4j.appender.errorfile.maxfilesize=10mblog4j.appender.errorfile.maxbackupindex=10log4j.appender.errorfile.layout= Org.apache.log4j.patternlayoutlog4j.appender.errorfile.layout.conversionpattern=%d{yyyy-mm-dd HH:mm:ss}:%p%c{1} : [%m-%l]-%m%nlog4j.appender.errorfile.filter.my= org.apache.log4j.varia.levelrangefilterlog4j.appender.errorfile.filter.my.levelmin= Errorlog4j.appender.errorfile.filter.my.levelmax=errorlog4j.appender.errorfile.filter.my.acceptonmatch= Truelog4j.rootlogger=info,stdout,infofile,errorfile,debug,console,r#ibatis Logger config #log4j. logger.com.ibatis =info #log4j. Logger.com.ibatis.common.jdbc.simpledatasource=info # Log4j.logger.com.ibatis.common.jdbc.scriptrunner=info # Log4j.logger.com.ibatis.sqlmap.engine.impl.sqlmapclientdelegate=info #log4j. Logger.java.sql.connection=info # Log4j.logger.java.sql.statement=info #log4j. logger.java.sql.preparedstatement=info# log4j.logger.org.mybatis.spring.sqlsessionutils=info# Log4j.logger.com.opensymphony.oscache.base.algorithm.abstractconcurrentreadcache=info#log4j. Logger.org.apache.ibatis.cache.cache=info#print MyBatis sqllog4j.logger.com.ibatis= Debuglog4j.logger.com.ibatis.common.jdbc.simpledatasource= Debuglog4j.logger.com.ibatis.common.jdbc.scriptrunner= debuglog4j.logger.com.ibatis.sqlmap.engine.impl.sqlmapclientdelegate=infolog4j.logger.java.sql.connection= Debuglog4j.logger.java.sql.statement=debuglog4j.logger.java.sql.preparedstatement= Debuglog4j.logger.org.springframework.jdbc.datasource.datasourcetransactionmanager=info
Mybatis Console typing sql-log settings