ResultSet Pattern

UsersJDBCDao.java

public class UsersJDBCDao {
	private static final String GET_ALL_USERS = "SELECT * FROM users";

	public UsersResultSet getAllUsers() {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;

		try {
			conn = getConnection();
			ps = conn.prepareStatement(GET_ALL_ORDERS);
			ps.setFetchSize(1000); // Fetch users lazily 1000-by-1000
			rs = ps.executeQuery();
			return new UsersResultSet(rs, ps, conn);

		} catch (SQLException se) {
			// Deal with exception
		}
	}
}