public List<Gaest> getGaester()
    {
        Gaest gl = null;
        String SQLString =
                " select * from GAEST_TBL";
        PreparedStatement statement = null;
        List<Gaest> gaesteListe = new ArrayList<>();
        try
        {
            statement = con.prepareStatement(SQLString);
            ResultSet rs = statement.executeQuery();

            while (rs.next())
            {
                String gaeid = rs.getString("GAEST_ID");
                String fnavn = rs.getString("FORNAVN_E");
                String enavn = rs.getString("EFTERNAVN");
                int telnu    = rs.getInt("TELEFONNUMMER");
                String mail  = rs.getString("E_MAIL");
                String vnavn = rs.getString("VEJNAVN");
                int vno      = rs.getInt("VEJNUMMER");
                int pno      = rs.getInt("POSTNUMMER");
                String bnavn = rs.getString("BYNAVN");
                String land  = rs.getString("LAND");
                String rbu   = rs.getString("REJSEBUREAU");
                
                gaesteListe.add(new Gaest(gaeid,fnavn,enavn,telnu,mail,vnavn,vno,pno,bnavn,land,rbu));
            }

        } catch (SQLException e)
        {
            System.out.println("Fail in Mapper - getGæster");
            System.out.println(e.getMessage());
        } finally // must close statement
        {
            try
            {
                if (statement != null)
                {
                    statement.close();
                }
            } catch (SQLException e)
            {
                System.out.println("Fail in Mapper - getGæster");
                System.out.println(e.getMessage());
            }
        }
        return gaesteListe;
    }