iBATIS动态标签

来源：互联网发布：集成吊顶算法编辑：程序博客网时间：2024/06/02 06:29

§<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>  <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>  <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>  <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>  <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>      </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><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><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><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><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></select></sqlMap>