参数调用sql语句，但是语句拼接不成功 ${if(len(oop)!=0 && oop != "00000001" && len(yg)==0 , ("select '一区' ,sum(lw_cnt) from dm_dwlwzs_info where 1=1 and gsdwh='"+ oop +"'" + if(len(tbsj_ks) == 0,"","and tjny >= '" +tbsj_ks + "'") + if(len(tbsj_js) == 0,"","and tjny <= '" +tbsj_js + "'") union select '二区', sum(lw_cnt) from dm_dwlwzs_info where 1=1 and gsdwh='"+ oop +"'" + if(len(tbsj_ks) == 0,"","and tjny >= '" +tbsj_ks + "'") + if(len(tbsj_js) == 0,"","and tjny <= '" +tbsj_js + "'")' ) , "")}
|
1min目标场景问卷
立即参与
最佳回答 |
||||
|
0
|
|
|||
