Package org.hibernate.criterion

Examples of org.hibernate.criterion.ProjectionList

113
114
115
116
117
118
119
120
121
122
123
124
                criteria.add(Expression.eq("nodeId", nodeId));

                criteria.add(Expression.eq("alive", java.lang.Boolean.TRUE));

                ProjectionList prolist = Projections.projectionList();
                prolist.add(Projections.rowCount());
                criteria.setProjection(prolist);

                return criteria.uniqueResult();
            }
        });
View Full Code Here
139
140
141
142
143
144
145
146
147
148
149
150
                Criterion cri2 = Expression.eq("state", new Integer(ITaskInstance.COMPLETED));

                criteria.add(cri2);

                ProjectionList prolist = Projections.projectionList();
                prolist.add(Projections.rowCount());
                criteria.setProjection(prolist);

                return criteria.uniqueResult();
            }
        });
View Full Code Here
168
169
170
171
172
173
174
175
176
177
178
179
                Criterion cri2 = Expression.eq("state", new Integer(ITaskInstance.RUNNING));
                Criterion cri_or = Expression.or(cri1, cri2);

                criteria.add(cri_or);

                ProjectionList prolist = Projections.projectionList();
                prolist.add(Projections.rowCount());
                criteria.setProjection(prolist);

                return criteria.uniqueResult();
            }
        });
View Full Code Here
857
858
859
860
861
862
863
864
865
866
867
868
                Criterion cri_or = Expression.or(cri1, cri2);
//              Criterion cri_or = Expression.or(cri_tmp, cri3);

                criteria.add(cri_or);

                ProjectionList prolist = Projections.projectionList();
                prolist.add(Projections.rowCount());
                criteria.setProjection(prolist);

                return criteria.uniqueResult();
            }
        });
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
40
41
          //      c1.setProjection(Projections.property("username"));
          //      c1.setProjection(Projections.property("address"));
    int len=s.length;
    System.out.println(len);
   
    ProjectionList p1=Projections.projectionList();        
    for(int i=0; i<len; i++)
    {
                 p1.add(Projections.property(s[i]));
                 System.out.println(s[i]);
                
          //        p1.add(Projections.property("address"));
    }          
                 
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
41
42
43
    Session session=s1.openSession();
    //processor p=new processor();

   
    Criteria criteria=session.createCriteria(osvo.class);
    ProjectionList p=Projections.projectionList();
    //p.add(Projections.property("osname"));
    p.add(Projections.groupProperty("osname"));
    p.add(Projections.rowCount());
    criteria.setProjection(p);
   
   
 
    List l1 =  criteria.list();
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
41
42
43
    Session session=s1.openSession();
    //select os.osname id.name from machine id, osvo so
    Criteria criteria = session.createCriteria(osvo.class, "os");
    criteria.createAlias("os.machineid", "id", Criteria.INNER_JOIN);
   
    ProjectionList p=Projections.projectionList();
   
    p.add(Projections.property("id.name"));
    p.add(Projections.property("osname"));
    criteria.setProjection(p);
    List l1 =  criteria.list();
    Gson gson = new Gson();
         String record = gson.toJson(l1);
         System.out.println("record in json = " + record);
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
44
45
    Criteria c1=session.createCriteria(login.class);
  //  c1.add(Restrictions.and(Restrictions.eq("id", new Integer(0)),Restrictions.like("username","vipul")));
  //  c1.addOrder(Order.desc("id"));
  //  c1.setProjection(Projections.property("username"));
  //  c1.setProjection(Projections.property("address"));
    ProjectionList p1=Projections.projectionList();
    p1.add(Projections.property("username"));
    p1.add(Projections.property("address"));
   
   
    c1.setProjection(p1);
   
    List l1 = (List) c1.list();
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
45
46
47
          //      c1.setProjection(Projections.property("username"));
          //      c1.setProjection(Projections.property("address"));
    int len=s.length;
    System.out.println(len);
   
    ProjectionList p1=Projections.projectionList();        
    for(int i=0; i<len; i++)
    {
                 p1.add(Projections.property(s[i]));
                 System.out.println(s[i]);
                
          //        p1.add(Projections.property("address"));
    }          
                 
View Full Code Here
3844
3845
3846
3847
3848
3849
3850
3851
3852
3853
3854
3855
3856
3857
3858
    conj.add(Restrictions.ne("tipoMovimento", tipoMovimento));
    conj.add(Restrictions.eq("legalEntity", legalEntity));
    conj.add(Restrictions.eq("organizationUnit", organizationUnit));
    criteria.add(conj);

    ProjectionList proList = Projections.projectionList();
    proList.add(Projections.groupProperty("dataRegistrazione"));
    proList.add(Projections.groupProperty("codiceSocietaVeicolo"));
    proList.add(Projections.sum("importoDare"));
    proList.add(Projections.sum("importoAvere"));

    criteria.setProjection(proList);

    List<?> result = getHibernateTemplate().findByCriteria(criteria);
View Full Code Here
TOP

Related Classes of org.hibernate.criterion.ProjectionList

  • com.abiquo.server.core.infrastructure.network.IpPoolManagementDAO
  • com.abiquo.server.core.statistics.CloudUsageDAO
  • com.abiquo.server.core.statistics.EnterpriseResourcesDAO
  • com.logic
  • com.main
  • com.os
  • com.supinfo.youfood.dao.hibernate.HibOrderDao
  • de.sub.goobi.forms.ProjekteForm
  • de.sub.goobi.helper.ProjectHelper
  • it.pdor.contabilita.dao.ContabilitaDaoHibernateImpl
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.