@SuppressWarnings("unchecked") public static List<Object> listCurrentRecords(int objectType) { // TODO by the candidate /* * This method is called when you open any list screen and should return * all records of the specified type */ Session session = sessionFactory.getCurrentSession(); List<Object> objList = new ArrayList<Object>(); try { session.beginTransaction(); switch (objectType) { case TYPE_CUSTOMER: objList = session.createCriteria(Customer.class).list(); break; case TYPE_PRODUCT: objList = session.createCriteria(Product.class).list(); break; case TYPE_SALESORDER: Set<SalesOrder> set = new HashSet<SalesOrder>(session.createCriteria(SalesOrder.class).list()); objList = new ArrayList<Object>(set); break; default: break; } session.getTransaction().commit(); } catch (HibernateException e) { logger.error("Error while retrieving records", e); session.getTransaction().rollback(); } return objList; }
public List getWeblogEntries(WeblogCategoryData cat, boolean subcats) throws RollerException { try { Session session = ((HibernatePersistenceStrategy) this.strategy).getSession(); List entries = new LinkedList(); if (subcats) { // Get entries in subcategories Criteria assocsQuery = session.createCriteria(WeblogCategoryAssoc.class); assocsQuery.add(Expression.eq("ancestorCategory", cat)); Iterator assocs = assocsQuery.list().iterator(); while (assocs.hasNext()) { WeblogCategoryAssoc assoc = (WeblogCategoryAssoc) assocs.next(); Criteria entriesQuery = session.createCriteria(WeblogEntryData.class); entriesQuery.add(Expression.eq("category", assoc.getCategory())); Iterator entryIter = entriesQuery.list().iterator(); while (entryIter.hasNext()) { WeblogEntryData entry = (WeblogEntryData) entryIter.next(); entries.add(entry); } } } // Get entries in category Criteria entriesQuery = session.createCriteria(WeblogEntryData.class); entriesQuery.add(Expression.eq("category", cat)); Iterator entryIter = entriesQuery.list().iterator(); while (entryIter.hasNext()) { WeblogEntryData entry = (WeblogEntryData) entryIter.next(); entries.add(entry); } return entries; } catch (HibernateException e) { throw new RollerException(e); } }
@Test public void testSimpleCrossTxnWork() { Session session1 = injector.getInstance(SessionFactory.class).openSession(); ManagedSessionContext.bind(session1); HibernateTestEntity entity = injector .getInstance(ManualLocalTransactionsWithCustomMatchersTest.TransactionalObject.class) .runOperationInTxn(); injector .getInstance(ManualLocalTransactionsWithCustomMatchersTest.TransactionalObject.class) .runOperationInTxn2(); assert injector.getInstance(Session.class).contains(entity) : "Session appears to have been closed across txns!"; session1.close(); // try to query them back out Session session = injector.getInstance(SessionFactory.class).openSession(); assert null != session .createCriteria(HibernateTestEntity.class) .add(Expression.eq("text", UNIQUE_TEXT)) .uniqueResult(); assert null != session .createCriteria(HibernateTestEntity.class) .add(Expression.eq("text", UNIQUE_TEXT_2)) .uniqueResult(); session.close(); }
public ArrayList<Candidate> getNumOfCandidateConstituency(Long constituency, String elecid) { Session session = null; ArrayList<String> numcon = new ArrayList<String>(); ArrayList<Candidate> numcan = new ArrayList<Candidate>(); Criteria ctr; try { session = getSessionFactory().openSession(); ctr = session.createCriteria(Locations.class); ctr.add(Restrictions.eq("elecid", elecid)); ctr.add(Restrictions.eq("constituency", constituency)); if (ctr.list().size() > 0) { ctr = session.createCriteria(Candidate.class); ctr.add(Restrictions.eq("constituency", constituency)); ctr.add(Restrictions.eq("validity", Candidate.ACCEPTED)); for (int i = 0; ctr.list().size() > 0 && i < ctr.list().size(); i++) numcan.add((Candidate) ctr.list().get(i)); } } catch (HibernateException e) { System.err.println("Error: file: LocationsDAO method: getNumOfCOnsti()"); } finally { if (session != null) session.close(); } return numcan; }
@Test @TestForIssue(jiraKey = "HHH-7767") public void testCriteriaRestrictionOnIdManyToOne() { Session s = openSession(); s.beginTransaction(); s.createQuery("from Course c join c.students cs join cs.student s where s.name = 'Foo'").list(); Criteria criteria = s.createCriteria(Course.class); criteria .createCriteria("students") .createCriteria("student") .add(Restrictions.eq("name", "Foo")); criteria.list(); Criteria criteria2 = s.createCriteria(Course.class); criteria2.createAlias("students", "cs"); criteria2.add(Restrictions.eq("cs.value", "Bar")); criteria2.createAlias("cs.student", "s"); criteria2.add(Restrictions.eq("s.name", "Foo")); criteria2.list(); s.getTransaction().commit(); s.close(); }
@SuppressWarnings("unchecked") public List<Dap> getDaps() { if (dapExample != null) { Example example = Example.create(dapExample).excludeFalse().ignoreCase().enableLike(MatchMode.ANYWHERE); return session.createCriteria(Dap.class).add(example).list(); } else if (searchText != null && searchText.trim().length() > 0) { FullTextSession fullTextSession = Search.getFullTextSession(sessionManager.getSession()); try { fullTextSession.createIndexer().startAndWait(); } catch (java.lang.InterruptedException e) { logger.warn("Lucene Indexing was interrupted by something " + e); } QueryBuilder qb = fullTextSession.getSearchFactory().buildQueryBuilder().forEntity(Dap.class).get(); org.apache.lucene.search.Query luceneQuery = qb.keyword().onFields("name").matching(searchText).createQuery(); return fullTextSession.createFullTextQuery(luceneQuery, Dap.class).list(); } else { // default - unfiltered - all entitites list return session.createCriteria(Dap.class).list(); } }
@GET @SuppressWarnings("unchecked") public ResultList<InfoClinica> list( @QueryParam("count") Integer count, @QueryParam("page") Integer page, @QueryParam("search.valor") String valor) { Session session = (Session) em.getDelegate(); Criteria criteria = session.createCriteria(getType()); Criteria countCriteria = session.createCriteria(getType()); criteria.addOrder(Order.asc("valor")); if (count != null) { criteria.setMaxResults(count); } if (count != null && page != null) { criteria.setFirstResult((page - 1) * count); } if (valor != null) { criteria.add(Restrictions.ilike("nome", valor, ANYWHERE)); countCriteria.add(Restrictions.ilike("nome", valor, ANYWHERE)); } List<InfoClinica> list = criteria.list(); Long totalResults = (Long) countCriteria.setProjection(Projections.rowCount()).uniqueResult(); return new ResultList<>(list, page, count, totalResults.intValue()); }
public ArrayList<Election> getElectionByConstituency(Long constituency) { Session session = null; ArrayList<Election> eleclist = new ArrayList<Election>(); Criteria ctr, tempctr; try { session = getSessionFactory().openSession(); ctr = session.createCriteria(Locations.class); ctr.add(Restrictions.eq("constituency", constituency)); for (int i = 0; ctr.list().size() > 0 && i < ctr.list().size(); i++) { tempctr = session.createCriteria(Election.class); tempctr.add(Restrictions.eq("validity", Election.NOTDONE)); tempctr.add(Restrictions.idEq(((Locations) ctr.list().get(i)).getElecid())); tempctr.add(Restrictions.le("start", new Timestamp(new Date().getTime()))); tempctr.add(Restrictions.ge("end", new Timestamp(new Date().getTime()))); if (tempctr.list().size() > 0) eleclist.add((Election) tempctr.list().get(0)); } } catch (HibernateException e) { System.err.println("Error: file: LocationsDAO method: getNumOfCOnsti()"); } finally { if (session != null) session.close(); } return eleclist; }
/** * prepare query based on criteria * * @param session hib session * @return the query */ private Criteria attachCriteriaInfo(Session session) { Criteria query = null; if (StringUtils.isBlank(this.entityName)) { if (StringUtils.isBlank(this.alias)) { query = session.createCriteria(this.persistentClass); } else { query = session.createCriteria(this.persistentClass, alias); } } else { query = session.createCriteria(this.entityName); } // add criterions if (this.criterions != null) { query.add(this.criterions); } boolean secondLevelCaching = HibUtils.secondLevelCaching( ByCriteriaStatic.this.cacheable, ByCriteriaStatic.this.queryOptions); query.setCacheable(secondLevelCaching); if (secondLevelCaching) { String secondLevelCacheRegion = HibUtils.secondLevelCacheRegion( ByCriteriaStatic.this.cacheRegion, ByCriteriaStatic.this.queryOptions); if (!StringUtils.isBlank(secondLevelCacheRegion)) { query.setCacheRegion(secondLevelCacheRegion); } } QuerySort querySort = this.queryOptions == null ? null : this.queryOptions.getQuerySort(); if (querySort != null) { List<QuerySortField> sorts = querySort.getQuerySortFields(); for (QuerySortField theSort : GrouperUtil.nonNull(sorts)) { Order order = theSort.isAscending() ? Order.asc(theSort.getColumn()) : Order.desc(theSort.getColumn()); query.addOrder(order); } } QueryPaging queryPaging = this.queryOptions == null ? null : this.queryOptions.getQueryPaging(); if (queryPaging != null) { // GRP-1024: sql server problems with paging page number when not initted if (queryPaging.getFirstIndexOnPage() < 0) { query.setFirstResult(0); } else { query.setFirstResult(queryPaging.getFirstIndexOnPage()); } query.setMaxResults(queryPaging.getPageSize()); } return query; }
@Scheduled(fixedDelay = 60000) public void changeSessionStatus() { List<CurrentUsersDTO> allList = null; List<CurrentUsersDTO> activeList = null; String currentTime = getTime(); String beforeTime = getBeforeTime(); String beforeHeartBeatTime = getBeforeHeartBeatTime(); Session session = getSession(); session.getTransaction().begin(); Criteria criteria = session .createCriteria(SessionDetails.class, "sessionDetails") .add( Restrictions.between( "sessionDetails.heartBeatTime", beforeHeartBeatTime, currentTime)) .add(Restrictions.between("sessionDetails.lastAccessTime", beforeTime, currentTime)); criteria.addOrder(Order.asc("SID")); criteria.setProjection( Projections.projectionList() .add(Projections.property("SID").as("sid")) .add(Projections.property("lastAccessTime").as("lastAccessTime"))); activeList = criteria.setResultTransformer(Transformers.aliasToBean(CurrentUsersDTO.class)).list(); Criteria criteria1 = session.createCriteria(SessionDetails.class, "sessionDetails"); criteria1.addOrder(Order.asc("SID")); criteria1.setProjection( Projections.projectionList() .add(Projections.property("SID").as("sid")) .add(Projections.property("lastAccessTime").as("lastAccessTime"))); allList = criteria1.setResultTransformer(Transformers.aliasToBean(CurrentUsersDTO.class)).list(); for (CurrentUsersDTO dto : allList) { try { SessionDetails sd = getById(dto.getSid()); sd.setStatus("INACTIVE"); saveSessionDetails(sd); } catch (Exception e) { System.out.println("E :" + e); } } for (CurrentUsersDTO dto : activeList) { try { SessionDetails sd = getById(dto.getSid()); sd.setStatus("ACTIVE"); saveSessionDetails(sd); } catch (Exception e) { System.out.println("E :" + e); } } session.getTransaction().commit(); session.close(); }
@GlobalDBOpenCloseAndUserPrivilages public Map getUserTypeSize( Session session, HttpServletRequest request, HttpServletResponse response, String LoggedInRegion, String LoggedInUser) { Map resultMap = new HashMap(); String isAccountModule = "No"; Map financialYearMap = new LinkedHashMap(); financialYearMap.put("0", "--Select--"); UserViewModel userObj = (UserViewModel) request.getSession(false).getAttribute("userDetails"); Criteria rcCriteria = session.createCriteria(Useroperatingrights.class); rcCriteria.add(Restrictions.sqlRestriction("userid = '" + userObj.getUserid() + "'")); rcCriteria.add(Restrictions.sqlRestriction("accessright is true")); rcCriteria.addOrder(Order.asc("usertypeid")); List rcList = rcCriteria.list(); resultMap.put("typesize", rcList.size()); Criteria fyearsCriteria = session.createCriteria(Accountingyear.class); List fyearsList = fyearsCriteria.list(); if (fyearsList.size() > 0) { for (int i = 0; i < fyearsList.size(); i++) { Accountingyear accountingyearObj = (Accountingyear) fyearsList.get(i); financialYearMap.put( accountingyearObj.getId(), (accountingyearObj.getStartyear() + "-" + accountingyearObj.getEndyear())); } } resultMap.put("financialYearMap", financialYearMap); if (rcList.size() == 1) { Useroperatingrights useroperatingrightsObj = (Useroperatingrights) rcList.get(0); Criteria privileageCriteria = session.createCriteria(Menuprivilages.class); privileageCriteria.add( Restrictions.sqlRestriction("usertype = " + useroperatingrightsObj.getUsertypeid())); privileageCriteria.add(Restrictions.sqlRestriction("accessright is true")); List privileageList = privileageCriteria.list(); if (privileageList.size() > 0) { for (int j = 0; j < privileageList.size(); j++) { Menuprivilages menuprivilagesObj = (Menuprivilages) privileageList.get(j); // // System.out.println("menuprivilagesObj.getMenumaster().getGrouptype()==" + // menuprivilagesObj.getMenumaster().getGrouptype()); if (menuprivilagesObj.getMenumaster().getGrouptype() == null) { } else if (menuprivilagesObj.getMenumaster().getGrouptype() == 'A') { isAccountModule = "Yes"; break; } } } } resultMap.put("isAccountModule", isAccountModule); return resultMap; }
@Override public Query createQuery(Class type, String alias) { final PersistentEntity persistentEntity = getMappingContext().getPersistentEntity(type.getName()); Session currentSession = getHibernateTemplate().getSessionFactory().getCurrentSession(); final Criteria criteria = alias != null ? currentSession.createCriteria(type, alias) : currentSession.createCriteria(type); getHibernateTemplate().applySettings(criteria); return new HibernateQuery(criteria, this, persistentEntity); }
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods. * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); try { String su = request.getParameter("subid"); int i = 1; Session s = NewHibernateUtil.getSessionFactory().openSession(); Transaction t = s.beginTransaction(); Criteria cr = s.createCriteria(Subject.class); cr.add(Restrictions.eq("idsubject", Integer.parseInt(su))); Subject sab = (Subject) cr.uniqueResult(); Subject subt = (Subject) s.load(Subject.class, sab.getIdsubject()); Criteria c = s.createCriteria(School.class); c.add(Restrictions.eq("subject", subt)); JSONArray json = new JSONArray(); Map m = new HashMap(); List<School> list = c.list(); for (School school : list) { m.put("schoolName", school.getSchoolName()); m.put("grade11", school.getGrade11()); m.put("grade10", school.getGrade10()); m.put("grade9", school.getGrade9()); m.put("subject", school.getSubject().getSubjectName()); json.add(m); m = null; m = new HashMap(); out.write(json.toJSONString()); // out.write("<tr>" + school.getSchoolName() + "</tr>"); // out.write("<tr>" + school.getGrade11() + "</tr>"); // out.write("<tr>" + school.getGrade10() + "</tr>"); // out.write("<tr>" + school.getGrade9() + "</tr>"); // out.write("<tr>" + school.getSubject().getSubjectName() + "</tr>"); } } catch (Exception e) { throw new ServletException(e); } }
protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); HttpSession httpSession = request.getSession(); String answer; Session hibSession = HibernateUtil.getSession(); hibSession.beginTransaction(); int param1 = Integer.parseInt(request.getParameter("param1")); List clients = hibSession.createCriteria(Client.class).add(Restrictions.eq("client_id", param1)).list(); Client client = (Client) clients.get(0); List agreements = hibSession.createCriteria(Agreement.class).add(Restrictions.eq("client", client)).list(); Collections.sort( agreements, new Comparator<Agreement>() { @Override public int compare(Agreement lhs, Agreement rhs) { return -1 * lhs.getDate_written().compareTo(rhs.getDate_written()); } }); List payments = hibSession.createCriteria(Payment.class).add(Restrictions.eq("client", client)).list(); Collections.sort( payments, new Comparator<Payment>() { @Override public int compare(Payment lhs, Payment rhs) { return -1 * lhs.getPaym_date().compareTo(rhs.getPaym_date()); } }); Gson gson = new Gson(); String jsonClient = gson.toJson(clients.get(0), Client.class); String jsonAgreements = gson.toJson(agreements); String jsonPayments = gson.toJson(payments); answer = "{ \"client\" : " + jsonClient + ", " + "\"agreements\" : " + jsonAgreements + ", " + "\"payments\" : " + jsonPayments + "}"; hibSession.beginTransaction().commit(); hibSession.close(); if (clients.size() != 1) answer = FAILURE; response.getWriter().write(answer); }
/** * Tìm kiếm nhanh * * @param idHangDienThoai id của HangDienThoai. * @param ten tên DienThoai. * @param giaTu giá chặn dưới. * @param giaDen giá chặn trên. * @return Danh sách DienThoai thỏa tiêu chí tìm kiếm. */ @SuppressWarnings("unchecked") public List<DienThoai> quickSearch(int idHangDienThoai, String ten, double giaTu, double giaDen) { Session session = factory.getCurrentSession(); Criteria criteria = session.createCriteria(DienThoai.class); if (idHangDienThoai > 0) { Criterion manufacture = Restrictions.eq("hangDienThoai.id", idHangDienThoai); criteria.add(manufacture); } if (ten != null) { Criterion name = Restrictions.like("ten", "%" + ten + "%"); criteria.add(name); } if (giaTu >= 0.0) { Criterion minPrice = Restrictions.ge("giaHienHanh", giaTu); criteria.add(minPrice); } if (giaDen >= 0.0) { Criterion maxPrice = Restrictions.le("giaHienHanh", giaDen); criteria.add(maxPrice); } criteria.add(Restrictions.eq("xoa", false)); return criteria.list(); }
public static Group findByOrgAndName(Organisation org, String name, Session session) { Criteria crit = session.createCriteria(Group.class); crit.setCacheable(true); crit.add(Restrictions.eq("organisation", org)); crit.add(Restrictions.eq("name", name)); return (Group) crit.uniqueResult(); }
public static List<Group> findByOrg(Organisation org, Session session) { Criteria crit = session.createCriteria(Group.class); crit.setCacheable(true); crit.add(Restrictions.eq("organisation", org)); crit.addOrder(Order.asc("name")); return DbUtils.toList(crit, Group.class); }
public List getAll() { List values = null; Session session = getSession(); Criteria allValues = session.createCriteria(CorporateRegistrationSchemeType.class); values = allValues.list(); return values; }
public List<Consulta> pesquisarTodosConsultaData(Date data) throws Exception { List<Consulta> lista = null; Criteria cr = session.createCriteria(Consulta.class).add(Restrictions.eq("dataConsulta", data)); lista = (ArrayList) cr.list(); closeSession(); return lista; }
public List<Consulta> pesquisarTodosConsulta() throws Exception { List<Consulta> lista = null; Criteria cr = session.createCriteria(Consulta.class); lista = (ArrayList) cr.list(); closeSession(); return lista; }
// 此方法用于动态条件查询 public Collection find(Product product) throws ManagerProductException { Session session = null; Transaction tran = null; Collection list = null; try { session = HibernateUtils.getSession(); tran = session.beginTransaction(); Criteria crit = session.createCriteria(Product.class); if (product.getAuthor().equals("")) { crit.add(Restrictions.like("author", "%")); } else { crit.add(Restrictions.like("author", "%" + product.getAuthor() + "%")); } if (product.getName().equals("")) { crit.add(Restrictions.like("name", "%")); } else { crit.add(Restrictions.like("name", "%" + product.getName() + "%")); } if (product.getPublish().equals("")) { crit.add(Restrictions.like("publish", "%")); } else { crit.add(Restrictions.like("publish", "%" + product.getPublish() + "%")); } list = crit.list(); tran.commit(); } catch (Exception e) { e.printStackTrace(); tran.rollback(); } finally { session.close(); return list; } }
/** * Tìm kiếm nhanh * * @param c Tiêu chí tìm kiếm * @return Danh sách các điện thoại thỏa tiêu chí tìm kiếm */ @SuppressWarnings("unchecked") public List<DienThoai> quickSearch(QuickSearchCriteria c) { Session session = factory.getCurrentSession(); Criteria criteria = session.createCriteria(DienThoai.class); if (c.getIdHangDienThoai() > 0) { Criterion manufacture = Restrictions.eq("hangDienThoai.id", c.getIdHangDienThoai()); criteria.add(manufacture); } if (c.getTenDienThoai() != null) { Criterion name = Restrictions.like("ten", "%" + c.getTenDienThoai() + "%"); criteria.add(name); } if (c.getGiaTu() >= 0.0) { Criterion minPrice = Restrictions.ge("giaHienHanh", c.getGiaTu()); criteria.add(minPrice); } if (c.getGiaDen() >= 0.0) { Criterion maxPrice = Restrictions.le("giaHienHanh", c.getGiaDen()); criteria.add(maxPrice); } criteria.add(Restrictions.eq("xoa", false)); return criteria.list(); }
public User getDetail(String login, Session session) { Criteria criteria = session.createCriteria(User.class); criteria.add(Restrictions.eq("login", login)); User user = (User) criteria.uniqueResult(); return user; }
public static void main(String[] args) { System.out.println("Testing Hibernate Utility Class"); Session session = HibernateUtil.getSessionFactory().openSession(); session.beginTransaction(); Profile u = new Profile(); u.setCreateDate(new Date()); u.setFirstName("firstName"); u.setLastName("lastNAme"); u.setPassword("password1"); session.save(u); u = new Profile(); u.setCreateDate(new Date()); u.setFirstName("firstName"); u.setLastName("lastNAme"); u.setPassword("password1"); session.save(u); List all = session.createCriteria(Profile.class).list(); System.out.println(all); // session.delete(cat); session.getTransaction().commit(); }
@Override public List<Role> getAllRoles() { Session session = SessionFactoryProvider.getSessionFactory().openSession(); Transaction tx = null; List<Role> allRoles = new ArrayList<Role>(); try { tx = session.beginTransaction(); Criteria criteria = session.createCriteria(Role.class); List<Role> roles = criteria.list(); for (Role r : roles) { allRoles.add(r); } tx.commit(); } catch (HibernateException e) { if (tx != null) { e.printStackTrace(); } } finally { session.close(); } return allRoles; }
public Collection getAllRateCodes(int tdspId) { /** * Requires - Modifies - Effects - * * @throws - */ Criteria objCriteria = null; Session objSession = null; List objList = null; try { logger.info("GETTING ALL RATE CODES BY TDSP ID"); objSession = HibernateUtil.getSession(); objCriteria = objSession .createCriteria(RateCodesVO.class) .add(Restrictions.eq("tdsp.tdspIdentifier", new Integer(tdspId))); objCriteria.addOrder(Order.asc("rateCode")); objList = objCriteria.list(); logger.info("GOT ALL RATE CODES BY TDSP ID"); } catch (HibernateException e) { logger.error("HIBERNATE EXCEPTION DURING GET ALL RATE CODES BY TDSP ID", e); e.printStackTrace(); } finally { if (objSession != null) { objSession.close(); } } return objList; }
public HashMap getAllRateCodes() { /** * Requires - Modifies - Effects - * * @throws - */ Criteria objCriteria = null; Session objSession = null; Integer totRecordCount = null; List objList = null; HashMap hmResult = new HashMap(); try { logger.info("GETTING ALL RATE CODES"); objSession = HibernateUtil.getSession(); objCriteria = objSession.createCriteria(RateCodesVO.class); totRecordCount = new Integer(objCriteria.list().size()); objList = objCriteria.list(); hmResult.put("TotalRecordCount", totRecordCount); hmResult.put("Records", objList); logger.info("GOT ALL RATE CODES"); } catch (HibernateException e) { logger.error("HIBERNATE EXCEPTION DURING GET ALL RATE CODES", e); e.printStackTrace(); } finally { if (objSession != null) { objSession.close(); } } return hmResult; }
public List<Consulta> pesquisarConsultaPorPaciente(Paciente paciente) throws Exception { List<Consulta> lista = null; Criteria cr = session.createCriteria(Consulta.class).add(Restrictions.eq("paciente", paciente)); lista = (ArrayList) cr.list(); closeSession(); return lista; }
@Override public List<Statistics> getByBookId(int id) { Session session = sessionFactory.getCurrentSession(); Criteria criteria = session.createCriteria(Statistics.class); List<Statistics> statistics = criteria.add(Restrictions.eq("book.id", id)).list(); return statistics; }
public Consulta pesquisarConsultaPorId(long id) throws Exception { Consulta c = new Consulta(); Criteria cr = session.createCriteria(Consulta.class).add(Restrictions.eq("idConsulta", id)); c = (Consulta) cr.uniqueResult(); closeSession(); return c; }