葉明的javablog

log4j.properties? 配置文件代碼：
# Attach appender A1 to root. Set root level to Level.DEBUG.

log4j.rootLogger=INFO, A1,A4

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

log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern=%p [%t] %c{2} (%M:%L) - %m%n

log4j.appender.A4=org.apache.log4j.DailyRollingFileAppender
log4j.appender.A4.file=D:\\Java\\logs\\yeming.log
log4j.appender.A4.Encoding=GBK
log4j.appender.A4.DatePattern='.'yyyy-MM-dd
log4j.appender.A4.layout=org.apache.log4j.PatternLayout
log4j.appender.A4.layout.ConversionPattern=%-d{yyyy-MM-dd HH:mm:ss} [%c]-[%p] %m%n

使用代碼：
package com.javawoker.yeming.jiemie.database;
import java.sql.Connection;
import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import org.apache.log4j.Logger;
/**
?*@author 葉明 ---guming123416@gmail.com
?*@version $Id: v 1.01 2006/06/38 16:09:14 teodord Exp $
?*/
public class Pubconn {
?
?/*
? * 創建私有變量conn為數據庫連接對象中Connection
? * 創建私有變量dsye為數據庫連接池的DataSource
? */
?
?private Connection conn;
?private DataSource dsye;
?private static Logger log=Logger.getLogger(Pubconn.class);
?/*
? * 創建構造函數Pubconn，在建立class中加載數據源的InitialContext
? */
?public Pubconn()
?{
??try{
???Context initCtx=new InitialContext();
???if(initCtx==null)
???{
????throw new Exception("不能加載文件Context");
???}
???dsye=(javax.sql.DataSource)initCtx.lookup("jdbc/yeming");
??}catch(Exception ex)
??{
???ex.printStackTrace();
???log.error("在加栽數據庫連接池時間發生錯誤"+ex.getMessage());
??}
?}
?/*
? * 從連接池中取出一條連接變量
? *
? */
?public Connection getConn()
?{
??try{
???conn=dsye.getConnection();
??}catch(SQLException ex)
??{
???ex.printStackTrace();
???log.error("獲得連接對象CONN時間發生錯誤"+ex.getMessage());
??}
??return conn;
?}
?/*
? * 關閉數據庫連接，釋放資源
? */
?public void closeConn(Connection conn)
?{
??try{
???if(conn!=null)
???{
????conn.close();
????conn=null;
???}
??}catch(SQLException ex)
??{
???ex.printStackTrace();
???log.error("關閉CONN時間發生錯誤"+ex.getMessage());
??}
?}

}