Shulou(Shulou.com)06/01 Report--

This is mainly the sql statement for mysql:

①-MyBatis SQL xml handles less than sign and greater than sign

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

= &'"

②-sql fuzzy query-

And ver_code like CONCAT ('%', CONCAT (# {pd.verCode},'%'))

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.