log4j配置mysql控制台打印_log4j配置控制台打印jdbc相关语句

log4j配置：

#log 日志

log4j.rootLogger=DEBUG, A1

log4j.logger.java.sql.Connection=DEBUG

log4j.logger.java.sql.PreparedStatement=DEBUG

#log4j.logger.java.sql.Statement=DEBUG

log4j.logger.java.sql.ResultSet=DEBUG

#控制台

log4j.appender.A1=org.apache.log4j.ConsoleAppender

log4j.appender.A1.Threshold=DEBUG

log4j.appender.A1.Target=System.out

log4j.appender.A1.layout=org.apache.log4j.PatternLayout

log4j.appender.A1.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %5p [%13F:%L] - %m%n

请问这样配置有什么问题，为什么sql不能打印到控制台？

问题补充：没有使用框架。

package com.newbridge.iwifi.util.db;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import com.newbridge.iwifi.util.Properties;

public class DBHelper implements DB{

private static final String DRIVERCLASSNAME = Properties.dbConfig.getString("jdbc.driver");

private static final String URL = Properties.dbConfig.getString("jdbc.url");

private static final String USERNAME = Properties.dbConfig.getString("jdbc.username");

private static final String PASSWORD = Properties.dbConfig.getString("jdbc.password");

@Override

public Connection getConnection() throws SQLException {

// TODO Auto-generated method stub

Connection conn = null;

try {

Class.forName(DRIVERCLASSNAME);

conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return conn;

}

@Override

public void closeConn(Connection connection) throws SQLException {

// TODO Auto-generated method stub

connection.close();

}

public static void main(String[] args) {

try {

System.out.println(new DBHelper().getConnection());

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}