急求~通过在log4j.properties配置输出操作JDBC的sql语句？
我用的 环境是 tomcat6,jdk1.6
src目录下log4j.properties
log4j.rootLogger=DEBUG,CONSOLE
log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %5p [%13F:%L] - %m%n
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG
操作数据库的语句是：
----------------------------------
package com.dao;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.model.Student;
public class StudentDAO {
public static List<Student> getAll(){
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
List<Student> list=new ArrayList<Student>();
try{
con=ConnectionDB.getConnection();
String sql="select * from student";
stmt = con.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next()){
Student stu=new Student();
System.out.println(rs.getString("stu_name"));
stu.setName(rs.getString("stu_name"));
list.add(stu);
}
}catch(SQLException e){
System.out.println(e);
throw new RuntimeException(e);
}finally{
if(null!=con){
try{
rs.close();
stmt.close();
con.close();
}catch(SQLException x){
System.out.println(x);
throw new RuntimeException(x);
}
}
}
return list;
}
}
可就是在控制台打印不出 操作的的SQL语句？
[解决办法]
