One 、 Scene description

stay springboot Project use mybatis+mybatis-plus, To meet business needs , stay mapper Used in the method defined in @Select mapping SQL sentence
　 matters needing attention ：
　1. Need to use labels script Label the parcel
　2. Note the escape when using the greater than less than symbol
　3.mybatis Common escape is as follows

	&lt;          < 
    &gt;          >  
    &lt;&gt;     <>
    &amp;        & 
    &apos;       '
    &quot;       "

@Select({
    "<script>"+
" select t.* from track_name t"+
" <where>"+
" <if test='username!= null and username !=\"\" '>"+
" and t.username=#{username}"+
" </if>"+
" <if test='gmtCreateTime!=null and gmtCreateTime !=\"\" '>"+
" and t.gmtCreateTime &gt; #{gmtCreateTime} "+
" </if>"+
" </where>"+
"</script>"
})
IPage<TrackName> queryCondition(Page<TrackName> page,@Param("username")String username,@Param("gmtCreateTime")String gmtCreateTime)