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

import java.sql.*;

public class BaseDAO {

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

  BaseDAO() {
  }

  protected Connection dbConnection;
  protected ResultSet res;
  protected PreparedStatement pStatement;
  protected String strSql;

  public 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 void closeConnection() {
    try {
      if (dbConnection != null && (!dbConnection.isClosed()))
        dbConnection.close();
    }
    catch (SQLException sqlEx) {
      sqlEx.printStackTrace();
    }

  }

  /**
   * clear the resultset and statement
   * @throws SystemException
   */
  public void clearDao() {
    closeResultSet();
    closeStatement();
    closeConnection();
  }

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

  /**
   * close the statement
   */

  protected void closeStatement() {
    try {
      if (this.pStatement != null) {
        this.pStatement.close();
        this.pStatement = null;
      }
    }
    catch (SQLException e) {
      e.printStackTrace();
    }
  }

}