private void addItem()
    {
	String stock_num = null;
	System.out.println("Type the stock number of the item you would like to purchase.");
	try {
		BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
		stock_num = br.readLine();
	} catch (Exception e) {
		System.out.println("error reading input");
	}

	Statement st = null;
	ResultSet rs = null;

	try {
		st = custConn.getConnection().createStatement();
		String qry = "select p.stock_number from Product p where p.stock_number = '" + stock_num + "'";
		rs = st.executeQuery(qry);
	
		if (rs.next() != false)
		{
			System.out.println("How much of this item do you want to purchase?");
			Scanner in = new Scanner(System.in);
			int num = in.nextInt();

			String priceOfItem = "select p.Price from Product p where p.stock_number= '" + stock_num + "'";
			rs = st.executeQuery(priceOfItem);

			rs.getInt("Price");

			//query price of item
			String insertData = "INSERT INTO ShoppingCart(customer_ID, stock_number, quantity)" + 
							 " VALUES('" + customerID + "','" + stock_num + "'," + num + ")";
			try {
				rs = st.executeQuery(insertData);
			} catch (Exception e) {
				System.out.println("Item already in cart");
			} //Might want to add functionality of letting a user put more of an item that's already in the cart in the cart
		}
		else
			System.out.println("Please enter a valid stock number");
		
	} catch (Exception e) {
		System.out.println("error accessing tables");
	}

	
    }