import java.sql.*;
import java.math.*;

public class ex{
public static void main(String[] args) throws Exception
{
	Class.forName("org.postgresql.Driver");
	Connection conn = DriverManager.getConnection("jdbc:postgresql:test", "cts1","");
	
	Statement stmt = conn.createStatement();
	conn.setAutoCommit(false);
	stmt.setFetchSize(2);
	ResultSet rs = stmt.executeQuery("select * from integer_tab");
	rs.setFetchDirection(ResultSet.FETCH_FORWARD);
	while (rs.next())
		System.out.println(rs.getString(1));
	rs.setFetchDirection(ResultSet.FETCH_REVERSE);
	while (rs.next())
		System.out.println(rs.getString(1));
}
}
