Ibatis语句如何使用if判断

[坐观垂钓者]

Ibatis语句如何使用if判断，哪位大虾有例子！

[15年老程创业中]

isNotNull
isEmpty
isGreaterEqual
isNotNull
isLessEqual
……

[softroad]

学习了。

[坐观垂钓者]

有实例没有啊

[游一游走一走]

<select id="getPersonsByName" resultClass="com.unmi.Person">       
      select id as id,name as name,passwd as passwd from person       
        <dynamic prepend="WHERE">       
            <isNotNull prepend="AND" property="name">       
                  (name like #name#)       
            </isNotNull>       
        </dynamic>       
</select> 

[pengpeng107]

<!-- find user list page -->
	<select id="find-count-of-users" parameterClass="User" resultClass="int">
		select count(*) from t_user
			<dynamic prepend="where">
				<isNotEqual property="type" compareValue="-1" prepend="AND">
	                user_type = #type#
	            </isNotEqual>
	            <isNotEmpty property="userName" prepend="and">
	            	user_name like '%$userName$%'
	            </isNotEmpty>
				<isNotEqual property="state" compareValue="3" prepend="AND">
	                user_state = #state#
	            </isNotEqual>
	            <isNotEqual property="usedSpaceSize" compareValue="-1" prepend="AND">
	                user_used_space_size >= #usedSpaceSize#
	            </isNotEqual>
			</dynamic>
	</select>

[飓风zj]

还没用过ibatIS

[zhangwonderful]

[Quote=引用 5 楼 pengpeng107 的回复:]
XML code


<!-- find user list page -->
<select id="find-count-of-users" parameterClass="User" resultClass="int">
select count(*) from t_user
<dynamic prepend="where">
……
[/Quote]
支持

[moment52]

去看我的资源，有你需要的