在url中传参,并添加查询条件,比如前面为 sql 如果有参数A 拼接 sql=sql+'字段=A',如果有参数B 拼接 sql=sql+'字段=B'
SELECT * FROM 订单 WHERE 1=1 ${if(len(a) == 0,"","and 字段 = '" + a + "'")} ${if(len(b) == 0,"","and 字段 = '" + b + "'")} ----------------- SELECT * FROM 订单 WHERE 1=1 ${if(len(参数名) == 0,"","and 字段 = '" + 参数名 + "'")}
=======
二种语境,自行选择;