Example: Nstarfainet SQL XML File Demo

The syntax for all SQL XML files is as shown above, and the statement types are divided into insert,update,delete,select. Variable symbol uniform use $, other such as #, etc symbols this schema does not support!nstarfainet Sal The syntax format of the XML file is somewhat similar to the ibatisnet, but not as powerful and intelligent as ibatisnet, but very simple! Ibatisnet's SQL Map statement does not seem to handle special characters such as $, and Nstarfainet has made some improvements in this regard.

<?xml version= "1.0" encoding= "Utf-8"?>
<statements>
<select id= "Selecttest" >
SELECT * FROM Bsi_test where 1=1
<dynamics>
<dynamic prepend= "and" property= "Test_name" value= "Upper (Test_name) =upper (' $test _name$ ')"/>
</dynamics>
ORDER BY test_id
</select>
</statements>