// Simple database example in Java
// By Dan Hyde, October 7, 2008
// Assumes database created with a "nameTable" with entries

import java.sql.*; // need for databases

public class SimpleDatabase {

    public static void main(String[] args) {
	
	Connection conn;
	Statement stmt = null;
	ResultSet rset;

	// Setup the database
	// ------------------

	System.out.println("\n Connecting to data base ...");
	try{
	    // create a driver to MySQL
	    try {
		Class.forName("com.mysql.jdbc.Driver").newInstance();
	    } catch (Exception ex) {
		System.out.println("Error in Driver");
	    }
	    
	    // create a connection to database - fill in host-name,
	    //            database-name, account-name and password
	    //	    conn = DriverManager.getConnection(
	    //	   "jdbc:mysql://db.eg.bucknell.edu/database-name",
	    //	   "account-name", "password");
	    conn = DriverManager.getConnection(
		   "jdbc:mysql://db.eg.bucknell.edu/hydedb",
		   "hyde", "password");
					      
	    // create a statement for SQL query execution
	    stmt = conn.createStatement();
	}
	catch (Exception e) {
	    System.err.println("Error in connection to db:" + e);
	    e.printStackTrace();
	}
    
	System.out.println("\n Connected to data base.  Now trying a query ...");
	// Query the database
	// ------------------
	String name2;

	try{
	    // issue a SQL command
	    rset=stmt.executeQuery("SELECT * FROM nameTable");

	    // the result is a table in a ResultSet object

	    // Extract each element from the ResultSet rset
	    while (rset.next()) {
		// gets the value of the "name" attribute
		name2 = rset.getString("name");
		System.out.println("name is " + name2);
	    }
	}  catch (Exception e){
	    System.err.println("Error in query to db:" + e);
	    e.printStackTrace();
	}
 
    }
}

/* compile  and run

[hyde@linuxremote1 ~/CS475]$ javac SimpleDatabase.java
[hyde@linuxremote1 ~/CS475]$ java SimpleDatabase

 Connecting to data base ...

 Connected to data base.  Now trying a query ...
name is Darth Vader
name is Luke Skywalker
[hyde@linuxremote1 ~/CS475]$ 

*/