<sql id="where_id">
<where>
<if test="ENAME!=null and ENAME!=''">
and ENAME LIKE concat('%',#{ENAME},'%')
</if>
<if test="minSal!=null and minSal !=''">
and sal >= #{minSal}
</if>
<if test="maxSal!=null and maxSal!=''">
and sal <= #{maxSal}
</if>
</where>
</sql>
动态sql语句不能末尾添加分号,死规定
反例: and sal <= #{maxSal}; 报错为sql语法异常