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

import java.sql.*;

public class ConnectionManager {

  private static final String DRIVER_CLASS =
      "sun.jdbc.odbc.JdbcOdbcDriver";
  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";





  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;
  }

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

  }



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

  /**
   * close the statement
   */

  public static void closeStatement(PreparedStatement pStatement) {
    try {
      if (pStatement != null) {
        pStatement.close();
        pStatement = null;
      }
    }
    catch (SQLException e) {
      e.printStackTrace();
    }
  }

}