log4j配置:
#日志
log4j.rootLogger=DEBUG,lmdsl/p log4j.logger.Java.SQL.connection=debug
log4j.logger.Java.SQL.prepared statement=debug
# log4j.logger.Java.SQL.statement=debug
log4j.logger.Java.SQL.resultset=debug
#控制台
log4j.appender.a1=org.Apache.log4j.ka dsy/p log4j.appender.a1.threshold=debug
log4j.appender.a1.target=system.out
log4j.appender.a1.layout=org.Apache.log4j.pattern layout
log4j.appender.a1.layout.conversion pattern=% d { yyyy-mm-ddhh : mm : ss } % 5p [ f : % l ]-m % n
这样的结构有什么问题吗? 为什么sql不能打印到控制台?
package com.new bridge.I wifi.util.db;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql .甜美短靴;
import com.new bridge.I wifi.util.properties;
publicclassdbhelperimplementsdb {
privatestaticfinalstringdriverclassname=properties.db config.getstring (' JDBC.driver ' );
privatestaticfinalstringurl=properties.db config.getstring (' JDBC.URL );
privatestaticfinalstringusername=properties.db config.getstring (JDBC.username );
privatestaticfinalstringpassword=properties.db config.getstring (' JDBC.password ' );
@Override
public Connection getConnection () throws甜短靴。
//todo自动生成方法stub
connection conn=空;
try {
class.forname (驱动程序类名称;
conn=driver manager.getconnection (URL,USERNAME,PASSWORD );
}catch(classnotfoundexceptione ) )
//todo自动生成的catch block
e .打印任务跟踪(;
}
return conn;
}
@Override
public void closeconn (connection connection ) throws甜美短靴)
//todo自动生成方法stub
connection.close (;
}
publicstaticvoidmain (stringajdcsargs ) {
try {
) } catch (甜蜜的短靴e ) )。
//todo自动生成的catch block
e .打印任务跟踪(;
}
}
}