IBatis分页显示
<select id="pagedListOrderOpen">
SELECT * FROM (
</select>
<sql id="pagedListOrderClose">
) PagedList
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="StartIndex"><![CDATA[PagedList.rowNum>=#StartIndex#]]></isNotNull>
<isNotNull prepend="AND" property="EndIndex"><![CDATA[PagedList.rowNum<=#EndIndex#]]></isNotNull>
</dynamic>
</sql>
<select id="selOrdersWithPaging" parameterClass="OrderSearch" resultClass="Order" extends="pagedListOrderOpen" resultMap="OrderMappingResult">
SELECT O.*,rowNum = ROW_NUMBER() OVER(ORDER BY OrderId DESC)
FROM OrderInfo AS O (NOLOCK)
<include refid="fuzzySearchActivityConfig"/>
<include refid="pagedListOrderClose" />
</select>
<sql id="fuzzySearchOrder">
<dynamic prepend="WHERE">
<isNotEmpty property="Caption" prepend="AND">
<![CDATA[O.Caption LIKE '%$Caption$%']]>
</isNotEmpty>
<isNotNull property="SaleStartDate" prepend="AND">
<![CDATA[O.SaleDate >= #SaleStartDate#]]>
</isNotNull>
<isNotNull property="SaleEndDate" prepend="AND">
<![CDATA[O.SaleDate <= #SaleEndDate#]]>
</isNotNull>
<isNotEmpty property="Status" prepend="AND">
<![CDATA[O.Status=#Status#]]>
</isNotEmpty>
</dynamic>
</sql>
最新文章
- 360浏览器导出Excel闪退BUG
- 安装yii2时出错 Invalid Parameter – yii\base\InvalidParamException
- [转]浅谈php web安全
- jquery id选择器 id带";.";问题
- 【转】 GridView 72般绝技
- Day2(2016/1/22)——Testing
- Html5工具
- Netbeans Platform 工程,免安装JDK
- 仿QQ注册验证码的实现。
- 学习笔记之Java程序设计实用教程
- nativescript环境搭建
- uva 10154 贪心+dp
- XMEAG-128A1
- 【玩转开源】BananaPi R2 —— 第三篇 基于Openwrt开发一个简单的路由器
- Android View的滑动
- LNMP平台部署
- vs里32位项目和64位项目的区别
- linux编译安装php apache mysql (已试过)
- Word Ladder leetcode java
- web.xml配置文件中<;async-supported>;true<;/async-supported>;报错