Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What is the correct format for MyBatis SQL xml to handle less-than and greater-than signs

2025-01-16 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

This article introduces what is the correct format for MyBatis SQL xml to deal with less than sign and greater sign. The content is very detailed. Interested friends can use it for reference. I hope it will be helpful to you.

When we need to process sql statements in xml format, we often use

< ,,>

=, etc., but it is easy to cause errors in xml format, which will lead to background conversion of xml strings to xml document Times errors, resulting in program errors.

Such problems often need to be dealt with in iBatiS or in custom xml programs that deal with sql. In fact, it is very simple. We only need to make the following replacement to avoid the above mistakes:

Original symbol

< >

= &'"replace symbol

< >

= & & apos; "

Wrong xml format:

AND START_DATE > = to_date ('2013-01-01-01) AND START_DATE = to_date (' 2013-01-01-01) AND START_DATE

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report