/*
* 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();
}
}
}