public static void printAll()
	{
		try
		{
			PreparedStatement stmt = Main.EMART_CONNECTION.prepareStatement("select * " +
					"from ReplenishmentOrder");
			ResultSet rs = stmt.executeQuery();
			System.out.println("Replenishment Order:");
			while (rs.next())
			{
				System.out.println(rs.getInt("order_id") + "|" + rs.getString("mname"));
				System.out.println("in order:");
				PreparedStatement ordstmt = Main.EMART_CONNECTION.prepareStatement("select order_id, stock_number, amount from InReplenishmentOrder where order_id = ?");
				ordstmt.setString(1, rs.getString("order_id"));
				ResultSet ordrs = ordstmt.executeQuery();
				while (ordrs.next())
				{
					System.out.println(ordrs.getString("order_id") + "|" + ordrs.getString("stock_number")
							+ "|" + ordrs.getString("amount"));
				}
			}
		} catch (SQLException e)
		{
			e.printStackTrace();
		}
	}