StringBuffer sql = new StringBuffer; sqlappend select substrahphm01 sf ; sqlappend nvlsumcase when ahpzl like 小型 then 1 else 0 end0 xxsl ; sqlappend nvlsumcase when ah

StringBuffer sql = new StringBuffer(); sql.append(" select substr(a.hphm,0,1) as sf, "); sql.append(" nvl(sum(case when a.hpzl like '%小型%' then 1 else 0 end),0) as xxsl, "); sql.append(" nvl(sum(case when a.hpzl like '%大型%' then 1 else 0 end),0) as dxsl "); sql.append(" from video_passvehicle_push a "); sql.append(" where 1=1 "); if (StringUtils.isNotBlank(judgmentDTO.getGwdq())){ String[] split = judgmentDTO.getGwdq().split(","); for (int i = 0; i < split.length; i++) { if (i==0){ sql.append(" and (a.hphm like '%").append(split[i]).append("%' "); }else { sql.append(" or a.hphm like '%").append(split[i]).append("%' "); } } sql.append(") "); } if (StringUtils.isNotBlank(judgmentDTO.getKssj())){ sql.append(" and a.gcsj >= to_date('").append(judgmentDTO.getKssj()+" 00:00:00").append("','yyyy-MM-dd hh24:mi:ss') "); } if (StringUtils.isNotBlank(judgmentDTO.getJssj())){ sql.append(" and a.gcsj <= to_date('").append(judgmentDTO.getJssj()+" 23:59:59").append("','yyyy-MM-dd hh24:mi:ss') "); } //getAreaSql(sql,judgmentDTO); sql.append(" group by substr(a.hphm,0,1) ")