请问在where 条件里写或的条件怎么写 类似于 where 1=1 and date=....... and line=...... and (number1=...... or number2=...... or number3=...... or number4=......) 写成参数形式 where 1=1 ${if(len(date)=0,""," and date in ('" + date + "') ")} ${if(len(line)=0,""," and line in ('" + line + "') ")} ${if(len(number)=0,""," and number1 in ('" + number + "') ")} ${if(len(number)=0,""," or number2 in ('" + number + "') ")} ${if(len(number)=0,""," or number3 in ('" + number + "') ")} ${if(len(number)=0,""," or number4 in ('" + number + "') ")} 最后的number1 number2 number3 number4参数应该怎么写? |
最佳回答 |
||||
1
|
|