import java.net.URL;
import java.sql.*;

public class Pg
{
     public static void main (String args [])
           throws SQLException
    {
            String url = "jdbc:postgresql://postgres.cise.ufl.edu/cisedb";
            Connection db;
            Statement st;
            String query = "select name, id from mytable";
   
            try {
                    System.err.println ( "Loading driver ..." );
                    Class.forName ("org.postgresql.Driver");
            } catch (java.lang.ClassNotFoundException e) {
                    System.err.print ("ClassNotFoundException:");
                    System.err.println (e.getMessage());
            }
   
            try {
                    System.err.println ( "Connecting ..." );
                    db = DriverManager.getConnection (url,"user","password");
                    System.err.println ( "Preparing statement ..." );
                    st = db.createStatement ();
                    System.err.println ( "Executing query ..." );
                    ResultSet rs = st.executeQuery (query);
                    while (rs.next()) {
                        System.out.println(rs.getString(1) + " " + rs.getString(2));
                    }
                    st.close ();
                    db.close ();
            } catch (SQLException ex) {
                    System.err.println ( "SQLState:" + ex.getSQLState() );
                    System.err.println ( "Message:" + ex.getMessage() );
                    System.err.println ( "Vendor:" + ex.getErrorCode() );
            }
    }
}