resultSet = preparedStatement.executeQuery();
List<Review> reviews = new ArrayList<Review>();
while (resultSet.next()) {
Review review = new Review();
review.setId(resultSet.getInt("id"));
review.setNotRecomend(resultSet.getBoolean("notRecomend"));
review.setRecomend(resultSet.getBoolean("recomend"));
review.setNotUsefullVotes(resultSet.getInt("notUsefull"));
review.setUsefullVotes(resultSet.getInt("usefull"));
review.setRating(resultSet.getDouble("rating"));
review.setText(resultSet.getString("text"));
review.setStatements(getStatements(review.getId()));
review.setLemma(resultSet.getString("lemma"));
reviews.add(review);
}
preparedStatement.close();
resultSet.close();