BiTel

String query = " SELECT count(id) FROM contract_tariff_option WHERE cid = " + cid + " AND option_id = " + secondMonthOption + " AND time_to IS NULL";
      java.sql.PreparedStatement ps = con.prepareStatement( query );
      ResultSet rs = ps.executeQuery();
      while ( rs.next() )
      {
         int count  = rs.getInt(1);
         if(count > 0)
         {
            check = true;
         }
      }
      rs.close();
      ps.close();