Paginación OracleDB con Atributos simples

Paginación con OracleDB, agregar al AbstractFacade los métodos

// <editor-fold defaultstate="collapsed" desc="List<T> sql(QuerySQL querySQL)">
    public List<T> sql(QuerySQL querySQL) {
        List<T> list = new ArrayList<>();
        try {
            Query query = getEntityManager().createQuery(querySQL.getQuery());   
            
            list = query.getResultList();
        } catch (Exception e) {
             ConsoleUtil.error(JsfUtil.nameOfMethod() + " " + e.getLocalizedMessage());
            ConsoleUtil.error(JsfUtil.nameOfMethod() + " " + e.getLocalizedMessage());
        }
        return list;

    }

    // </editor-fold>
    // <editor-fold defaultstate="collapsed" desc="List<T> pagination(Query query,Integer pageNumber,Integer rowForPage)">
    public List<T> pagination(QuerySQL querySQL, Integer pageNumber, Integer rowForPage) {
        List<T> list = new ArrayList<>();
        try {
            Query query = getEntityManager().createQuery(querySQL.getQuery());

            query.setFirstResult(pageNumber).setMaxResults(rowForPage);
            list = query.getResultList();
        } catch (Exception e) {
             ConsoleUtil.error(JsfUtil.nameOfMethod() + " " + e.getLocalizedMessage());
        }
        return list;

    }

    // </editor-fold>
    // <editor-fold defaultstate="collapsed" desc="int count(Query query)">    
    public int count(QuerySQL querySQL) {
        try {
           
            Query query = getEntityManager().createQuery(querySQL.getCount());
            return ((Long) query.getSingleResult()).intValue();

        } catch (Exception e) {
             ConsoleUtil.error(JsfUtil.nameOfMethod() + " " + e.getLocalizedMessage());
        }
        return 0;

    }
    // </editor-fold>

Last updated

Was this helpful?