root/trunk/ConDB.java

/* ConDB.java
 * The Monitors connection class
 *
 */

import java.util.Vector;
import java.io.*;
import java.sql.*;
import java.util.*;
import java.text.*;


/**
 * ConDB
 * The following class is for DB connection
 */
public class ConDB {
    /** The connection object (connects to the database) */
    Connection connection;


    /**
     * ConDB
     * Logs on to the monitors database using username: monitors
     * and password 2172442757 This is the default constructor for the class
     */
    public ConDB(){
        System.out.println("Trying to connect to the Monitors database");
        login("monitors", "2172442757");
        System.out.println("Connected to the Monitors database");
    }

    /**
     * ConDB
     * Constructor Logs in into the database adn creates a new
     * @param username the username for the database
     *        password the password for the database
     */
    public ConDB (String username, String password) {
        System.out.println("Trying to connect to the db");
        login(username, password);
        System.out.println("Connected to the database");
    }


    /**
     * Login
     * logs into the Monitors database using the specified verification details
     * including username and password
     * @param username the username of the database
     *        password the password of the database for log on verification
     */
    void login(String username, String password) {
        final String DRIVER = "org.gjt.mm.mysql.Driver";
        final String URL ="jdbc:mysql://www3.isrl.uiuc.edu/monitors?user="+username+"&password="+password;

        try{
            Class c= Class.forName(DRIVER);
            //COMMENT - COMPILE HACK
            //DriverManager.registerDriver(new org.gjt.mm.mysql.Driver());
            connection = DriverManager.getConnection(URL);
        }
        catch(ClassNotFoundException e) {
            System.err.println("Cannot load Driver");
            System.exit(1);
        }
        catch(SQLException e) {
            e.printStackTrace();
            System.err.println("Cant Connect");
            System.exit(1);
        }
        catch (Exception e) {
            System.err.println(e.getMessage());
            System.exit(0);
        }
    }//end of login


    /**
     * getConnection
     * returns the current connection object
     * @return connection a Connection object for the current connection
     *                    to the database
     *
     */
    public Connection getConnection() {
        return connection;
    }//end getConnection


    /**
     * close
     * This method closes the connection to the database
     * This is very essential or else the database would be
     * eveloaded with useless open connections.
     */
    public void close() {
        try {
            connection.close();
        }
        catch (Exception e) {
            e.printStackTrace();
        }
        System.out.println("Closed DB connection");
    }


} //class ConDB