Jakarta Persistence Query Language: Difference between revisions

Revision as of 10:14, 26 November 2014

Revision as of 12:02, 21 January 2015

Line 93:

public List<Author> getAuthorsByLastName(String lastName) {

String queryString = "SELECT a FROM Author a " +

"WHERE a.lastName IS NULL OR LOWER(a.lastName) = LOWER(:lastName)";

Query query = getEntityManager().createQuery(queryString);

query.setParameter("lastName", StringUtils.lowerCase(lastName));

return query.getResultList();

}