gistfile1.java

    public boolean checkGiftCardStatus(String code, CardStatus status) throws TestException {
        try {
            Connection conn = getCentrumConnection(SET);
            String sql = "SELECT * FROM card_cards WHERE numberfield = ? ";
            PreparedStatement st = conn.prepareStatement(sql);
            st.setString(1, code);
            ResultSet rs = st.executeQuery();
            boolean exist = false;
            while (rs.next()) {
                exist = rs.getInt("status") == status.ordinal();
            }
            return exist;
        } catch (SQLException e) {
            throw new TestException("Ошибка при получении статуса подарочной карты на сервере", e);
        }
    }