Hibernate qbc(Query By Criteria)查询示例

最新推荐文章于 2021-06-10 08:42:18 发布

Dug_Zhang

最新推荐文章于 2021-06-10 08:42:18 发布

阅读量265

点赞数

分类专栏： hibernate 文章标签： hibernate java

本文链接：https://blog.csdn.net/Dug_Zhang/article/details/113610200

版权

hibernate 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Predicate;
import javax.persistence.criteria.Root;





public List<CmsTask> getHtmlTaskList(Boolean isIos) {
    Session session = getSession();
    CriteriaBuilder criteriaBuilder = session.getCriteriaBuilder();
    CriteriaQuery<CmsTask> createQuery=criteriaBuilder.createQuery(CmsTask.class);
    Root<CmsTask> root = createQuery.from(CmsTask.class);
    Predicate queryCondition = criteriaBuilder.equal(root.get("htmlTask"), true);
    queryCondition.equals(criteriaBuilder.equal(root.get("disabled"), false));
    if(null==isIos || isIos) {
        //iosShow是CmsTask中的字段
   		queryCondition.equals(criteriaBuilder.equal(root.get("iosShow"), true));
    }else {
    	queryCondition.equals(criteriaBuilder.equal(root.get("androidShow"), true));
    }
    return  session.createQuery(createQuery.where(queryCondition)).getResultList();
}

protected Session getSession() {
    return sessionFactory.getCurrentSession();
}