List of usage examples for org.hibernate.criterion Restrictions eq
public static SimpleExpression eq(String propertyName, Object value)
From source file:ViewAgentFeedback.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 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(); HttpSession hs = request.getSession(); try { Login ln = (Login) hs.getAttribute("user"); System.out.println("uid is -------" + ln); SessionFactory sf = util.NewHibernateUtil.getSessionFactory(); Session ss = sf.openSession(); Criteria cr1 = ss.createCriteria(AgentDetail.class); cr1.add(Restrictions.eq("uId", ln)); ArrayList<AgentDetail> adl = (ArrayList<AgentDetail>) cr1.list(); if (!adl.isEmpty()) { AgentDetail ad = adl.get(0); System.out.print("adl not empty and the aid is :" + ad.getAId()); Criteria cr = ss.createCriteria(AgentFeedback.class); cr.add(Restrictions.eq("aId", ad)); ArrayList<AgentFeedback> afL = (ArrayList<AgentFeedback>) cr.list(); if (!afL.isEmpty()) { // HttpSession hs1=request.getSession(); System.out.println("adl size:" + adl.size() + "afl size:" + afL.size()); System.out.println("inside the servlet else"); System.out.println("inside the servlet else11"); request.setAttribute("afL", afL); System.out.println("inside the servlet else222"); } } RequestDispatcher rd = request.getRequestDispatcher("myfeedback_sample.jsp"); System.out.println("forwarding"); rd.forward(request, response); } catch (HibernateException e) { out.println(e.getMessage()); } }
From source file:forgotpassword.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods./*from 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"); PrintWriter out = response.getWriter(); try { String mail = request.getParameter("mail"); SessionFactory sf = HibernateUtil.getSessionFactory(); Session s = sf.openSession(); Transaction tr = s.beginTransaction(); Criteria c = s.createCriteria(Patient.class); c.add(Restrictions.eq("emailId", mail)); ArrayList<Patient> al = (ArrayList<Patient>) c.list(); String name = ""; if (al.size() > 0) { Patient p = al.get(0); Login l = p.getUsedId(); name = l.getPassword(); //name=l.getPassword(); System.out.println("---------------------" + name); String subject = "Forgot Password - Cardiac:"; String content = "Your password" + name; String[] recipients = new String[] { mail }; //String[] bccRecipients = new String[]{"sunilkotadiya777@gmail.com"}; if (new MailUtil().sendMail(recipients, subject, content)) { RequestDispatcher rd = request.getRequestDispatcher("forgetpassword_refresh.jsp"); rd.forward(request, response); } } else { String msg = "plz enter the correct email"; request.setAttribute("msg", msg); RequestDispatcher rd = request.getRequestDispatcher("forgotpassword.jsp"); rd.forward(request, response); } tr.commit(); } catch (HibernateException he) { out.println(he.getMessage()); } }
From source file:jobServ.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods.// www . j a va2s .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 { String j = request.getParameter("job"); Session se = NewHibernateUtil.getSessionFactory().openSession(); Transaction tr = se.beginTransaction(); Criteria cr = se.createCriteria(Job.class); cr.add(Restrictions.eq("jname", j)); ArrayList<Job> al = (ArrayList<Job>) cr.list(); tr.commit(); request.setAttribute("al", al); RequestDispatcher rd = request.getRequestDispatcher("job_search.jsp"); rd.forward(request, response); } catch (Exception e) { out.println(e.getMessage()); } }
From source file:getlab.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods./*from w w w . ja v a2 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 { SessionFactory sf = HibernateUtil.getSessionFactory(); Session ss = sf.openSession(); Transaction tr = ss.beginTransaction(); String code = ""; Criteria cr = ss.createCriteria(Lab.class); ArrayList<Lab> all = (ArrayList<Lab>) cr.list(); // request.setAttribute("dlist", all); Criteria cr1 = ss.createCriteria(Lab.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("labName")); } else if (so.equals("2")) { cr1.addOrder(Order.desc("labName")); } //.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("labName", so + "%")); } ArrayList<Lab> all1 = (ArrayList<Lab>) cr1.list(); if (all1.size() > 0) { for (int i = 0; i < all1.size(); i++) { Lab 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/Lab-Icon-245x300.png\" class=\"media-object news-img\"> \n" + " </div>\n" + " <div class=\"media-body\">\n" + " <h4 class=\"author-name\">" + dd.getLabName() + "</h4>\n" + " <a target='_blank' href='http://" + dd.getWebsite() + "'> <span class=\"comments-date\">" + dd.getWebsite() + "</span> </a>\n" + " <p>" + dd.getAddressid().getCityId().getCityName() + "</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=\"take_test?labid=" + dd.getLId() + "\">Take Appointment</a>\n" + " </div>\n" + " </div>\n" + " </li>"); } } } catch (HibernateException he) { he.getMessage(); } finally { out.close(); } }
From source file:doc_view_patient_allreport.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods./*from ww w.j a v a 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"); PrintWriter out = response.getWriter(); try { SessionFactory sf = HibernateUtil.getSessionFactory(); Session ss = sf.openSession(); Transaction tr = ss.beginTransaction(); HttpSession hs = request.getSession(); if (hs.getAttribute("doctor") != null) { Doctor a = (Doctor) hs.getAttribute("doctor"); if (request.getParameter("pid") != null) { int pid = Integer.parseInt(request.getParameter("pid")); // Calculationmeteredata cal = (Calculationmeteredata) ss.get(Calculationmeteredata.class, pid); Criteria cr = ss.createCriteria(Calculationmeteredata.class); cr.add(Restrictions.eq("pId", new Patient(pid))); ArrayList<Calculationmeteredata> da = (ArrayList<Calculationmeteredata>) cr.list(); if (da.size() > 0) { request.setAttribute("da", da); } tr.commit(); RequestDispatcher rd = request.getRequestDispatcher("doctor_view_system_report.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:viewTask.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods.//from w w w . j a v a 2 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(); String path = ""; try { HttpSession hs = request.getSession(); SessionFactory sf = NewHibernateUtil.getSessionFactory(); Session ss = sf.openSession(); Transaction tr = ss.beginTransaction(); int userId = Integer.parseInt(hs.getAttribute("userId").toString()); String page = request.getParameter("page").toString(); LoginInfo user_id_to = new LoginInfo(); user_id_to.setUserId(userId); Criteria cr = ss.createCriteria(TaskDetails.class); cr.add(Restrictions.eq("userIdTo", user_id_to)); ArrayList<TaskDetails> TaskList = (ArrayList<TaskDetails>) cr.list(); System.out.println(TaskList.size()); int i = 0; UserInfo ui = null; Criteria cr1 = ss.createCriteria(UserInfo.class); ArrayList<UserInfo> uiList = new ArrayList<UserInfo>(); for (i = 0; i < TaskList.size(); i++) { cr1.add(Restrictions.eq("userId", TaskList.get(i).getUserIdFrom())); System.out.println("criteria " + i); ui = (UserInfo) cr1.list().get(0); uiList.add(ui); } request.setAttribute("TaskList", TaskList); request.setAttribute("uiList", uiList); request.setAttribute("page", page); path = "TaskList.jsp"; RequestDispatcher rd = request.getRequestDispatcher(path); rd.forward(request, response); } catch (Exception e) { path = "FailureDRO.jsp"; System.out.println(e.getMessage()); RequestDispatcher rd = request.getRequestDispatcher(path); rd.forward(request, response); } }
From source file:admin_add_doctors.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods./*ww w . j a 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 { SessionFactory sf = HibernateUtil.getSessionFactory(); Session ss = sf.openSession(); Transaction tr = ss.beginTransaction(); HttpSession hs = request.getSession(); if (hs.getAttribute("admin") != null) { Admin a = (Admin) hs.getAttribute("admin"); if (request.getParameter("status") != null && request.getParameter("dId") != null) { int apid = Integer.parseInt(request.getParameter("dId")); Doctor doc1 = (Doctor) ss.get(Doctor.class, apid); if (request.getParameter("status").equals("approve")) { doc1.setStatus("ACTIVE"); ss.update(doc1); String subject = "Your Appointment is Approved.!"; String content = "Hi, Dr." + doc1.getDFirstname() + " " + doc1.getDLastname() + "\n" + "Your Request has been approved by Admin" + ".\n"; String mail = doc1.getEmailId(); String[] recipients = new String[] { mail }; //String[] bccRecipients = new String[]{"sunilkotadiya777@gmail.com"}; if (new MailUtil().sendMail(recipients, subject, content)) { } request.setAttribute("msg", "Appointment accepted..!"); } else if (request.getParameter("status").equals("reject")) { doc1.setStatus("REJECTED"); ss.update(doc1); String subject = "Your Request is Rejected.!"; String content = "Hi, " + doc1.getDFirstname() + " " + doc1.getDLastname() + "Your Request to join Cardiac Countermeasure has been rejected by admin" + ".\n anil "; String mail = doc1.getEmailId(); String[] recipients = new String[] { mail }; //String[] bccRecipients = new String[]{"sunilkotadiya777@gmail.com"}; if (new MailUtil().sendMail(recipients, subject, content)) { } request.setAttribute("msg", "Appointment rejected..!"); } } Criteria cr = ss.createCriteria(Doctor.class); //cr.add(Restrictions.eq("dId", a)); cr.add(Restrictions.eq("status", "not_active")); ArrayList<Doctor> da = (ArrayList<Doctor>) cr.list(); if (da.size() > 0) { request.setAttribute("da", da); } tr.commit(); RequestDispatcher rd = request.getRequestDispatcher("admin_add_doctors.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:consultarProfessor.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods.// 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"); try (PrintWriter out = response.getWriter()) { Session sessao = HibernateUtil.getSessionFactory().openSession(); String nome = request.getParameter("nome"); String sobrenome = request.getParameter("sobrenome"); String disciplina = request.getParameter("disciplina"); Criteria c = sessao.createCriteria(Professor.class); if (nome != null && !nome.trim().equals("")) { c.add(Restrictions.eq("nome", nome)); } if (sobrenome != null && !sobrenome.trim().equals("")) { c.add(Restrictions.eq("sobrenome", sobrenome)); } if (disciplina != null && !disciplina.trim().equals("")) { c.add(Restrictions.eq("disciplina", disciplina)); } List<Professor> result = c.list(); if (result != null && result.size() > 0) { for (Professor prof : result) { out.println("<br><a href=\"formEditar?nome=" + prof.getNome() + "\">editar</a> : " + prof.getNome() + " " + prof.getSobrenome()); } } else { out.println("Nenhum resultado encontrado para esse criterio de busca: " + nome + "|" + sobrenome + "|" + disciplina); } } }
From source file:systemgeneratedreport.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods.//from w ww . j a va 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"); 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:$.GenericDaoHibernate.java
protected Criteria findByAttribute(String attribute, Object value) { return getSession().createCriteria(entityClass).add(Restrictions.eq(attribute, value)); }