我在jsp页面中使用的例子
<%@ page contentType="text/html; charset=UTF-8" %>
<%@ page import ="db.*" %>
<html>
<head>
<title>
jsp1
</title>
</head>
<body bgcolor="#ffffff">
<table>
<%//
StringBuffer s = new StringBuffer();//
s.append("select * from employee where 1=1 ");//bean.ViewQueryBean
if (request.getParameter("condition")!=null)
{s.append(" and ");
s.append(request.getParameter("condition"));
}
PageResultSet p = new PageResultSet();
p.executeQuery(s.toString());
int pg ,pageRows,pageCount;
pageCount = p.getPageCount();
System.out.println(pageCount);
if (request.getParameter("page")!=null){
pg = Integer.parseInt(request.getParameter("page")); }
else{pg=1;}
pageRows = p.getPageRows();
p.scrollToRows((pg-1)*pageRows+1);
int i=1;
do
{out.println(p.getString(1));
System.out.print(p.getString(2));i++;
}while(p.next() && i<=pageRows);
p.close();
%>
</table>
<table width="100%" >
<tr ><div align="center"> 绗?%=pg%>椤? ???%=pageCount%>椤?/div></tr>
<tr><div align="center">
<%if(pg<pageCount){%>
<a href="employeeBrowser.jsp?page=<%=pg+1%>">涓?涓?椤?/a>
<%}%>
<%if(pg>1){%>
<a href="employeeBrowser.jsp?page=<%=pg-1%>">涓?涓?椤?/a>
<%}%>
<%for (int j= 1;j<=pageCount ;j++)
{out.print("<a href='employeeBrowser.jsp?page="+j+"'>["+j+"]</a>");
}%></div>
</tr>
</table>
</body>
</html>
<%@ page contentType="text/html; charset=UTF-8" %>
<%@ page import ="db.*" %>
<html>
<head>
<title>
jsp1
</title>
</head>
<body bgcolor="#ffffff">
<table>
<%//
StringBuffer s = new StringBuffer();//
s.append("select * from employee where 1=1 ");//bean.ViewQueryBean
if (request.getParameter("condition")!=null)
{s.append(" and ");
s.append(request.getParameter("condition"));
}
PageResultSet p = new PageResultSet();
p.executeQuery(s.toString());
int pg ,pageRows,pageCount;
pageCount = p.getPageCount();
System.out.println(pageCount);
if (request.getParameter("page")!=null){
pg = Integer.parseInt(request.getParameter("page")); }
else{pg=1;}
pageRows = p.getPageRows();
p.scrollToRows((pg-1)*pageRows+1);
int i=1;
do
{out.println(p.getString(1));
System.out.print(p.getString(2));i++;
}while(p.next() && i<=pageRows);
p.close();
%>
</table>
<table width="100%" >
<tr ><div align="center"> 绗?%=pg%>椤? ???%=pageCount%>椤?/div></tr>
<tr><div align="center">
<%if(pg<pageCount){%>
<a href="employeeBrowser.jsp?page=<%=pg+1%>">涓?涓?椤?/a>
<%}%>
<%if(pg>1){%>
<a href="employeeBrowser.jsp?page=<%=pg-1%>">涓?涓?椤?/a>
<%}%>
<%for (int j= 1;j<=pageCount ;j++)
{out.print("<a href='employeeBrowser.jsp?page="+j+"'>["+j+"]</a>");
}%></div>
</tr>
</table>
</body>
</html>