Java 类org.hibernate.criterion.Restrictions 实例源码

项目：hska-vis-legacy 文件：UserDAO.java

public User getUserByUsername(String name) {
    SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
    Session session = sessionFactory.getCurrentSession();
    try
    {
        User user = null;
        session.beginTransaction();
           Criteria crit = session.createCriteria(User.class);
           crit.add(Restrictions.eq("username",name));
           List<User> resultList = crit.list();
           if (resultList.size() > 0) {
            user = (User) crit.list().get(0);
           }
           session.getTransaction().commit();
           return user;
    }
    catch (HibernateException e)
    {
        System.out.println("Hibernate Exception" + e.getMessage());
        session.getTransaction().rollback();
        throw new RuntimeException(e);
    }
}

项目：DWSurvey 文件：SurveyDirectoryManagerImpl.java

@Override
public Page<SurveyDirectory> findPage(Page<SurveyDirectory> page,
        SurveyDirectory entity) {
    page.setOrderBy("createDate");
    page.setOrderDir("desc");

    List<Criterion> criterions=new ArrayList<Criterion>();
    criterions.add(Restrictions.eq("visibility", 1));
    criterions.add(Restrictions.eq("surveyState", 1));

    criterions.add(Restrictions.eq("dirType", 2));
    criterions.add(Restrictions.eq("surveyModel", 1));

    Integer share = entity.getIsShare();
    if(share!=null && share==1){
        criterions.add(Restrictions.eq("isShare", share));
    }

    return surveyDirectoryDao.findPageList(page, criterions);
}

项目：bdf2 文件：HibernateDao.java

private void buildCriterions(Collection<com.bstek.dorado.data.provider.Criterion> criterions,
        org.hibernate.criterion.Junction dc) {
    for (com.bstek.dorado.data.provider.Criterion c : criterions) {
        if (c instanceof SingleValueFilterCriterion) {
            SingleValueFilterCriterion fc = (SingleValueFilterCriterion) c;
            dc.add(this.buildCriterion(fc));
        }
        if (c instanceof Junction) {
            Junction jun = (Junction) c;
            org.hibernate.criterion.Junction junction = null;
            if (jun instanceof Or) {
                junction = Restrictions.disjunction();
            } else if (jun instanceof And) {
                junction = Restrictions.conjunction();
            }
            Collection<com.bstek.dorado.data.provider.Criterion> subCriterions = jun.getCriterions();
            if (subCriterions != null) {
                buildCriterions(subCriterions, dc);
            }
            dc.add(junction);
        }
    }
}

项目：ctsms 文件：ECRFDaoImpl.java

@Override
protected long handleGetCount(Long trialId, Long groupId, Long visitId, Boolean active) throws Exception {
    org.hibernate.Criteria ecrfCriteria = createEcrfCriteria(null);
    if (trialId != null) {
        ecrfCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));
    }
    if (groupId != null) {
        ecrfCriteria.add(Restrictions.or(Restrictions.eq("group.id", groupId.longValue()),
                Restrictions.isNull("group.id")));
    }
    if (visitId != null) {
        ecrfCriteria.add(Restrictions.or(Restrictions.eq("visit.id", visitId.longValue()),
                Restrictions.isNull("visit.id")));
    }
    if (active != null) {
        ecrfCriteria.add(Restrictions.eq("active", active.booleanValue()));
    }
    return (Long) ecrfCriteria.setProjection(Projections.rowCount()).uniqueResult();
}

项目：dhus-core 文件：NetworkUsageDao.java

public long getDownloadedSizeByUserSince (final User user, final Date date)
{
   Long result =
         getHibernateTemplate ().execute (new HibernateCallback<Long> ()
         {
            @Override
            public Long doInHibernate (Session session)
                  throws HibernateException, SQLException
            {
               Criteria criteria = session.createCriteria (
                     NetworkUsage.class);
               criteria.setProjection (Projections.sum ("size"));
               criteria.add (Restrictions.eq ("isDownload", true));
               criteria.add (Restrictions.eq ("user", user));
               criteria.add (Restrictions.gt ("date", date));
               return (Long) criteria.uniqueResult ();
            }
         });
   return (result == null) ? 0 : result;
}

项目：ImageClassify 文件：ZipService.java

/**
     * 展示已经解压未识别的列表
     */
@Override
public List<Zip> showZipAndUnClassifyFolder() {
    List<Zip> zips = new ArrayList<Zip>();
       Session session = HibernateUtils.getSession();//生成Session实例
     Transaction tx = session.beginTransaction();//生成事务实例  
     try {
          zips = session.createCriteria(Zip.class).add(Restrictions.eq("isZip", 1)).add(Restrictions.eq("isClassify", 0)).list();
          tx.commit();//提交事务
    } catch (Exception e) {
        e.printStackTrace();
        tx.rollback();
    }finally {
        HibernateUtils.closeSession();//关闭session实例
    }
     return zips;
}

项目：ctsms 文件：TrialDaoImpl.java

@Override
protected Collection<Trial> handleFindByDepartmentPayoffs(Long departmentId, Boolean payoffs, PSFVO psf) throws Exception {
    org.hibernate.Criteria trialCriteria = createTrialCriteria(null);
    SubCriteriaMap criteriaMap = new SubCriteriaMap(Trial.class, trialCriteria);
    if (departmentId != null) {
        trialCriteria.add(Restrictions.eq("department.id", departmentId.longValue()));
    }
    if (payoffs != null) {
        if (payoffs) {
            trialCriteria.add(Restrictions.sizeGt("payoffs", 0));
        } else {
            trialCriteria.add(Restrictions.sizeEq("payoffs", 0));
        }
    }
    CriteriaUtil.applyPSFVO(criteriaMap, psf);
    return trialCriteria.list();
}

项目：ctsms 文件：StaffTagDaoImpl.java

@Override
protected Collection<StaffTag> handleFindByPersonOrganisationIdExcel(
        Boolean person, Boolean organisation, Long tagId, Boolean excel) throws Exception {
    org.hibernate.Criteria staffTagCriteria = this.getSession().createCriteria(StaffTag.class);
    staffTagCriteria.setCacheable(true);
    if (excel != null) {
        staffTagCriteria.add(Restrictions.eq("excel", excel.booleanValue()));
    }
    if (person != null) {
        if (tagId != null) {
            staffTagCriteria.add(Restrictions.or(Restrictions.eq("person", person.booleanValue()), Restrictions.idEq(tagId.longValue())));
        } else {
            staffTagCriteria.add(Restrictions.eq("person", person.booleanValue()));
        }
    }
    if (organisation != null) {
        if (tagId != null) {
            staffTagCriteria.add(Restrictions.or(Restrictions.eq("organisation", organisation.booleanValue()), Restrictions.idEq(tagId.longValue())));
        } else {
            staffTagCriteria.add(Restrictions.eq("organisation", organisation.booleanValue()));
        }
    }
    return staffTagCriteria.list();
}

项目：ctsms 文件：ProbandListEntryTagDaoImpl.java

@Override
protected Collection<ProbandListEntryTag> handleFindByTrialExcelEcrfProbandSorted(Long trialId, Boolean excel, Boolean ecrf, Long probandId) throws Exception {
    org.hibernate.Criteria listEntryTagCriteria = createListEntryTagCriteria();
    if (trialId != null) {
        listEntryTagCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));
    }
    if (excel != null) {
        listEntryTagCriteria.add(Restrictions.or(Restrictions.eq("excelValue", excel.booleanValue()),
                Restrictions.eq("excelDate", excel.booleanValue())));
    }
    if (ecrf != null) {
        listEntryTagCriteria.add(Restrictions.eq("ecrfValue", ecrf.booleanValue()));
    }
    if (probandId != null) {
        listEntryTagCriteria.createCriteria("tagValues", CriteriaSpecification.INNER_JOIN).createCriteria("listEntry", CriteriaSpecification.INNER_JOIN)
        .add(Restrictions.eq("proband.id", probandId.longValue()));
    }
    applySortOrders(listEntryTagCriteria);
    // listEntryTagCriteria.setResultTransformer(org.hibernate.Criteria.DISTINCT_ROOT_ENTITY);
    // return listEntryTagCriteria.list();
    return CriteriaUtil.listDistinctRoot(listEntryTagCriteria, this, "trial.id", "position");
}

项目：ctsms 文件：CriteriaDaoImpl.java

@Override
protected Collection<Criteria> handleFindByModuleCategory(DBModule module,
        String category, Boolean loadByDefault, PSFVO psf) throws Exception {
    org.hibernate.Criteria criteriaCriteria = createCriteriaCriteria();
    SubCriteriaMap criteriaMap = new SubCriteriaMap(Criteria.class, criteriaCriteria);
    if (module != null) {
        criteriaCriteria.add(Restrictions.eq("module", module));
    }
    if (loadByDefault != null) {
        criteriaCriteria.add(Restrictions.eq("loadByDefault", loadByDefault.booleanValue()));
    }
    if (category != null && category.length() > 0) {
        criteriaCriteria.add(Restrictions.eq("category", category));
    } else {
        criteriaCriteria.add(Restrictions.or(Restrictions.eq("category", ""), Restrictions.isNull("category")));
    }
    CriteriaUtil.applyPSFVO(criteriaMap, psf);
    return criteriaCriteria.list();
}

项目：bdf2 文件：HibernateDao.java

private void buildCriterions(Collection<com.bstek.dorado.data.provider.Criterion> criterions,DetachedCriteria dc){
    for(com.bstek.dorado.data.provider.Criterion c : criterions){
        if (c instanceof SingleValueFilterCriterion){
            SingleValueFilterCriterion fc = (SingleValueFilterCriterion) c;
            dc.add(this.buildCriterion(fc));
        }
        if (c instanceof Junction) {
            Junction jun = (Junction) c;
            org.hibernate.criterion.Junction junction = null;
            if (jun instanceof Or) {
                junction = Restrictions.disjunction();
            } else if (jun instanceof And) {
                junction = Restrictions.conjunction();
            }
            Collection<com.bstek.dorado.data.provider.Criterion> subCriterions = jun.getCriterions();
            if (subCriterions != null) {
                buildCriterions(subCriterions, junction);
            }
            dc.add(junction);
        }
    }
}

项目：gitplex-mit 文件：DefaultPullRequestReferenceManager.java

@Transactional
@Listen
public void on(PullRequestEvent event) {
    if (event instanceof MarkdownAware) {
        String markdown = ((MarkdownAware)event).getMarkdown();
        if (markdown != null) {
            String html = markdownManager.render(markdown, null, false);

            for (PullRequest referenced: new PullRequestParser().parseRequests(html)) {
                if (!referenced.equals(event.getRequest())) {
                    EntityCriteria<PullRequestReference> criteria = EntityCriteria.of(PullRequestReference.class);
                    criteria.add(Restrictions.eq("referenced", referenced));
                    criteria.add(Restrictions.eq("referencedBy", event.getRequest()));
                    if (dao.find(criteria) == null) {
                        PullRequestReference reference = new PullRequestReference();
                        reference.setReferencedBy(event.getRequest());
                        reference.setReferenced(referenced);
                        reference.setDate(new Date());
                        reference.setUser(userManager.getCurrent());
                        save(reference);
                    }
                }                   
            }
        }
    }
}

项目：ctsms 文件：ProbandListEntryTagDaoImpl.java

@Override
protected Collection<ProbandListEntryTag> handleFindAllSorted(String nameInfix, Integer limit) throws Exception {
    org.hibernate.Criteria listEntryTagCriteria = createListEntryTagCriteria();
    if (!CommonUtil.isEmptyString(nameInfix)) {
        org.hibernate.Criteria trialCriteria = listEntryTagCriteria.createCriteria("trial", "trial0", CriteriaSpecification.INNER_JOIN);
        org.hibernate.Criteria fieldCriteria = listEntryTagCriteria.createCriteria("field", "inputField", CriteriaSpecification.INNER_JOIN);
        //fieldCriteria.add(Restrictions.eq("localized", false));
        listEntryTagCriteria.add(Restrictions.or(
                (new CategoryCriterion(nameInfix, "inputField.nameL10nKey", MatchMode.ANYWHERE)).getRestriction(),
                (new CategoryCriterion(nameInfix, "trial0.name", MatchMode.ANYWHERE)).getRestriction()
                ));
    }
    applySortOrders(listEntryTagCriteria);
    CriteriaUtil.applyLimit(limit, Settings.getIntNullable(SettingCodes.PROBAND_LIST_ENTRY_TAG_FIELD_AUTOCOMPLETE_DEFAULT_RESULT_LIMIT, Bundle.SETTINGS,
            DefaultSettings.PROBAND_LIST_ENTRY_TAG_FIELD_AUTOCOMPLETE_DEFAULT_RESULT_LIMIT), listEntryTagCriteria);
    return listEntryTagCriteria.list();
}

项目：sjk 文件：AppDaoImpl.java

@Override
public List<App> getLatest(short catalog, Integer subCatalog, Long date, int currentPage, int pageSize,
        Boolean noAds, Boolean noVirus, Boolean official) {
    Criteria cri = getSession().createCriteria(App.class);
    getLastestByFilter(catalog, subCatalog, date, cri);
    cri.add(Restrictions.eq("hidden", false));
    filterAdVirusOfficial(noAds, noVirus, official, cri);

    if (date != null) {
        cri.addOrder(Order.desc("viewCount"));
    } else {
        // 不查询日期,按日期先排序.
        cri.addOrder(Order.desc("lastUpdateTime"));
    }
    cri.setFirstResult(HibernateHelper.firstResult(currentPage, pageSize));
    cri.setMaxResults(pageSize);
    List<App> list = HibernateHelper.list(cri);
    return list;
}

项目：Equella 文件：EntityLockingServiceImpl.java

@Override
@Transactional
public EntityLock lockEntity(BaseEntity entity, String sessionId)
{
    EntityLock lock = entityLockDao.findByCriteria(Restrictions.eq("entity", entity));
    if( lock != null )
    {
        throw new LockedException("Entity is already locked", lock.getUserID(), lock.getUserSession(),
            entity.getId());
    }
    else
    {
        lock = new EntityLock();
        lock.setEntity(entity);
        lock.setUserID(CurrentUser.getUserID());
        lock.setUserSession(sessionId);
        lock.setInstitution(CurrentInstitution.get());
        entityLockDao.save(lock);
        return lock;
    }
}

项目：Equella 文件：EntityLockingServiceImpl.java

@Override
@Transactional(propagation = Propagation.MANDATORY)
public EntityLock getLock(BaseEntity entity, String lockId)
{
    EntityLock lock = entityLockDao.findByCriteria(Restrictions.eq("entity", entity));
    if( lock != null )
    {
        if( lockId == null )
        {
            throw new LockedException("Entity is locked by another user '" + lock.getUserID() + "'",
                lock.getUserID(), lock.getUserSession(), entity.getId());
        }
        if( !lockId.equals(lock.getUserSession()) )
        {
            throw new LockedException("Wrong lock id. Entity is locked by user.", lock.getUserID(),
                lock.getUserSession(), entity.getId());
        }
    }
    else if( lockId != null )
    {
        throw new LockedException("Entity is not locked", null, null, entity.getId());
    }
    return lock;
}

项目：ImageClassify 文件：OauthService.java

/**
 * 依据oauth_token找到oauth实体对象
 */
@Override
public Oauth findOauthByOauthToken(String oauth_token) {
     Oauth oauth = null;
     Session session = HibernateUtils.getSession();
     Transaction tx = session.beginTransaction(); //开启事务
     try {
         //使用criteria查询oauth对象
          oauth = (Oauth) session.createCriteria(Oauth.class).add(Restrictions.eq("oauth_token", oauth_token)).uniqueResult();
          tx.commit();
    } catch (Exception e) {
      e.printStackTrace();
      tx.rollback();
    }finally{
        HibernateUtils.closeSession();
    }
     return oauth; //返回oauth对象
}

项目：ctsms 文件：InquiryValueDaoImpl.java

@Override
protected long handleGetCount(Long trialId, String category, Boolean active, Boolean activeSignup, Long probandId) throws Exception {
    org.hibernate.Criteria inquiryValueCriteria = createInquiryValueCriteria();
    if (probandId != null) {
        inquiryValueCriteria.add(Restrictions.eq("proband.id", probandId.longValue()));
    }
    org.hibernate.Criteria inquiryCriteria = inquiryValueCriteria.createCriteria("inquiry", CriteriaSpecification.INNER_JOIN);
    if (trialId != null) {
        inquiryCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));
    }
    if (active != null) {
        inquiryCriteria.add(Restrictions.eq("active", active.booleanValue()));
    }
    if (activeSignup != null) {
        inquiryCriteria.add(Restrictions.eq("activeSignup", activeSignup.booleanValue()));
    }
    if (category != null && category.length() > 0) {
        inquiryCriteria.add(Restrictions.eq("category", category));
    } else {
        inquiryCriteria.add(Restrictions.or(Restrictions.eq("category", ""), Restrictions.isNull("category")));
    }
    return (Long) inquiryValueCriteria.setProjection(Projections.rowCount()).uniqueResult();
}

项目：Equella 文件：PortletServiceImpl.java

@Override
@Transactional
public void userDeletedEvent(UserDeletedEvent event)
{
    Criterion owner = Restrictions.eq("owner", event.getUserID());
    Criterion inst = Restrictions.eq("institution", CurrentInstitution.get());
    for( Portlet p : portletDao.findAllByCriteria(owner, inst) )
    {
        delete(p, false);
    }

    prefDao.deleteAllForUser(event.getUserID());

    // We don't want to call super here since we're deleting the portlets.
    // The default behaviour for base entities is to orphan them instead
    //
    // super.userDeletedEvent(event);
}

项目：ctsms 文件：InventoryBookingDaoImpl.java

@Override
protected Collection<InventoryBooking> handleFindByCourseSorted(Long courseId, Boolean isRelevantForCourseAppointments, boolean sort) throws Exception
{
    Criteria bookingCriteria = createBookingCriteria();
    if (courseId != null) {
        bookingCriteria.add(Restrictions.eq("course.id", courseId.longValue()));
    }
    if (isRelevantForCourseAppointments != null) {
        bookingCriteria.createCriteria("inventory", CriteriaSpecification.INNER_JOIN).createCriteria("category", CriteriaSpecification.INNER_JOIN)
        .add(Restrictions.eq("relevantForCourseAppointments", isRelevantForCourseAppointments.booleanValue()));
    }
    if (sort) {
        bookingCriteria.addOrder(Order.asc("start"));
    }
    return bookingCriteria.list();
}

项目：Equella 文件：OAuthServiceImpl.java

@Transactional
@Override
public void userDeletedEvent(UserDeletedEvent event)
{
    // The super behaviour is to orphan things and we want most OAuthClients
    // to stick around, so let owned ones be orphaned first.
    super.userDeletedEvent(event);

    // ...but, clients that are locked to the user being deleted are
    // useless, so we'll delete those.
    Criterion c1 = Restrictions.eq("userId", event.getUserID());
    Criterion c2 = Restrictions.eq("institution", CurrentInstitution.get());
    for( OAuthClient oc : clientDao.findAllByCriteria(c1, c2) )
    {
        delete(oc, false);
    }

    tokenDao.deleteAllForUser(event.getUserID());
}

项目：sjk 文件：AppDaoImpl.java

@Override
public List<App> search(Short catalog, Integer subCatalog, int page, int rows, String keywords, Integer id,
        String sort, String order) {
    Criteria cri = searchByFilter(catalog, subCatalog, keywords, id);
    if (subCatalog != null) {
        cri.add(Restrictions.eq("subCatalog", subCatalog));
    }
    // cri.addOrder(Order.asc("auditCatalog"));
    if (sort != null && !sort.isEmpty()) {
        HibernateHelper.addOrder(cri, sort, order);
    } else {
        if (order != null && "asc".equals(order)) {
            cri.addOrder(Order.asc("downloadRank"));
        } else {
            cri.addOrder(Order.desc("downloadRank"));
        }
    }
    if ("marketName".equals(sort)) {
        cri.addOrder(Order.desc("downloadRank"));
    }
    // cri.addOrder(Order.asc("name"));
    cri.setMaxResults(rows);
    cri.setFirstResult(HibernateHelper.firstResult(page, rows));
    List<App> list = HibernateHelper.list(cri);
    return list;
}

项目：bdf2 文件：HibernateDao.java

private void buildCriterions(Collection<com.bstek.dorado.data.provider.Criterion> criterions,
        org.hibernate.criterion.Junction dc) {
    for (com.bstek.dorado.data.provider.Criterion c : criterions) {
        if (c instanceof SingleValueFilterCriterion) {
            SingleValueFilterCriterion fc = (SingleValueFilterCriterion) c;
            dc.add(this.buildCriterion(fc));
        }
        if (c instanceof Junction) {
            Junction jun = (Junction) c;
            org.hibernate.criterion.Junction junction = null;
            if (jun instanceof Or) {
                junction = Restrictions.disjunction();
            } else if (jun instanceof And) {
                junction = Restrictions.conjunction();
            }
            Collection<com.bstek.dorado.data.provider.Criterion> subCriterions = jun.getCriterions();
            if (subCriterions != null) {
                buildCriterions(subCriterions, dc);
            }
            dc.add(junction);
        }
    }
}

项目：ctsms 文件：ProbandListEntryTagDaoImpl.java

@Override
protected Collection<ProbandListEntryTag> handleFindByTrialJsVariableName(
        Long trialId, String jsVariableName) throws Exception {
    org.hibernate.Criteria listEntryTagCriteria = createListEntryTagCriteria();
    if (trialId != null) {
        listEntryTagCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));
    }
    listEntryTagCriteria.add(Restrictions.eq("jsVariableName", jsVariableName));
    return listEntryTagCriteria.list();
}

项目：ctsms 文件：InventoryBookingDaoImpl.java

/**
 * @inheritDoc
 */
@Override
protected Collection<InventoryBooking> handleFindByCourse(Long courseId, PSFVO psf) throws Exception
{
    Criteria bookingCriteria = createBookingCriteria();
    SubCriteriaMap criteriaMap = new SubCriteriaMap(InventoryBooking.class, bookingCriteria);
    if (courseId != null) {
        bookingCriteria.add(Restrictions.eq("course.id", courseId.longValue()));
    }
    CriteriaUtil.applyPSFVO(criteriaMap, psf);
    return bookingCriteria.list();
}

项目：Biliomi 文件：CommandHistoryRecordDao.java

public List<CommandHistoryRecord> getLatestHistoryForCommand(String command) {
  return criteria()
      .add(Restrictions.eq("command", command))
      .addOrder(Order.desc("id"))
      .setMaxResults(20)
      .getList();
}

项目：admin-shiro 文件：AdminService.java

@Transactional(propagation = Propagation.REQUIRED, readOnly = true)
public AdminDO findByUserName(String userName){
    Criteria criteria = daoSupport.createCriteria(AdminDO.class);
    criteria.add(Restrictions.eq("userName", userName));
    Object o = criteria.list().get(0);
    if (Objects.nonNull(o)){
        return (AdminDO)o;
    }else {
        return null;
    }
}

项目：ctsms 文件：AnnouncementDaoImpl.java

/**
 * @inheritDoc
 */
@Override
protected Announcement handleGetAnnouncement()
{
    org.hibernate.Criteria announcementCriteria = this.getSession().createCriteria(Announcement.class);
    announcementCriteria.setCacheable(true);
    announcementCriteria.add(Restrictions.eq("visible", true));
    announcementCriteria.addOrder(Order.desc("timestamp"));
    announcementCriteria.addOrder(Order.desc("id"));
    announcementCriteria.setMaxResults(1);
    return (Announcement) announcementCriteria.uniqueResult();
}

项目：DWSurvey 文件：QuestionBankManagerImpl.java

@Override
public QuestionBank findByNameUn(String id, String parentId, String bankName) {
    List<Criterion> criterions=new ArrayList<Criterion>();
    Criterion eqName=Restrictions.eq("bankName", bankName);
    Criterion eqParentId=Restrictions.eq("parentId", parentId);
    criterions.add(eqName);
    criterions.add(eqParentId);

    if(id!=null && !"".equals(id)){
        Criterion eqId=Restrictions.ne("id", id);   
        criterions.add(eqId);
    }
    return questionBankDao.findFirst(criterions);
}

项目：ctsms 文件：OpsSystCategoryDaoImpl.java

@Override
protected Collection<String> handleFindCategoryPreferredRubricLabels(
        String preferredRubricLabelInfix, Integer limit) throws Exception {
    org.hibernate.Criteria opsSystCategoryCriteria = this.getSession().createCriteria(OpsSystCategory.class);
    opsSystCategoryCriteria.setCacheable(true);
    CategoryCriterion.apply(opsSystCategoryCriteria, new CategoryCriterion(preferredRubricLabelInfix, "preferredRubricLabel", MatchMode.ANYWHERE));
    opsSystCategoryCriteria.add(Restrictions.not(Restrictions.or(Restrictions.eq("preferredRubricLabel", ""), Restrictions.isNull("preferredRubricLabel"))));
    // opsSystCategoryCriteria.add(Restrictions.eq("revision",
    // Settings.getString(SettingCodes.OPS_SYSTEMATICS_REVISION, Bundle.SETTINGS, DefaultSettings.OPS_SYSTEMATICS_REVISION)));
    opsSystCategoryCriteria.addOrder(Order.asc("preferredRubricLabel"));
    opsSystCategoryCriteria.setProjection(Projections.distinct(Projections.property("preferredRubricLabel")));
    CriteriaUtil.applyLimit(limit, Settings.getIntNullable(SettingCodes.OPS_SYST_CATEGORY_PREFERRED_RUBRIC_LABEL_AUTOCOMPLETE_DEFAULT_RESULT_LIMIT, Bundle.SETTINGS,
            DefaultSettings.OPS_SYST_CATEGORY_PREFERRED_RUBRIC_LABEL_AUTOCOMPLETE_DEFAULT_RESULT_LIMIT), opsSystCategoryCriteria);
    return opsSystCategoryCriteria.list();
}

项目：sjk 文件：AppDaoImpl.java

@Override
public App getAppByPackageName(Session sess, String pkname) {
    Criteria cri = sess.createCriteria(App.class);
    cri.add(Restrictions.eq("pkname", pkname));
    Object o = cri.uniqueResult();
    if (o != null) {
        return (App) o;
    }
    return null;
}

项目：sjk 文件：AppDaoImpl.java

@Override
public List<App> get(List<Integer> ids, String sort, String order) {
    List<Integer> sorted = new ArrayList<Integer>(ids);
    Collections.sort(sorted);
    Criteria cri = getSession().createCriteria(App.class);
    cri.add(Restrictions.in("id", sorted));
    cri.add(Restrictions.eq("hidden", false));
    HibernateHelper.addOrder(cri, sort, order);
    List<App> list = HibernateHelper.list(cri);
    return list;
}

项目：Biliomi 文件：InvestmentRecordDao.java

public List<InvestmentRecord> getRecords(User user, int limit) {
  return criteria()
      .createAlias("invester", "i")
      .add(Restrictions.eq("i.id", user.getId()))
      .addOrder(Order.desc("id"))
      .setMaxResults(limit)
      .getList();
}

项目：Biliomi 文件：GameDao.java

public Game getBySteamIdOrName(long steamId, String name) {
  return criteria()
      .add(Restrictions.or(
          Restrictions.eq("steamId", steamId),
          Restrictions.eq("name", name).ignoreCase()
      ))
      .getResult();
}

项目：Equella 文件：OAuthTokenDaoImpl.java

@Override
public OAuthToken getToken(String userId, OAuthClient client)
{
    // Tempororary hax for #6659
    List<OAuthToken> tokens = findAllByCriteria(Restrictions.eq("userId", userId),
        Restrictions.eq("client", client));
    if( !tokens.isEmpty() )
    {
        return tokens.get(0);
    }
    return null;
}

项目：ctsms 文件：ECRFStatusTypeDaoImpl.java

/**
 * @inheritDoc
 */
@Override
protected Collection<ECRFStatusType> handleFindInitialStates()
{
    org.hibernate.Criteria ecrfStatusTypeCriteria = createEcrfStatusTypeCriteria();
    ecrfStatusTypeCriteria.add(Restrictions.eq("initial", true));
    ecrfStatusTypeCriteria.addOrder(Order.asc("id"));
    return ecrfStatusTypeCriteria.list();
}

项目：uflo 文件：GetHistoryActivitiyCommand.java

@SuppressWarnings("unchecked")
public List<HistoryActivity> execute(Context context) {
    Criteria criteria=context.getSession().createCriteria(HistoryActivity.class);
    if(isProcessInstanceId){
        criteria.add(Restrictions.eq("rootProcessInstanceId", instanceId));
    }else{
        criteria.add(Restrictions.eq("historyProcessInstanceId", instanceId));
    }
    criteria.addOrder(Order.desc("endDate"));
    return criteria.list();
}

项目：infotaf 文件：ManipDao.java

public Manip getManip(String name){
    logger.debug("IN - name: {}", name);
    Criterion whereName = Restrictions.eq("nom", name);

    Manip manip = (Manip) getSession()
                .createCriteria(Manip.class)
                .add(whereName)
                .uniqueResult();
    return manip;
}

项目：OSWf-OSWorkflow-fork 文件：HibernateStore.java

private Criterion buildNested(NestedExpression nestedExpression) {

    Criterion full = null;

    for (int i = 0; i < nestedExpression.getExpressionCount(); i++) {
        Criterion expr;
        Expression expression = nestedExpression.getExpression(i);

        if (expression.isNested()) {
            expr = buildNested((NestedExpression) nestedExpression.getExpression(i));
        } else {
            FieldExpression sub = (FieldExpression) nestedExpression.getExpression(i);
            expr = queryComparison(sub);

            if (sub.isNegate()) {
                expr = Restrictions.not(expr);
            }
        }

        if (full == null) {
            full = expr;
        } else {
            switch (nestedExpression.getExpressionOperator()) {
            case AND:
                full = Restrictions.and(full, expr);
                break;

            case OR:
                full = Restrictions.or(full, expr);
            }
        }
    }

    return full;
}

项目：ctsms 文件：InputFieldSelectionSetValueDaoImpl.java

@Override
protected long handleGetCount(Long fieldId, Boolean preset) throws Exception {
    org.hibernate.Criteria selectionSetValueCriteria = createSelectionSetValueCriteria();
    if (fieldId != null) {
        selectionSetValueCriteria.add(Restrictions.eq("field.id", fieldId.longValue()));
    }
    if (preset != null) {
        selectionSetValueCriteria.add(Restrictions.eq("preset", preset.booleanValue()));
    }
    return (Long) selectionSetValueCriteria.setProjection(Projections.rowCount()).uniqueResult();
}