
package temp;

import java.sql.*;
import java.util.*;


/**
 *
 * @author  okomba
 */
public class TestJDBC {
    
   
   
    
    /** Creates a new instance of TestJDBC */
    public TestJDBC() {
    }
    
   
    
    public static void main(String [] argv) {
        
            String jdbcClassName = "org.postgresql.Driver";
            String DBUrl = "jdbc:postgresql://localhost:5432/database?charSet=LATIN1";
            String username  = "user";
            String password = "pass";
            
        
        if((jdbcClassName!="") && (DBUrl!="")){
            

            try {
                Class.forName(jdbcClassName).newInstance();
                Connection conn = DriverManager.getConnection(DBUrl,username,password);
                ResultSet rs = null;
                
                String statement = "SELECT *   FROM currencies";
                Statement stmt = conn.createStatement();

                rs = stmt.executeQuery(statement);
                boolean entryExists = rs.next();
                

                while(rs.next()) {

                    ResultSetMetaData metadata = rs.getMetaData();
                    int columnCount = metadata.getColumnCount();
                    
                    String columnName="";
                    Object columnEntry=null;                       
                
                    for (int columnCountIndex = 1; columnCountIndex <= columnCount;columnCountIndex++) {

                        columnName = metadata.getColumnName(columnCountIndex);
                    
                        try {
                            columnEntry = rs.getObject(columnName);
                        }
                        catch(java.lang.StringIndexOutOfBoundsException sioob){}
                        
                        System.out.println(columnEntry + " - entry");
                    
                    } // end for                    
                
                
                    System.out.println("=====================================================");
                 
                    
                } // end while
                

            } //end try
            catch (ClassNotFoundException cnfe) {
                System.out.println(cnfe.getMessage() + " - cnfe.getMessage()");
                cnfe.printStackTrace();
                conn = null;
            }
            catch (InstantiationException ie) {
                System.out.println(ie.getMessage() + " - ie.getMessage() ");
                ie.printStackTrace();
                conn = null;
            }
            catch (IllegalAccessException iae) {
                System.out.println(iae.getMessage() + " - iae.getMessage() ");
                iae.printStackTrace();
                conn = null;
            }
            catch (SQLException sqle) {
                System.out.println(sqle.getMessage() + " - sqle.getMessage() ");
                sqle.printStackTrace();
                conn = null;
            }
            
            catch (StackOverflowError sofe) {
                System.out.println(sofe.getMessage() + " - sofe.getMessage() ");
                sofe.printStackTrace();
                conn = null;
            }            
            
        } // end if
        
    } // end function
    
 
 
  

}




