package ch03.section10;

import java.sql.*;

public class bka {
  String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
  String sConnStr = "jdbc:odbc:bka";
  Connection conn = null;
  ResultSet rs = null;

  public bka() {
    try {
      Class.forName(sDBDriver);
    }
    catch (java.lang.ClassNotFoundException e) {
      System.err.println("bka(): " + e.getMessage());
    }
  }

  public ResultSet executeQuery(String sql) {
    rs = null;
    try {
      conn = DriverManager.getConnection(sConnStr, "sa", "sa");
      Statement stmt = conn.createStatement();
      rs = stmt.executeQuery(sql);
    }
    catch (SQLException ex) {
      System.err.println("aq.executeQuery: " + ex.getMessage());
    }
    return rs;
  }
}