connectionmanager.java

ACCP课程中的商业程序网吧管理系统

package com.jbaptech.accp.netbar.server.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.ResultSet;
import java.sql.PreparedStatement;

/**
 * class description here.
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: 北京阿博泰克北大青鸟信息技术有限公司</p>
 *
 * @author luohao
 * @version 1.0
 */
public class ConnectionManager {

  /**
   * driver class.
   */
  private static final String DRIVER_CLASS =
      "sun.jdbc.odbc.JdbcOdbcDriver";
  /**
   * database source.
   */
  private static final String DATASOURCE = "jdbc:odbc:NetBarDataSource";

//  private static final String DRIVER_CLASS =
//      "com.microsoft.jdbc.sqlserver.SQLServerDriver";
//  private static final String DATABASE_URL =
//      "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=NetBar";
//  private static final String DATABASE_USRE = "sa";
//  private static final String DATABASE_PASSWORD = "sa";


  /**
   *  get connection.
   * @return Connection
   */
  public static Connection getConnction() {
    Connection dbConnection = null;
    try {
      Class.forName(DRIVER_CLASS);
//      dbConnection = DriverManager.getConnection(DATABASE_URL, DATABASE_USRE,
//                                                 DATABASE_PASSWORD);

      dbConnection = DriverManager.getConnection(DATASOURCE);
    } catch (Exception e) {
      e.printStackTrace();
    }

    return dbConnection;
  }

  /**
   * close a connection.
   * @param dbConnection Connection
   */
  public static void closeConnection(Connection dbConnection) {
    try {
      if (dbConnection != null && (!dbConnection.isClosed())) {
        dbConnection.close();
      }
    } catch (SQLException sqlEx) {
      sqlEx.printStackTrace();
    }

  }

  /**
   * close the resuletset.
   * @param res ResultSet
   */
  public static void closeResultSet( ResultSet res) {
    try {
      if (res != null) {
        res.close();
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }

  /**
   * close the statement.
   * @param pStatement PreparedStatement
   */
  public static void closeStatement( PreparedStatement pStatement) {
    try {
      if (pStatement != null) {
        pStatement.close();
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }

}