如何根据参数，执行不同的sql呢？ 我写了if语法： ${if(p_base_factory='厦门', " select * from( select * from tianma_bi.dws_panel_full_cost_actual_engineer_yield where base_factory ='厦门' union all select t1.* from (select * from tianma_bi.dws_panel_full_cost_actual_engineer_yield where base_factory ='上海' ) t1 join (select * from tianma_bi.dws_panel_full_cost_actual_engineer_yield where base_factory ='厦门') t2 on t1.code_name=t2.item_name )a ", " select * from( select * from tianma_bi.dws_panel_full_cost_actual_engineer_yield where 1=1 and base_factory in ('"+p_base_factory+"') )a ")} 这个是可以实现的，但我还有其他参数，比如 1、${if(len(p_process)=0,"","and process in ('"+p_process+"')")} 我要把这个参数，嵌套在上面的2个sql中，要怎么写 2、每个sql后面，我还需要 limit ${(pageNum - 1) * 100},100 又要怎么嵌套呢？ |
1min目标场景问卷
立即参与
最佳回答 |
||||
|
0
|
|
|||
