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了。