public ArrayList<Pallet> getPalletsWithBlockStatus(boolean status) {
		ArrayList<Pallet> pallets = new ArrayList<Pallet>();

		String sql = 
				"Select * from Pallets where isBLocked = ? ";

		PreparedStatement ps = null;
		try {
			ps = conn.prepareStatement(sql);
			ps.setBoolean(1, status);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		try {
				ResultSet rs = ps.executeQuery();
				while (rs.next()) {
					pallets.add(extractPallet(rs));
				}
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			} finally {
				if(ps != null)
					try {
						ps.close();
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
			}
		return pallets;
	}