private void searchPrompt()
    {
	ArrayList<String> searches = new ArrayList<String>();
	ArrayList<String> queries = new ArrayList<String>();
	
	System.out.println("Search in the form 'attribute identifier'. Press 'done' when finished with searches.");
	
	BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
	boolean continueSearch = true;
	int stringCounter = 0;
	String searchQuery = null;
	
	while (continueSearch == true)
	{
		try {
			searchQuery = br.readLine();
		} catch (IOException ioe) {
			System.out.println("Error");
		}

		if (!searchQuery.equals("done"))
		{
			searches.add(searchQuery);
			stringCounter++;
		}
		else
			continueSearch = false;
	}

	//need to modify for description
	for (int i = 0; i < stringCounter; i++)
	{
		String[] parts    = searches.get(i).split(" ");
		String attribute  = parts[0];
		String identifier = parts[1];

		String qry = " " + parts[0] + "=" + "'" + parts[1] + "'" + " ";
		queries.add(qry);
	}

	String finalQuery = "select * from Product P where";

	for (int i = 0; i < queries.size(); i++)
	{
		String queryAddition = queries.get(i);
		if (i != queries.size()-1)
			finalQuery = finalQuery + queryAddition + "AND";
		else
			finalQuery = finalQuery + queryAddition;
	}

	Statement st = null;
	ResultSet rs = null;

	System.out.println(finalQuery);

	try {
		st = custConn.getConnection().createStatement();
		rs = st.executeQuery(finalQuery);
		
		while (rs.next())
		{
			System.out.println("Product Stock number" + " " + rs.getString("stock_number"));
			System.out.println("Product Manufacturer" + " " + rs.getString("manufacturer_name"));	
		}
	} catch (Exception e) {
		System.out.println("Error executing queries");
	}

	
    }