log4j.rootLogger=WARN,Console
log4j.logger.com.xiaoyao=ERROR,Console,DataBase
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=\u7EBF\u7A0B[%t] \u4E8E %d{yyyy\u5E74MM\u6708dd\u65E5 HH\u65F6mm\u5206ss.SSS\u79D2} \u7531%37c\u622A\u83B7%-5p\u5F02\u5E38 %x- %m%n
#主要问题在下面的Appender，配置的数据库中，但是每次都不往数据库里插入数据，也没有什么异常。sql语句我试过，可以执行
log4j.appender.DataBase=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.DataBase.BufferSize=40
log4j.appender.DataBase.Driver=com.mysql.jdbc.Driver
log4j.appender.DataBase.URL=jdbc:mysql://localhost:3306/xy
log4j.appender.DataBase.User=root
log4j.appender.DataBase.Password=root
log4j.appender.DataBase.layout = org.apache.log4j.PatternLayout
log4j.appender.DataBase.layout.ConversionPattern = INSERT INTO xy_log4j(priority, milliseconds, category, thread,createDate) values('%p',%r,'%c','%t','%d')