xml中的sql代码如下
<select id="searchAll" resultType="*.Entity" >
SELECT SA.ID, SA.NAME FROM T_S SA WHERE 1=1
<if test="name != null">AND SA.NAME LIKE CONCAT(CONCAT('%',#{name}),'%')</if>
</select>
xml中的sql代码如下
<select id="searchAll" resultType="*.Entity" >
SELECT SA.ID, SA.NAME FROM T_S SA WHERE 1=1
<if test="name != null">AND SA.NAME LIKE CONCAT(CONCAT('%',#{name}),'%')</if>
</select>