ibatis怎样查询某个时间范围内的记录

it2022-05-05  164

<!-- 搜索功能(模糊查询)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增强版

最新回复(0)