import java.sql.*;

public class JDBCTest {
    public static void main(String args[]){
	Connection connection = null;
	int update_count = 0;
	String url = "jdbc:postgresql://acl2.cs.earlham.edu:5432/java";
	try {
	    Class.forName("postgresql.Driver");
	} catch (Exception e){
	    System.out.println(e);
	}
	try {
	    connection = DriverManager.getConnection(url,"jeremiah","");
	} catch (Exception e){
	    System.out.println(e);
	}
	try {
	    Statement statement = connection.createStatement();
	    update_count = statement.executeUpdate("insert into departments values ('244','English')");
	} catch (Exception e){
	    System.out.println(e);
	} 
	System.out.println(update_count+" Rows updated");
	
	//--------------------------------------------------------------------
	try {
	    Statement statement = connection.createStatement();
	    ResultSet results = statement.executeQuery("select * from departments");
	    ResultSetMetaData rsmd = results.getMetaData();
	    System.out.println("Column count = "+rsmd.getColumnCount());
	    while (results.next()){
		for (int i = 1 ; i <= rsmd.getColumnCount(); i++){
		    System.out.println(results.getObject(i));
		}
	    }
	    
	} catch (Exception e){
	    System.out.println(e);
	}
    }
}