iBATIS动态标签

§<dynamic>标签
§二元标签
§一元标签
§<iterate>标签
§ 共同的属性 prepend,open,close
<dynamic>标签

§<dynamic>标签
§属性 prepend,open,close
二元条件标签

§<isEqual property=“age” compareValue=“20”>  
比较属性值和静态值或另一个属性值是否相等  

§<isNotEqual>  
比较属性值和静态值或另一个属性值是否不相等。  

§<isGreaterThan>  
比较属性值是否大于静态值或另一个属性值。  

§<isGreaterEqual>  
比较属性值是否大于等于静态值或另一个属性值。  

§<isLessThan>  
比较属性值是否小于静态值或另一个属性值。  

§<isLessEqual>  
比较属性值是否小于等于静态值或另一个属性值。  

 

 

一元条件标签

 

§<isPropertyAvailable>  
检查是否存在该属性（存在parameter bean的属性）  

§<isNotPropertyAvailable>  
检查是否不存在该属性（不存在parameter bean的属性）  

§<isNull>  
检查属性是否为null  

§<isNotNull>  
检查属性是否不为null  

§<isEmpty>  
检查Collection.size()的值，属性的String或String.valueOf()值,是否为null或空（“”或size() < 1）  

§<isNotEmpty>  
检查Collection.size()的值，属性的String或String.valueOf()值,是否不为null或不为空（“”或size() > 0）

 

其他标签

 

 

§<isParameterPresent>  
检查是否存在参数对象（不为null）

§<isNotParameterPresent>  
检查是否不存在参数对象（参数对象为null）

§<iterate>  
遍历类型为java.util.List的元素。  

 

 

 

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"> <sqlMap> <!-- 动态查询1--> <select id="getOrders1" parameterClass="com.air.Account" resultClass="com.air.Product"> SELECT orders.id as id, orders.product as product, orders.customer as customer FROM orders <dynamic prepend=" WHERE "> <isNull property="username">customer IS NOT NULL</isNull> <isNotNull property="username"> orders.customer=#username# </isNotNull> </dynamic> </select> <!-- 动态查询2--> <select id="getOrders2" parameterClass="com.air.Account" resultClass="com.air.Product"> SELECT o.id as id, o.product as product, o.customer as customer FROM orders o <isNotNull property="username"> INNER JOIN user_account a ON o.customer=a.username </isNotNull> <dynamic prepend="where "> <isNotEmpty property="groupname" prepend="and " open="(" close=")"> a.groupname=#groupname# </isNotEmpty> </dynamic> </select> <!-- 动态查询3--> <select id="getOrders3" parameterClass="com.air.Product" resultClass="com.air.Product"> SELECT orders.id as id, orders.product as product, orders.customer as customer FROM orders <dynamic prepend="WHERE "> <isNotEmpty property="product" prepend="and" open="(" close=")" removeFirstPrepend="true"> product=#product# </isNotEmpty> <isNotEmpty property="customer" prepend="and" open="(" close=")"> customer=#customer# </isNotEmpty> </dynamic> </select> <!-- 动态查询4--> <select id="getOrders4" parameterClass="com.air.Product" resultClass="com.air.Product"> SELECT * FROM orders <dynamic prepend="WHERE "> <iterate property="keywords" open="(" close=")" conjunction="OR"> product=#keywords[]# </iterate> </dynamic> <!-- <dynamic prepend="WHERE product IN ">--> <!-- <iterate property="keywords" open="(" close=")" conjunction=","> --> <!-- #keywords[]#--> <!-- </iterate>--> <!-- </dynamic>--> </select> </sqlMap>

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"> <sqlMap> <!-- 动态查询1--> <select id="getOrders1" parameterClass="com.air.Account" resultClass="com.air.Product"> SELECT orders.id as id, orders.product as product, orders.customer as customer FROM orders <dynamic prepend=" WHERE "> <isNull property="username">customer IS NOT NULL</isNull> <isNotNull property="username"> orders.customer=#username# </isNotNull> </dynamic> </select> <!-- 动态查询2--> <select id="getOrders2" parameterClass="com.air.Account" resultClass="com.air.Product"> SELECT o.id as id, o.product as product, o.customer as customer FROM orders o <isNotNull property="username"> INNER JOIN user_account a ON o.customer=a.username </isNotNull> <dynamic prepend="where "> <isNotEmpty property="groupname" prepend="and " open="(" close=")"> a.groupname=#groupname# </isNotEmpty> </dynamic> </select> <!-- 动态查询3--> <select id="getOrders3" parameterClass="com.air.Product" resultClass="com.air.Product"> SELECT orders.id as id, orders.product as product, orders.customer as customer FROM orders <dynamic prepend="WHERE "> <isNotEmpty property="product" prepend="and" open="(" close=")" removeFirstPrepend="true"> product=#product# </isNotEmpty> <isNotEmpty property="customer" prepend="and" open="(" close=")"> customer=#customer# </isNotEmpty> </dynamic> </select> <!-- 动态查询4--> <select id="getOrders4" parameterClass="com.air.Product" resultClass="com.air.Product"> SELECT * FROM orders <dynamic prepend="WHERE "> <iterate property="keywords" open="(" close=")" conjunction="OR"> product=#keywords[]# </iterate> </dynamic> <!-- <dynamic prepend="WHERE product IN ">--> <!-- <iterate property="keywords" open="(" close=")" conjunction=","> --> <!-- #keywords[]#--> <!-- </iterate>--> <!-- </dynamic>--> </select> </sqlMap>