Example usage for org.hibernate Criteria add

Introduction

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

Prototype

public Criteria add(Criterion criterion);

Source Link

Document

Add a Criterion restriction to constrain the results to be retrieved.

Usage

From source file:ConsultaVinho.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");
    try (PrintWriter out = response.getWriter()) {
        /* TODO output your page here. You may use following sample code. */

        try {
            String vinho = request.getParameter("vinho");

            Session s = HibernateUtil.getSessionFactory().openSession();

            Criteria criteria = s.createCriteria(Vinho.class);
            criteria.add(Restrictions.eq("nome", vinho));

            List<Vinho> result = criteria.list();

            for (Vinho v : result) {
                out.println("<br>Vinho: " + v.getNome());
                out.println("<br>Uva: " + v.getUva());
                out.println("<br>Ano: " + v.getAno_safra());
                out.println("<br>");

            }
            s.close();
        } catch (Exception e) {
            out.println("Erro na Busca " + e.getMessage());
        }
    }
}

From source file:take_test.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./*  w  w  w. j  av  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) {
            if (request.getParameter("labid") != null) {
                Patient p = (Patient) hs.getAttribute("patient");
                int labid = Integer.parseInt(request.getParameter("labid"));
                Lab la = new Lab(labid);

                Criteria cr = ss.createCriteria(Labtest.class);
                cr.add(Restrictions.eq("lId", la));
                ArrayList<Labtest> ltlist = (ArrayList<Labtest>) cr.list();
                if (ltlist.size() > 0) {
                    request.setAttribute("ltlist", ltlist);
                }
                tr.commit();
                RequestDispatcher rd = request.getRequestDispatcher("patient_labtest_takeappointment.jsp");
                rd.forward(request, response);
            } else {
                tr.commit();
                RequestDispatcher rd = request.getRequestDispatcher("consult_lab.jsp");
                rd.forward(request, response);
            }
        } else {
            tr.commit();
            RequestDispatcher rd = request.getRequestDispatcher("login.jsp");
            rd.forward(request, response);
        }
    } catch (HibernateException he) {
        he.getMessage();
    } finally {
        out.close();
    }
}

From source file:searchagent_byarea.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.//from  w ww  .  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 {

        SessionFactory sf = NewHibernateUtil.getSessionFactory();
        Session ss = sf.openSession();
        Transaction tr = ss.beginTransaction();

        String stateid = request.getParameter("state");
        String cityid = request.getParameter("city");
        String areaid = request.getParameter("area");
        String aname = request.getParameter("aname");

        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("-------" + 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);
        }

        Criteria cr4 = ss.createCriteria(AgentDetail.class);
        cr4.add(Restrictions.eq("aState", state));
        cr4.add(Restrictions.eq("aCity", city));
        cr4.add(Restrictions.eq("aArea", area));

        ArrayList<AgentDetail> ar4 = (ArrayList<AgentDetail>) cr4.list();
        System.out.println("-------AgentList Size---" + ar4.size());
        if (ar4.isEmpty()) {
            out.print("no such agent");
            String msg = "Sorry, No results found.";
            request.setAttribute("error", msg);
        } else {
            request.setAttribute("agent_array", ar4);

        }

        RequestDispatcher rd = request.getRequestDispatcher("getstate?id=4");
        rd.forward(request, response);
        tr.commit();

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

From source file:login_serv.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./*from   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 {

        //            Login li=new Login();

        SessionFactory sf = NewHibernateUtil.getSessionFactory();
        Session ss = sf.openSession();
        Transaction tr = ss.beginTransaction();

        Criteria cr = ss.createCriteria(Login.class);

        String uname = request.getParameter("username");
        String pass = request.getParameter("psswd");

        cr.add(Restrictions.eq("uName", uname));
        cr.add(Restrictions.eq("pwd", pass));

        ArrayList<Login> alli = (ArrayList<Login>) cr.list();
        //            out.println("jgfghfgh");
        if (alli.isEmpty()) {

            String msg = "Invalid Username or Password.";
            request.setAttribute("error", msg);
            RequestDispatcher rd = request.getRequestDispatcher("/login.jsp");

            rd.forward(request, response);
        }

        else {
            Login l = alli.get(0);

            HttpSession session = request.getSession();
            session.setAttribute("user", l);

            //request.setAttribute("usname",uname);
            switch (l.getURole()) {
            case "customer": {
                RequestDispatcher rd = request.getRequestDispatcher("index.jsp");
                rd.include(request, response);
                break;
            }
            case "agent": {

                Criteria cr1 = ss.createCriteria(AgentDetail.class);
                cr1.add(Restrictions.eq("uId", l));
                ArrayList<AgentDetail> adl = (ArrayList<AgentDetail>) cr1.list();
                AgentDetail ad = adl.get(0);

                if (ad.getAStatus().equals("Accepted")) {
                    RequestDispatcher rd = request.getRequestDispatcher("index.jsp");
                    rd.include(request, response);
                }

                else if (ad.getAStatus().equals("Pending")) {
                    String msg = "Your details are still being verified. Please try later.";
                    request.setAttribute("error", msg);
                    RequestDispatcher rd = request.getRequestDispatcher("/login.jsp");

                    rd.forward(request, response);
                }
                break;
            }
            case "admin": {
                RequestDispatcher rd = request.getRequestDispatcher("adminhome.jsp");
                rd.include(request, response);
                break;
            }
            default: {
                RequestDispatcher rd = request.getRequestDispatcher("login.jsp");
                rd.include(request, response);
                break;
            }

            }

        }

        //            li=alli.get(0);
        tr.commit();

    } catch (Exception e) {
        System.out.print(e.getMessage());
    }

}

From source file:getarea.java

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

        int cityid = Integer.parseInt(request.getParameter("city"));
        //out.print(cityid);

        CityMaster cm = new CityMaster();
        cm.setCityId(cityid);

        Criteria cr = ss.createCriteria(AreaMaster.class);
        cr.add(Restrictions.eq("cityId", cm));
        // cr.add(Restrictions.eq("sId",sm));

        ArrayList<AreaMaster> ctlist = (ArrayList<AreaMaster>) cr.list();

        for (int i = 0; i < ctlist.size(); i++) {
            AreaMaster am = ctlist.get(i);
            String arname = am.getAreaName();
            System.out.println("-------------getarea" + arname);
            System.out.println("------------- " + am.getAreaId());
            out.print("<option value=" + am.getAreaId() + ">" + arname + "</option>");
        }

        tr.commit();

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

From source file:getgroups.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./*from w  w w .j a  va2  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 {

        SessionFactory sf = NewHibernateUtil.getSessionFactory();
        Session ss = sf.openSession();
        Transaction tr = ss.beginTransaction();

        Login ln = (Login) hs.getAttribute("user");
        System.out.println(ln.getUName() + "is the user");
        int id = Integer.parseInt(request.getParameter("id"));

        Criteria cr = ss.createCriteria(GmemberDetail.class);
        cr.add(Restrictions.eq("uId", ln));
        ArrayList<GmemberDetail> gmdl = (ArrayList<GmemberDetail>) cr.list();
        //            ArrayList<GroupDetail> gdl1 = new ArrayList<>();
        //            for (GmemberDetail g : gmdl) {
        //                
        //                System.out.println(g.getGId());
        //                Criteria cr1 = ss.createCriteria(GroupDetail.class);
        //                cr1.add(Restrictions.eq("gId", g.getGId().getGId()));
        //
        //                GroupDetail gd = (GroupDetail) cr1.uniqueResult();
        //                gdl1.add(gd);
        //
        //            }

        System.out.println("=====glist size=====" + gmdl.size());
        request.setAttribute("grouplist", gmdl);

        if (id == 0) {
            RequestDispatcher rd = request.getRequestDispatcher("group_home.jsp");
            rd.forward(request, response);
        } else if (id == 1)

        {

            int uid = Integer.parseInt(request.getParameter("uid"));
            request.setAttribute("uid", uid);
            RequestDispatcher rd = request.getRequestDispatcher("groupsofuser.jsp");
            rd.forward(request, response);
        }

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

From source file:go_to_user.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./*from   ww  w.j a v a2s .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 {
    PrintWriter out = response.getWriter();
    try {

        String id = request.getParameter("id");

        SessionFactory sf = NewHibernateUtil.getSessionFactory();
        Session ss = sf.openSession();
        Transaction tr = ss.beginTransaction();

        Login l = (Login) ss.get(Login.class, Integer.parseInt(id));
        System.out.println("uid is " + l.getUId());

        switch (l.getURole()) {
        case "customer": {
            Criteria cr = ss.createCriteria(CustomerDetail.class);
            cr.add(Restrictions.eq("uId", l));
            CustomerDetail cd = (CustomerDetail) cr.uniqueResult();

            request.setAttribute("fname", cd.getCFname());
            request.setAttribute("lname", cd.getCLname());

            request.setAttribute("email", cd.getCEmail());
            request.setAttribute("mobile", cd.getCNum());

            RequestDispatcher rd = request.getRequestDispatcher("contact_customer.jsp");
            rd.forward(request, response);

            break;
        }

        case "agent": {

            Criteria cr = ss.createCriteria(AgentDetail.class);
            cr.add(Restrictions.eq("uId", l));
            AgentDetail ad = (AgentDetail) cr.uniqueResult();

            Criteria cr1 = ss.createCriteria(AgentFeedback.class);
            cr1.add(Restrictions.eq("aId", ad));
            ArrayList<AgentFeedback> afl = (ArrayList<AgentFeedback>) cr1.list();

            request.setAttribute("ad", ad);

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

            break;
        }
        }

    }

    catch (HibernateException he) {
        System.out.println(he.getMessage());
    }

}

From source file:loginServlet.java

@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    String username = request.getParameter("username");
    String password = request.getParameter("password");
    SessionFactory sf = HibernateUtil.getSessionFactory();
    Session session = sf.openSession();/*from   w w  w  .j a va  2 s  .  c om*/
    //userpass query
    Criteria crit = session.createCriteria(SystemUser.class);
    Criterion cond1 = Restrictions.eq("username", username);
    Criterion cond2 = Restrictions.eq("password", password);
    crit.add(Restrictions.and(cond1, cond2));
    if ((SystemUser) crit.uniqueResult() != null) {
        //redirect positive
        RequestDispatcher rdp = request.getRequestDispatcher("/success.jsp");
        rdp.forward(request, response);
    } else {
        //redirect negative 
        RequestDispatcher rdp = request.getRequestDispatcher("/fail.jsp");
        rdp.forward(request, response);
    }
    ;

}

From source file:analysis_criteria.java

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

        String prstate = request.getParameter("state");
        String prcity = request.getParameter("city");
        String prarea = request.getParameter("area");
        String ptype = request.getParameter("type");
        String pbhk = request.getParameter("bhk");
        String przip = "";

        System.out.println("bhk is" + pbhk);
        System.out.println("type is" + ptype);

        String state = "";
        Criteria cr = ss.createCriteria(StateMaster.class);
        cr.add(Restrictions.eq("sId", Integer.parseInt(prstate)));
        ArrayList<StateMaster> ar = (ArrayList<StateMaster>) cr.list();
        if (ar.isEmpty()) {

        } else {
            StateMaster sm = ar.get(0);
            state = sm.getSName();

        }

        String city = "";
        Criteria cr2 = ss.createCriteria(CityMaster.class);
        cr2.add(Restrictions.eq("cityId", Integer.parseInt(prcity)));
        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(prarea)));
        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);
        }

        Criteria cr4 = ss.createCriteria(AreaMaster.class);
        cr4.add(Restrictions.eq("areaId", Integer.parseInt(prarea)));
        ArrayList<AreaMaster> ar4 = (ArrayList<AreaMaster>) cr4.list();
        System.out.println("----------" + ar4.size());
        if (ar4.isEmpty()) {

        } else {
            przip = ar4.get(0).getZip();
            System.out.println("-------" + przip);
        }

        out.print("after object 0");

        //            
        //            String s="select * from the_asset_consultancy.Filter_criteria;";
        //            
        //            SQLQuery query=ss.createSQLQuery(s);
        //            List<Filtercriteria> l=query.list();
        //          
        Criteria cr5 = ss.createCriteria(Filtercriteria.class);

        ArrayList<Filtercriteria> l = (ArrayList<Filtercriteria>) cr5.list();

        Filtercriteria old = l.get(0);
        System.out.println("this is old cr id:" + old.getCrId());

        Filtercriteria f = new Filtercriteria();

        f.setCrId(old.getCrId());

        f.setArea(area);

        out.print("after object 1");

        f.setBhk(pbhk);
        f.setType(ptype);
        f.setZip(przip);

        ss.evict(old);
        ss.update(f);

        out.print("after object 2");
        tr.commit();
        out.print("after object 3");

        out.print("after object 4");

        //for trial 
        HadoopProcessingClass.Do_Process();
        RequestDispatcher rd = request.getRequestDispatcher("show_growthrate");
        rd.forward(request, response);

        //Original code
        //            RequestDispatcher rd = request.getRequestDispatcher("analysis_search.jsp");
        //            rd.forward(request, response);

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

From source file:BuscarPorNome.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. */

        Session sessao = HibernateUtil.getSessionFactory().openSession();

        Criteria criteria = sessao.createCriteria(Cliente.class);

        criteria.add(Restrictions.eq("nome", request.getParameter("nome")));

        List<Cliente> resultado = criteria.list();

        for (Cliente c : resultado) {
            out.println("Cliente encontrado: ");
            out.println("nome: " + c.getNome());
            out.println("cpf: " + c.getCpf());
            out.println("");
        }

        out.println("<!DOCTYPE html>");
        out.println("<html>");
        out.println("<head>");
        out.println("<title>Servlet BuscarPorNome</title>");
        out.println("</head>");
        out.println("<body>");
        out.println("<h1>Servlet BuscarPorNome at " + request.getContextPath() + "</h1>");
        out.println("</body>");
        out.println("</html>");
    }
}