dbconnection.jad

ENTERPRISE RESOURCE INFORMATION SYSTEM(ERIS) is a compurised solution for recruiting angencies and s

// Decompiled by DJ v3.5.5.77 Copyright 2003 Atanas Neshkov  Date: 5/11/2005 4:44:34 PM
// Home Page : http://members.fortunecity.com/neshkov/dj.html  - Check often for new version!
// Decompiler options: packimports(3) 
// Source File Name:   DBConnection.java

package dbconnection;

import java.io.PrintStream;
import java.sql.*;

public class DBConnection
{

    public DBConnection()
    {
        con = null;
        rs = null;
        st = null;
        try
        {
            System.out.println("in con");
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con = DriverManager.getConnection("jdbc:odbc:eris", "scott", "tiger");
            System.out.println("after con");
        }
        catch(Exception exception)
        {
            exception.printStackTrace();
            System.out.println("in conexp");
        }
    }

    public Connection getConnection()
        throws Exception
    {
        System.out.println("get con");
        return con;
    }

    public ResultSet executeQuery(String s)
    {
        try
        {
            st = con.createStatement();
            rs = st.executeQuery(s);
            System.out.println("in st");
        }
        catch(Exception exception)
        {
            exception.printStackTrace();
            System.out.println("in st exp");
        }
        return rs;
    }

    public void close()
        throws Exception
    {
        rs.close();
        st.close();
        con.close();
    }

    Connection con;
    ResultSet rs;
    Statement st;
}