mybatis框架XML里的SQL中使用大于小于号的问题

最新推荐文章于 2024-09-06 09:44:37 发布

原创最新推荐文章于 2024-09-06 09:44:37 发布 · 785 阅读

2 ·

CC 4.0 BY-SA版权

JAVA 专栏收录该内容

73 篇文章

订阅专栏

本文详细解析了在MyBatis框架中使用SQL查询时，如何正确处理大于号(>)和小于号(<)，避免XML解析错误。介绍了两种有效方法：使用CDATA包裹条件语句和实体引用代替特殊符号。

Llama Factory

模型微调

LLama-Factory

LLaMA Factory 是一个简单易用且高效的大型语言模型（Large Language Model）训练与微调平台。通过 LLaMA Factory，可以在无需编写任何代码的前提下，在本地完成上百种预训练模型的微调

一、问题描述

mybatis框架下SQL查询时，mybatis会错误的将>与<认为是xml的分隔符，会导致如下类型的错误：

	<select id="findAllMenu" resultMap="MenuVOResultMap">
		SELECT mm.id as id,mm.title as title,mm.path as path,sm.id as sid,sm.title as stitle,sm.path as spath 
		from 
		(SELECT id,title,path,parent from sys_menus where <![CDATA[ parent >0 ]]> ) as sm 
		left join 
		(SELECT id,title,path,parent from sys_menus where <![CDATA[ parent <1 ]]>) mm
		on sm.parent=mm.id
	</select>

Caused by: org.xml.sax.SAXParseException: 元素内容必须由格式正确的字符数据或标记组成。

二、解决办法

1、 <![CDATA[带有>=和 <=的语句括起来]]>

	<select id="findAllMenu" resultMap="MenuVOResultMap">
		SELECT mm.id as id,mm.title as title,mm.path as path,sm.id as sid,sm.title as stitle,sm.path as spath 
		from 
		(SELECT id,title,path,parent from sys_menus where <![CDATA[ parent >0 ]]> ) as sm 
		left join 
		(SELECT id,title,path,parent from sys_menus where <![CDATA[ parent <1 ]]>) mm
		on sm.parent=mm.id
	</select>

2、用&lt；代替小于号，用&gt；代替大于号

	<select id="findAllMenu" resultMap="MenuVOResultMap">
		SELECT mm.id as id,mm.title as title,mm.path as path,sm.id as sid,sm.title as stitle,sm.path as spath 
		from 
		(SELECT id,title,path,parent from sys_menus where parent &gt; 0) as sm 
		left join 
		(SELECT id,title,path,parent from sys_menus where parent &lt; 1 ) mm
		on sm.parent=mm.id
	</select>

您可能感兴趣的与本文相关的镜像

Llama Factory

模型微调

LLama-Factory