mybatis动态sql语法错误

来源：互联网发布：java 语法糖不够编辑：程序博客网时间：2024/06/18 10:32

<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报错了
不能用大写的，必须小写

阅读全文

0 0