dbconn.java

只是一网站项目不错的可以看看的不看会后悔啊

package com.hygj.sunqi.j2ee.util;
import org.apache.log4j.Logger;
import java.sql.*;

public class DBConn {
  private static String classForName = "";
  private static String url = "";
  private static String dbUser = "";
  private static String dbpwd = "";
  private static Connection conn = null;
  private static Logger log = null;
  private static DBInfo dbInfo = new DBInfo("sqlInfo");
  public DBConn() {
  }
  public static Connection getConn(){
    try{
      classForName = dbInfo.getClassForName();
      url = dbInfo.getUrl();
      dbUser = dbInfo.getDbUser();
      dbpwd = dbInfo.getDbpwd();
      Class.forName(classForName);
      conn = DriverManager.getConnection(url,dbUser,dbpwd);
    }catch(Exception e){
      log = Logger.getLogger(DBConn.class);
      log.error(e);
    }
    return conn;
  }

}