} }
stmt.close(); conn.close();
}catch(SQLException se){
//Handle errors for JDBC se.printStackTrace();
}catch(Exception e){
//Handle errors for Class.forName e.printStackTrace();
}finally{ }
log.info(\終了!\);
try{
if(stmt!=null)
stmt.close();
}catch(SQLException se2){ } try{
if(conn!=null)
conn.close();
}catch(SQLException se){ }
se.printStackTrace();
11. jdbc.properties
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://172.999.999.35:3306/empdb user=empuser password=empuser123 initialSize=5 maxActive=50 maxIdle=30 minIdle=15 maxWait=60000
12. log4j.properties
#CONSOLE,fileoutの双方式
log4j.rootLogger=DEBUG,CONSOLE,FILEOUT log4j.addivity.org.apache=true
# CONSOLE
log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender log4j.appender.Threshold=DEBUG
log4j.appender.CONSOLE.Target=System.out
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
#log4j.appender.CONSOLE.layout.ConversionPattern=[framework] %d ? %c -%-4r [%t] %-5p %c %x ? %m%n log4j.appender.CONSOLE.layout.ConversionPattern=[%-5p] %d{yyyy-MM-dd HH\\:mm\\:ss} \\:%m%n # # FILEOUT
log4j.appender.FILEOUT=org.apache.log4j.RollingFileAppender log4j.appender.FILEOUT.File=${user.dir}\\\\filelog.log log4j.appender.fileout.MaxFileSize=100000KB
# default is true，append to the file; if false, the replace the log file whenever restart system log4j.appender.FILEOUT.Append=true log4j.appender.FILEOUT.MaxBackupIndex=1000 #RollingFileAppender没有DatePattern?个属性
log4j.appender.FILEOUT.layout=org.apache.log4j.PatternLayout
#log4j.appender.CONSOLE.layout.ConversionPattern=[framework] %d ? %c -%-4r [%t] %-5p %c %x ? %m%n log4j.appender.FILEOUT.layout.ConversionPattern=[%-5p]_%d{yyyy-MM-dd HH:mm:ss} :%m%n