<,>引起的mybatis异常：元素内容必须由格式正确的字符数据或标记组成_: 元素内容必须由格式正确的字符数据或标记组成。pycharm-优快云博客

本文链接：https://blog.youkuaiyun.com/sinat_27450377/article/details/78283672

<select id="qryEffSubsUppInstBySubsId"  resultType="com.ztesoft.zsmart.bss.iot.common.dto.SubsUppInst">

        SELECT SUBS_UPP_INST_ID,SUBS_ID,PRICE_PLAN_ID,CREATED_DATE,EFF_DATE,
            EXP_DATE,UPDATE_DATE,STATE,STATE_DATE,PROD_ID,PARENT_SUBS_UPP_INST_ID,
            COMPLETED_DATE,NEED_UPLOAD,PACKAGE_FLAG,AGM_EXP_DATE,SP_ID
            FROM SUBS_UPP_INST WHERE SUBS_ID = #{subsId} 
            AND STATE = 'A'
            AND EFF_DATE <= SYSDATE  AND (EXP_DATE IS NULL OR EXP_DATE > SYSDATE)
            <if test="spId != null">
                 AND SP_ID = #{spId}
            </if>
</select>

这里写图片描述

错误原因：mybatis查询的时候，需要用到运算符小于号：< 和大于号： >，在mybatis配置文件里面，这种会被认为是标签，所以解析错误.

解决方法,用

<select id="qryEffSubsUppInstBySubsId"  resultType="com.ztesoft.zsmart.bss.iot.common.dto.SubsUppInst">

        SELECT SUBS_UPP_INST_ID,SUBS_ID,PRICE_PLAN_ID,CREATED_DATE,EFF_DATE,
            EXP_DATE,UPDATE_DATE,STATE,STATE_DATE,PROD_ID,PARENT_SUBS_UPP_INST_ID,
            COMPLETED_DATE,NEED_UPLOAD,PACKAGE_FLAG,AGM_EXP_DATE,SP_ID
            FROM SUBS_UPP_INST WHERE SUBS_ID = #{subsId} 
            AND STATE = 'A'
            <![CDATA[AND EFF_DATE <= SYSDATE  AND (EXP_DATE IS NULL OR EXP_DATE > SYSDATE)]]>
            <if test="spId != null">
                 AND SP_ID = #{spId}
            </if>
</select>