• Example of using DataSource:: PostgreSQL

• Using DriverManager Class
  
  
   
• Using DataSource
  import org.postgresql.ds.PGPoolingDataSource;
  
  
• Processing or Loading ResultSet:
  

Important code:

 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);
}