/**
* Find all News entities with a specific property value.
*
* @param propertyName the name of the News property to query
* @param value the property value to match
* @param rowStartIdxAndCount Optional int varargs. rowStartIdxAndCount[0] specifies the the row
* index in the query result-set to begin collecting the results. rowStartIdxAndCount[1]
* specifies the the maximum number of results to return.
* @return List<News> found by query
*/
@SuppressWarnings("unchecked")
public List<News> findByProperty(
String propertyName, final Object value, final int... rowStartIdxAndCount) {
LogUtil.log(
"finding News instance with property: " + propertyName + ", value: " + value,
Level.INFO,
null);
try {
final String queryString =
"select model from News model where model." + propertyName + "= :propertyValue";
Query query = entityManager.createQuery(queryString);
query.setParameter("propertyValue", value);
if (rowStartIdxAndCount != null && rowStartIdxAndCount.length > 0) {
int rowStartIdx = Math.max(0, rowStartIdxAndCount[0]);
if (rowStartIdx > 0) {
query.setFirstResult(rowStartIdx);
}
if (rowStartIdxAndCount.length > 1) {
int rowCount = Math.max(0, rowStartIdxAndCount[1]);
if (rowCount > 0) {
query.setMaxResults(rowCount);
}
}
}
return query.getResultList();
} catch (RuntimeException re) {
LogUtil.log("find by property name failed", Level.SEVERE, re);
throw re;
}
}
/**
* Deletes all Results and ResultSets of a test, selftest or survey
*
* @param olatRes
* @param olatResDet
* @param repRef
* @return deleted ResultSets
*/
public int deleteAllResults(Long olatRes, String olatResDet, Long repRef) {
StringBuilder sb = new StringBuilder();
sb.append("select rset from ").append(QTIResultSet.class.getName()).append(" as rset ");
sb.append(
" where rset.olatResource=:resId and rset.olatResourceDetail=:resSubPath and rset.repositoryRef=:repoKey ");
EntityManager em = dbInstance.getCurrentEntityManager();
List<QTIResultSet> sets =
em.createQuery(sb.toString(), QTIResultSet.class)
.setParameter("resId", olatRes)
.setParameter("resSubPath", olatResDet)
.setParameter("repoKey", repRef)
.getResultList();
StringBuilder delSb = new StringBuilder();
delSb
.append("delete from ")
.append(QTIResult.class.getName())
.append(" as res where res.resultSet.key=:setKey");
Query delResults = em.createQuery(delSb.toString());
for (QTIResultSet set : sets) {
delResults.setParameter("setKey", set.getKey()).executeUpdate();
em.remove(set);
}
return sets.size();
}
public int findUserVisitsNo(Integer userId) {
Query q = em.createNamedQuery("findUserVisitsNo");
q.setParameter("userId", userId);
int result = (int) q.getSingleResult();
return result;
}
public void _endpoint_clear_rest(CommandInterpreter commandInterpreter) {
this.em.getTransaction().begin();
Query query = this.em.createQuery("DELETE FROM RESTEndpoint");
int deletedREST = query.executeUpdate();
commandInterpreter.println("Deleted " + deletedREST + " RESTEndpoints.");
this.em.getTransaction().commit();
}
/**
* Liste aller Lehrer abfragen
*
* @return List der Lehrer
*/
@GET
public List<Lehrer> getAllLehrer() {
Log.d("Webservice Lehrer Get:");
Query query = em.createNamedQuery("findAllTeachers");
List<Lehrer> lehrer = query.getResultList();
return lehrer;
}
public Object[] readDbValueForContinentAndExpired(String isoCode) {
Query query =
this.entityManager.createNativeQuery(
"select CONTINENT, EXPIRED from " + Country.TABLE_NAME + " where ISO_CODE=?");
query.setParameter(1, isoCode);
return (Object[]) query.getSingleResult();
}
/** @return */
private ArrayList<ReferenceDataRefDataType> getUsedRefSpecialtySchemes() {
System.out.println("\n========> Getting Used specialtyscheme references");
ArrayList<ReferenceDataRefDataType> refColl = new ArrayList<ReferenceDataRefDataType>();
Query query = null;
int startRec = refDetails.getStartingRecNumber();
int maxDisplay = refDetails.getMaxRecordsToShow();
if ((refDetails.getLookupSystem().getCodeSystem() == null)
|| (refDetails.getLookupSystem().getCodeSystem().isEmpty())) {
query = em.createNamedQuery("KMSpecialty.findAllDistinctScheme");
} else {
query = em.createNamedQuery("KMSpecialty.findAllDistinctSchemeByWildcard");
query.setParameter(
"terminologyScheme", refDetails.getLookupSystem().getCodeSystem().toUpperCase() + "%");
}
query.setFirstResult(startRec);
query.setMaxResults(maxDisplay);
List<String> foundList = (List<String>) query.getResultList();
for (int r = 0; r < foundList.size(); r++) {
ReferenceDataRefDataType aRefData = new ReferenceDataRefDataType();
aRefData.setId(
0); // TODO Need to pull the ID for each one of this type from ref_specialty_type
// ..another call
aRefData.setName(foundList.get(r));
refColl.add(aRefData);
}
return refColl;
}
@Override
public List<Productos> productosLike(String par, String id) {
/* String jpql = "SELECT EX.productos FROM Existencias EX "
+ " WHERE EX.bodegas.idBodega = '59' AND EX.productos.idProducto LIKE :par"
+ " OR EX.productos.nombre LIKE :par";*/
String jpql =
"SELECT PR FROM Productos PR where PR.idProducto LIKE :par OR PR.nombre LIKE :par";
Query query = em.createQuery(jpql);
String jpql1 =
"select DISTINCT pro.IdProducto, pro.Nombre from bodegaVirtualMM vb inner join Productos pro on vb.IdProducto = pro.IdProducto and vb.IdVendedor = ? where pro.IdProducto = ? or pro.Nombre like ? ";
// String jpql1 = "select DISTINCT pro.IdProducto, pro.Nombre from bodegaVirtualMM vb inner
// join Productos pro on vb.IdProducto = pro.IdProducto and vb.IdVendedor = ? order by
// pro.Nombre";
Query query2 = em.createNativeQuery(jpql1, Productos.class);
query2.setParameter(1, id);
query2.setParameter(2, par);
query2.setParameter(3, "%" + par + "%");
// query2.setParameter(1, "%"+ par +"%");
// query2.setParameter("par", "%"+ par +"%");
productosLikeList = query2.getResultList();
return productosLikeList;
/* String jpql = "select us.UID, us.Nombre as 'NombreUsuario' , pm.Nombre as 'NombrePerfil', pm.Descripcion as 'DescripcionPerfil' ,\n" +
" am.Nombre as NombreApp, am.Descripcion as 'DescripcionMovil' , am.Logo from Usuarios us inner join PerfilesMoviles pm \n" +
"on us.IdPerfilMovil = pm.IdPerfilMovil inner join AppPorPerfiles ap on us.IdPerfilMovil = ap.IdPerfilMovil\n" +
"inner join AppMoviles am on ap.IdAppMovil = am.IdAppMovil\n" +
"where us.UID = :par" ;*/
}
/**
* 查询类别包含数量
*
* @param parentId
* @param error
* @return
*/
public static List<v_news_types> queryTypeAndCount(long parentId, ErrorInfo error) {
error.clear();
List<v_news_types> types = new ArrayList<v_news_types>();
StringBuffer sql = new StringBuffer("");
sql.append(SQLTempletes.SELECT);
sql.append(SQLTempletes.V_NEWS_TYPES);
sql.append(" and parent_id = ? and status = true order by _order");
try {
// types = v_news_types.find("parent_id = ? and status = true order by _order",
// parentId).fetch();
EntityManager em = JPA.em();
Query query = em.createNativeQuery(sql.toString(), v_news_types.class);
query.setParameter(1, parentId);
types = query.getResultList();
} catch (Exception e) {
e.printStackTrace();
error.code = -1;
error.msg = "查询类别失败";
return null;
}
error.code = 0;
return types;
}
public List<Permissao> listaPermissaoDepartamentoDisponivel(
int idDepartamento, int idNivel, String descricaoPesquisa, int idCliente) {
String queryFiltro = "";
if (!descricaoPesquisa.equals("")) {
queryFiltro = " AND UPPER(P.rotina.rotina) LIKE '%" + descricaoPesquisa.toUpperCase() + "%'";
}
try {
Query query =
getEntityManager()
.createQuery(
" SELECT P FROM Permissao AS P WHERE P.id NOT IN ( SELECT PD.permissao.id FROM PermissaoDepartamento AS PD WHERE PD.departamento.id = "
+ idDepartamento
+ " AND PD.nivel.id = "
+ idNivel
+ " AND PD.cliente.id = "
+ idCliente
+ " ) "
+ queryFiltro
+ " ORDER BY P.modulo.descricao ASC, P.rotina.rotina ASC ");
List list = query.getResultList();
if (!list.isEmpty()) {
return list;
}
} catch (Exception e) {
return new ArrayList();
}
return new ArrayList();
}
public Permissao pesquisaPermissao(int idModulo, int idRotina, int idEvento, int idCliente) {
try {
Query query =
getEntityManager()
.createQuery(
" SELECT P "
+ " FROM Permissao AS P "
+ " WHERE P.modulo.id = :modulo "
+ " AND P.rotina.id = :rotina "
+ " AND P.rotina.ativo = true "
+ " AND P.segEvento.id = :evento ");
// + " AND P.cliente.id = :cliente ");
query.setParameter("modulo", idModulo);
query.setParameter("rotina", idRotina);
query.setParameter("evento", idEvento);
// query.setParameter("cliente", idCliente);
List list = query.getResultList();
if (!list.isEmpty() && list.size() == 1) {
return (Permissao) query.getSingleResult();
}
} catch (Exception e) {
return null;
}
return null;
}
public List pesquisaPermissaDisponivel(String ids) {
String queryString;
try {
if (ids.length() == 0) {
queryString =
"SELECT P "
+ " FROM Permissao AS P "
+ " ORDER BY P.modulo.descricao ";
} else {
queryString =
"SELECT P "
+ " FROM Permissao AS P "
+ " WHERE P.id NOT IN( "
+ " SELECT PD.permissao.id "
+ " FROM PermissaoDepartamento AS PD "
+ " WHERE PD.id IN("
+ ids
+ ") "
+ " ) "
+ " ORDER BY P.modulo.descricao, "
+ " P.rotina.rotina ";
}
Query query = getEntityManager().createQuery(queryString);
List list = query.getResultList();
if (!list.isEmpty()) {
return list;
}
} catch (Exception e) {
}
return new ArrayList();
}
/**
* @param user1
* @param user2
* @return
*/
@SuppressWarnings({"unused", "unchecked", "unchecked"})
private List<ContentItem> getUserEditingInteractivity(User user1, User user2) {
List<ContentItem> result = new LinkedList<ContentItem>();
String s =
" select ci from ContentItem ci join fetch ci.resource left outer join fetch ci.textContent tc "
+ " where ci.author.login =:user1 and tc.contentItem.author.login =:user2";
javax.persistence.Query q = entityManager.createQuery(s);
q.setParameter("user1", user1.getLogin());
q.setParameter("user2", user2.getLogin());
q.setHint("org.hibernate.cacheable", true);
try {
result = (List<ContentItem>) q.getResultList();
} catch (PersistenceException ex) {
ex.printStackTrace();
log.warn("error while listing user: query failed");
}
if (result == null) {
return Collections.EMPTY_LIST;
} else {
return result;
}
}
/**
* @param user1
* @param user2
* @return
*/
@SuppressWarnings({"unused", "unchecked", "unchecked"})
private List<CommentActivity> getUserCommentInteractivity(User user1, User user2) {
List<CommentActivity> result = new LinkedList<CommentActivity>();
String s =
"select a "
+ "from CommentActivity a inner join fetch a.comment left outer join a.contentItem as cia "
+ "where cia.author = :user1 and a.comment.author = :user2";
Query q = entityManager.createQuery(s);
q.setParameter("user1", user1);
q.setParameter("user2", user2);
q.setHint("org.hibernate.cacheable", true);
try {
result = (List<CommentActivity>) q.getResultList();
} catch (PersistenceException ex) {
ex.printStackTrace();
log.warn("error while listing user: query failed");
}
if (result == null) {
return Collections.EMPTY_LIST;
} else {
return result;
}
}
@Override
public List<Korisnik> sviKorisnici() {
em.getEntityManagerFactory().getCache().evictAll();
Query q = em.createNamedQuery("Korisnik.findAll");
List<Korisnik> korisnici = q.getResultList();
return korisnici;
}
public List missingSurgeryReport(String days) {
List resultList = null;
Integer daysInteger = 0;
Date limitDate = null;
if (days != null && !days.equalsIgnoreCase("")) {
limitDate = getLimitDate(Integer.valueOf(days));
}
String hql =
"Select DISTINCT c from Client c "
+ "inner join c.colorectalCycles colorectalCycles "
+ "inner join colorectalCycles.rsdiFormPathologyReports pathologyReports "
+ "inner join pathologyReports.rsdiFormPathologyReport pathologyReport "
+ "where lower(pathologyReport.recommendedTestItem.code) like lower(:surgery) "
+ "and pathologyReport.reportCompletedDate <= :limitDate "
+ "and pathologyReport.rsdiFormClientSnapshot.clientId is not null ";
/*+ "order by colorectalcancer.createDate DESC";*/
Query q = getEntityManager().createQuery(hql);
q.setParameter("surgery", "SURGERY");
if (limitDate != null) {
q.setParameter("limitDate", limitDate);
}
resultList = q.getResultList();
return resultList;
}
@SuppressWarnings("unchecked")
public List<Category> getCategories() {
Query query =
entityManager.createQuery("SELECT c FROM " + Category.class.getSimpleName() + " c");
return (List<Category>) query.getResultList();
}
public List needPathologyReport(String days) {
List resultList = null;
Integer daysInteger = 0;
Date limitDate = null;
if (days != null && !days.equalsIgnoreCase("")) {
limitDate = getLimitDate(Integer.valueOf(days));
}
String hql =
"Select DISTINCT c from Client c "
+ "left join c.colorectalCycles colorectalCycles "
+ "left join colorectalCycles.rsdiFormColorectalCancers colorectalCancers "
+ "left join colorectalCancers.rsdiFormColorectalCancer colorectalCancer "
+ "where lower(colorectalCancer.performedBiopsyItem.code) like lower(:yes) "
+ "and colorectalCancer.performedDate >= :limitDate "
+ "and colorectalcancer.rsdiFormClientSnapshot.clientId is not null ";
/*+ "order by colorectalcancer.createDate DESC";*/
Query q = getEntityManager().createQuery(hql);
q.setParameter("surgery", "SURGERY");
if (limitDate != null) {
q.setParameter("limitDate", limitDate);
}
resultList = q.getResultList();
return resultList;
}
@TransactionAttribute(REQUIRES_NEW)
public int clearAllIndexTimes() {
Query clearIndexTimes =
em.createQuery("UPDATE DvObject o SET o.indexTime = NULL, o.permissionIndexTime = NULL");
int numRowsUpdated = clearIndexTimes.executeUpdate();
return numRowsUpdated;
}
/**
* 通过物资编码查询物资类别信息
*
* @param materialCode 物资编码 物资编码
* @return
*/
public ArrayList FindmaterialTypeBymaterialCode(String materialCode) {
ArrayList list = new ArrayList(); // 创建list
Query q =
em.createQuery(
"select p from wzMaterialRecord p where p.materialCode =:materialCode"); // 建立带有参数的查询
q.setParameter("materialCode", materialCode); // 注入查询参数
if (!q.getResultList().isEmpty()) {
wzMaterialRecord mr = (wzMaterialRecord) q.getSingleResult(); // 返回单条结果
if (mr.getMaterialOneType() != null && mr.getMaterialOneType().getOneType() != 0) {
list.add(mr.getMaterialOneType().getOneType());
} else {
list.add("");
}
if (mr.getMaterialOneType() != null && mr.getMaterialOneType().getOneTypeName() != null) {
list.add(mr.getMaterialOneType().getOneTypeName());
} else {
list.add("");
}
if (mr.getMaterialTwoType() != null && mr.getMaterialTwoType().getTwoType() != 0) {
list.add(mr.getMaterialTwoType().getTwoType());
} else {
list.add("");
}
if (mr.getMaterialTwoType() != null && mr.getMaterialTwoType().getTwoTypeName() != null) {
list.add(mr.getMaterialTwoType().getTwoTypeName());
} else {
list.add("");
}
}
return list; // 返回list
}
@Override
/** {@Inheritdoc} */
public List<RESTEndpoint> getRestEndpoints(URI anyURI, CSARID csarId) {
this.init();
ArrayList<RESTEndpoint> results = new ArrayList<RESTEndpoint>();
/**
* Create Query to retrieve RESTEndpoints identified by a URI and thorID
*
* @see RESTEndpoint#getEndpointForPath
*/
Query getRestEndpointsQuery = this.em.createNamedQuery(RESTEndpoint.getEndpointForPath);
// Set Parameters
getRestEndpointsQuery.setParameter("path", anyURI.getPath());
getRestEndpointsQuery.setParameter("csarId", csarId);
// Get Query-Results and add them to the result list
@SuppressWarnings("unchecked")
// Result can only be a RESTEndpoint
List<RESTEndpoint> queryResults = getRestEndpointsQuery.getResultList();
for (RESTEndpoint endpoint : queryResults) {
results.add(endpoint);
}
return results;
}
private void initDialog() {
initPhase = true;
cmbDaysWeeks.setModel(
new DefaultComboBoxModel(
new String[] {SYSTools.xx("misc.msg.Days"), SYSTools.xx("misc.msg.weeks")}));
cbWeightControlled.setText(
SYSTools.xx("opde.medication.medproduct.wizard.subtext.weightControlled"));
cbWeightControlled.setSelected(tradeForm.isWeightControlled());
cbExpiresAfterOpened.setText(SYSTools.xx("tradeform.subtext.expiresAfterOpenedIn"));
cbExpiresAfterOpened.setSelected(tradeForm.getDaysToExpireAfterOpened() != null);
txtExpiresIn.setEnabled(cbExpiresAfterOpened.isSelected());
cmbDaysWeeks.setEnabled(cbExpiresAfterOpened.isSelected());
Pair<Integer, Integer> pair = TradeFormTools.getExpiresIn(tradeForm);
if (pair != null) {
txtExpiresIn.setText(
pair.getFirst() > 0 ? pair.getFirst().toString() : pair.getSecond().toString());
cmbDaysWeeks.setSelectedIndex(pair.getFirst() > 0 ? 0 : 1);
}
EntityManager em = OPDE.createEM();
Query query = em.createQuery("SELECT m FROM DosageForm m ORDER BY m.preparation, m.usageText");
cmbForm.setModel(new DefaultComboBoxModel(query.getResultList().toArray(new DosageForm[] {})));
cmbForm.setRenderer(DosageFormTools.getRenderer(0));
em.close();
cmbForm.setSelectedItem(tradeForm.getDosageForm());
txtZusatz.setText(SYSTools.catchNull(tradeForm.getSubtext()));
btnAdd.setEnabled(OPDE.getAppInfo().isAllowedTo(InternalClassACL.MANAGER, "opde.medication"));
btnEdit.setEnabled(OPDE.getAppInfo().isAllowedTo(InternalClassACL.MANAGER, "opde.medication"));
initPhase = false;
}
@Override
public void printPlanEndpoints() {
this.init();
this.em.getTransaction().begin();
List<WSDLEndpoint> endpoints = null;
Query queryWSDLEndpoint = this.em.createQuery("SELECT e FROM WSDLEndpoint e");
endpoints = queryWSDLEndpoint.getResultList();
this.em.getTransaction().commit();
StringBuilder builder = new StringBuilder();
String ls = System.getProperty("line.separator");
builder.append(
"debug output for stored endpoints of management plans, flags: csarid, planid, ianame, porttype "
+ ls);
for (WSDLEndpoint endpoint : endpoints) {
builder.append(
"endpoint: "
+ endpoint.getCSARId()
+ " "
+ endpoint.getPlanId()
+ " "
+ endpoint.getIaName()
+ " "
+ endpoint.getPortType()
+ ls);
}
CoreInternalEndpointServiceImpl.LOG.debug(builder.toString());
}
public TblMaterial getBasicInfo(String noParte) {
Query query =
em.createQuery(
"SELECT c.idtblMaterial,c.noParte,c.nombre,c.descripcion,c.stock,c.costo,c.imagen, c.idArea.idArea, c.idTipomaterial.idTipomaterial,c.subFamiliasidsubFam.idsubFam, c.idArea.descripcion, c.idTipomaterial.descripcion, c.subFamiliasidsubFam.nombre FROM TblMaterial c WHERE c.noParte = :noParte");
query.setParameter("noParte", noParte);
Object[] object = (Object[]) query.getSingleResult();
TblMaterial temp = new TblMaterial();
temp.setIdtblMaterial((Integer) object[0]);
temp.setNoParte((String) (object[1]));
temp.setNombre((String) (object[2]));
temp.setDescripcion((String) (object[3]));
temp.setStock((Integer) (object[4]));
temp.setCosto((Long) (object[5]));
temp.setImagen((String) (object[6]));
TblArea area = new TblArea((Integer) (object[7]));
area.setDescripcion((String) object[10]);
temp.setIdArea(area);
TblTipomaterial tipo = new TblTipomaterial((Integer) (object[8]));
tipo.setDescripcion((String) object[11]);
temp.setIdTipomaterial(tipo);
Subfamilias sub = new Subfamilias((Integer) (object[9]));
sub.setNombre((String) object[12]);
temp.setSubFamiliasidsubFam(sub);
return temp;
}
public List<BookLending> showAllLendings(Customer customer) {
Query query = em.createNamedQuery("findLendingByCustomer");
query.setParameter("customer", customer);
List<BookLending> bookLendings = query.getResultList();
if (bookLendings.isEmpty()) return null;
return bookLendings;
}
public int count(List<Filtro> filtros) {
javax.persistence.criteria.CriteriaQuery cq =
getEntityManager().getCriteriaBuilder().createQuery();
javax.persistence.criteria.Root<BaseEntity> rt = cq.from(entityClass);
CriteriaBuilder builder = getEntityManager().getCriteriaBuilder();
if (filtros != null) {
ArrayList<Predicate> predicatesList = new ArrayList<>();
for (Filtro filtro : filtros) {
switch (filtro.getTipoFiltro()) {
case Equals:
predicatesList.add(builder.equal(rt.get(filtro.getDescricao()), filtro.getValor()));
break;
case LessEqual:
Path<Date> date = rt.get(filtro.getDescricao());
predicatesList.add(builder.lessThanOrEqualTo(date, ((Date) filtro.getValor())));
break;
case GreaterEqual:
Path<Date> date2 = rt.get(filtro.getDescricao());
predicatesList.add(builder.greaterThanOrEqualTo(date2, ((Date) filtro.getValor())));
break;
default:
predicatesList.add(builder.equal(rt.get(filtro.getDescricao()), filtro.getValor()));
break;
}
}
cq.where(predicatesList.<Predicate>toArray(new Predicate[predicatesList.size()]));
}
cq.select(builder.count(rt));
javax.persistence.Query q = getEntityManager().createQuery(cq);
return ((Long) q.getSingleResult()).intValue();
}
public int getVoteCount() {
CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
Root<Vote> rt = cq.from(Vote.class);
cq.select(em.getCriteriaBuilder().count(rt));
Query q = em.createQuery(cq);
return ((Long) q.getSingleResult()).intValue();
}
// User defined finders/Buscadores definidos por el usuario
public static Size findById(int id) throws javax.ejb.ObjectNotFoundException {
if (XavaPreferences.getInstance().isJPAPersistence()) {
javax.persistence.Query query =
org.openxava.jpa.XPersistence.getManager()
.createQuery("from Size as o where o.id = :arg0");
query.setParameter("arg0", new Integer(id));
try {
return (Size) query.getSingleResult();
} catch (Exception ex) {
// In this way in order to work with Java pre 5
if (ex.getClass().getName().equals("javax.persistence.NoResultException")) {
throw new javax.ejb.ObjectNotFoundException(
XavaResources.getString("object_not_found", "Size"));
} else {
ex.printStackTrace();
throw new RuntimeException(ex.getMessage());
}
}
} else {
org.hibernate.Query query =
org.openxava.hibernate.XHibernate.getSession()
.createQuery("from Size as o where o.id = :arg0");
query.setParameter("arg0", new Integer(id));
Size r = (Size) query.uniqueResult();
if (r == null) {
throw new javax.ejb.ObjectNotFoundException(
XavaResources.getString("object_not_found", "Size"));
}
return r;
}
}
/**
* Find all News entities.
*
* @param rowStartIdxAndCount Optional int varargs. rowStartIdxAndCount[0] specifies the the row
* index in the query result-set to begin collecting the results. rowStartIdxAndCount[1]
* specifies the the maximum count of results to return.
* @return List<News> all News entities
*/
@SuppressWarnings("unchecked")
public List<News> findAll(final int... rowStartIdxAndCount) {
LogUtil.log("finding all News instances", Level.INFO, null);
try {
final String queryString = "select model from News model";
Query query = entityManager.createQuery(queryString);
if (rowStartIdxAndCount != null && rowStartIdxAndCount.length > 0) {
int rowStartIdx = Math.max(0, rowStartIdxAndCount[0]);
if (rowStartIdx > 0) {
query.setFirstResult(rowStartIdx);
}
if (rowStartIdxAndCount.length > 1) {
int rowCount = Math.max(0, rowStartIdxAndCount[1]);
if (rowCount > 0) {
query.setMaxResults(rowCount);
}
}
}
return query.getResultList();
} catch (RuntimeException re) {
LogUtil.log("find all failed", Level.SEVERE, re);
throw re;
}
}
@SuppressWarnings("unchecked")
@Override
public List<Banda> buscarTodos() {
String jpql = "SELECT x FROM Banda x";
Query query = em.createQuery(jpql);
return query.getResultList();
}