各位大佬，是要把bxxz作為引數控制元件，下拉選擇交強，商業以及全選時刷選出對應的資料，前面的SQL能運行，寫了最后一條陳述句后無法運行，檢查了${}里面的陳述句是合法的，麻煩幫忙看一下問題在哪
select b.policy_no,b.qbrq,a.bmz,a.syxz,a.z_zyfs,b.bf,a.xz,a.cdrq,a.bdzt
from ids.fz_bdb a,ids.fz_bfb b,ids.AUTO_NEW_PRODUCT_INFO_T c
where a.policy_no = b.policy_no
and b.policy_no = c.policy_no
and b.endorsement_no = c.endorsement_no
and b.qbrq >= to_date('${starttime}','yyyy-mm-dd hh24:mi:ss')
and b.qbrq <= to_date('${endtime}','yyyy-mm-dd hh24:mi:ss')
and '${if(bxxz='交強險', "a.xz in ('11022400','11026000')",if(bxxz='商業險',"a.xz not in ('11022400','11026000')",if(bxxz='整體'," ","1=1","0=1")))}'
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/68186.html
標籤：基礎類