项目刚好用到IBatis.Net,备份一份 注:log4net版本是1.2的,(弄了好久都没有日志,才发现版本不对) IBatis.Net中提供了方便的日志处理,可以输出sql语句等调试信息。 常用的有两种: 1、输出到控制台: < configSections > < sectionGroup name = " iBATIS " > < section name = " logging " type = " IBatisNet.Common.Logging.ConfigurationSectionHandler, IBatisNet.Common " /> </ sectionGroup > </ configSections > < iBATIS > < logging > < logFactoryAdapter type = " IBatisNet.Common.Logging.Impl.TraceLoggerFA, IBatisNet.Common " > < arg key = " showLogName " value = " true " /> < arg key = " showDataTime " value = " true " /> < arg key = " level " value = " ALL " /> < arg key = " dateTimeFormat " value = " yyyy/MM/dd HH:mm:ss:SSS " /> </ logFactoryAdapter > </ logging > </ iBATIS > 2、利用log4net输出到文件: < configSections > < sectionGroup name = " iBATIS " > < section name = " logging " type = " IBatisNet.Common.Logging.ConfigurationSectionHandler, IBatisNet.Common " /> </ sectionGroup > < section name = " log4net " type = " log4net.Config.Log4NetConfigurationSectionHandler, log4net " /> </ configSections > < iBATIS > < logging > < logFactoryAdapter type = " IBatisNet.Common.Logging.Impl.Log4NetLoggerFA, IBatisNet.Common.Logging.Log4Net " > < arg key = " configType " value = " inline " /> </ logFactoryAdapter > </ logging > </ iBATIS > < log4net > <!-- Define some output appenders --> < appender name = " RollingLogFileAppender " type = " log4net.Appender.RollingFileAppender " > < param name = " File " value = " f:\log.txt " /> < param name = " AppendToFile " value = " true " /> < param name = " MaxSizeRollBackups " value = " 2 " /> < param name = " MaximumFileSize " value = " 100KB " /> < param name = " RollingStyle " value = " Size " /> < param name = " StaticLogFileName " value = " true " /> < layout type = " log4net.Layout.PatternLayout " > < param name = " Header " value = " [Header]\r\n " /> < param name = " Footer " value = " [Footer]\r\n " /> < param name = " ConversionPattern " value = " %d [%t] %-5p %c [%x] - %m%n " /> </ layout > </ appender > < appender name = " ConsoleAppender " type = " log4net.Appender.ConsoleAppender " > < layout type = " log4net.Layout.PatternLayout " > < param name = " ConversionPattern " value = " %d [%t] %-5p %c [%x] <%X{auth}> - %m%n " /> </ layout > </ appender > <!-- Set root logger level to ERROR and its appenders --> < root > < level value = " DEBUG " /> < appender - ref ref = " RollingLogFileAppender " /> < appender - ref ref = " ConsoleAppender " /> </ root > <!-- Print only messages of level DEBUG or above in the packages --> < logger name = " IBatisNet.DataMapper.Configuration.Cache.CacheModel " > < level value = " DEBUG " /> </ logger > < logger name = " IBatisNet.DataMapper.Configuration.Statements.PreparedStatementFactory " > < level value = " DEBUG " /> </ logger > < logger name = " IBatisNet.DataMapper.LazyLoadList " > < level value = " DEBUG " /> </ logger > < logger name = " IBatisNet.DataAccess.DaoSession " > < level value = " DEBUG " /> </ logger > < logger name = " IBatisNet.DataMapper.SqlMapSession " > < level value = " DEBUG " /> </ logger > < logger name = " IBatisNet.Common.Transaction.TransactionScope " > < level value = " DEBUG " /> </ logger > < logger name = " IBatisNet.DataAccess.Configuration.DaoProxy " > < level value = " DEBUG " /> </ logger > </ log4net >