mybatis-plus时间范围查询和条件查询

keep one's resolveY

已于 2022-12-28 20:59:21 修改

阅读量1.4k

点赞数

分类专栏： MyBatis 文章标签： mybatis java 开发语言

于 2022-08-02 23:06:56 首次发布

原文链接：https://blog.csdn.net/weixin_44735933/article/details/106651433?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522165945229116781685334466%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=165945229116781685334466&biz_id=0&ut

版权

MyBatis 专栏收录该内容

12 篇文章 1 订阅

订阅专栏

mybatis-plus条件查询_starcpdk的博客-CSDN博客_mybatisplus条件查询

MyBatisPlus之条件查询（常规查询、范围查询、模糊查询、null值处理等）_熊凯瑞的博客-CSDN博客_mybatisplus条件查询

主要还是要去参考mybatisplus的官方博客

    @Override
    public Page<EuVoyage> queryEUVoyageInfo(Long pageNo, Long pageSize, Date startTime, Date endTime) {
        QueryWrapper<EuVoyage> euVoyageQueryWrapper = new QueryWrapper<>();
        String startTimeString = cn.hutool.core.date.DateUtil.format(startTime, "yyyy-MM-dd HH:mm:ss");
        String endTimeString = cn.hutool.core.date.DateUtil.format(endTime, "yyyy-MM-dd HH:mm:ss");
        euVoyageQueryWrapper.apply(StringUtils.isNotBlank(startTimeString),
                        "date_format (start_time,'%Y-%m-%d %H:%i:%s') >= date_format('" + startTimeString + "','%Y-%m-%d %H:%i:%s')")
                        .apply(StringUtils.isNotBlank(endTimeString),
                                "date_format (end_time,'%Y-%m-%d %H:%i:%s') <= date_format('" + endTimeString + "','%Y-%m-%d %H:%i:%s')");
        Page<EuVoyage> euVoyagePage = new Page<>(pageNo, pageSize);
        Page<EuVoyage> page = this.page(euVoyagePage,euVoyageQueryWrapper);
        return page;

        QueryWrapper<EuVoyage> euVoyageQueryWrapper = new QueryWrapper<>();
        euVoyageQueryWrapper.ge("判断条件","start_time",startTime);
        euVoyageQueryWrapper.le("判断条件","start_time",endTime);
        Page<EuVoyage> euVoyagePage = new Page<>(pageNo, pageSize);
        Page<EuVoyage> page = this.page(euVoyagePage,euVoyageQueryWrapper);