多条件查询
首先,在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.