mybatis-plus 自定sql 分页查询

最新推荐文章于 2024-08-09 21:51:09 发布

tonysh_zds

最新推荐文章于 2024-08-09 21:51:09 发布

阅读量308

点赞数

分类专栏： vue 文章标签： mybatis sql mysql

本文链接：https://blog.csdn.net/tonysh_zds/article/details/125564094

版权

vue 专栏收录该内容

91 篇文章 1 订阅

订阅专栏

DasInfoVolumesController 类

@AutoLog(value = "卷内表无原文-列表查询")
   @ApiOperation(value="卷内表无原文-列表查询", notes="卷内表无原文-列表查询")
   @GetMapping(value = "/queryNoAttachmentList")
   public Result<?> queryPgList(DasInfoVolumes dasInfoVolumes,
                                @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
                                @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize,
                                HttpServletRequest req) {
       Page<DasInfoVolumes> page = new Page<DasInfoVolumes>(pageNo, pageSize);
       IPage<DasInfoVolumes> pageList = dasInfoVolumesService.getNoAttachmentList(page, dasInfoVolumes);
       return Result.OK(pageList);
   }

IDasInfoVolumesService 类增加方法

public IPage<DasInfoVolumes> getNoAttachmentList(Page page,DasInfoVolumes dasInfoVolumes);

DasInfoVolumesServiceImpl 增加方法

   @Override
	public IPage<DasInfoVolumes> getNoAttachmentList(Page page, DasInfoVolumes dasInfoVolumes){
		return  dasInfoVolumesMapper.getNoAttachmentList(page,dasInfoVolumes);
	}

DasInfoVolumesMapper 增加方法

public IPage<DasInfoVolumes> getNoAttachmentList(Page page,@Param("dasInfoVolumes") DasInfoVolumes dasInfoVolumes);

DasInfoVolumesMapper.xml 增加方法

<select id="getNoAttachmentList" parameterType="org.jeecg.modules.das.archive.entity.DasInfoVolumes" resultType="org.jeecg.modules.das.archive.entity.DasInfoVolumes">
		SELECT *
		FROM  das_info_volumes
		WHERE del_flag=0 and
			 id not in (SELECT volume_id from das_info_vattachment)
		<if test="dasInfoVolumes.folderNo!=null and dasInfoVolumes.folderNo!=''">
			and folder_no = #{dasInfoVolumes.folderNo}
		</if>
		<if test="dasInfoVolumes.archiveNo!=null and dasInfoVolumes.archiveNo!=''">
			and archive_no = #{dasInfoVolumes.archiveNo}
		</if>
		<if test="dasInfoVolumes.maintitle!=null and dasInfoVolumes.maintitle!=''">
			and maintitle = #{dasInfoVolumes.maintitle}
		</if>

	</select>