java访问sqlserver2008分页问题
最近想学java,在用jdbc连接sqlserver2008做分页的时候遇到如下问题,还请高手指教:
sql = "select * from (select ROW_NUMBER()over(order by orderby) as num,* from t_book where cid='5F79D0D246AD4216AC04E9C5FAB3199E') as t where num between 1 and 11";
List<Book> beanList = qr.query(sql, new BeanListHandler<Book>(Book.class));
这样就好使,但是换成参数化就报错
sql = "select * from (select ROW_NUMBER()over(order by orderby) as num,* from t_book where cid=?) as t where num between ? and ?";
params.add(“5F79D0D246AD4216AC04E9C5FAB3199E”);//当前页首行记录的下标
params.add((pc-1) * ps);//当前页首行记录的下标
params.add(ps);//一共查询几行,就是每页记录数
List<Book> beanList = qr.query(sql, new BeanListHandler<Book>(Book.class),params.toArray());
总是报sql错误
还请高手回答,难道参数化不支持嵌套?