ibatis 的动态查询

<sql id="sql_sel">
		select *
	</sql>
	<sql id="sql_wh">
		from users
		<dynamic prepend="where">
			<isNotEmpty prepend="and" property="usphone">
				us_phone=#usphone#
			</isNotEmpty>
			<isNotEmpty prepend="and" property="usnickname">
				usnickname like
				'%$usnickname$%'
			</isNotEmpty>
		</dynamic>
	</sql>
	<select id="users_friend" parameterClass="users" resultClass="users">
		<include refid="sql_sel" />
		<include refid="sql_wh" />
	</select>

在ibatis运用中，所有的命名都不能重复，并且  id等于refid