Example usage for org.hibernate.criterion Restrictions eq

List of usage examples for org.hibernate.criterion Restrictions eq

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. eq

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions eq.

Prototype

public static SimpleExpression eq(String propertyName, Object value)

Source Link

Document

Apply an "equal" constraint to the named property

Usage

From source file:ConsultaVinho.java

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

        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./*  www .  j ava2 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("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 w w.jav 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 {

        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.// ww w  . 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 {

        //            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.//from ww w  .  ja  va2  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  . 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();
    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 . java2 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 {
    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();/*ww w  . jav a  2 s .c o  m*/
    //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:GCTestClient.java

License:BSD License

/**
 * Use case : Basic Genomic ID Search /*from   w  w w.ja va 2s .c om*/
 * Search on one more attribute within a Gene,MessengerRNA or Protein and 
 * return result from that search as a list of objects of the same class
 *  
 *  Query in this Method:
 *  Search on Gene where ensemblGeneId='ENS2' and get associated MessengerRNA 
 *  and print GenbankAccession.
 *   
 */
static void querySimple() throws Exception {

    /**
     * Create a DetachedCriteria for Gene with ensemblGeneId=ENS2
     */
    DetachedCriteria geneCriteria = DetachedCriteria.forClass(Gene.class);
    geneCriteria.add(Restrictions.eq("ensemblGeneId", "ENS2"));

    List resultList = appService.query(geneCriteria, Gene.class.getName());

    for (Iterator iter1 = resultList.iterator(); iter1.hasNext();) {
        /** get Gene Object form resultList*/
        Gene gene = (Gene) iter1.next();
        System.out.println("EnsemblGeneId : " + gene.getEnsemblGeneId());
        /** get associated mRNAColelction from Gene*/
        Collection coll = gene.getMessengerRNACollection();
        for (Iterator iter = coll.iterator(); iter.hasNext();) {
            MessengerRNA mrna = (MessengerRNA) iter.next();

            /** Print value of GenbankAccession attribute of MessengerRNA object */
            System.out.println("GenbankAccession : " + mrna.getGenbankAccession());
        }
    }

}

From source file:GCTestClient.java

License:BSD License

/**
 * Use case : Query Based on Confidence 
 * Search on one more attribute within a Gene,MessengerRNA or Protein class
 * with a given or higher confidence score (from GenomicIdentifierSet).
 * Traverse the model to get data from the other classes.
 *  //w w w. jav  a 2 s .c o  m
 *  Query in this method:
 *  Search on Protein where ensemblGeneId='ENS2' AND unigene,ensemblPeptide as output 
 *  AND confidenceScore > 0.2
 *  Print Set ID,Confidenscore and associated Gene,mRNA values with this Set 
 *  
 */

static void queryConfScore() throws Exception {
    /**
     * Create Detached for GenomicIdentifierSet Object and add restriction on confidence score
     * confidenceScore>0.2
     */
    DetachedCriteria genomicIdSetCriteria = DetachedCriteria.forClass(GenomicIdentifierSet.class);
    genomicIdSetCriteria.add(Restrictions.gt("confidenceScore", new Float("0.1")));

    /**
     * Create Criteria for search on ensemblGeneId = ENS2 AND unigeneAsOutput = true
     * AND ensemblPeptideAsOutput=true
     */

    DetachedCriteria geneCriteria = genomicIdSetCriteria.createCriteria("gene");
    geneCriteria.add(Restrictions.eq("ensemblGeneId", "ENS2"));

    geneCriteria.add(Restrictions.eq("unigeneAsOutput", new Boolean(true)));

    DetachedCriteria proteinCriteria = genomicIdSetCriteria.createCriteria("protein");
    proteinCriteria.add(Restrictions.eq("ensemblPeptideAsOutput", new Boolean(true)));
    /**
     * Execute the Query
     */
    List resultList = appService.query(genomicIdSetCriteria,
            "edu.wustl.geneconnect.domain.GenomicIdentifierSet");
    System.out.println("Result Size: " + resultList.size());
    for (Iterator iter = resultList.iterator(); iter.hasNext();) {

        GenomicIdentifierSet gset = (GenomicIdentifierSet) iter.next();
        /**Print Set Id and Confidence Score*/
        System.out.println(
                "\nSet Id: " + gset.getId() + "  Confidence Score: " + gset.getConfidenceScore() + "\n");
        Gene gene = gset.getGene();
        MessengerRNA mrna = gset.getMessengerRNA();
        Protein protein = gset.getProtein();

        System.out.println("Ensembl Gene ID | UniGene cluster ID | Ensembl Peptide ID");
        System.out.println(gene.getEnsemblGeneId() + "           | " + gene.getUnigeneClusterId()
                + "            | " + protein.getEnsemblPeptideId());

        System.out
                .println("-----------------------------------------------------------------------------------");
    }
}