MyBatis if test is equal how to dynamically stitch SQL

Today's procedures need to be based on the status of the reception to judge in the database is to take where a>b

Or is it a<b or a=0 's situation? Finally tried the next in the If inside stitching #{status}=#{status} everything OK

The detailed code is as follows

                                <if test= "Status==1" > and    inv.security_inventory < inv.actual_inventory and #{status} = #{status}  </if> <if test= "  status==2" ><!--out of stock--and  inv.security_inventory > Inv.actual_ Inventory and  #{status} = #{status} </if> <if test= "  status==3" ><!--not in stock-and  Inv.security_inventory = 0 and  #{status} = #{status} </if>

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

MyBatis if test is equal how to dynamically stitch SQL