public Map<Long, Double> findAvailability(
			final ApparelAvailSearchParams searchParams) {
		final Map<Long, Double> result = new LinkedHashMap<Long, Double>();
		try {
			boolean found = false;
			rs = stmt
					.executeQuery("SELECT store_id, price FROM Bag_Availability WHERE bag_id ="
							+ searchParams.getApparelId() + " ORDER BY price");
			while (rs.next()) {
				found = true;
				result.put(rs.getLong("store_id"), rs.getDouble("price"));
			}
			for (final String type : new String[] { "Shoes", "Clothing" }) {
				if (found) {
					return result;
				}
				final String sql = "SELECT store_id, sizes, price FROM type_Availability WHERE type_id = "
						+ searchParams.getApparelId() + " ORDER BY Price";
				rs = stmt.executeQuery(sql.replaceAll("type", type));
				while (rs.next()) {
					found = true;
					final String sizes = rs.getString("sizes");
					boolean add = false;
					if (searchParams.getSize() != null) {
						for (final String size : sizes.split(",")) {
							if (Double.valueOf(size).equals(
									searchParams.getSize())) {
								add = true;
								break;
							}
						}
					} else {
						add = true;
					}
					if (add) {
						result.put(rs.getLong("store_id"),
								rs.getDouble("price"));
					}
				}
			}
		} catch (SQLException e) {
			throw new RuntimeException(e);
		}
		return result;
	}