gist123.java

public List<Evaluation> findEvaluationsAssignedToUser(String login, Integer tenderId, Integer proposalId) {
        Connection connection = null;
        PreparedStatement preparedStatement = null;
        List<Evaluation> evaluations = new ArrayList<>();
        System.out.println("from EvaluationDaoImpl findEvaluationsAssignedToUser start" + evaluations);
        try {
            System.out.println("from findEvaluationsAssignedToUser page login" +login+" tenderId "+ tenderId+" proposalId "+proposalId);
            connection = ConnectionPool.getInstance().getConnection();
            preparedStatement = connection.prepareStatement(PREPARED_STATEMENT_EVALUATION_FIND_BY_USER);
            preparedStatement.setString(1, login);
            preparedStatement.setInt(2, tenderId);
            preparedStatement.setInt(3, proposalId);
            ResultSet rs = preparedStatement.executeQuery();
            System.out.println(rs.wasNull());
            while (rs.next()) {
                System.out.println("1");
                Evaluation entity = new Evaluation();
                entity.setId(Integer.parseInt(rs.getString(PARAM_ID)));
                entity.setCriteria(rs.getString(PARAM_EVALUATION_CRITERIA));
                entity.setWeight(Double.parseDouble(rs.getString(PARAM_EVALUATION_WEIGHT)));
                Tender tender = new Tender();
                tender.setTenderId(Integer.parseInt(rs.getString(PARAM_TENDER_ID)));
                entity.setTender(tender);
                evaluations.add(entity);
                System.out.println("from EvaluationDaoImpl findUserEvaluations cycle " + entity);
            }
        } catch (SQLException e) {
            logger.log(INFO, "dao exception", e);
        } catch (PoolException ex) {
            logger.log(INFO, "dao exception", ex);
        } finally {
            try {
                preparedStatement.close();
                connection.close();
            } catch (SQLException ex) {
                logger.log(INFO, "dao exception", ex);
            }
        }
        System.out.println("from EvaluationDaoImpl findUserEvaluations end " + evaluations);
        return evaluations;
    }
}