mybatis OR语句的写法

最新推荐文章于 2025-03-09 23:46:58 发布

Leolu007

最新推荐文章于 2025-03-09 23:46:58 发布

阅读量1.7w

点赞数 1

分类专栏： mybatis

本文链接：https://blog.youkuaiyun.com/Leolu007/article/details/51655986

版权

mybatis 专栏收录该内容

23 篇文章

订阅专栏

本文介绍了一种通过关键字查询资讯列表的方法，该方法使用关键字匹配资讯的标题和关键词字段，并结合状态和来源进行过滤，最终按发布时间降序排列返回资讯列表。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

/**
     * 根据关键字获取[相关资讯]列表
     * WHERE
     * DELETED = ?
     * AND STATE = ?
     * AND ( KEYWORDS LIKE '%aaa%' or TITLE  '%aaa%' ) OR ( KEYWORDS LIKE '%bbb%' or TITLE  '%bbb%' );
     *
     * @param keywords
     * @return
     */
    public Pager getInformationListByKeywords(String keywords, Pager pager) {
        Condition condition = new Condition(Information.class);

        if (!StringUtil.isEmpty(keywords)) {

            String keyArray[] = keywords.trim().split(",|，");
            for (int i = 0; i < keyArray.length; i++) {
                Criteria criteria = condition.or();
                criteria
                        .andEqualTo("deleted", 0)
                        .andEqualTo("state", InformationState.STATE_PUBLHISHED)
                        .andEqualTo("source", getSOURCE())
                        .andLike("keywords", "%" + keyArray[i] + "%");

                Criteria criteria2 = condition.or();
                criteria2.andEqualTo("deleted", 0)
                        .andEqualTo("state", InformationState.STATE_PUBLHISHED)
                        .andEqualTo("source", getSOURCE())
                        .andLike("title", "%" + keyArray[i] + "%");
            }
        } else {
            Criteria criteria = condition.or();
            criteria
                    .andEqualTo("deleted", 0)
                    .andEqualTo("source", getSOURCE())
                    .andEqualTo("state", InformationState.STATE_PUBLHISHED);
        }
        condition.setOrderByClause("publish_time desc");

        pager.setResult(this.selectPage(condition, pager.getPageNo(), pager.getPageSize()));
        pager.setTotalRows(this.countByCondition(condition));
        return pager;
    }