求教Mybatis多条件查询问题

select b.loc,b.findtime,b.status,b.b_uid,b.desc,b.uname
from bugdesc b,user u
<where>
u.id=b.b_uid
<if test="#{id}!=null">id=#{id}</if>
<if test="#{b_uid}!=null">b_uid=#{b_uid}</if>
<if test="#{author}!=null">author=#{author}</if>
<if test="#{begin}!=null">b.findtime >= #{begin}</if>
<!-- <if test="#{end}!=null">b.findtime <= #{end}</if> -->

</where>

这样写么


还有最后一个条件的小于号，在xml文件里怎么输入

<![CDATA[
sql语句
]]>

select b.loc,b.findtime,b.status,b.b_uid,b.desc,b.uname
from bugdesc b,user u
<dynamic prepend=" where ">
<isNotNull property="id" prepend=" and ">
  <isNotEmpty property="id">
  id=#id#
  </isNotEmpty>
</isNotNull>
<isNotNull property="end" prepend=" and ">
  <isNotEmpty property="end">
  <![CDATA[
  b.findtime <= #end#
  ]]>
  </isNotEmpty>
</isNotNull>
</dynamic>