mybatis之IN多条件查询，查询status=多个值的数据

最新推荐文章于 2024-07-07 16:45:38 发布

红烧牛肉排骨饭

最新推荐文章于 2024-07-07 16:45:38 发布

阅读量1.9k

点赞数 2

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

本文链接：https://blog.csdn.net/weixin_43762113/article/details/127966996

版权

本文详细介绍了如何在MyBatis中使用IN操作符进行多条件查询，特别是针对status字段查询多个可能值的情况。通过实例代码和解析，帮助读者理解这一查询技巧。

摘要由CSDN通过智能技术生成

1.controller

import com.chint.common.CommonPage;
import com.chint.common.ResponseData;
import com.chint.entity.dto.DeliverInfoParam;
import com.chint.entity.dto.DeliverTaskResultDTO;
import com.chint.entity.dto.PhotoResultDTO;
import com.chint.service.DeliverGpsTrajectoryService;
import com.chint.service.ISmallProgramService;
import com.chint.service.ITransTaskService;
import com.chint.util.ZiamUtil;
import com.chint.ziam.library.AuthenticationContext;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletRequest;
import java.util.List;

/**
 * 
 *
 *
 **/
@Api(tags = "小程序")
@Slf4j
@RestController
@RequestMapping("/smallProgram")
public class SmallProgramController {

    @Autowired
    ISmallProgramService smallProgramService;


    @ApiOperation("运单列表查询")
    @RequestMapping(value = "/listDeliver", method = RequestMethod.POST)
    @ResponseBody
    public ResponseData<CommonPage<DeliverTaskResultDTO>> listDeliver(@RequestBody DeliverInfoParam deliverInfoParam, 
                                                                      @RequestParam(value = "pageSize", defaultValue = "5") Integer pageSize,
                                                                      @RequestParam(value = "pageNum", defaultValue = "1") Integer pageNum){

       
        List<DeliverTaskResultDTO> deliverTaskList = smallProgramService.listDeliver(deliverInfoParam,pageSize,pageNum);

        return ResponseData.success(CommonPage.restPage(deliverTaskList));
    }



}
2.service

import com.baomidou.mybatisplus.extension.service.IService;
import com.chint.entity.DeliveryTaskInfo;
import com.chint.entity.dto.*;
import org.springframework.web.bind.annotation.RequestParam;

import java.util.List;

/**
 * <p>

public