SpringBoot多条件查询

多条件查询

首先，在sqlProvide写sql语句和条件判断(mybatisGenerator自动生成文件)

 public String selectDeviceBrandBo(DeviceByCodeBo deviceByCodeBo){
   
            /*
             * 1. 给出一个sql语句前半部
             */
            StringBuilder sql = new StringBuilder("select d.id, name_chs,code,ds.`status` from device d left join brand b on b.id=d.brand_id\n" +
                    "                   left join device_status ds on ds.device_id=d.id \n" +
                    "                    where d.status=0 and 1=1");
            if(!("".equals(deviceByCodeBo.getCode()))&&deviceByCodeBo.