<,>引起的mybatis异常：元素内容必须由格式正确的字符数据或标记组成

来源：互联网发布：淘宝描述不符违规编辑：程序博客网时间：2024/05/16 08:46

<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>

阅读全文

0 0