package javatemplate1;

 
import java.sql.*;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
//
import javax.naming.*;
import javax.sql.*;
import javax.sql.DataSource;
import javax.sql.rowset.RowSetMetaDataImpl;
import org.postgresql.ds.PGPoolingDataSource;


public class JavaTemplate1 {
    // example of 
       public static void main(String[] args) {
            // TODO code application logic here
           Statement st = null ;
           ResultSet rs= null; 
          RowSet rset= null; 
            Connection conn = null;
           String sqlQuery = "Select *  from pgsvisitor1b "  ;      
        // Datasource 
PGPoolingDataSource source = new PGPoolingDataSource();
source.setDataSourceName("A Data Source");
source.setServerName("localhost");
source.setDatabaseName("pgsdemo1");
source.setUser("postgres");
source.setPassword("postgre_manas9");
source.setMaxConnections(10);
     
try {
    conn = source.getConnection();
    // use connection
    if(conn!=null){
     System.out.println("Db Connected::using DataSource ");
     st = conn.createStatement(); 
       rs = st.executeQuery(sqlQuery);
     ResultSetMetaData metaData = rs.getMetaData();
     int numberOfColumns = metaData.getColumnCount();  
     // get name of the columuns 
         for ( int i = 1; i <= numberOfColumns; i++ )
         System.out.printf( "%-4s\t", 
                 metaData.getColumnName( i ) );
         System.out.println();
        //
           Process.loaddata(rs, numberOfColumns);
    }
} catch (SQLException e) {
    // log error
} finally {
    if (conn != null) {
        try { conn.close(); } catch (SQLException e) {}
    }
}

      System.out.println("dis-Connected to  database successfully"); 

    } 
      
}
class Process {
   //private int empno;  private String empname; 
   // private String empjob; private float empsal; 
    //

public static void loaddata( ResultSet   x1 , int n2)
        throws SQLException
{ int size = 0; 
    while ( x1.next() ) 
         {
             size++; 
            for ( int i = 1; i <= n2; i++ )
                try {
          System.out.printf( "%-4s\t", x1.getObject( i ));
          } catch (SQLException ex) {
            Logger.getLogger(Process.class.getName()).
             log(Level.SEVERE, null, ex);
                }
            System.out.println();
         }
    //displayMap(list1); 
    System.out.println("processed rows :: "+ size);
}

}