Package org.hibernate

Examples of org.hibernate.Criteria.addOrder()

224
225
226
227
228
229
230
231
232
233
234
      }

      // Sorting of elements.
      if (getFeatureInfo().getSortAttributeName() != null) {
        if (SortType.ASC.equals(getFeatureInfo().getSortType())) {
          criteria.addOrder(Order.asc(getFeatureInfo().getSortAttributeName()));
        } else {
          criteria.addOrder(Order.desc(getFeatureInfo().getSortAttributeName()));
        }
      }
View Full Code Here
226
227
228
229
230
231
232
233
234
235
236
      // Sorting of elements.
      if (getFeatureInfo().getSortAttributeName() != null) {
        if (SortType.ASC.equals(getFeatureInfo().getSortType())) {
          criteria.addOrder(Order.asc(getFeatureInfo().getSortAttributeName()));
        } else {
          criteria.addOrder(Order.desc(getFeatureInfo().getSortAttributeName()));
        }
      }

      criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
        Session session = (Session)entityManager.getDelegate();

        Criteria crit = session.createCriteria(User.class).add(example);
        if (orderByProperty != null)
                crit.addOrder( orderDescending ? Order.desc(orderByProperty) : Order.asc(orderByProperty) );

        return crit.setResultTransformer(DistinctRootEntityResultTransformer.INSTANCE);
    }

}
View Full Code Here
59
60
61
62
63
64
65
66
67
68
    public void retrieveAllMembersOrderedByName() {

        // using Hibernate Session and Criteria Query via Hibernate Native API
        Session session = (Session) em.getDelegate();
        Criteria cb = session.createCriteria(Member.class);
        cb.addOrder(Order.asc("name"));
        members = (List<Member>) cb.list();

    }
}
View Full Code Here
40
41
42
43
44
45
46
47
48
49
    @SuppressWarnings("unchecked")
    public List<Member> findAllOrderedByName() {
        // using Hibernate Session and Criteria Query via Hibernate Native API
        Session session = (Session) em.getDelegate();
        Criteria cb = session.createCriteria(Member.class);
        cb.addOrder(Order.asc("name"));
        return (List<Member>) cb.list();
        // return members;
    }
}
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
          public Object doInHibernate(final Session session) {
            Criteria crit = session.createCriteria(Supplier.class);

            if (orderBy != null) {
              crit.addOrder(Order.asc(orderBy));
            }

            crit = crit.createCriteria("supplierType").add(
                Restrictions.ilike("supplierTypeName",
                    typeString));
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
                    Restrictions.or(Restrictions
                        .isNull("inactive"),
                        Restrictions.eq("inactive", 0)));

            if (orderBy != null) {
              crit.addOrder(Order.asc(orderBy));
            }
           
            crit.createAlias("supplierType", "supplierType");
            crit.add(Restrictions.ilike("supplierType.supplierTypeName", typeString));
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
            .getProductAreaGroupName();
        if (!productAreaGroupName.equalsIgnoreCase("Alle")) {
          criteria.add(Restrictions.eq("productAreaGroupName",
              productAreaGroupName));
        }
        criteria.addOrder(Order.desc("productArea")).addOrder(
            Order.asc("orderReadyDay"));
        return criteria.list();
      }

    });
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
        }
        if (productAreaGroupName != null) {
          criteria.add(Restrictions.eq("productAreaGroupName",
              productAreaGroupName));
        }
        criteria.addOrder(Order.asc("productArea"))
            .addOrder(Order.asc("transportYear"))
            .addOrder(Order.asc("transportWeek")).list();
        return criteria.list();
      }
View Full Code Here
129
130
131
132
133
134
135
136
137
138
139
                .add(Restrictions.eq("customerNr", customerNr));
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
           
            criteria.addOrder(Order.asc("orderNr")).addOrder(
                    Order.asc("defaultArticle")).addOrder(
                    Order.desc("numberOfItems"));
            return criteria.list();
          }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.