接口里定义的函数:
我想出现的结果是就一个Parameters,而且应该是“福建”才对,
你吧sql改一下,Parma2!=null 和 福建外省重复了。
sql里面的参数名不是在mapper命名的吗?
if test=" param1 ='' and param2 = '福建' "
area = #{param2} and
if
if test=" param1 ='' and param2 = '外省' "
area != “福建” and
if
if test=" param1 ='' and param1 != null and param2 = '全部' "
shipper_name = #{param1} and
if
if test=" param1 ='' and param1 != null and param2 = '福建' "
shipper_name = #{param1} and area=#{param2} and
if
if test=" param1 ='' and param1 != null and param2 = '福建' "
shipper_name = #{param1} and area != “福建” and
if