IBATIS查询 模糊查询分享

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap>
 <typeAlias alias="tbuser" type="com.test.model.TbUser" />
 <select id="findAll" resultClass="tbuser">
  select * from tbuser
 </select>
 <select id="findByPropertyJoin" parameterClass="tbuser"
  resultClass="tbuser">
  select * from tbuser
  <dynamic prepend="WHERE">
   <isPropertyAvailable property="id">
    <isNotEmpty prepend="AND" property="id">
     id=#id#
    </isNotEmpty>
   </isPropertyAvailable>
   <isPropertyAvailable property="username">
    <isNotEmpty prepend="AND" property="username">
     username like '%$username$%'
    </isNotEmpty>
   </isPropertyAvailable>
   <isPropertyAvailable property="password">
    <isNotEmpty prepend="AND" property="password">
     password=#password#
    </isNotEmpty>
   </isPropertyAvailable>
   <isPropertyAvailable property="sex">
    <isNotEmpty prepend="AND" property="sex">
     sex=#sex#
    </isNotEmpty>
   </isPropertyAvailable>
  </dynamic>
 </select>
 <select id="findByPropertyOr" parameterClass="tbuser"
  resultClass="tbuser">
  select * from tbuser
  <dynamic prepend="WHERE">
   <isPropertyAvailable property="id">
    <isNotEmpty prepend="or" property="id">
     id=#id#
    </isNotEmpty>
   </isPropertyAvailable>
   <isPropertyAvailable property="username">
    <isNotEmpty prepend="or" property="username">
     username like '%$username$%'
    </isNotEmpty>
   </isPropertyAvailable>
   <isPropertyAvailable property="password">
    <isNotEmpty prepend="or" property="password">
     password=#password#
    </isNotEmpty>
   </isPropertyAvailable>
   <isPropertyAvailable property="sex">
    <isNotEmpty prepend="or" property="sex">
     sex=#sex#
    </isNotEmpty>
   </isPropertyAvailable>
  </dynamic>
 </select>
 <insert id="insert" parameterClass="tbuser">
  insert into tbuser(username,password,sex) values(#username#,#password#,#sex#)
 </insert>
 <update id="update" parameterClass="tbuser">
  update tbuser set username=#username#,password=#password#,sex=#sex# where id=#id#
 </update>
 <delete id="delete" parameterClass="tbuser">
  delete from tbuser where id=#id#
 </delete>
</sqlMap>