public static void printAll()
	{
		try
		{

			PreparedStatement stmt = Main.EMART_CONNECTION.prepareStatement("select * from sale");
			ResultSet rs = stmt.executeQuery();
			System.out.println("Orders:");
			while (rs.next())
			{
				System.out.println("Order:");
				System.out.println(rs.getString("order_id") + " | " + rs.getString("cid") + " | " + rs.getDouble("total") + " | " + rs.getTimestamp("tstmp"));
				System.out.println("ordered items:");
				PreparedStatement desstmt = Main.EMART_CONNECTION.prepareStatement("select * from ordereditem where order_id = ?");
				desstmt.setString(1, rs.getString("order_id"));
				ResultSet desrs = desstmt.executeQuery();
				while (desrs.next())
				{
					System.out.println(desrs.getString("stock_number") + ": " + desrs.getInt("amount") + " $" + desrs.getDouble("item_total"));
				}
			}
		} catch (SQLException e)
		{
			e.printStackTrace();
		}
	}