public Collection<Integer> palletId(String recName) {
		PreparedStatment ps = null;
		ArrayList<Integer> ids = new ArrayList<Integer>();
		try {
			String sql = "SELECT Pallets.id AS PalletID, "
					+ "Pallets.recName FROM Pallets "
					+ "WHERE recName LIKE ‘?’";

			ps = conn.prepareStatement(sql);
			ResultSet rs = ps.executeQuery();
			while (rs.next()) {
				ids.add(PalletID);
			}
			return ids;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				ps.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}


	/**Returnerar en lista med namn på de som mottagit varan*/
	public Collection<String> String name(){
		PreparedStatment ps = null;
		ArrayList<String> names = new ArrayList<String>();
		try {
			String sql = "SELECT Pallets.customerName AS Customer, "
					+ "Pallets.recName AS Cookie, "
					+ "Pallets.id AS PalletID, "
					+ "Orders.id AS OrderID "
					+ "FROM Pallets, Orders"
					+ "WHERE Pallets.status = ‘Delivered’";

			ps = conn.prepareStatement(sql);
			ResultSet rs = ps.executeQuery);
			while (rs.next()) {
				names.add(rs.getString("Customer"));
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				ps.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}

	}


	public Collection<Integer> getPalletsCreated(String d1, String d2){ //vet inte vilka parametrar som egentligen ska in

		PreparedStatement ps = null;
		ArrayList<Map<String, String>> betweenDates = new ArrayList<Map<String, String>>();
		try{
				String sql = "SELECT * FROM Pallets WHERE "
						+ "created >= ? AND created < ?;";

				ps = conn.prepareStatement(sql);
				ps.setString(1, date1);
				ps.setString(2, date2);
				ResultSet rs = ps.executeQuery();
				while(rs.next()){
					Map<String, String> pallet = new HashMap<String, String>();
					pallet.put("id", rs.getString);
				}

				PreparedStatement ps = null;
				ArrayList<Map<String, String>> performances = new ArrayList<Map<String, String>>();
				try {
					String sql = "SELECT movieTitle, aDate, theatreName "
							+ "FROM Performances "
							+ "WHERE Performances.movieTitle = ? ";
					ps = conn.prepareStatement(sql);
					ps.setString(1, movieTitle);
					ResultSet rs = ps.executeQuery();
					while (rs.next()) {
						Map<String, String> performance = new HashMap<String, String>();
						performance.put("movie", rs.getString("movieTitle"));
						performance.put("aDate", rs.getString("aDate"));


				return idsBetweenDates;
		} catch (SQLException e) {
			e.printStackTrace();
			return null;
		} finally {
			try {
				ps.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}