Bootstrap React 1190000010383464
XML in < escape to thi tha
<if test= "Pricehigh!=null" >
and Price < #{pricehigh,jdbctype=integer}
</if>
MyBatis Dynamic SQL uses if tags and choose tags
<SelectId="GetItems"ParameterType=" com.ipro.shopping.to.IntegerEntity " resulttype =" Itemstype ">
select * from itemstype
<where>
<!--Way one uses choose Way to query-->&NBSP;&NBSP;
<!-- <choose>
<WhenTest="ParentID!=0">parenttypeid=#{parentid}</when>
<WhenTest=" parentid==0 "> Parenttypeid is null</when>
</choose> -->
<!--two ways to use the IF query --
<if < span class= "attribute" style= "margin:0px; padding:0px; Border:currentcolor; color:red; Line-height:1.5em ">test=< Span class= "Attribute-value" style= "margin:0px; padding:0px; Border:currentcolor; Color: #0000ff; Line-height:1.5em ">" parentid!=0 ">
parenttypeid =#{parentid}
</If>
<if < span class= "attribute" style= "margin:0px; padding:0px; Border:currentcolor; color:red; Line-height:1.5em ">test=< Span class= "Attribute-value" style= "margin:0px; padding:0px; Border:currentcolor; Color: #0000ff; Line-height:1.5em ">" parentid==0 ">
parenttypeid is null
</if>
</where>
</Select>
MyBatis Dynamic SQL uses if tags and choose tags