Попробуйте:
String query = "..."; PreparedStatement stat = conn.prepareStatement(query); ResultSet rs = stat.executeQuery(); while (rs.next()) { // TODO }