Example usage for org.hibernate Criteria list

List of usage examples for org.hibernate Criteria list

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.*
  5. Criteria
  6. list

Introduction

In this page you can find the example usage for org.hibernate Criteria list.

Prototype

public List list() throws HibernateException;

Source Link

Document

Get the results.

Usage

From source file:get_lab_admin.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./* ww w.  java 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();

    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();

        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>" + dd.getStatus() + "</p>\n"
                        + "                                        <div class=\"ui heart rating\" data-rating=\"1\" data-max-rating=\"3\"></div>\n"
                        + "                                        <a class=\"reply-btn\" href=\"view_labprofile_admin?lid="
                        + dd.getLId() + "\">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:ProjectList.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./* www.  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");
    String page = "null";
    PrintWriter out = response.getWriter();
    try {
        SessionFactory sf = NewHibernateUtil.getSessionFactory();
        Session ss = sf.openSession();
        Transaction tr = ss.beginTransaction();

        page = request.getParameter("page");
        request.getSession().setAttribute("page", page);

        String role = "", path = "ProjectList.jsp";
        Criteria cr = null;
        ArrayList<ProjectDetails> ProjectList = new ArrayList<ProjectDetails>();
        ArrayList<ProjectUserDetails> ProjectUserList = null;

        LoginInfo loginInfo = (LoginInfo) request.getSession().getAttribute("loginInfo");
        int userId = Integer.parseInt(request.getSession().getAttribute("userId").toString());
        role = request.getSession().getAttribute("role").toString();

        HttpServletRequest request1 = (HttpServletRequest) request;
        String uri = request1.getRequestURI();
        switch (role) {
        case "G":
            ProjectDetails pd = new ProjectDetails();
            cr = ss.createCriteria(ProjectDetails.class);
            cr.add(Restrictions.eq("userIdFrom", loginInfo));
            ProjectList = (ArrayList<ProjectDetails>) cr.list();
            //                    System.out.println(ProjectList.size());
            break;

        default:
            ProjectUserDetails pudDRO = new ProjectUserDetails();
            cr = ss.createCriteria(ProjectUserDetails.class);
            cr.add(Restrictions.eq("userIdTo", loginInfo));
            ProjectUserList = (ArrayList<ProjectUserDetails>) cr.list();
            //                    System.out.println(ProjectUserList.size());

            //                    ProjectDetails mineId;
            //                    ProjectDetails pd1;
            //                    for (int i = 1; i <= ProjectUserList.size(); i++) {
            //                         mineId=(ProjectDetails) ProjectUserList.get(i).getMineId();                         
            ////                         pd1 = new ProjectDetails();
            ////                         cr = ss.createCriteria(ProjectDetails.class);
            ////                         cr.add(Restrictions.eq("mineId", mineId));                           
            //                         ProjectList.set(i, mineId);
            //                    }
            for (ProjectUserDetails pud : ProjectUserList) {
                Criteria cr3 = ss.createCriteria(ProjectDetails.class);
                cr3.add(Restrictions.eq("mineId", pud.getMineId().getMineId()));
                ArrayList<ProjectDetails> pList = (ArrayList<ProjectDetails>) cr3.list();

                if (pList.size() != 0) {
                    ProjectList.add(pList.get(0));
                }

            }
            break;
        }

        tr.commit();
        HttpSession hs = request.getSession();
        hs.setAttribute("ProjectList", ProjectList);
        RequestDispatcher rd = request.getRequestDispatcher(path);
        rd.forward(request, response);

    } catch (Exception e) {
        out.println(e.getMessage());
    }
}

From source file:agentrequestlist_serv.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.//from   w ww  .  j  a 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 = NewHibernateUtil.getSessionFactory();
        Session ss = sf.openSession();
        Transaction tr = ss.beginTransaction();
        String status = "Pending";

        Criteria cr = ss.createCriteria(AgentDetail.class);
        cr.add(Restrictions.eq("aStatus", status));
        ArrayList<AgentDetail> adl = (ArrayList<AgentDetail>) cr.list();

        if (!adl.isEmpty()) {
            request.setAttribute("adl", adl);
            RequestDispatcher rd = request.getRequestDispatcher("agentrequestlist.jsp");
            rd.forward(request, response);
        }

    } catch (HibernateException e) {
        out.print(e.getMessage());
    }
}

From source file:consulta.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");
    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./*  ww w. java2s .  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 {

        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.//from  w w w  . j  ava 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();
        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:viewblogs_user.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./*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");
    PrintWriter out = response.getWriter();
    try {

        SessionFactory sf = HibernateUtil.getSessionFactory();
        Session ss = sf.openSession();
        Transaction tr = ss.beginTransaction();
        HttpSession hs = request.getSession();

        if (hs.getAttribute("patient") != null) {

            Blog b1 = new Blog();

            Criteria cr = ss.createCriteria(Blog.class);
            ArrayList<Blog> da = (ArrayList<Blog>) cr.list();
            if (da.size() > 0) {

                request.setAttribute("da", da);
            }

            tr.commit();
            RequestDispatcher rd = request.getRequestDispatcher("blogs_user.jsp");
            rd.forward(request, response);

        } else {
            RequestDispatcher rd = request.getRequestDispatcher("login.jsp");
            rd.forward(request, response);
        }
    }

    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 ww  w.ja 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");

    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 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 = "";

    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  w  w.  jav 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 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());
    }
}