/* * D.A.O. for JPA * Created on 17 d�c. 2012 ( Time 15:40:00 ) */ package org.demo.publisher.dao; import java.util.ArrayList; import java.util.List; import javax.persistence.EntityManager; import javax.persistence.TypedQuery; import javax.persistence.criteria.CriteriaBuilder; import javax.persistence.criteria.CriteriaQuery; import javax.persistence.criteria.Predicate; import javax.persistence.criteria.Root; import org.telosys.starterkits.strutsjpa.CoreUtils; import org.telosys.starterkits.strutsjpa.GenericJpaDao; import org.demo.publisher.bean.Publisher; public class JpaPublisherDAO extends GenericJpaDao<Publisher, Integer> { private static final Predicate[] ap = {}; /** * Constructs a DAO for Publisher */ public JpaPublisherDAO() { super(Publisher.class); } /** * Search by Publisher example */ public List<Publisher> search(final Publisher element) { final EntityManager em = getEntityManager(); if ( element != null ) { CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder(); CriteriaQuery<Publisher> criteriaQuery = criteriaBuilder.createQuery(Publisher.class); Root<Publisher> from = criteriaQuery.from(Publisher.class); List<Predicate> listP = new ArrayList<Predicate>(); if (CoreUtils.isNotBlank(element.getCode())) { Predicate predicate = criteriaBuilder.equal(from.get("code"), element.getCode()); listP.add(predicate); } if (CoreUtils.isNotBlank(element.getCountryCode())) { Predicate predicate = criteriaBuilder.equal(from.get("countryCode"), element.getCountryCode()); listP.add(predicate); } if (CoreUtils.isNotBlank(element.getName())) { Predicate predicate = criteriaBuilder.equal(from.get("name"), element.getName()); listP.add(predicate); } if (CoreUtils.isNotBlank(element.getEmail())) { Predicate predicate = criteriaBuilder.equal(from.get("email"), element.getEmail()); listP.add(predicate); } if (CoreUtils.isNotBlank(element.getContact())) { Predicate predicate = criteriaBuilder.equal(from.get("contact"), element.getContact()); listP.add(predicate); } if (CoreUtils.isNotBlank(element.getCity())) { Predicate predicate = criteriaBuilder.equal(from.get("city"), element.getCity()); listP.add(predicate); } if (CoreUtils.isNotBlank(element.getZipCode())) { Predicate predicate = criteriaBuilder.equal(from.get("zipCode"), element.getZipCode()); listP.add(predicate); } if (CoreUtils.isNotBlank(element.getPhone())) { Predicate predicate = criteriaBuilder.equal(from.get("phone"), element.getPhone()); listP.add(predicate); } criteriaQuery.where(listP.toArray(ap)); TypedQuery<Publisher> tq = em.createQuery(criteriaQuery); return tq.getResultList(); } else { return this.loadAll(); } } }