ibatis配置文件语法.DOC

ibatis配置文件 [color=darkred][/color]最近在用ibatis，想看看他的xml文件中都定义了哪些属性，于是去下了个sql-map-2.dtd和sql-map-config-2.dtd文件。 SqlMapConfig.xml文件用的是sql-map-config-2.dtd 映射文件用的是sql-map-2.dtd SqlMapConfig.xml文件没有什么好看的，都是一般的数据库配置等。 sql-map-config-2.dtd值得研究下。 我感兴趣的是如下属性： include | iterate | isParameterPresent | isNotParameterPresent | isEmpty | isNotEmpty | isNotNull | isNull | isNotEqual | isEqual | isGreaterThan | isGreaterEqual | isLessThan | isLessEqual | isPropertyAvailable | isNotPropertyAvailable 这些在我们组建sql的时候很有用，如在where后组装sql isNotEmpty property=name isEqual property=isNameLike compareValue=on AND t3.name like $name$% /isEqual isNotEqual property=isNameLike compareValue=on AND t3.name= #name# /isNotEqual /isNotEmpty dtd文件中还有注释和例子，真是学习的好东西。 include： Example: sql id=selectItem_fragment FROM items WHERE parentid = 6 /sql select id=selectItemCount resultClass=int SELECT COUNT(*) AS total /select select id=selectItems resultClass=Item SELECT id, name include refid=selectItem_fragment/ /select iterate: Iterates over a property that is an implementation java.util.Collection, or java.util.Iterator, or is an array. Example Usage: iterate prepend=”AND” property=”userNameList” open=”(” close=”)” conjunction=”OR” username=#userNameList[]# /iterate It is also possible to use the iterate when the collection is passed in as a parameter to your mapped statement. Example Usage: iterate prepend=”AND” open=”(” close=”)” conjunction=”OR” username=#[]# /iterate Note: It is very important to include the square brackets[] at the end of the property name when using the Iterate element. These brackets distinguish this object as a collection to keep the parser from simply outputting the collection as a string. 很简单的E文。开发时有dtd文档做参考其实就够了，不用google了。 ----------------------------------------------------------------- 在ibatis中使用安全的拼接语句,动态查询 ibatis比JDBC的优势之一,安全高效 说明文字在注释中 select id=selectAllProducts parameterClass=Product resultMap=ProductResult select id,