/*
 * TestPostgis.java
 *
 * Created on 20 March 2002, 16:28
 */
package uk.ac.leeds.ccg.tests.postgres;

import java.util.*;
import java.lang.*;

import java.sql.*;
// import javax.sql.*;

import org.postgis.*;

//import org.postgresql.*;
//import org.postgresql.core.*;
//import org.postgresql.fastpath.*;
//import org.postgresql.geometric.*;
//import org.postgresql.jdbc2.*;
//import org.postgresql.largeobject.*;
//import org.postgresql.util.*;

/**
 *
 * @author  andyt
 */
public class TestPostgis {
    
    /** Creates a new instance of TestPostgis */
    public TestPostgis() {
    }
    
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        
        // Connection parameters
        String url = "jdbc:postgresql://feathers.leeds.ac.uk/postgis_test";
        String myLogin = "postgis_ro";
        String myPassword = "postgis_ro";
        
        String query1 = "select * from testset;";
        
        // Test org.postgresql.Driver using java.sql.Connection
        System.out.println("Test org.postgresql.Driver using java.sql.Connection");
        try {
            Class.forName( "org.postgresql.Driver" );
            java.sql.Connection con = DriverManager.getConnection( url, myLogin, myPassword);
            // Add geometry types to the connection.
            //((org.postgresql.Connection) con).addDataType("geometry","org.postgis.PGgeometry");
            //((org.postgresql.Connection) con).addDataType("box3d","org.postgis.PGbox3d");
            // Create a statement and execute a select query.
            Statement s = con.createStatement();
            //ResultSet rs = s.executeQuery("select AsText(geom) as geom,id from geomtable");
            ResultSet rs = s.executeQuery( query1 );
            //con.
            while( rs.next() ) {
                System.out.println("results " + rs.getString(1));
                //PGgeometry geom = (PGgeometry) rs.getObject(1);
                //int id = rs.getInt(2);
                //System.out.println("Row " + id + ":");
                //System.out.println(geom.toString());
            }
            s.close();
            con.close();
        } catch( Exception e ) {e.printStackTrace();}
        
        
        // Test org.postgresql.Driver using org.postgres.Connection
        System.out.println( "Test org.postgresql.Driver using org.postgres.Connection" );
        try {
            Class.forName( "org.postgresql.Driver" );
            org.postgresql.Connection con = ( org.postgresql.Connection ) DriverManager.getConnection( url, myLogin, myPassword);
            org.postgresql.ResultSet rs = (org.postgresql.ResultSet) con.ExecSQL( query1 );
            //con.
            while( rs.next() ) {
                System.out.println( "results " + rs.getString(1) );
                //PGgeometry geom = (PGgeometry) rs.getObject(1);
                //int id = rs.getInt(2);
                //System.out.println("Row " + id + ":");
                //System.out.println(geom.toString());
            }
            con.close();
        } catch( Exception e ) {e.printStackTrace();}
        
        
        // Test org.postgresql.Driver using org.postgres.jdbc2.Connection
        System.out.println( "Test org.postgresql.Driver using org.postgres.Connection" );
        try {
            Class.forName( "org.postgresql.Driver" );
            org.postgresql.jdbc2.Connection con = ( org.postgresql.jdbc2.Connection ) DriverManager.getConnection( url, myLogin, myPassword );
            org.postgresql.jdbc2.Statement s = ( org.postgresql.jdbc2.Statement ) con.createStatement( org.postgresql.jdbc2.ResultSet.TYPE_SCROLL_SENSITIVE, org.postgresql.jdbc2.ResultSet.CONCUR_READ_ONLY );
            org.postgresql.jdbc2.ResultSet rs = ( org.postgresql.jdbc2.ResultSet ) s.executeQuery( query1 ); // Execute statement
            //con.
            while( rs.next() ) {
                System.out.println( "results " + rs.getString(1) );
                //PGgeometry geom = (PGgeometry) rs.getObject(1);
                //int id = rs.getInt(2);
                //System.out.println("Row " + id + ":");
                //System.out.println(geom.toString());
            }
            con.close();
        } catch( Exception e ) {e.printStackTrace();}
        
    }
}