private void displayItem()
    {
	Statement st = null;
	ResultSet rs = null;
	try {
		st = custConn.getConnection().createStatement();
		System.out.println(customerID);
		String qry = "select * from ShoppingCart sc where sc.customer_ID = '" + customerID + "'";
		rs = st.executeQuery(qry);

		while(rs.next())
		{
			System.out.println("stock number:   " + rs.getString("stock_number"));
			System.out.println("         qty:   " + rs.getInt("quantity"));
		}

	while (rs.next())
	{
		System.out.println("Shopping Cart:");
	
	}		

	} catch (Exception e) {
		System.out.println("error with sql statement");
	}
		
    }