public ArrayList<Order> getAllOrders(Connection conn) {
        ArrayList<Order> orders = new ArrayList();
        ArrayList<Item> itemlist = new ArrayList();
        PreparedStatement statement = null;
        Order o = null;
        int tjek = 0;
        int orderNo = 0;
        String SQLString = "SELECT * FROM ordre NATURAL JOIN ordredetails NATURAL JOIN varer";
        try {
            statement = conn.prepareStatement(SQLString);
            ResultSet rs = statement.executeQuery();
            while (rs.next()) {
                o = getSingleOrder(orderNo = rs.getInt(2), conn);
                if (orders.isEmpty()) {
                    orders.add(o);
                } else if (orders.get(tjek).getOrderNo() != o.getOrderNo()) {
                    orders.add(o);
                    tjek++;
                }
            }
        } catch (Exception e) {
            System.out.println("Fejl i TheMapper - getAllOrders");
        }
        return orders;
    }