private void deleteItem()
    {
	String stock_num = null;
	System.out.println("Type the stock number of the item you would like to delete from the cart.");
	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 sc.stock_number from ShoppingCart sc where sc.stock_number = '" + stock_num + "'";
		rs = st.executeQuery(qry);

		if (rs.next() != false)
		{
			System.out.println("How much of this item do you want to decrease?");
			Scanner in = new Scanner(System.in);
			int decreaseNum = in.nextInt();
			
			String checkQty = "select sc.quantity from ShoppingCart sc where sc.stock_number = '" + stock_num + "'";
			rs = st.executeQuery(checkQty);
			rs.next();
			int actQty = rs.getInt("quantity");
			
			if (actQty < decreaseNum)
			{
				String deleteRow = "delete from ShoppingCart sc where sc.stock_number = '" + stock_num + "'";
				rs = st.executeQuery(deleteRow);
			}
			else
			{
				int updateNum = actQty - decreaseNum;
				String updateRow = "update ShoppingCart sc set sc.quantity = " + Integer.toString(updateNum) + " where sc.stock_number = '" + stock_num + "'";
				rs = st.executeQuery(updateRow);
			}
			
		}
		else
			System.out.println("Please enter a valid stock number");
	}
	catch (Exception e) {
		System.out.println("Error");
	}

		
    }