jsp 和 SQL server实现分页问题

我这是参照的MYSQL 的例子，但是我不知道SQLServer 2000中的分页如何写，请大虾指教！！java.sql.SQLException:[Microsotf][SQLServer 2000 Driver for JDBC][SQLServer]第一行：'limit' 附近有语法错误。
tomcat报错：
java.lang.NullPointerException
admin.product.ProductSQLserverDAO.getProducts(ProductSQLserverDAO.java:105)
admin.product.ProductService.getProducts(ProductService.java:24)
org.apache.jsp.admin.ProductList_jsp._jspService(org.apache.jsp.admin.ProductList_jsp:69)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)返回方法如下：
public int getProducts(List<Product> products, int pageNo, int pageSize, boolean lazy) {
int totalRecords = -1;
Connection conn = DBConnection.getConn();
Statement stmt = DBConnection.getStatement(conn);

String sql = "";
if(lazy) {
sql = "select * from dish order by pdate desc";
} else {
sql = "select p.id productid, p.dishName pname, p.descr pdescr, p.normalprice, " +
" p.pdate, p.categoryid , " +
" c.id categoryid, c.categoryName cname, c.descr cdescr," +
" from dish p , category c where p.categoryid = c.id order by p.pdate ";
}
sql +=  " limit " + (pageNo - 1) * pageSize + "," + pageSize;

ResultSet rs = DBConnection.getResultSet(stmt, sql);
Statement stmtCount = DBConnection.getStatement(conn);
ResultSet rsCount = DBConnection.getResultSet(stmtCount,
"select count(*) from dish");

try {
rsCount.next();
totalRecords = rsCount.getInt(1);

while (rs.next()) {
Product p = null;
if(lazy) {
p = this.getProductFromRs(rs);
} else {
p = new Product();
p.setId(rs.getInt("productid"));
p.setName(rs.getString("pname"));
p.setDescr(rs.getString("pdescr"));
p.setNormalPrice(rs.getFloat("normalprice"));
p.setPdate(rs.getTimestamp("pdate"));
p.setCategoryId(rs.getInt("categoryid"));

Category c = new Category();
c.setId(rs.getInt("categoryid"));

c.setDescr(rs.getString("cdescr"));


p.setCategory(c);
}
products.add(p);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBConnection.close(rsCount);
DBConnection.close(stmtCount);
DBConnection.close(stmt);
DBConnection.close(rs);
DBConnection.close(conn);
} return totalRecords;
}