高手请帮忙:
          我现在想用log4j操作mysql数据库:代码如下
log4j.propertieslog4j.rootLogger=WARN,DATABASE
log4j.addivity.org.apache=true
# imporin jdbc.jar
log4j.appender.DATABASE=org.apache.log4j.jdbc.JDBCAppender  
# connection    
log4j.appender.DATABASE.URL=jdbc:mysql://localhost:3306/log4j
log4j.appender.DATABASE.driver=com.mysql.jdbc.Driver 
log4j.appender.DATABASE.user=root
log4j.appender.DATABASE.password=123456
log4j.appender.DATABASE.Threshold=INFO
log4j.appender.DATABASE.BufferSize=10
# sql  
log4j.appender.DATABASE.sql=INSERT INTO log4j (Username,Class,Method,CreateTime,LogLevel,MSG) VALUES('%X{userName}','%C,%L','%M','%d{yyyy-MM-dd HH\:mm\:ss}','%p','%m')  
log4j.appender.DATABASE.layout=org.apache.log4j.PatternLayout
Test.javapackage sy.ic.dev.log4j;import org.apache.log4j.Logger;
import org.apache.log4j.MDC;
import org.apache.log4j.PropertyConfigurator;import sy.ic.dev.model.Log4j;
import sy.ic.dev.model.User;public class Test { public static void main(String[] args) {
Logger log = Logger.getLogger(Test.class);                        PropertyConfigurator.configure("F:\\MyEclipse8.5\\Workspaces\\Log4JTest\\src\\log4j.properties");

User us = new User();
Log4j log4j = new Log4j(); us.setUserName("lishuo");
log4j.setClass_("Test"); System.out.println("-----------" + us.getUserName() + "登陆啦"
+ "------------");
MDC.put("Username", us.getUserName());
MDC.put("Class", log4j.getClass_());
log.warn("管理员登陆啦~!!!");
}
}
现在的问题是控制台报异常,告诉我加载驱动失败,究竟是什么问题啊?我需要怎么改?请高手帮忙解答一下。
log4j:ERROR Failed to load driver
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver 
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.apache.log4j.jdbc.JDBCAppender.setDriver(JDBCAppender.java:351)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.log4j.config.PropertySetter.setProperty(PropertySetter.java:205)
at org.apache.log4j.config.PropertySetter.setProperty(PropertySetter.java:164)
at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:129)
at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:96)
at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:654)
at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:612)
at org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfigurator.java:509)
at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:415)
at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:316)
at org.apache.log4j.PropertyConfigurator.configure(PropertyConfigurator.java:324)
at sy.ic.dev.log4j.Test.main(Test.java:15)
-----------lishuo登陆啦------------