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

public Article mergeArticle(Article article) {
return em.merge(article);
}
public void removeArticle(Article article) {
article = em.find(Article.class, article.getId());
em.remove(article);
}
public List<Article> getArticleByCriteria(String jpqlStmt,
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 Article o</code> */
public List<Article> findArticlesAll() {
return em.createNamedQuery("findArticlesAll").getResultList();
}
/** <code>select o from Article o</code> */
public List<Article> findArticlesAllByRange(int firstResult,
int maxResults) {
Query query = em.createNamedQuery("findArticlesAll");
if (firstResult > 0) {
query = query.setFirstResult(firstResult);
}
if (maxResults > 0) {
query = query.setMaxResults(maxResults);
}
return query.getResultList();
}
public Section persistSection(Section section) {
em.persist(section);
return section;
}
public Section mergeSection(Section section) {
return em.merge(section);
}
public void removeSection(Section section) {
section = em.find(Section.class, section.getId());
em.remove(section);
}
public List<Section> getSectionByCriteria(String jpqlStmt,
int firstResult,int