ibatis怎样查询某个时间范围内的记录
<!-- 搜索功能(模糊查询)start-->
<select id="SearchRFID" resultMap="T_HLM_RFIDResult" parameterClass='T_HLM_RFID'>
SELECT A.* FROM [T_HLM_RFID] A
<dynamic prepend="WHERE">
<isNotEmpty prepend=" and" property="RFID_Person">
A.RFID_Person like '%$RFID_Person$%'
</isNotEmpty>
<isNotEmpty prepend=" and" property="RFID_Code" >
A.RFID_Code = #RFID_Code#
</isNotEmpty>
<isGreaterThan prepend=" and" property="StartTime" compareValue="1900-1-1">
<![CDATA[
A.RFID_Time >= #StartTime#
]]>
</isGreaterThan>
<isGreaterThan prepend=" and" property="EndTime" compareValue="1900-1-1">
<![CDATA[
A.RFID_Time<= #EndTime#
]]>
</isGreaterThan>
</dynamic>
</select>
<!-- 搜索功能(模糊查询)end-->