dbconnection.java

一个完整的网络订餐系统

package com.common;

import java.sql.*;

public class DBConnection {
  private static String DBDriver = null;
  private static String ConnStr = null;
  private int nDriverLoaded;

  public DBConnection()
      throws ClassNotFoundException
  {
      nDriverLoaded = -1;
      DBDriver = SystemConfig.getDbDriver();//"com.microsoft.jdbc.sqlserver.SQLServerDriver";
      ConnStr = SystemConfig.getDBConnection();
      try
      {
          Class.forName(DBDriver);
          nDriverLoaded = 0;
      }
      catch(ClassNotFoundException e)
      {
          throw e;
      }
  }


  public Connection getDBConnection()
      throws SQLException
  {
      Connection conn = null;
      if(nDriverLoaded == 0)
          try
          {
              conn = DriverManager.getConnection(ConnStr);
          }
          catch(SQLException e)
          {
              throw e;
          }
      return conn;
  }


  public void closeDBConnection(Connection conn)
      throws SQLException
  {
      try
      {
          conn.close();
      }
      catch(SQLException e)
      {
          throw e;
      }
  }
}