package javatemplate1;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.sql.RowSetEvent;
import javax.sql.RowSetListener;
import javax.sql.rowset.CachedRowSet;
import javax.sql.rowset.JdbcRowSet;
import javax.sql.rowset.RowSetProvider;
import com.sun.rowset.CachedRowSetImpl;
import java.util.ArrayList;
/**
*
* @author Manas14
*/
public class JavaTemplate1 {

public static void main(String[] args) {
// TODO code application logic here
System.out.println("main block executing ");
Connection c = null;
String dbURL = "jdbc:postgresql://localhost:5432/pgsdemo1";
String user = "postgres"; String pwd = "postgre_manas9";
PreparedStatement ps= null;
String sql1 = "Select * from emp";
//SQLInterface iface = new SQLInterface(sql1);
// connecting to db
try {
c = DriverManager.getConnection(dbURL,user,pwd);
System.out.println("Connected to database successfully");
CachedRowSet chrowSet;
chrowSet = new CachedRowSetImpl();
chrowSet.setUrl(dbURL);
chrowSet.setUsername(user);
chrowSet.setPassword(pwd);
chrowSet.setCommand(sql1);
// int [] keys= { 1};
// chrowSet.setKeyColumns(keys);
chrowSet.execute();
//
chrowSet.first(); //
System.out.println( chrowSet.getRow()+ chrowSet.getInt("EMPNO") +
" ename " + chrowSet.getString("ename") +
" JOB " +chrowSet.getString("JOB")
+ " SAL " + chrowSet.getFloat("SAL") );

while(chrowSet.next())
{
int eno= chrowSet.getInt("EMPNO");
String name = chrowSet.getString("ename");
String job = chrowSet.getString("JOB");
int manager = chrowSet.getInt("MGR");
Date date = chrowSet.getDate("HIREDATE");
float salary = chrowSet.getFloat("SAL");
int deptno = chrowSet.getInt("DEPTNO");
System.out.println(" deptno " + deptno + " eno " + eno+ " name "+
name + " JOB " + job +" manager " + manager +
" hired" + date + " sal " + salary );
}

//
} catch (SQLException ex) { ex.getErrorCode();
String message = ex.getMessage();
System.out.println(message);
} finally {
System.out.println("going through final block");
try {
if (ps== null || ps.isClosed()) {
} else {
ps.close();
}
if (c != null && !c.isClosed()) {
c.close(); }
} catch (SQLException ex) { ex.getErrorCode();
ex.getMessage();
}
}
System.out.println("dis-Connected to database successfully");
// st.close(); con.commit();con.close();
}

}