ExampleDAO

package com.foxconn.nwe.flex.ejb.dao.engineering;

import java.util.List;

import com.foxconn.nwe.flex.ejb.model.engineering.Example;

public interface ExampleDAO {
public Example find(int id);

public boolean insert(Example example);

public boolean update(Example example);

public boolean delete(int id);

public List<Example> list(String nweBU, String type, String subType,
String subject, String correlate, int start, int limit);

public long sum(String nweBU, String type, String subType);

public long sum(String subject, String correlate);
}

package com.foxconn.nwe.flex.ejb.dao.engineering.jpa;

import java.util.List;

import javax.ejb.Remote;
import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;

import com.foxconn.nwe.flex.ejb.dao.engineering.ExampleDAO;
import com.foxconn.nwe.flex.ejb.model.engineering.Example;

@Stateless
@Remote({ExampleDAO.class})
public class ExampleDAOBean implements ExampleDAO {

@PersistenceContext(unitName = "Oracle104PU")
private EntityManager em;

public boolean delete(int id) {
Example example = this.find(id);

if (example == null) {
return false;
} else {
try {
em.remove(example);
} catch (Exception e) {
e.printStackTrace();
return false;
}
}

return true;
}

public Example find(int id) {
return em.find(Example.class, id);
}

public boolean insert(Example example) {
if (example == null) {
return false;
} else {
try {
em.persist(example);
} catch (Exception e) {
e.printStackTrace();
return false;
}
}

return true;
}

@SuppressWarnings("unchecked")
public List<Example> list(String nweBU, String type, String subType,
String subject, String correlate, int start, int limit) {
String jpql = "select e from Example e where (e.nweBU=?1 and e.type=?2 and e.subType=?3) or (e.subject like '%"
+ subject
+ "%' and e.correlate like '%"
+ correlate
+ "%') order by e.recordDate desc";

Query query = em.createQuery(jpql);

query.setParameter(1, nweBU);
query.setParameter(2, type);
query.setParameter(3, subType);

query.setFirstResult(start);
query.setMaxResults(limit);

return query.getResultList();
}

public long sum(String nweBU, String type, String subType) {
String jpql = "select count(e) from Example e where e.nweBU=?1 and e.type=?2 and e.subType=?3";

Query query = em.createQuery(jpql);

query.setParameter(1, nweBU);
query.setParameter(2, type);
query.setParameter(3, subType);

return (Long) query.getSingleResult();
}

public long sum(String subject, String correlate) {
String jpql = "select count(e) from Example e where e.subject like '%"
+ subject + "%' and e.correlate like '%" + subject + "%'";

Query query = em.createQuery(jpql);

return (Long) query.getSingleResult();
}

public boolean update(Example example) {
if (example == null) {
return false;
} else {
try {
em.merge(example);
} catch (Exception e) {
e.printStackTrace();
return false;
}
}

return true;
}

}