Question

SERVLET怎样实现数据分页？

Answer 1

servlet分难做分页,除非在循环的sql语句中应用~~~

Answer 2

declare @pageIndex int --页索引
declare @pageSize int --页数据大小
set @pageIndex=1;
set @pageSize=20;

declare @From int
declare @To int
set @From=(@pageIndex - 1) * @pageSize + 1;
set @To=@pageIndex * @pageSize;
select * from
(
select a.*,ROW_NUMBER() OVER (ORDER BY /*排序字段*/ desc) AS RowNum from
(
--查询的数据
) as a
) as a
where RowNum BETWEEN @From AND @To ORDER BY RowNum ASC;