// substitute your own class path
package com.jspcafe.beans;

// standard classes to import when using jdbc
import java.sql.*;
import java.io.*;

public class OdbcBean {

// db is our connection object
Connection db = null;

// stmt will hold our jdbc statements
// i.e. sql and stored procedures
Statement stmt = null;

// result will hold the recordset
ResultSet result = null;

// default constructor
public OdbcBean() {
}

/*********************************************
* @dsn String for ODBC Datasource name
* @uid String for ODBC Datasource user name
* @pwn String for ODBC Datasource password
*/
public void OpenConn(
String dsn,
String uid,
String pwd) throws Exception {

try {
dsn = "jdbc:odbc:" + dsn;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
db = DriverManager.getConnection(dsn, uid, pwd);
} catch (Exception e) {
e.printStackTrace();
}
}


/*********************************************
* @sproc String for sql statement or stored
* procedure
*/
public ResultSet getResults(String sproc)
throws Exception {

stmt = db.createStatement();
result = stmt.executeQuery(sproc);
return result;
}

/*********************************************
* @sproc String for sql statement or stored
* procedure
*/
public void execute(String sproc)
throws Exception {

stmt = db.createStatement();
stmt.execute(sproc);
}

// Don't forget to clean up!
public void CloseStmt()
throws Exception {

stmt.close();
stmt = null;
}

// Don't forget to clean up!
public void CloseConn()
throws Exception {

db.close();
db = null;
}

}