IBatisnet中，SQL语句字符与配置文件XML保留字符冲突的区别（比如>,

转载于 2006-05-12 17:32:00 发布 · 101 阅读

本文探讨了在单一文档中结合使用SQL与XML时可能遇到的符号冲突问题，特别是大于号和小于号这类常用符号。文章提供了一种简单有效的解决方案：通过使用CDATA元素来规避XML保留符号与SQL语句之间的冲突。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Escaping XML symbols
Because you are combining SQL and XML in a single document, conflicts can occur. The most common conflict is the greater-than and less-than symbols (><). SQL statements use these symbols as operators, but they are reserved symbols in XML. A simple solution is to escape the SQL statements that uses XML reserved symbols within a CDATA element. Example 3.6 demonstrates this.
Example 3.6. Using CDATA to "escape" SQL code
<statement id="SelectPersonsByAge" parameterClass="int" resultClass="Person">
<![CDATA[
SELECT * FROM PERSON WHERE AGE > #value#
]]>
</statement