List of usage examples for org.hibernate.criterion Projections max
public static AggregateProjection max(String propertyName)
From source file:calculatefactorrisk.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods.//w ww .j a v a2 s . c om * * @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"); try (PrintWriter out = response.getWriter()) { /* TODO output your page here. You may use following sample code. */ SessionFactory sf = HibernateUtil.getSessionFactory(); Session ss = sf.openSession(); Transaction tr = ss.beginTransaction(); HttpSession hs = request.getSession(); if (hs.getAttribute("patient") != null) { Patient p1 = (Patient) hs.getAttribute("patient"); int metervalue = 0; double rmetervalue = 0; int facindex = 0; int points = 0; String[] chartdata = new String[4]; chartdata[0] = "5"; chartdata[1] = "12"; chartdata[2] = "25"; chartdata[3] = "60"; ArrayList<PatientfactorAnswer> finalans = new ArrayList<PatientfactorAnswer>(); if (request.getParameter("facindex") != null && request.getParameter("ans") != null) { if (hs.getAttribute("metervalue") != null) { metervalue = (Integer) hs.getAttribute("metervalue"); } if (hs.getAttribute("finalans") != null) { finalans = (ArrayList<PatientfactorAnswer>) hs.getAttribute("finalans"); } if (request.getParameter("ans").equals("15")) { hs.setAttribute("gender", "MALE"); hs.setAttribute("agefactor", null); } if (request.getParameter("ans").equals("16")) { hs.setAttribute("gender", "FEMALE"); hs.setAttribute("agefactor", null); } facindex = Integer.parseInt(request.getParameter("facindex")); if (request.getParameter("next") != null) { int ansid = Integer.parseInt(request.getParameter("ans")); FactorOption ansfo = (FactorOption) ss.get(FactorOption.class, ansid); if (ansfo.getFactorId().equals(new FactorDetails(2))) { hs.setAttribute("agefactor", ansfo); } PatientfactorAnswer currentans = new PatientfactorAnswer(); currentans.setFactorId(ansfo.getFactorId()); currentans.setFactorOptionId(ansfo); currentans.setPId(p1); if (finalans.size() > 0) { ArrayList<PatientfactorAnswer> finalans1 = finalans; for (int i1 = 0; i1 < finalans1.size(); i1++) { PatientfactorAnswer c1 = finalans.get(i1); if (c1.getFactorId().equals(currentans.getFactorId())) { finalans.remove(i1); } } } finalans.add(facindex, currentans); // System.out.println(finalans.get(0).getFactorOptionId()); // System.out.println(finalans.get(1).getFactorOptionId()); // System.out.println(finalans.get(2).getFactorOptionId()); System.out.println("size : " + finalans.size()); facindex = facindex + 1; } else if (request.getParameter("prev") != null) { if (facindex > 0) { facindex = facindex - 1; } } if (finalans.size() > 0) { String gender = "MALE"; if (hs.getAttribute("gender") != null) { gender = (String) hs.getAttribute("gender"); } if (gender.equals("MALE") && hs.getAttribute("agefactor") != null) { FactorOption agefac = (FactorOption) hs.getAttribute("agefactor"); for (PatientfactorAnswer c1 : finalans) { points = points + c1.getFactorOptionId().getMen(); } if (points < 0) { points = 0; } if (points > 14) { points = 14; } // Count risk on point Criteria cr2 = ss.createCriteria(AbsulateRiskMale.class); cr2.add(Restrictions.eq("foptionid", agefac)); cr2.add(Restrictions.eq("point", points)); ArrayList<AbsulateRiskMale> riskdata = (ArrayList<AbsulateRiskMale>) cr2.list(); if (riskdata.size() > 0) { AbsulateRiskMale risk = riskdata.get(0); if (risk.getGreen() != null) { metervalue = risk.getGreen(); } else if (risk.getViolet() != null) { metervalue = risk.getViolet(); } else if (risk.getYellow() != null) { metervalue = risk.getYellow(); } else if (risk.getRed() != null) { metervalue = risk.getRed(); } if (risk.getRGreen() != null) { rmetervalue = risk.getRGreen(); } else if (risk.getRViolet() != null) { rmetervalue = risk.getRViolet(); } else if (risk.getRYellow() != null) { rmetervalue = risk.getRYellow(); } else if (risk.getRRed() != null) { rmetervalue = risk.getRRed(); } // System.out.println("Risk data : " + risk); } System.out.println("Meter value : " + metervalue); System.out.println("RMeter value : " + rmetervalue); // Set Chart Data Criteria cr01 = ss.createCriteria(AbsulateRiskMale.class); cr01.add(Restrictions.eq("foptionid", agefac)); cr01.setProjection(Projections.max("green")); if (cr01.uniqueResult() != null) { chartdata[0] = cr01.uniqueResult().toString(); } Criteria cr02 = ss.createCriteria(AbsulateRiskMale.class); cr02.add(Restrictions.eq("foptionid", agefac)); cr02.setProjection(Projections.max("violet")); if (cr02.uniqueResult() != null) { chartdata[1] = cr02.uniqueResult().toString(); } Criteria cr03 = ss.createCriteria(AbsulateRiskMale.class); cr03.add(Restrictions.eq("foptionid", agefac)); cr03.setProjection(Projections.max("yellow")); if (cr03.uniqueResult() != null) { chartdata[2] = cr03.uniqueResult().toString(); } chartdata[3] = "54"; } if (gender.equals("FEMALE") && hs.getAttribute("agefactor") != null) { FactorOption agefac = (FactorOption) hs.getAttribute("agefactor"); for (PatientfactorAnswer c1 : finalans) { points = points + c1.getFactorOptionId().getWomen(); } if (points < 0) { points = 0; } if (points > 17) { points = 17; } // Count risk on point Criteria cr2 = ss.createCriteria(AbsoluteRiskFemale.class); cr2.add(Restrictions.eq("foptionid", agefac)); cr2.add(Restrictions.eq("point", points)); ArrayList<AbsoluteRiskFemale> riskdata = (ArrayList<AbsoluteRiskFemale>) cr2.list(); if (riskdata.size() > 0) { AbsoluteRiskFemale risk = riskdata.get(0); if (risk.getGreen() != null) { metervalue = risk.getGreen(); } else if (risk.getViolet() != null) { metervalue = risk.getViolet(); } else if (risk.getYellow() != null) { metervalue = risk.getYellow(); } else if (risk.getRed() != null) { metervalue = risk.getRed(); } if (risk.getRGreen() != null) { rmetervalue = risk.getRGreen(); } else if (risk.getRViolet() != null) { rmetervalue = risk.getRViolet(); } else if (risk.getRYellow() != null) { rmetervalue = risk.getRYellow(); } else if (risk.getRRed() != null) { rmetervalue = risk.getRRed(); } // System.out.println("Risk data : " + risk); } // System.out.println("Meter value : " + metervalue); // Set Chart Data Criteria cr01 = ss.createCriteria(AbsoluteRiskFemale.class); cr01.add(Restrictions.eq("foptionid", agefac)); cr01.setProjection(Projections.max("green")); if (cr01.uniqueResult() != null) { chartdata[0] = cr01.uniqueResult().toString(); } Criteria cr02 = ss.createCriteria(AbsoluteRiskFemale.class); cr02.add(Restrictions.eq("foptionid", agefac)); cr02.setProjection(Projections.max("violet")); if (cr02.uniqueResult() != null) { chartdata[1] = cr02.uniqueResult().toString(); } Criteria cr03 = ss.createCriteria(AbsoluteRiskFemale.class); cr03.add(Restrictions.eq("foptionid", agefac)); cr03.setProjection(Projections.max("yellow")); if (cr03.uniqueResult() != null) { chartdata[2] = cr03.uniqueResult().toString(); } chartdata[3] = "30"; } } } System.out.println("sssss : " + hs.getAttribute("agefactor")); Criteria cr = ss.createCriteria(FactorDetails.class); ArrayList<FactorDetails> fdlist = (ArrayList<FactorDetails>) cr.list(); if (fdlist.size() > facindex) { FactorDetails factor = fdlist.get(facindex); Criteria cr1 = ss.createCriteria(FactorOption.class); cr1.add(Restrictions.eq("factorId", factor)); ArrayList<FactorOption> folist = (ArrayList<FactorOption>) cr1.list(); if (folist.size() > 0) { request.setAttribute("folist", folist); } // metervalue = metervalue + 3; hs.setAttribute("metervalue", metervalue); hs.setAttribute("rmetervalue", rmetervalue); hs.setAttribute("points", points); hs.setAttribute("finalans", finalans); hs.setAttribute("chartdata", chartdata); request.setAttribute("factor", factor); request.setAttribute("facindex", facindex); } else { // Save In database final ans ArrayList<PatientfactorAnswer> save = (ArrayList<PatientfactorAnswer>) hs .getAttribute("finalans"); Calculationmeteredata cm = new Calculationmeteredata(); cm.setFinalpoints((Integer) hs.getAttribute("points")); cm.setMetervalue((Integer) hs.getAttribute("metervalue")); cm.setRmetervalue((Double) hs.getAttribute("rmetervalue")); cm.setDate(new Date().toString()); cm.setPId(p1); ss.save(cm); if (cm.getCalculationmeteredataId() != null) { for (PatientfactorAnswer pans : save) { pans.setCalculationmeteredataId(cm); ss.save(pans); } } tr.commit(); RequestDispatcher rd = request.getRequestDispatcher( "systemgeneratedreport?calcid=" + cm.getCalculationmeteredataId()); rd.forward(request, response); } tr.commit(); RequestDispatcher rd = request.getRequestDispatcher("heartattack_calculater.jsp"); rd.forward(request, response); } else { tr.commit(); RequestDispatcher rd = request.getRequestDispatcher("login.jsp"); rd.forward(request, response); } } }
From source file:systemgen_report_doc.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods.//from w w w.ja v a 2 s. c o m * * @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 { /* TODO output your page here. You may use following sample code. */ SessionFactory sf = HibernateUtil.getSessionFactory(); Session ss = sf.openSession(); Transaction tr = ss.beginTransaction(); HttpSession hs = request.getSession(); if (hs.getAttribute("doctor") != null) { Patient p1 = (Patient) hs.getAttribute("patient"); if (request.getParameter("calcid") != null) { int calcid = Integer.parseInt(request.getParameter("calcid")); Calculationmeteredata cm1 = (Calculationmeteredata) ss.get(Calculationmeteredata.class, calcid); String color = "red"; if (cm1.getCalculationmeteredataId() != null) { String gender = "MALE"; Criteria optcr = ss.createCriteria(PatientfactorAnswer.class); optcr.add(Restrictions.eq("calculationmeteredataId", cm1)); ArrayList<PatientfactorAnswer> anslist = (ArrayList<PatientfactorAnswer>) optcr.list(); if (anslist.size() > 0) { FactorOption agefac = new FactorOption(); for (PatientfactorAnswer opp : anslist) { if (opp.getFactorId().equals(new FactorDetails(1))) { if (opp.getFactorOptionId().getFoptionId().equals(16)) { gender = "FEMALE"; } System.out.println("Gender is :" + gender + opp.getFactorOptionId()); } if (opp.getFactorId().equals(new FactorDetails(2))) { agefac = opp.getFactorOptionId(); System.out.println("Age is :" + agefac.getFactorOption()); } } if (gender.equals("MALE")) { // Set Chart Data String[] chartdata = new String[4]; String[] rchartdata = new String[4]; Criteria cr01 = ss.createCriteria(AbsulateRiskMale.class); cr01.add(Restrictions.eq("foptionid", agefac)); cr01.setProjection(Projections.max("green")); if (cr01.uniqueResult() != null) { chartdata[0] = cr01.uniqueResult().toString(); int cdata = Integer.parseInt(chartdata[0]); if (cdata >= cm1.getMetervalue()) { color = "green"; } } Criteria cr02 = ss.createCriteria(AbsulateRiskMale.class); cr02.add(Restrictions.eq("foptionid", agefac)); cr02.setProjection(Projections.max("violet")); if (cr02.uniqueResult() != null) { chartdata[1] = cr02.uniqueResult().toString(); int cdata = Integer.parseInt(chartdata[1]); if (cdata >= cm1.getMetervalue()) { color = "violet"; } } System.out.println(chartdata[1]); System.out.println(color); Criteria cr03 = ss.createCriteria(AbsulateRiskMale.class); cr03.add(Restrictions.eq("foptionid", agefac)); cr03.setProjection(Projections.max("yellow")); if (cr03.uniqueResult() != null) { chartdata[2] = cr03.uniqueResult().toString(); int cdata = Integer.parseInt(chartdata[2]); if (cdata >= cm1.getMetervalue()) { color = "yellow"; } } chartdata[3] = "54"; // RchartData create Criteria cr010 = ss.createCriteria(AbsulateRiskMale.class); cr010.add(Restrictions.eq("foptionid", agefac)); cr010.setProjection(Projections.max("rGreen")); if (cr010.uniqueResult() != null) { rchartdata[0] = cr010.uniqueResult().toString(); } Criteria cr020 = ss.createCriteria(AbsulateRiskMale.class); cr020.add(Restrictions.eq("foptionid", agefac)); cr020.setProjection(Projections.max("rViolet")); if (cr020.uniqueResult() != null) { rchartdata[1] = cr020.uniqueResult().toString(); } System.out.println(chartdata[1]); System.out.println(color); Criteria cr030 = ss.createCriteria(AbsulateRiskMale.class); cr030.add(Restrictions.eq("foptionid", agefac)); cr030.setProjection(Projections.max("rYellow")); if (cr030.uniqueResult() != null) { rchartdata[2] = cr030.uniqueResult().toString(); } rchartdata[3] = "30"; request.setAttribute("rchartdata", rchartdata); request.setAttribute("chartdata", chartdata); } else if (gender.equals("FEMALE")) { // Set Chart Data String[] chartdata = new String[4]; String[] rchartdata = new String[4]; Criteria cr01 = ss.createCriteria(AbsoluteRiskFemale.class); cr01.add(Restrictions.eq("foptionid", agefac)); cr01.setProjection(Projections.max("green")); if (cr01.uniqueResult() != null) { chartdata[0] = cr01.uniqueResult().toString(); int cdata = Integer.parseInt(chartdata[0]); if (cdata >= cm1.getMetervalue()) { color = "green"; } } Criteria cr02 = ss.createCriteria(AbsoluteRiskFemale.class); cr02.add(Restrictions.eq("foptionid", agefac)); cr02.setProjection(Projections.max("violet")); if (cr02.uniqueResult() != null) { chartdata[1] = cr02.uniqueResult().toString(); int cdata = Integer.parseInt(chartdata[1]); if (cdata >= cm1.getMetervalue()) { color = "violet"; } } Criteria cr03 = ss.createCriteria(AbsoluteRiskFemale.class); cr03.add(Restrictions.eq("foptionid", agefac)); cr03.setProjection(Projections.max("yellow")); if (cr03.uniqueResult() != null) { chartdata[2] = cr03.uniqueResult().toString(); int cdata = Integer.parseInt(chartdata[2]); if (cdata >= cm1.getMetervalue()) { color = "yellow"; } } chartdata[3] = "30"; // RchartData create Criteria cr010 = ss.createCriteria(AbsoluteRiskFemale.class); cr010.add(Restrictions.eq("foptionid", agefac)); cr010.setProjection(Projections.max("rGreen")); if (cr010.uniqueResult() != null) { rchartdata[0] = cr010.uniqueResult().toString(); } Criteria cr020 = ss.createCriteria(AbsoluteRiskFemale.class); cr020.add(Restrictions.eq("foptionid", agefac)); cr020.setProjection(Projections.max("rViolet")); if (cr020.uniqueResult() != null) { rchartdata[1] = cr020.uniqueResult().toString(); } System.out.println(chartdata[1]); System.out.println(color); Criteria cr030 = ss.createCriteria(AbsoluteRiskFemale.class); cr030.add(Restrictions.eq("foptionid", agefac)); cr030.setProjection(Projections.max("rYellow")); if (cr030.uniqueResult() != null) { rchartdata[2] = cr030.uniqueResult().toString(); } rchartdata[3] = "20"; request.setAttribute("rchartdata", rchartdata); request.setAttribute("chartdata", chartdata); } Criteria testcr = ss.createCriteria(TestRecommend.class); testcr.add(Restrictions.eq("color", color)); ArrayList<TestRecommend> tlist = (ArrayList<TestRecommend>) testcr.list(); if (tlist.size() > 0) { request.setAttribute("testlist", tlist); } request.setAttribute("calcdata", cm1); request.setAttribute("anslist", anslist); } } tr.commit(); RequestDispatcher rd = request.getRequestDispatcher("doctor_view_systemreport_full.jsp"); rd.forward(request, response); } } else { tr.commit(); RequestDispatcher rd = request.getRequestDispatcher("login.jsp"); rd.forward(request, response); } } catch (HibernateException he) { out.println(he.getMessage()); } finally { out.close(); } }
From source file:systemgeneratedreport.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods./*from w w w. j a va 2 s. com*/ * * @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"); try (PrintWriter out = response.getWriter()) { /* TODO output your page here. You may use following sample code. */ SessionFactory sf = HibernateUtil.getSessionFactory(); Session ss = sf.openSession(); Transaction tr = ss.beginTransaction(); HttpSession hs = request.getSession(); if (hs.getAttribute("patient") != null) { Patient p1 = (Patient) hs.getAttribute("patient"); if (request.getParameter("calcid") != null) { int calcid = Integer.parseInt(request.getParameter("calcid")); Calculationmeteredata cm1 = (Calculationmeteredata) ss.get(Calculationmeteredata.class, calcid); String color = "red"; if (cm1.getCalculationmeteredataId() != null) { String gender = "MALE"; Criteria optcr = ss.createCriteria(PatientfactorAnswer.class); optcr.add(Restrictions.eq("calculationmeteredataId", cm1)); ArrayList<PatientfactorAnswer> anslist = (ArrayList<PatientfactorAnswer>) optcr.list(); if (anslist.size() > 0) { FactorOption agefac = new FactorOption(); for (PatientfactorAnswer opp : anslist) { if (opp.getFactorId().equals(new FactorDetails(1))) { if (opp.getFactorOptionId().getFoptionId().equals(16)) { gender = "FEMALE"; } System.out.println("Gender is :" + gender + opp.getFactorOptionId()); } if (opp.getFactorId().equals(new FactorDetails(2))) { agefac = opp.getFactorOptionId(); System.out.println("Age is :" + agefac.getFactorOption()); } } if (gender.equals("MALE")) { // Set Chart Data String[] chartdata = new String[4]; String[] rchartdata = new String[4]; Criteria cr01 = ss.createCriteria(AbsulateRiskMale.class); cr01.add(Restrictions.eq("foptionid", agefac)); cr01.setProjection(Projections.max("green")); if (cr01.uniqueResult() != null) { chartdata[0] = cr01.uniqueResult().toString(); int cdata = Integer.parseInt(chartdata[0]); if (cdata >= cm1.getMetervalue()) { color = "green"; } } Criteria cr02 = ss.createCriteria(AbsulateRiskMale.class); cr02.add(Restrictions.eq("foptionid", agefac)); cr02.setProjection(Projections.max("violet")); if (cr02.uniqueResult() != null) { chartdata[1] = cr02.uniqueResult().toString(); int cdata = Integer.parseInt(chartdata[1]); if (cdata >= cm1.getMetervalue()) { color = "violet"; } } System.out.println(chartdata[1]); System.out.println(color); Criteria cr03 = ss.createCriteria(AbsulateRiskMale.class); cr03.add(Restrictions.eq("foptionid", agefac)); cr03.setProjection(Projections.max("yellow")); if (cr03.uniqueResult() != null) { chartdata[2] = cr03.uniqueResult().toString(); int cdata = Integer.parseInt(chartdata[2]); if (cdata >= cm1.getMetervalue()) { color = "yellow"; } } chartdata[3] = "54"; // RchartData create Criteria cr010 = ss.createCriteria(AbsulateRiskMale.class); cr010.add(Restrictions.eq("foptionid", agefac)); cr010.setProjection(Projections.max("rGreen")); if (cr010.uniqueResult() != null) { rchartdata[0] = cr010.uniqueResult().toString(); } Criteria cr020 = ss.createCriteria(AbsulateRiskMale.class); cr020.add(Restrictions.eq("foptionid", agefac)); cr020.setProjection(Projections.max("rViolet")); if (cr020.uniqueResult() != null) { rchartdata[1] = cr020.uniqueResult().toString(); } System.out.println(chartdata[1]); System.out.println(color); Criteria cr030 = ss.createCriteria(AbsulateRiskMale.class); cr030.add(Restrictions.eq("foptionid", agefac)); cr030.setProjection(Projections.max("rYellow")); if (cr030.uniqueResult() != null) { rchartdata[2] = cr030.uniqueResult().toString(); } rchartdata[3] = "30"; request.setAttribute("rchartdata", rchartdata); request.setAttribute("chartdata", chartdata); } else if (gender.equals("FEMALE")) { // Set Chart Data String[] chartdata = new String[4]; String[] rchartdata = new String[4]; Criteria cr01 = ss.createCriteria(AbsoluteRiskFemale.class); cr01.add(Restrictions.eq("foptionid", agefac)); cr01.setProjection(Projections.max("green")); if (cr01.uniqueResult() != null) { chartdata[0] = cr01.uniqueResult().toString(); int cdata = Integer.parseInt(chartdata[0]); if (cdata >= cm1.getMetervalue()) { color = "green"; } } Criteria cr02 = ss.createCriteria(AbsoluteRiskFemale.class); cr02.add(Restrictions.eq("foptionid", agefac)); cr02.setProjection(Projections.max("violet")); if (cr02.uniqueResult() != null) { chartdata[1] = cr02.uniqueResult().toString(); int cdata = Integer.parseInt(chartdata[1]); if (cdata >= cm1.getMetervalue()) { color = "violet"; } } Criteria cr03 = ss.createCriteria(AbsoluteRiskFemale.class); cr03.add(Restrictions.eq("foptionid", agefac)); cr03.setProjection(Projections.max("yellow")); if (cr03.uniqueResult() != null) { chartdata[2] = cr03.uniqueResult().toString(); int cdata = Integer.parseInt(chartdata[2]); if (cdata >= cm1.getMetervalue()) { color = "yellow"; } } chartdata[3] = "30"; // RchartData create Criteria cr010 = ss.createCriteria(AbsoluteRiskFemale.class); cr010.add(Restrictions.eq("foptionid", agefac)); cr010.setProjection(Projections.max("rGreen")); if (cr010.uniqueResult() != null) { rchartdata[0] = cr010.uniqueResult().toString(); } Criteria cr020 = ss.createCriteria(AbsoluteRiskFemale.class); cr020.add(Restrictions.eq("foptionid", agefac)); cr020.setProjection(Projections.max("rViolet")); if (cr020.uniqueResult() != null) { rchartdata[1] = cr020.uniqueResult().toString(); } System.out.println(chartdata[1]); System.out.println(color); Criteria cr030 = ss.createCriteria(AbsoluteRiskFemale.class); cr030.add(Restrictions.eq("foptionid", agefac)); cr030.setProjection(Projections.max("rYellow")); if (cr030.uniqueResult() != null) { rchartdata[2] = cr030.uniqueResult().toString(); } rchartdata[3] = "20"; request.setAttribute("rchartdata", rchartdata); request.setAttribute("chartdata", chartdata); } Criteria testcr = ss.createCriteria(TestRecommend.class); testcr.add(Restrictions.eq("color", color)); ArrayList<TestRecommend> tlist = (ArrayList<TestRecommend>) testcr.list(); if (tlist.size() > 0) { request.setAttribute("testlist", tlist); } request.setAttribute("calcdata", cm1); request.setAttribute("anslist", anslist); } } tr.commit(); RequestDispatcher rd = request.getRequestDispatcher("system_generated_report1.jsp"); rd.forward(request, response); } } else { tr.commit(); RequestDispatcher rd = request.getRequestDispatcher("login.jsp"); rd.forward(request, response); } } }
From source file:alpha.portal.dao.hibernate.AlphaCardDaoHibernate.java
License:Apache License
/** * List alpha cards by criterion./*from w w w .jav a 2 s .c o m*/ * * @param caseId * the case id * @param criteriaArray * the criteria array * @return the list * @see alpha.portal.dao.AlphaCardDao#listAlphaCardsByCriterion(org.hibernate.criterion.Criterion) */ public List<AlphaCard> listAlphaCardsByCriterion(final String caseId, final Criterion... criteriaArray) { Session session; boolean sessionOwn = false; try { session = this.getSessionFactory().getCurrentSession(); } catch (final Exception e) { session = this.getSessionFactory().openSession(); sessionOwn = true; } // get newest sequenceNumber for each cardId final DetachedCriteria version = DetachedCriteria.forClass(AlphaCard.class, "cardVersion") .add(Property.forName("card.alphaCardIdentifier.cardId") .eqProperty("cardVersion.alphaCardIdentifier.cardId")) .setProjection( Projections.projectionList().add(Projections.max("alphaCardIdentifier.sequenceNumber"))); final Criteria crit = session.createCriteria(AlphaCard.class, "card"); for (final Criterion c : criteriaArray) { // Create the subquery (somehow we need to use the Descriptor or // else the subquery-JOIN is not done) final DetachedCriteria subcrit = DetachedCriteria.forClass(AlphaCardDescriptor.class, "crit"); // Join the adornments subcrit.createAlias("crit.adornmentList", "ad"); // Add adornment condition subcrit.add(c); // Map the subquery back to the outer query subcrit.add(Restrictions.eqProperty("card.alphaCardIdentifier", "crit.alphaCardIdentifier")); // Narrow down subquery or else we get a NullPointer-Exception subcrit.setProjection(Projections.property("crit.alphaCardIdentifier.cardId")); // Add this subquery to the outer query. crit.add(Subqueries.exists(subcrit)); } crit.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY) .add(Property.forName("alphaCardIdentifier.sequenceNumber").eq(version)) .createAlias("alphaCase", "case").add(Restrictions.eq("case.caseId", caseId)); List<AlphaCard> list = crit.list(); if (list.size() > 1) { final List<AlphaCard> order = (list.get(0)).getAlphaCase().getAlphaCards(); final List<AlphaCard> orderedList = new LinkedList<AlphaCard>(); for (final AlphaCard cc : order) { for (final AlphaCard c : list) { if (c.getAlphaCardIdentifier().equals(cc.getAlphaCardIdentifier())) { orderedList.add(c); break; } } } list = orderedList; } if (sessionOwn) { session.close(); } return list; }
From source file:ar.com.zauber.commons.repository.aggregate.ProjectionAggregateFunctionVisitor.java
License:Apache License
/** crea projecciones en base a {@link PropertyAggregateFunction}. */ private static Projection createPropertyProjection(final PropertyAggregateFunction paf) { final String propertyName = paf.getProperty(); final Projection projection; if (paf instanceof AveragePropertyAggregateFunction) { projection = Projections.avg(propertyName); } else if (paf instanceof CountDistinctPropertyAggregateFunction) { projection = Projections.countDistinct(propertyName); } else if (paf instanceof CountPropertyAggregateFunction) { projection = Projections.count(propertyName); } else if (paf instanceof MaxPropertyAggregateFunction) { projection = Projections.max(propertyName); } else if (paf instanceof MinPropertyAggregateFunction) { projection = Projections.min(propertyName); } else if (paf instanceof SumPropertyAggregateFunction) { projection = Projections.sum(propertyName); } else if (paf instanceof GroupPropertyAggregateFilter) { projection = Projections.groupProperty(propertyName); } else {/*www . j a v a 2 s . c o m*/ throw new IllegalArgumentException("don't know how to process " + paf.getClass()); } return projection; }
From source file:au.org.theark.phenotypic.model.dao.PhenotypicDao.java
License:Open Source License
@Override public Long getNextAvailbleNumberForPickedCategory(Study study, ArkFunction arkFunction, ArkUser arkUser) { Long maxNumber;/* w w w . j a v a2s . c o m*/ Criteria criteria = getSession().createCriteria(PickedPhenoDataSetCategory.class); criteria.add(Restrictions.eq("arkFunction", arkFunction)); criteria.add(Restrictions.eq("study", study)); criteria.add(Restrictions.eq("arkUser", arkUser)); //criteria.add(Restrictions.isNull("parentPickedPhenoDataSetCategory")); criteria.setProjection(Projections.max("orderNumber")); maxNumber = (Long) criteria.uniqueResult(); if (maxNumber != null) { return ++maxNumber; } else { return new Long(1); } }
From source file:au.org.theark.phenotypic.model.dao.PhenotypicDao.java
License:Open Source License
@Override public Long getNextAvailbleNumberForAssignedField(Study study, ArkFunction arkFunction, ArkUser arkUser, PhenoDataSetCategory phenoDataSetCategory) { Long maxNumber;/*from w w w . j a v a 2 s . com*/ Criteria criteria = getSession().createCriteria(LinkPhenoDataSetCategoryField.class); criteria.add(Restrictions.eq("arkFunction", arkFunction)); criteria.add(Restrictions.eq("study", study)); criteria.add(Restrictions.eq("arkUser", arkUser)); criteria.add(Restrictions.eq("phenoDataSetCategory", phenoDataSetCategory)); criteria.setProjection(Projections.max("orderNumber")); maxNumber = (Long) criteria.uniqueResult(); if (maxNumber != null) { return ++maxNumber; } else { return new Long(1); } }
From source file:bernardo.venda.controle.AbstractControle.java
public Long ultimoCodigo() { Long codigo = null;// w ww . j av a2s . com try { codigo = (Long) getSession().createCriteria(persistentClass).setProjection(Projections.max("codigo")) .uniqueResult(); } catch (HibernateException | NumberFormatException e) { JOptionPane.showMessageDialog(null, "Ocorreu um Erro Inesperado\n" + e); } return codigo; }
From source file:br.com.magmadoctor.modelo.profissional.ProfissionalDAOHibernate.java
@Override public Integer retornaUltimoCodigo() { int ultimo = 0; Criteria criteria = this.session.createCriteria(Profissional.class).setProjection(Projections.max("id")); if (criteria.uniqueResult() == null) { return ultimo; } else {// w w w . ja v a 2 s. com ultimo = (Integer) criteria.uniqueResult(); } return ultimo; }
From source file:br.com.muranodesign.dao.impl.PlanoEstudoDAOImpl.java
License:Creative Commons License
@SuppressWarnings("unchecked") public List<PlanoEstudo> utimoPlanoEstudos(int idAluno) { Criteria criteria = getSession().createCriteria(PlanoEstudo.class); criteria.createAlias("aluno", "aluno"); Criteria criteria2 = getSession().createCriteria(PlanoEstudo.class); criteria2.createAlias("aluno", "aluno"); criteria2.add(Restrictions.eq("aluno.idAluno", idAluno)); criteria2.setProjection(Projections.max("dataInicio")); criteria.add(Restrictions.eq("aluno.idAluno", idAluno)); criteria.add(Restrictions.eq("dataInicio", criteria2.uniqueResult())); List<PlanoEstudo> result = criteria.list(); return result; }