数据库查询语句，追加条件的写法。

最新推荐文章于 2024-05-10 20:02:28 发布

门前大乔吓

最新推荐文章于 2024-05-10 20:02:28 发布

阅读量4.2k

点赞数

文章标签：数据库追加条件 sql语句

本文链接：https://blog.csdn.net/qq_37301964/article/details/78399480

版权

本篇完全为项目中摘抄下来的，仅为本人记录之用。外人看到，仅做参考。

 @Override
    public PagedResult<InspPointResultDto> getPointPaged(PointCretiria tQuery) {
        String sql = "select p.*,t.id pointTypeId,t.pointTypeName from insp_point p left join insp_point_type t on p.pointTypeId=t.id where p.is_active = 1 ";
        //名称 类型 部门
        Map<String , Object> params=new HashMap<>();
        if(!StringUtil.isEmpty(tQuery.getPointName())){
            sql+=" and pointName like :pointName";
            params.put("pointName" , "%"+tQuery.getPointName()+"%");
        }
        if(!StringUtil.isEmpty(tQuery.getPointTypeId())){
            sql+=" and pointTypeId=:poinetTypeId";
            params.put("pointTypeId" , tQuery.getPointTypeId());
        }
        if(!StringUtil.isEmpty(tQuery.getDeptName())){
            sql+=" and pointDept like :pointDept";
            params.put("pointDept" ,"%"+ tQuery.getDeptName()+"%");
        }
        if(!StringUtil.isEmpty(tQuery.getPointNo())){
            sql+=" and p.pointNo like :pointNo";
            params.put("pointNo" ,"%"+ tQuery.getPointNo()+"%");
        }
        sql+=" order by create_datetime desc";
        PagedResult<InspPointResultDto> inspPointDtoPagedResult = this.pagingBySql(tQuery.getPageIndex(), tQuery.getPageSize(), InspPointResultDto.class, sql, params);
        inspPointDtoPagedResult.getResult().stream().forEach(x -> {
            x.setQrcode(WebSettingContext.getHostName() + x.getQrcode());
            x.setPointImage(excuteImageUrl(x.getPointImage()));
        });
        return inspPointDtoPagedResult;
    }