方法一:一般用法
select * from orcl_test t
and t.status = 1
and t.status NOT IN (2,3,4)
and t.delete_flag = 1
方法二:使用choose标签代替if-else。
select * from orcl_test t
and t.status = 1
and t.status IN (2,3,4)
and t.delete_flag = 1