log4j.xml数据库保存日志

这篇文章主要是来实现log4j.xml实现打印sql语句和日志存入数据库。以下是最完整的配置，大家要相互学习和分享啊，o((≧▽≦o)！！

<?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="%d{ABSOLUTE} %3p %c{1}.%M():%L - %m%n" />
		</layout>
	</appender>

        <!-- 打印数据库数据 -->
	<appender name="db" class="org.apache.log4j.jdbc.JDBCAppender">
	<param name="driver" value="com.mysql.jdbc.Driver" />
	<param name="URL"
		value="jdbc:mysql://10.x.x.x:3306/security_db?useUnicode