List of usage examples for org.hibernate.criterion Restrictions eq
public static SimpleExpression eq(String propertyName, Object value)
From source file:consulta.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods.//from w w w . j a v a 2 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. */ out.println("<!DOCTYPE html>"); out.println("<html>"); out.println("<head>"); out.println("<title>Servlet consulta</title>"); out.println("</head>"); out.println("<body>"); out.println("<h1>Servlet consulta at " + request.getContextPath() + "</h1>"); out.println("</body>"); out.println("</html>"); Session s = HibernateUtil.getSessionFactory().openSession(); Criteria criteria; Criteria Criteria = criteria = s.createCriteria(Pincel.class); criteria.add(Restrictions.eq("Cor", "Azul")); List<Pincel> result = criteria.list(); out.println("<br>pinceis encotrados;<br>"); s.close(); } }
From source file:fetch_propfeedback.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods./*from w ww .j a v a2 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"); PrintWriter out = response.getWriter(); HttpSession hs = request.getSession(); try { PropDetail pd = (PropDetail) hs.getAttribute("propobj"); SessionFactory sf = util.NewHibernateUtil.getSessionFactory(); Session ss = sf.openSession(); Criteria cr1 = ss.createCriteria(PropFeedback.class); cr1.add(Restrictions.eq("pId", pd)); ArrayList<PropFeedback> pfl = (ArrayList<PropFeedback>) cr1.list(); if (!pfl.isEmpty()) { // HttpSession hs1=request.getSession(); System.out.println(pfl.size()); System.out.println("inside the servlet else"); System.out.println("inside the servlet else11"); hs.setAttribute("pfl", pfl); System.out.println("inside the servlet else222"); } else { System.out.println("no property feedback found"); ; } RequestDispatcher rd = request.getRequestDispatcher("single.jsp"); System.out.println("forwarding"); rd.forward(request, response); } catch (HibernateException e) { out.println(e.getMessage()); } }
From source file:get_doctor_admin.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods./*www. j av a 2s . 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 { SessionFactory sf = HibernateUtil.getSessionFactory(); Session ss = sf.openSession(); Transaction tr = ss.beginTransaction(); String code = ""; Criteria cr = ss.createCriteria(Doctor.class); ArrayList<Doctor> all = (ArrayList<Doctor>) cr.list(); Criteria cr1 = ss.createCriteria(Doctor.class); cr1.add(Restrictions.eq("status", "ACTIVE")); if (request.getParameter("sort") != null) { String so = request.getParameter("sort"); if (so.equals("1")) { cr1.addOrder(Order.asc("dFirstname")); } else if (so.equals("2")) { cr1.addOrder(Order.desc("dFirstname")); } //.add( Restrictions.like("name", "F%") //.addOrder( Order.asc("name") ) //.addOrder( Order.desc("age") ) //.setMaxResults(50) // cr.add(Restrictions.eq("password", request.getParameter("password"))); } if (request.getParameter("search") != null) { String so = request.getParameter("search"); cr1.add(Restrictions.like("dFirstname", so + "%")); } ArrayList<Doctor> all1 = (ArrayList<Doctor>) cr1.list(); if (all1.size() > 0) { for (int i = 0; i < all1.size(); i++) { Doctor dd = all1.get(i); out.println("<li class=\"author-comments\" style=\"margin-top: 36px\">\n" + " <div class=\"media\">\n" + " <div class=\"media-left\"> \n" + " <img alt=\"img\" src=\"images/doctor-2.jpg\" class=\"media-object news-img\"> \n" + " </div>\n" + " <div class=\"media-body\">\n" + " <h4 class=\"author-name\">Dr. " + dd.getDFirstname() + " " + dd.getDLastname() + "</h4>\n" + " <span class=\"comments-date\"> " + dd.getQualificationId().getQualificationName() + "</span>\n" + " <p>" + dd.getAddressid().getCityId().getCityName().toString() + "</p>\n" + " <p class=\"fa fa-check-circle\" style=\"color: green\">" + dd.getStatus() + "</p>\n" + " <div class=\"ui heart rating\" data-rating=\"1\" data-max-rating=\"3\"></div>\n" + " <a class=\"reply-btn\" href=\"view_docprofile_admin?did=" + dd.getDId() + "\">View profile</a>\n" + " </div>\n" + " </div>\n" + " </li>"); } } request.setAttribute("dlist", all); } catch (HibernateException he) { out.println(he.getMessage()); } finally { out.close(); } }
From source file:getcity.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods./*from w ww . j av a 2s . 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"); PrintWriter out = response.getWriter(); try { SessionFactory sf = NewHibernateUtil.getSessionFactory(); Session ss = sf.openSession(); Transaction tr = ss.beginTransaction(); int stateid = Integer.parseInt(request.getParameter("state")); out.print(stateid); StateMaster sm = new StateMaster(); sm.setSId(stateid); Criteria cr = ss.createCriteria(CityMaster.class); cr.add(Restrictions.eq("sId", sm)); ArrayList<CityMaster> ctlist = (ArrayList<CityMaster>) cr.list(); for (int i = 0; i < ctlist.size(); i++) { CityMaster cm = ctlist.get(i); System.out.println("------------- getcity" + cm.getCityName()); System.out.println("------------- " + cm.getCityId()); out.print("<option value=" + cm.getCityId() + ">" + cm.getCityName() + "</option>"); } tr.commit(); } catch (Exception e) { out.println(e.getMessage()); } }
From source file:ViewProject.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods.//from w w w . j a va 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(); String path = ""; RequestDispatcher rd; try { SessionFactory sf = NewHibernateUtil.getSessionFactory(); Session ss = sf.openSession(); Transaction tr = ss.beginTransaction(); HttpSession hs = request.getSession(); int mineId = Integer.parseInt(request.getParameter("mineId").toString()); Criteria cr = ss.createCriteria(ProjectDetails.class); cr.add(Restrictions.eq("mineId", mineId)); ArrayList<ProjectDetails> PDlist = (ArrayList<ProjectDetails>) cr.list(); ProjectDetails pd = PDlist.get(0); tr.commit(); request.setAttribute("projDet", pd); hs.setAttribute("projDet", pd); path = "viewProject.jsp"; rd = request.getRequestDispatcher(path); } catch (Exception e) { path = "FailureME.jsp"; rd = request.getRequestDispatcher(path); } rd.forward(request, response); }
From source file:GetCityServ.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods./*from w ww .ja v a2 s . co 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 se = sf.openSession(); Transaction tr = se.beginTransaction(); String sid = request.getParameter("state"); State sm = new State(); sm.setSId(Integer.parseInt(sid)); Criteria cr = se.createCriteria(City.class); cr.add(Restrictions.eq("stateId", sm)); ArrayList<City> cmli = (ArrayList<City>) cr.list(); for (int i = 0; i < cmli.size(); i++) { City cm = cmli.get(i); String cname = cm.getCityName(); out.print("<option value =" + cm.getCityId() + " >" + cname + "</option>"); } tr.commit(); } catch (Exception e) { out.println(e.getMessage()); } }
From source file:reg_serv_agent.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods./*from w w w .j a va2 s.co 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 { String fn = request.getParameter("fname"); String ln = request.getParameter("lname"); String un = request.getParameter("uname"); String e = request.getParameter("email"); String stateid = request.getParameter("state"); System.out.println("-------" + stateid); String cityid = request.getParameter("city"); System.out.println("-------" + cityid); String r = request.getParameter("role"); String p = request.getParameter("pwd"); String areaid = request.getParameter("area"); System.out.println("-------" + areaid); String no = request.getParameter("num"); String adrs1 = request.getParameter("addrss"); String adrs2 = request.getParameter("addrss2"); Login li = new Login(); li.setUName(un); li.setPwd(p); li.setURole("agent"); SessionFactory sf = NewHibernateUtil.getSessionFactory(); Session ss = sf.openSession(); Transaction tr = ss.beginTransaction(); ss.save(li); String state = ""; Criteria cr = ss.createCriteria(StateMaster.class); cr.add(Restrictions.eq("sId", Integer.parseInt(stateid))); ArrayList<StateMaster> ar = (ArrayList<StateMaster>) cr.list(); System.out.println("----------" + ar.size()); if (ar.isEmpty()) { } else { state = ar.get(0).getSName(); System.out.println("-------" + ar.get(0)); } String city = ""; Criteria cr2 = ss.createCriteria(CityMaster.class); cr2.add(Restrictions.eq("cityId", Integer.parseInt(cityid))); ArrayList<CityMaster> ar2 = (ArrayList<CityMaster>) cr2.list(); System.out.println("----------" + ar2.size()); if (ar2.isEmpty()) { } else { city = ar2.get(0).getCityName(); System.out.println("-------" + city); } String area = ""; Criteria cr3 = ss.createCriteria(AreaMaster.class); cr3.add(Restrictions.eq("areaId", Integer.parseInt(areaid))); ArrayList<AreaMaster> ar3 = (ArrayList<AreaMaster>) cr3.list(); System.out.println("----------" + ar3.size()); if (ar3.isEmpty()) { } else { area = ar3.get(0).getAreaName(); System.out.println("-------" + area); } AgentDetail ad = new AgentDetail(); ad.setUId(li); ad.setAFname(fn); ad.setALname(ln); ad.setAAddress1(adrs1); ad.setAAddress2(adrs2); ad.setARating(0); ad.setAEmail(e); ad.setAState(state); ad.setACity(city); ad.setAArea(area); ad.setAStatus("Pending"); ad.setANo(no); ss.save(ad); // out.println("Agent Registered"); tr.commit(); HttpSession session = request.getSession(); session.setAttribute("user", li); RequestDispatcher rd = request.getRequestDispatcher("login.jsp"); rd.include(request, response); } catch (Exception e) { out.print(e.getMessage()); } }
From source file:search_prop.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods./*ww w.ja v a 2s. 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"); PrintWriter out = response.getWriter(); try { SessionFactory sf = NewHibernateUtil.getSessionFactory(); Session ss = sf.openSession(); String[] bhkGroup = request.getParameterValues("bhkgroup"); String[] typeGroup = request.getParameterValues("typegroup"); System.out.println("the types are:" + typeGroup[0]); System.out.println("the bhks are:" + bhkGroup[0]); String stateid = request.getParameter("state"); String cityid = request.getParameter("city"); String areaid = request.getParameter("area"); // String minp = request.getParameter("minprice"); // String maxp = request.getParameter("maxprice"); // String minsq = request.getParameter("minsqfeet"); // String maxsq = request.getParameter("maxsqfeet"); // //Edited int minp = Integer.parseInt(request.getParameter("minprice")); int maxp = Integer.parseInt(request.getParameter("maxprice")); int minsq = Integer.parseInt(request.getParameter("minsqfeet")); int maxsq = Integer.parseInt(request.getParameter("maxsqfeet")); String state = ""; Criteria cr1 = ss.createCriteria(StateMaster.class); cr1.add(Restrictions.eq("sId", Integer.parseInt(stateid))); ArrayList<StateMaster> ar = (ArrayList<StateMaster>) cr1.list(); System.out.println("----------" + ar.size()); if (ar.isEmpty()) { } else { state = ar.get(0).getSName(); System.out.println("-------" + state); } String city = ""; Criteria cr2 = ss.createCriteria(CityMaster.class); cr2.add(Restrictions.eq("cityId", Integer.parseInt(cityid))); ArrayList<CityMaster> ar2 = (ArrayList<CityMaster>) cr2.list(); System.out.println("----------" + ar2.size()); if (ar2.isEmpty()) { } else { city = ar2.get(0).getCityName(); System.out.println("-------" + city); } String area = ""; Criteria cr3 = ss.createCriteria(AreaMaster.class); cr3.add(Restrictions.eq("areaId", Integer.parseInt(areaid))); ArrayList<AreaMaster> ar3 = (ArrayList<AreaMaster>) cr3.list(); System.out.println("----------" + ar3.size()); if (ar3.isEmpty()) { } else { area = ar3.get(0).getAreaName(); System.out.println("-------" + area); } System.out.println(minp + " " + maxp + " " + minsq + " " + maxsq); Criteria cr = ss.createCriteria(PropDetail.class); cr.add(Restrictions.in("pBhk", bhkGroup)); cr.add(Restrictions.in("pType", typeGroup)); cr.add(Restrictions.eq("pState", state)); cr.add(Restrictions.eq("pCity", city)); cr.add(Restrictions.eq("pArea", area)); cr.add(Restrictions.between("pPrice", minp, maxp)); cr.add(Restrictions.between("pFloor", minsq, maxsq)); ArrayList<PropDetail> pd = (ArrayList<PropDetail>) cr.list(); /* for(PropDetail p: pd) { out.print(p.getPId()+" type:"+p.getPType()+" bhk:"+p.getPBhk()); out.println(" "); } */ if (pd.isEmpty()) { out.print("no such property"); String msg = "Sorry, No results found."; request.setAttribute("error", msg); } else { request.setAttribute("proplist", pd); } RequestDispatcher rd = request.getRequestDispatcher("getstate?id=9"); rd.forward(request, response); } catch (HibernateException e) { out.println("There was some error with the taken action."); System.out.print(e.getMessage()); } }
From source file:GetPropDetailServ.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods./*from ww w . j a v a 2s .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 { SessionFactory sf = util.NewHibernateUtil.getSessionFactory(); Session ss = sf.openSession(); int pid = Integer.parseInt(request.getParameter("pid")); ArrayList<AssetRecords> a = new ArrayList<>(); String s = "SELECT sum(Price),Year FROM the_asset_consultancy.AssetRecords where Assetid=" + pid + " group by Price,Year ;"; SQLQuery query = ss.createSQLQuery(s); List<Object[]> lt = query.list(); for (Object[] op : lt) { AssetRecords ar = new AssetRecords(); ar.setPrice(op[0].toString()); ar.setYear(op[1].toString()); a.add(ar); out.println(a); } System.out.println("Size of array:" + a.size()); request.setAttribute("al", a); Collections.sort(a, new Comparator<AssetRecords>() { @Override public int compare(AssetRecords o1, AssetRecords o2) { return o1.getYear().compareTo(o2.getYear()); } }); Criteria cr = ss.createCriteria(PropDetail.class); cr.add(Restrictions.eq("pId", pid)); PropDetail pd = (PropDetail) cr.uniqueResult(); System.out.println("property found:" + pd.getPId()); Criteria cr1 = ss.createCriteria(PropFeedback.class); cr1.add(Restrictions.eq("pId", pd)); ArrayList<PropFeedback> pfl = (ArrayList<PropFeedback>) cr1.list(); request.setAttribute("pd", pd); if (!pfl.isEmpty()) { request.setAttribute("pfl", pfl); } else { System.out.println("No property feedback available"); } //for the random agent display Criteria cr2 = ss.createCriteria(AgentDetail.class); ArrayList<AgentDetail> adl = (ArrayList<AgentDetail>) cr2.list(); if (!adl.isEmpty()) { request.setAttribute("adl", adl); } else { System.out.println("random agent list empty"); } RequestDispatcher rd = request.getRequestDispatcher("single.jsp"); rd.forward(request, response); } catch (HibernateException e) { out.print(e.getMessage()); } }
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 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"); 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(); } }