public void sendOrder()
    {
	//query the orders table by order number
	//

	ArrayList<Item> order = new ArrayList<Item>();

	BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
	
	String commandArg = null;

	System.out.println("Please enter the name of the manufacturer.");

	String manu = "";

	try {
	    commandArg = br.readLine();
	}
	catch (IOException ioe) {
	    System.out.println("Error reading manufacturer. Exiting...");
	    System.exit(1);
	}

	manu = commandArg;

	System.out.println("Enter products in the form 'model_number quantity'. Type 'done' when finished");

	boolean continueOrder = true;
	String productQuery = "";
	ArrayList<String> products = new ArrayList<String>(); 
	int productCounter = 0;
	while (continueOrder == true)
	{
		try {
			productQuery = br.readLine();
		} catch (IOException ioe) {
			System.out.println("Error");
		}

		if (!productQuery.equals("done"))
		{
			products.add(productQuery);
			productCounter++;
		}
		else
			continueOrder = false;
	}
	//	System.out.println("oi");

	for (int i = 0; i < productCounter; i++)
	{
		String[] parts = products.get(i).split(" ");
		String modNum  = parts[0];
		int qty = Integer.parseInt(parts[1]);
		Item item = new Item(modNum, qty);
		//	System.out.println("hey");
		order.add(item);
		// String qry = " " + parts[0] + "=" + "'" + parts[1] + "'" + " ";
		// queries.add(qry);
	}
	
	ExternalWorldInterface e_w_i = new ExternalWorldInterface(custConn);

	int random1 = (int)(Math.random()*9 + 1);
	int random2 = (int)(Math.random()*9 + 1);
	int random3 = (int)(Math.random()*9 + 1);
	int random4 = (int)(Math.random()*9 + 1);
	String shipid = "111" + random4 + random3 + random2 + random1;
	String SNinsert = "INSERT INTO ShippingNotice(shipID, manufacturer) VALUES ('" + shipid + "', '" + manu + "')";
	Statement stm = null;
	ResultSet rs;
	try {
	    stm = custConn.getConnection().createStatement();
	    rs = stm.executeQuery(SNinsert);
	}
	catch (Exception e) {
	    System.out.println("Error inserting into ShippingNotice. Exiting");
	    System.exit(1);
	}
	//insert into shipped items    
	for (int i = 0; i < productCounter; i++) {
	    Item t = order.get(i);
	    
	    String SIinsert = "INSERT INTO ShippedItems(model_number, quantity, shipID) VALUES ('" + t.modNum + "', '" + t.qty + "', '" + shipid + "')"; 

	    try {
		//	Statement stt = custConn.getConnection().createStatement();
		rs = stm.executeQuery(SIinsert);
		System.out.println("inserted into shipped items");
	    } catch (Exception e) {
		System.out.println("Unable to insert into shipped items");
		System.exit(1);
	    }
        }
    
	System.out.println("Sent!");
	System.out.println("ORDER SUMMARY");
	
	System.out.println("Manufacturer: " + manu);


	for(int i = 0; i < productCounter; i++)
	{
	    Item t = order.get(i);
	    System.out.print("Item/Quantity: ");

	    System.out.println(t.modNum + "/" + t.qty);
	}

	e_w_i.receiveShippingNotice(shipid, manu, order);
	e_w_i.receiveShipment(shipid);
    }