<!-- 搜索功能(模糊查询)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-->
转载于:https://www.cnblogs.com/zhangweijia/archive/2012/07/24/2606572.html
相关资源:DirectX修复工具V4.0增强版