java如何调用分页存储过程_java 调用存储过程实现分页 sql server 2012 版

存储过程：(sql语句中必须有order by  仅支持2012)USE [stww]

GO

/****** Object: StoredProcedure [dbo].[SplitPage] Script Date: 2013/11/29 16:20:19 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCedure [dbo].[SplitPage]

@sqlQuery varchar(2000), --//输入参数：SQL检索语句或表名

@pageIndex int, --//输入参数：当前页码

@pageSize int --//输入参数：每页显示记录条数

as SET NOCOUNT ON

SET ANSI_WARNINGS OFF

declare @indexStart varchar(20),@indexEnd varchar(20)

set @indexStart = cast((@pageIndex-1)*@pageSize+1 as varchar(20))

if @indexStart <0

set @indexStart = 0

--//数据起始行ID

exec( @sqlQuery + " offset " + @indexStart + " row fetch next " + @pageSize +" rows only") --//检索该页数据

GO

java：

try{

String sql = s_sql;

sql += " order by "+s_pk+" "+s_sort;

PreparedStatement pstmt = conn.prepareStatement("{call SplitPage(?,?,?)}");

System.out.println("sql"+sql);

pstmt.setString(1, sql);

pstmt.setInt(2, Integer.parseInt(pageNo));

pstmt.setInt(3, pageSize);

rs = pstmt.executeQuery();

}catch(Exception e){

System.out.println(e.getMessage());

return null;

}

//System.out.println(sql);

return rs;