sqlText = "select b.hospital_name,type1,sum(a.hj) as bj "+
"from (select SUBSTR(HOSPITAL_CODE, 1, 6) AS depCode,count(0) as hj,decode(BED_TYPE,'U','未占用','占用')as type1 "+
"from BED_CONFIG group by HOSPITAL_CODE,BED_TYPE) a inner join hospital b "+
"on a.depCode||'00' = b.HOSPITAL_CODE "+
" group by b.HOSPITAL_NAME,type1 "+
" order by b.HOSPITAL_NAME " ;现在问题是要加一句and hospital_code like '" + hospitalCode + "%'
这样就可以根据选的地方的hospitalCode 来制出相应的地方的表了,不然是所有的表还需要再前台去写一大堆if else
"from (select SUBSTR(HOSPITAL_CODE, 1, 6) AS depCode,count(0) as hj,decode(BED_TYPE,'U','未占用','占用')as type1 "+
"from BED_CONFIG group by HOSPITAL_CODE,BED_TYPE) a inner join hospital b "+
"on a.depCode||'00' = b.HOSPITAL_CODE "+
" group by b.HOSPITAL_NAME,type1 "+
" order by b.HOSPITAL_NAME " ;现在问题是要加一句and hospital_code like '" + hospitalCode + "%'
这样就可以根据选的地方的hospitalCode 来制出相应的地方的表了,不然是所有的表还需要再前台去写一大堆if else
这句话应该怎么加?
where hospital_code like '" + hospitalCode + "%' +
" group by b.HOSPITAL_NAME,type1 "+
以where条件的形式加进去,具体拼接的语句可能不对,你稍微改一下就行