建网站做站在,做网站哪些技术,青海网站开发 建设,推广员是什么工作摘要#xff1a;Sql Server 分页查询sql!
Sql Server 2005分页查询数据#xff0c;适用于手机端和服务器端交互
一#xff1a;Dao代码#xff1a; /*** 分页查询研讯分类下的新闻列表*/Overridepublic ListTblNews getListByYunXunNewId(int cId, int start, int…摘要Sql Server 分页查询sql!
Sql Server 2005分页查询数据适用于手机端和服务器端交互
一Dao代码 /*** 分页查询研讯分类下的新闻列表*/Overridepublic ListTblNews getListByYunXunNewId(int cId, int start, int limit) {String sql select top limit * from (select * from dbo.tbl_news where category_id cId ) as a where id not in (select top ( limit *( start -1)) id from tbl_news where category_id cId order by id desc) order by id desc;SQLQuery sqlQuery this.getSession().createSQLQuery(sql);sqlQuery.addEntity(TblNews.class);return sqlQuery.list();} 注释其中cId代表新闻分类Idstart代表页数limit代表每页显示几条数据 二SQL语句 select top 10 * from (select * from tbl_news where category_id 20) as a where id not in (select top (10*(1-1)) id from tbl_news where category_id20 order by id desc) order by id desc;