需求:现有number单条精确查询,需改成模糊查询,并支持多选
分析:技术可以实现,但是性能很低,思路如下:
(number like “%number%”) or (number like “%number%”) or (number like “%number%” )
改善:从业务角度出发,可以判断,如果查询单条可以用模糊查询,多条采用in
if(numbers.size()>1){
numbers.get(0)= number;
number like "%number%"
}else{
number in numbers
}