Using JSF with Entity Relationships - EJB 3.0 Database Persistence with Oracle Fusion Middleware 11g - page 332

int firstResult,int maxResults) {
Query query = em.createQuery(jpqlStmt);
if (firstResult > 0) {
query = query.setFirstResult(firstResult);
}
if (maxResults > 0) {
query = query.setMaxResults(maxResults);
}
return query.getResultList();
}
/** <code>select o from Edition o</code> */
public List<Edition> findEditionAll() {
return em.createNamedQuery("findEditionAll").getResultList();
}
/** <code>select o from Edition o</code> */
public List<Edition> findEditionAllByRange(int firstResult,
int maxResults) {
Query query = em.createNamedQuery("findEditionAll");
if (firstResult > 0) {
query = query.setFirstResult(firstResult);
}
if (maxResults > 0) {
query = query.setMaxResults(maxResults);
}
return query.getResultList();
}
/** <code>SELECT o from Edition o WHERE o.id = :id</code> */
public List<Edition> findEditionById(String id) {
return em.createNamedQuery("findEditionById").
setParameter("id", id).getResultList();
}
/** <code>SELECT o from Edition o WHERE o.id = :id</code> */
public List<Edition> findEditionByIdByRange(String id, int
firstResult,
int maxResults) {
Query query = em.createNamedQuery(
"findEditionById").setParameter("id",id);
if (firstResult > 0) {
query = query.setFirstResult(firstResult);
}
if (maxResults > 0) {
query = query.setMaxResults(maxResults);
}
return query.getResultList();
}
public Article persistArticle(Article article) {
em.persist(article);
return article;
}