<?
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 >
< 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 >
所有sql xml文件的语法如上所示,语句类型分为insert,update,delete,select.变量符号统一使用$,其他如#,?等符号本架构不支持!nstarfainet的sal xml文件的语法格式和ibatisnet的有点类似,但没有ibatisnet那么强大和智能,不过很简单!一看就会! ibatisnet的sql map语句似乎不好处理$等特殊字符,nstarfainet在这方面做了些改进。