// make sure autocommit is off
conn.setAutoCommit(false);
Statement st = conn.createStatement();
// Turn use of the cursor on.
ResultSet rs = st.executeQuery("SELECT * FROM mytable");
System.out.print("a row was returned.");
rs = st.executeQuery("SELECT * FROM mytable");
System.out.print("many rows were returned.");