DetachedCriteria dc = DetachedCriteria.forClass(Student.class) .add( Property.forName("name").eq("Gavin King") ) .addOrder( Order.asc("studentNumber") );
@Override public List<MessageGroup> getGroupListByIds(String groupIds) { DetachedCriteria criteria = DetachedCriteria.forClass(MessageGroup.class); String[] groupArr = groupIds.split(","); criteria.add(Restrictions.in("groupId", groupArr)); criteria.addOrder(Order.desc("sort")); return this.findByCriteria(criteria); }
/** * 根据附件IDS 获取文件 * @param fileIds * @param request * @return */ @RequestMapping(value="/getFiles",method = RequestMethod.POST) @ResponseBody public FileResult getFiles(String fileIds,HttpServletRequest request){ List<SysFile> fileList=new ArrayList<>(); if(!StrUtil.isEmpty(fileIds)) { String[] fileIdArr = fileIds.split(","); DetachedCriteria criteria = DetachedCriteria.forClass(SysFile.class); criteria.add(Restrictions.in("id", fileIdArr)); criteria.addOrder(Order.asc("createDateTime")); fileList = uploaderService.findByCriteria(criteria); } return getPreivewSettings(fileList,request); }
protected void addOrderingsToCriteria(List<Order> orderings, DetachedCriteria criteria){ for(Order order : orderings){ criteria.addOrder(order); } }
DetachedCriteria cr = DetachedCriteria.forClass(entityClass); //Add expressions or restrictions to your citeria //And add your ordering cr.addOrder(Order.asc("yourID")); List<T> ls = getHibernateTemplate().findByCriteria(cr); return ls;
public static DetachedCriteria addOrders(DetachedCriteria dc, Order... orders) { for (Order o : orders) { dc.addOrder(o); } return dc; }
public static DetachedCriteria addOrders(DetachedCriteria dc, Iterable<Order> orders) { for (Order o : orders) { dc.addOrder(o); } return dc; }
/** * {@inheritDoc} */ @Override public DetachedCriteria addOrder(Order order) { DetachedCriteria returnedCrit = super.addOrder(order); if (currentOrders == null) { currentOrders = new ArrayList<>(); currentOrders.add(order); } return returnedCrit; }
/** * @see org.ikasan.console.pointtopointflow.dao.PointToPointFlowProfileDao#findAllPointToPointFlowProfiles() */ @SuppressWarnings("unchecked") public Set<PointToPointFlowProfile> findAllPointToPointFlowProfiles() { Set<PointToPointFlowProfile> pointToPointFlowProfiles = new LinkedHashSet<PointToPointFlowProfile>(); pointToPointFlowProfiles.addAll((Collection<? extends PointToPointFlowProfile>) getHibernateTemplate() .findByCriteria(DetachedCriteria.forClass(PointToPointFlowProfileImpl.class).addOrder(Order.asc("name")))); return pointToPointFlowProfiles; }
/** * @see org.ikasan.console.module.dao.ModuleDao#findAllModules() */ @SuppressWarnings("unchecked") public Set<Module> findAllModules() { Set<Module> modules = new LinkedHashSet<Module>(); modules.addAll((Collection<? extends Module>) getHibernateTemplate().findByCriteria(DetachedCriteria.forClass(Module.class).addOrder(Order.asc("name")))); return modules; }
DetachedCriteria criteria = DetachedCriteria.forClass(News.class); criteria.setProjection( Projections.property("com"), "com")); criteria.add(Restrictions.idEq(id)); DetachedCriteria cComment = criteria.createCriteria("comments"); cComment.addOrder(Order.desc("addDate")); List<String> list = (List<String>)findByCriteria(cComment, false);
protected void copyOrdersAndTheirSubcriteriaFromCriteriaToAnother(Criteria executable, DetachedCriteria criteria){ Map<Subcriteria, Order> aliasToOrderMap = getSortSubcriteriaFromCriteria(executable); for(Subcriteria subcriteria : aliasToOrderMap.keySet()){ criteria.createAlias(subcriteria.getPath(), subcriteria.getAlias(), subcriteria.getJoinType()); } for(Order order : aliasToOrderMap.values()){ criteria.addOrder(order); } }
DetachedCriteria subQuery = DetachedCriteria.forClass(LoanProfileStateChanges.class); subQuery.add(Restrictions.lt("date", new Date()); subQuery.add(Restrictions.in("id", Arrays.asList(1,2,3)); ProjectionList pl = Projections.projectionList(); pl.add(Projections.max("id")).add(Projections.groupProperty("loanProfileId")); subQuery.setProjection(pl); DetachedCriteria dc = DetachedCriteria.forClass(LoanProfileStateChanges.class); dc.add(Subqueries.propertyIn("id", subQuery); dc.addOrder(Order.desc("id"));
@SuppressWarnings("unchecked") @Override public List<ParameterName> getParameterNameByMappingConfigurationId(Long mappingConfigurationId) { DetachedCriteria criteria = DetachedCriteria.forClass(ParameterName.class); criteria.add(Restrictions.eq("mappingConfigurationId", mappingConfigurationId)); criteria.addOrder(Order.asc("ordinal")); return (List<ParameterName>)this.getHibernateTemplate().findByCriteria(criteria); }
@Override public List<ExclusionEvent> findAll() { DetachedCriteria criteria = DetachedCriteria.forClass(ExclusionEventImpl.class); criteria.addOrder(Order.desc("timestamp")); return (List<ExclusionEvent>)this.getHibernateTemplate().findByCriteria(criteria); }
/** * {@inheritDoc} */ @SuppressWarnings("unchecked") public List<SignupMeeting> getAllSignupMeetings(String siteId) { DetachedCriteria criteria = DetachedCriteria.forClass( SignupMeeting.class).addOrder(Order.asc("startTime")) .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY) .createCriteria("signupSites").add( Restrictions.eq("siteId", siteId)); return (List<SignupMeeting>) getHibernateTemplate().findByCriteria(criteria); }
@Transactional(readOnly = true) public List<String> getAllModuleNames() { DetachedCriteria query = DetachedCriteria.forClass(MessageBundleProperty.class) .setProjection(Projections.distinct(Projections.property("moduleName"))) .addOrder(Order.asc("moduleName")); List<String> results = (List<String>) getHibernateTemplate().findByCriteria(query); Hibernate.initialize(results); return results; }
@Transactional(readOnly = true) public List<String> getAllBaseNames() { DetachedCriteria query = DetachedCriteria.forClass(MessageBundleProperty.class) .setProjection(Projections.distinct(Projections.property("baseName"))) .addOrder(Order.asc("baseName")); List<String> results = (List<String>) getHibernateTemplate().findByCriteria(query); Hibernate.initialize(results); return results; }
private void addOrderToDetachedCriteria(DetachedCriteria dc, String property, Order order) { if(dc != null) { org.hibernate.criterion.Order hibernateOrder = order.getDirection() == Order.Direction.ASC ? org.hibernate.criterion.Order.asc(calculatePropertyName(property)) : org.hibernate.criterion.Order.desc(calculatePropertyName(property)); dc.addOrder(order.isIgnoreCase() ? hibernateOrder.ignoreCase() : hibernateOrder); } }