JDBC MySQL Cursor Example

gistfile1.java

Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
	conn = template.getDataSource().getConnection();
	stmt = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
	stmt.setFetchSize(Integer.MIN_VALUE);
	rs = stmt.executeQuery("SELECT * FROM push");

	while (rs.next()) {
		System.out.println(rs.getString(1) + " " + rs.getString(2));
		Thread.sleep(1000);
	}
} finally {
	try {
		conn.close();
	} catch (Exception e) {
	}
	try {
		stmt.close();
	} catch (Exception e) {
	}
	try {
		rs.close();
	} catch (Exception e) {
	}
}