今天整理的一个JSP高效分页查询代码。
Jsp如下：**********************<%@ page language="java" import="java.util.*,java.sql.*" %><%@ page contentType="text/html;charset=gb2312"%><jsp:useBean id="cnsm" scope="page" class="com.DJGJDBC" /><%int curpage=1; //当前页int page_record=20; //每页显示的记录数curpage=Integer.parseInt(request.getParameter("page")); //获取传递的值，需要显示的页ResultSet rs=cnsm.getrsQuery("select top "+page_record+" * from tablename where id not in (select top "+((curpage-1)*page_record)+" id from tablename