v3.0 新增表达式引擎,进一步提升执行速度和效率,同时支持指针参数,test != null ,和test ! = nil
v3.0 新增表达式引擎,进一步提升执行速度和效率,同时支持指针参数,test != null ,和test ! = nil
老版本:
<select id="selectByCondition" resultMap="BaseResultMap">
<bind name="pattern" value="'%' + name + '%'"/>
select * from biz_activity
<where>
<if test="name != '' ">
<!--可以使用bind标签 and name like #{pattern}-->
and name like #{pattern}
<!--可以使用默认 and name like concat('%',#{name},'%')-->
<!--and name like concat('%',#{name},'%')-->
</if>
<if test="startTime != ''">and create_time >= #{startTime}</if>
<if test="endTime != ''">and create_time <= #{endTime}</if>
</where>
order by create_time desc
<if test="page != 0 and size != 0">limit #{page}, #{size}</if>
</select>
新版本:
<select id="selectByCondition" resultMap="BaseResultMap">
<bind name="pattern" value="'%' + name + '%'"/>
select * from biz_activity
<where>
<if test="name != null">
<!--可以使用bind标签 and name like #{pattern}-->
and name like #{pattern}
<!--可以使用默认 and name like concat('%',#{name},'%')-->
<!--and name like concat('%',#{name},'%')-->
</if>
<if test="startTime != null">and create_time >= #{startTime}</if>
<if test="endTime != null">and create_time <= #{endTime}</if>
</where>
order by create_time desc
<if test="page != null and size != null">limit #{page}, #{size}</if>
</select>