<sql id="searchByPo">
<trim prefix="where" prefixOverrides="and|or">
<if test="id !='' and id !=null">
id = #{id}
</if>
<if test="taskName !='' and taskName !=null">
and task_name = #{taskName}
</if>
<if test="taskIdentifier !='' and taskIdentifier !=null">
and task_identifier = #{taskIdentifier}
</if>
<if test="taskMethodName !='' and taskMethodName !=null">
and task_method_name = #{taskMethodName}
</if>
<if test="taskCircle !='' and taskCircle !=null">
and task_circle = #{taskCircle}
</if>
<if test="successCnt !='' and successCnt !=null">
and success_cnt = #{successCnt}
</if>
<if test="failCnt !='' and failCnt !=null">
and fail_cnt = #{failCnt}
</if>
<if test="createTime !='' and createTime !=null">
and create_time = #{createTime}
</if>
<if test="lastProcessTime !='' and lastProcessTime !=null">
and last_process_time = #{lastProcessTime}
</if>
<if test="status !='' and status !=null">
and status = #{status}
</if>
</trim>
</sql>
这块代码本来<if test="taskName !='' AND taskName !=null">
用的大写AND报错了
不能用大写的,必须小写