public ArrayList getRooms(String x, String y) {
        System.out.println(x);
        System.out.println(y);
        ledig_id.clear();
        
        String SQLString =
                " SELECT BOOKING_ID, LEJLIGHED_ID, to_char(CHECK_IN_DATO, 'DD-MM-YYYY'), to_char(CHECK_OUT_DATO, 'DD-MM-YYYY') from BOOKEDE_LEJLIGHED_TBL "
                + "WHERE BOOKING_ID NOT IN("
                + "  SELECT BOOKING_ID FROM BOOKEDE_LEJLIGHED_TBL"
                + "  WHERE CHECK_IN_DATO < to_date('" + x + "','DD-MM-YYYY') AND "
                + "  CHECK_OUT_DATO      > to_date('" + x + "','DD-MM-YYYY') OR "
                + "  CHECK_IN_DATO       < to_date('" + y + "','DD-MM-YYYY') AND "
                + "  CHECK_OUT_DATO      > to_date('" + y + "','DD-MM-YYYY') OR "
                + "  CHECK_IN_DATO       > to_date('" + x + "','DD-MM-YYYY') AND "
                + "  CHECK_OUT_DATO      < to_date('" + y + "','DD-MM-YYYY') OR "
                + "  CHECK_IN_DATO       < to_date('" + x + "','DD-MM-YYYY') AND "
                + "  CHECK_OUT_DATO      > to_date('" + y + "','DD-MM-YYYY'))";
        
        
        
        PreparedStatement statement = null;
        
        try {
            statement = con.prepareStatement(SQLString);
            ResultSet rs = statement.executeQuery();
            
            while (rs.next()) {
                String BOOK_ID   = rs.getString("BOOKING_ID");
                int LEJ_ID       = rs.getInt("LEJLIGHED_ID");
                String CHECK_IND = rs.getString("CHECK_IN_DATO");
                String CHECK_UD  = rs.getString("CHECK_OUT_DATO");
                
                ledig_id.add(new Booking(BOOK_ID, LEJ_ID, CHECK_IND, CHECK_UD));               
            }
            
        }
        catch(Exception e) {
            System.out.println("Fail in Mapper - getRooms");
            System.out.println(e.getMessage());
        }
        finally
        {
            try
            {
                if (statement != null)
                {
                    statement.close();
                }
            } catch (SQLException e)
            {
                System.out.println("Fail in Mapper - getRooms");
                System.out.println(e.getMessage());
            }
        
        
        return ledig_id;
    }
}