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:GCTestClient.java

License:BSD License

/**
 * @throws Exception/* w w  w .  j av  a 2 s. c o  m*/
 */
static void querybyNodeTraversal() throws Exception {
    /*Detached Criteria for GenomicIdentifier Set object*/
    DetachedCriteria genomicIdSetCriteria = DetachedCriteria.forClass(GenomicIdentifierSet.class);

    /**
     * Create criteria for ONT where Set should contain a ONT as 
     * EnsemblGene ---Direct---> Entrez Gene ---Direct---> UniGene
     * and optionally can also specify link type between each data source pair.
     */

    /**
     * Create criteria for ONT as:
     * EnsemblGene ---Direct
     */
    DetachedCriteria ontCrit = genomicIdSetCriteria.createCriteria("orderOfNodeTraversalCollection");
    DetachedCriteria ontCritF = ontCrit.createCriteria("sourceDataSource")
            .add(Restrictions.eq("name", "Ensembl Gene"));
    ontCrit.createCriteria("linkType").add(Restrictions.eq("type", "DIRECT"));

    /**
     * Create criteria for ONT as:
     * EnsemblGene ---Direct---> Entrez Gene ---Direct
     */
    DetachedCriteria ontCritF1 = ontCrit.createCriteria("childOrderOfNodeTraversal");

    ontCritF1.createCriteria("sourceDataSource").add(Restrictions.eq("name", "Entrez Gene"));
    ontCritF1.createCriteria("linkType").add(Restrictions.eq("type", "DIRECT"));

    /**
     * Create criteria for ONT as:
     * EnsemblGene ---Direct---> Entrez Gene ---Direct---> UniGene
     */
    DetachedCriteria ontCritF2 = ontCritF1.createCriteria("childOrderOfNodeTraversal");
    DetachedCriteria ontCritF3 = ontCritF2.createCriteria("sourceDataSource");
    ontCritF3.add(Restrictions.eq("name", "UniGene"));
    ontCritF2.add(Restrictions.isNull("childOrderOfNodeTraversal"));

    /**
     * Create Critria for ensemblTranscriptId = ENST1 AND
     * ensemblGeneAsOutput = true AND ensemblPeptideAsOutput = true
     */
    DetachedCriteria mrnaCriteria = genomicIdSetCriteria.createCriteria("messengerRNA");
    mrnaCriteria.add(Restrictions.eq("ensemblTranscriptId", "ENST1"));

    DetachedCriteria geneCriteria = genomicIdSetCriteria.createCriteria("gene");
    geneCriteria.add(Restrictions.eq("ensemblGeneAsOutput", new Boolean(true)));

    DetachedCriteria proteinCriteria = genomicIdSetCriteria.createCriteria("protein");
    proteinCriteria.add(Restrictions.eq("ensemblPeptideAsOutput", new Boolean(true)));

    // load all GenomicIdentifierSet objects with Gene.entrezgeneID = A1 and ONT A->C->D->B

    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();
        System.out.println("**************************************************************");
        System.out.println("Set id: " + gset.getId() + "  Confidence Score: " + gset.getConfidenceScore());
        //         System.out.println("Gid: " + gset.getGene().getEntrezgeneID());
        Collection coll = gset.getOrderOfNodeTraversalCollection();

        /*Get and Print the Order of Node Traveersal associated with this GenomicIdentifierSet*/
        System.out.println("________________________________________________________");
        for (Iterator iter1 = coll.iterator(); iter1.hasNext();) {
            System.out.println("ONT Id----DataSource-------LinkType");
            OrderOfNodeTraversal ont = (OrderOfNodeTraversal) iter1.next();

            OrderOfNodeTraversal tempont = ont;
            while (tempont != null) {
                LinkType ltype = tempont.getLinkType();
                String linkType = null;
                if (ltype != null)
                    linkType = ltype.getType();
                System.out.println(tempont.getId() + "----" + tempont.getSourceDataSource().getName() + "------"
                        + linkType);
                OrderOfNodeTraversal nextont = tempont.getChildOrderOfNodeTraversal();
                tempont = nextont;
            }
            System.out.println("________________________________________________________");
        }
        System.out.println("**************************************************************");
    }
}

From source file:GCTestClient.java

License:BSD License

/**
 * Use case : Query By Limiting ID Frequency 
 * Search on one ensemblPeptideId attribute within a Protein 
 * with a given higher frequency (from GenomicIdentifierData) for Entrez Gene 
 * data source.//from ww w .  ja v  a 2s . c o m
 *  
 * Display the result contining Genomic IDs and associated Frequency
 *   
 * @throws Exception
 */
public static void queryByLimitingIDFrequency() throws Exception {

    /**
     * Create DetachedCriteria for GenomicIdentifierSet with restriction for confidenceScore >=0.2 
     */
    DetachedCriteria genomicIdSetCriteria = DetachedCriteria.forClass(GenomicIdentifierSet.class);

    /**
     * Create Criteria to search on guven frequency of given data source 
     */

    DetachedCriteria freqCriteria = genomicIdSetCriteria.createCriteria("consensusIdentifierDataCollection");

    freqCriteria.add(Restrictions.gt("frequency", new Float("0.1")));
    freqCriteria.add(Restrictions.gt("frequency", new Float("0.1")));

    /** 
     * The dataSource value should be one of the Data Source Name
     * 
     */
    DetachedCriteria genomicIdCriteria = freqCriteria.createCriteria("genomicIdentifier");

    genomicIdCriteria.add(Restrictions.eq("dataSource", "Ensembl Gene"));
    genomicIdCriteria.add(Restrictions.eq("dataSource", "Entrez Gene"));

    /**
     * Create Criteria for ensemblGene selected as ouput 
     */
    DetachedCriteria geneCriteria = genomicIdSetCriteria.createCriteria("gene");
    geneCriteria.add(Restrictions.eq("ensemblGeneAsOutput", new Boolean(true)));

    /**
     * Create Criteria for search on ensemblPeptideId attribute
     */
    DetachedCriteria proteinCriteria = genomicIdSetCriteria.createCriteria("protein");
    proteinCriteria.add(Restrictions.eq("ensemblPeptideId", "ENSP1"));

    /**
     * Create Criteria for refseqmRNA selected as ouput 
     */
    DetachedCriteria mranCriteria = genomicIdSetCriteria.createCriteria("messengerRNA");
    mranCriteria.add(Restrictions.eq("refseqmRNAAsOutput", new Boolean(true)));

    List resultList = appService.query(genomicIdSetCriteria, GenomicIdentifierSet.class.getName());
    System.out.println("ResultSet 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 p = gset.getProtein();

        System.out.println("Ensembl Gene ID | Ensembl Peptide ID | RefSeq mRNA ID");
        System.out.println(gene.getEnsemblGeneId() + "           | " + p.getEnsemblPeptideId()
                + "            | " + mrna.getRefseqId());

        System.out
                .println("-----------------------------------------------------------------------------------");
    }
    /*
     * Print the Genomic identiifer and its frequency throughout the GenomicIdentifierSolution
     */
    System.out.println(
            "Following is  a list of all genomic identifers (occured in this result)and its frequency");
    if (resultList.size() > 0) {
        GenomicIdentifierSet set = (GenomicIdentifierSet) resultList.get(0);

        GenomicIdentifierSolution solution = set.getGenomicIdentifierSolution();
        Collection coll = solution.getConsensusIdentifierDataCollection();
        System.out.println("Genomic Identifer\tFrequency");
        for (Iterator iter1 = coll.iterator(); iter1.hasNext();) {
            //OrderOfNodeTraversal ont = (OrderOfNodeTraversal)iter1.next();
            ConsensusIdentifierData ont = (ConsensusIdentifierData) iter1.next();
            GenomicIdentifier g = ont.getGenomicIdentifier();
            if (g != null)
                System.out.println("\t" + g.getGenomicIdentifier() + "\t\t\t" + ont.getFrequency());
        }
    }
}

From source file:analysis_criteria.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 {

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

From source file:reg_serv_cust.java

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

        //out.println("1");
        String fn = request.getParameter("fname");
        String ln = request.getParameter("lname");
        String un = request.getParameter("uname");
        String stateid = request.getParameter("state");

        String cityid = request.getParameter("city");
        String areaid = request.getParameter("area");
        String e = request.getParameter("email");
        String num = request.getParameter("number");
        String p = request.getParameter("pwd");

        //out.print("2");
        //  out.print("ijhdi");
        SessionFactory sf = NewHibernateUtil.getSessionFactory();
        Session ss = sf.openSession();
        Transaction tr = ss.beginTransaction();

        //out.print("111");
        Login li = new Login();
        li.setUName(un);
        li.setPwd(p);
        li.setURole("customer");

        //    out.print("22");
        ss.save(li);

        // out.println("3");

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

        CustomerDetail cd = new CustomerDetail();
        cd.setUId(li);
        cd.setCFname(fn);
        cd.setCLname(ln);

        cd.setCState(state);
        cd.setCCity(city);
        cd.setCArea(area);

        cd.setCNum(num);
        cd.setCEmail(e);

        ss.save(cd);

        //  out.println("Customer Registered");

        /*
            else if(r.equals(strg2))
            {
                
        AgentDetail ad=new AgentDetail();
        ad.setUId(li);
        ad.setAFname(fn);
        ad.setALname(ln);
        ad.setANo(null);
        ad.setARating(null);
        ad.setAAddress(null);
        ad.setAEmail(e);
                
        ss.save(ad);
        out.println("Agent Registered");
                             
                          
            }
          */

        tr.commit();

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

        RequestDispatcher rd = request.getRequestDispatcher("agent_home.jsp");
        rd.include(request, response);

        // out.println("Registration Complete");

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

From source file:ConsultaProduto.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.//  ww w.  ja  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 ConsultaProduto</title>");
        out.println("</head>");
        out.println("<body>");
        out.println("<h1>Servlet ConsultaProduto at " + request.getContextPath() + "</h1>");
        out.println("</body>");
        out.println("</html>");

        Session s = HibernateUtil.getSessionFactory().openSession();//conectar com o banco

        Criteria criterio = s.createCriteria(Produto.class);
        criterio.add(Restrictions.eq("nome", "azul")); //==> where nome_produ = azul

        List<Produto> resul = criterio.list();

        out.println("Produtos encontrado: <br>");

        for (Produto p : resul) {
            out.println("<br>Produto num: " + p.getIdentificador());
            out.println("<br>Cor: " + p.getNome());
            out.println("<br>Tipo: " + p.getFabricante());
        }
        s.close();

    }
}

From source file:fetch_agentfeedback.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./*  ww  w.  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();
    HttpSession hs = request.getSession();
    try {

        AgentDetail ad = (AgentDetail) hs.getAttribute("agentobj");
        System.out.print("agent id is" + ad.getAId());
        SessionFactory sf = util.NewHibernateUtil.getSessionFactory();
        Session ss = sf.openSession();

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

        if (!afl.isEmpty()) {

            // HttpSession hs1=request.getSession();
            System.out.println(afl.size());
            System.out.println("inside the servlet else");
            System.out.println("inside the servlet else11");

            hs.setAttribute("afl", afl);
            System.out.println("inside the servlet else222");

        }

        else {
            System.out.println("no agent feedback found");
            ;
        }

        RequestDispatcher rd = request.getRequestDispatcher("agentdescription.jsp");
        System.out.println("forwarding");
        rd.forward(request, response);

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

From source file:view_pastsystemreport_bydoc.java

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

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

        if (hs.getAttribute("docotr") != null) {
            Patient a = (Patient) hs.getAttribute("patient");
            int pid = a.getPId();
            Calculationmeteredata cal = (Calculationmeteredata) ss.get(Calculationmeteredata.class, pid);
            Criteria cr = ss.createCriteria(Calculationmeteredata.class);
            cr.add(Restrictions.eq("pId", a));
            // cr.add(Restrictions.eq("status", "PENDING"));
            ArrayList<DoctorAppointment> da = (ArrayList<DoctorAppointment>) cr.list();
            if (da.size() > 0) {
                request.setAttribute("da", da);
            }
            tr.commit();
            RequestDispatcher rd = request.getRequestDispatcher("patient_my_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:TechGuideExamples.java

License:BSD License

public static void main(String[] args) throws Exception {

    System.out.println("*** Tech Guide Examples");

    ApplicationService appService = ApplicationServiceProvider.getApplicationService();

    /** Examples used in Developer Guide */

    try {//  w  ww  . j a  v  a 2  s .  c  o m
        System.out.println("\nExample One: Simple Search (Single Criteria Object)");
        Gene gene = new Gene();
        // searching for all genes whose symbol starts with brca
        gene.setSymbol("brca*");

        List resultList = appService.search(Gene.class, gene);

        for (Iterator resultsIterator = resultList.iterator(); resultsIterator.hasNext();) {
            Gene returnedGene = (Gene) resultsIterator.next();
            System.out.println("Symbol: " + returnedGene.getSymbol() + "\tTaxon:"
                    + returnedGene.getTaxon().getScientificName() + "\tName " + returnedGene.getFullName());
        }
    } catch (RuntimeException e) {
        e.printStackTrace();
    }

    try {
        System.out.println("\nExample Two: Simple Search (Criteria Object Collection)");
        Taxon taxon1 = new Taxon();
        taxon1.setAbbreviation("hs"); // Homo sapiens
        Taxon taxon2 = new Taxon();
        taxon2.setAbbreviation("m"); // Mus musculus
        List<Taxon> taxonList = new ArrayList<Taxon>();
        taxonList.add(taxon1);
        taxonList.add(taxon2);
        List resultList = appService.search(Gene.class, taxonList);
        System.out.println("Total # of records = " + resultList.size());

    } catch (Exception e) {
        e.printStackTrace();
    }

    try {
        System.out.println("\nExample Three: Simple Search (Compound Criteria Object)");
        Taxon taxon = new Taxon();
        taxon.setAbbreviation("hs"); // Homo sapiens
        Gene gene = new Gene();
        gene.setTaxon(taxon);
        gene.setSymbol("IL5"); // Interleukin 5
        List<Gene> geneList = new ArrayList<Gene>();
        geneList.add(gene);
        Pathway pathway = new Pathway();
        pathway.setGeneCollection(geneList);
        List resultList = appService.search("gov.nih.nci.cabio.domain.Pathway", pathway);
        for (Iterator resultsIterator = resultList.iterator(); resultsIterator.hasNext();) {
            Pathway returnedPathway = (Pathway) resultsIterator.next();
            System.out.println("Name: " + returnedPathway.getName() + "\tDisplayValue: "
                    + returnedPathway.getDisplayValue());
        }
    } catch (Exception e) {
        e.printStackTrace();
    }

    try {
        System.out.println("\nExample Four: Nested Search");
        Gene gene = new Gene();
        gene.setSymbol("TP53"); // Tumor protein p53 (Li-Fraumeni syndrome)   
        List resultList = appService
                .search("gov.nih.nci.cabio.domain.ProteinSequence,gov.nih.nci.cabio.domain.Protein", gene);
        for (Iterator resultsIterator = resultList.iterator(); resultsIterator.hasNext();) {
            ProteinSequence returnedProtSeq = (ProteinSequence) resultsIterator.next();
            System.out.println("Id: " + returnedProtSeq.getId() + "\tLength: " + returnedProtSeq.getLength());
        }
    } catch (Exception e) {
        e.printStackTrace();
    }

    try {
        System.out.println("\nExample Five: Detached Criteria Search");
        DetachedCriteria criteria = DetachedCriteria.forClass(PhysicalLocation.class);
        criteria = criteria.add(Restrictions.gt("chromosomalStartPosition", new Long(86851632)));
        criteria = criteria.add(Restrictions.lt("chromosomalEndPosition", new Long(86861632)));
        criteria = criteria.add(Restrictions.ilike("assembly", "reference"));
        criteria = criteria.createCriteria("chromosome").add(Restrictions.eq("number", "1"));
        List resultList = appService.query(criteria);
        System.out.println("Total # of  records = " + resultList.size());
    } catch (Exception e) {
        e.printStackTrace();
    }

    try {
        System.out.println("\nExample Six: HQL Search");
        String hqlString = "FROM gov.nih.nci.cabio.domain.Gene g WHERE g.symbol LIKE ?";
        List<String> params = new ArrayList<String>();
        params.add("BRCA%");
        HQLCriteria hqlC = new HQLCriteria(hqlString, params);
        List resultList = appService.query(hqlC);
        System.out.println("Total # of records = " + resultList.size());
    } catch (Exception e) {
        e.printStackTrace();
    }

}

From source file:prop_add_serv.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.//from ww  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, FileUploadException {
    response.setContentType("text/html;charset=UTF-8");

    HttpSession hs = request.getSession();
    PrintWriter out = response.getWriter();
    try {

        if (hs.getAttribute("user") != null) {
            Login ln = (Login) hs.getAttribute("user");
            System.out.println(ln.getUId());
            String pradd1 = "";
            String pradd2 = "";
            String prage = "";
            String prarea = "";
            String prbhk = "";
            String prdescrip = "";
            String prprice = "";
            String prcity = "";
            String prstate = "";
            String prname = "";
            String prtype = "";

            String prfarea = "";
            String prphoto1 = "";
            String prphoto2 = "";
            String prphoto3 = "";
            String prphoto4 = "";

            //             
            // creates FileItem instances which keep their content in a temporary file on disk
            FileItemFactory factory = new DiskFileItemFactory();
            // Create a new file upload handler
            ServletFileUpload upload = new ServletFileUpload(factory);

            //get the list of all fields from request
            List<FileItem> fields = upload.parseRequest(request);
            // iterates the object of list
            Iterator<FileItem> it = fields.iterator();
            //getting objects one by one
            while (it.hasNext()) {
                //assigning coming object if list to object of FileItem
                FileItem fileItem = it.next();
                //check whether field is form field or not
                boolean isFormField = fileItem.isFormField();

                if (isFormField) {
                    //get the filed name 
                    String fieldName = fileItem.getFieldName();

                    if (fieldName.equals("pname")) {
                        //getting value of field
                        prname = fileItem.getString();
                        System.out.println(prname);
                    } else if (fieldName.equals("price")) {
                        //getting value of field
                        prprice = fileItem.getString();
                        System.out.println(prprice);
                    } else if (fieldName.equals("city")) {
                        prcity = fileItem.getString();
                        System.out.println(prcity);
                    } else if (fieldName.equals("state")) {
                        prstate = fileItem.getString();
                        System.out.println(prstate);
                    } else if (fieldName.equals("area")) {
                        prarea = fileItem.getString();
                        System.out.println(prarea);
                    } else if (fieldName.equals("pbhk")) {
                        prbhk = fileItem.getString();
                        System.out.println(prbhk);
                    } else if (fieldName.equals("pdescription")) {
                        prdescrip = fileItem.getString();
                        System.out.println(prdescrip);

                    } else if (fieldName.equals("ptype")) {
                        prtype = fileItem.getString();
                        System.out.println(prtype);

                    } else if (fieldName.equals("paddress1")) {
                        pradd1 = fileItem.getString();
                        System.out.println(pradd1);
                    } else if (fieldName.equals("paddress2")) {
                        pradd2 = fileItem.getString();
                        System.out.println(pradd2);
                    } else if (fieldName.equals("page")) {
                        prage = fileItem.getString();
                        System.out.println(prage);
                    } else if (fieldName.equals("pfarea")) {
                        prfarea = fileItem.getString();
                        System.out.println(prfarea);
                    }
                } else {

                    String fieldName = fileItem.getFieldName();

                    if (fieldName.equals("photo1")) {

                        //getting name of file
                        prphoto1 = new File(fileItem.getName()).getName();

                        //get the extension of file by diving name into substring
                        // String extension=prphoto.substring(prphoto.indexOf(".")+1,prphoto.length());;
                        //rename file...concate name and extension
                        //prphoto=prname+"."+extension;
                        //System.out.println(prphoto);
                        try {

                            String fp = "/home/rushin/NetBeansProjects/The_Asset_Consultancy/web/images/property/";
                            // FOR UBUNTU add GETRESOURCE  and GETPATH
                            // String filePath = this.getServletContext().getResource("/images").getPath() + "\\";
                            fileItem.write(new File(fp + prphoto1));
                        } catch (Exception ex) {
                            out.println(ex.toString());
                        }
                    }

                    //PHOTO 2

                    else if (fieldName.equals("photo2")) {
                        prphoto2 = new File(fileItem.getName()).getName();

                        try {

                            String fp = "/home/rushin/NetBeansProjects/The_Asset_Consultancy/web/images/property/";
                            fileItem.write(new File(fp + prphoto2));
                        } catch (Exception ex) {
                            out.println(ex.toString());
                        }

                    }
                    //PHOTO 3
                    else if (fieldName.equals("photo3")) {

                        prphoto3 = new File(fileItem.getName()).getName();
                        try {

                            String fp = "/home/rushin/NetBeansProjects/The_Asset_Consultancy/web/images/property/";
                            fileItem.write(new File(fp + prphoto3));
                        } catch (Exception ex) {
                            out.println(ex.toString());
                        }
                    }

                    //PHOTO 4
                    else if (fieldName.equals("photo4")) {
                        prphoto4 = new File(fileItem.getName()).getName();
                        try {

                            String fp = "/home/rushin/NetBeansProjects/The_Asset_Consultancy/web/images/property/";
                            fileItem.write(new File(fp + prphoto4));
                        } catch (Exception ex) {
                            out.println(ex.toString());
                        }
                    }

                }

            }

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

            String op = "";
            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);
                op = 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);
            }

            PropDetail pd = new PropDetail();

            pd.setUId(ln);

            pd.setPAge(Integer.parseInt(prage));

            pd.setPBhk(prbhk);
            pd.setPDescription(prdescrip.trim());
            pd.setPAdd1(pradd1);
            pd.setPAdd2(pradd2);
            pd.setPPrice(Integer.parseInt(prprice));

            pd.setPCity(city);
            pd.setPState(op);
            pd.setPArea(area);

            pd.setPName(prname);
            pd.setPType(prtype);
            pd.setPImg1(prphoto1);
            System.out.println(prphoto1);
            System.out.println(prphoto2);
            pd.setPImg2(prphoto2);

            pd.setPImg3(prphoto3);
            pd.setPImg4(prphoto4);

            pd.setPFloor(Integer.parseInt(prfarea));

            ss.save(pd);

            tr.commit();

            RequestDispatcher rd = request.getRequestDispatcher("property_search_1.jsp");
            rd.forward(request, response);
        }
    } catch (HibernateException e) {
        out.println(e.getMessage());
    }
}