📄 simplepage.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="simpleforum.page.*"%>
<html>
<head>
<title> 分页测试 </title>
</head>
<%
String countSql = "select count(*) from forumpost where answerPostId= 0 ";
String jumpPage = (request.getParameter("jumpPage")==null)?"1":request.getParameter("jumpPage");
String objSql = "select * from forumpost where answerPostId=0 ";
SimplePageDb2 sp = new SimplePageDb2();
sp.setRowsPerPage(6); //设置每页显示多少行记录
sp.setCurPage(Integer.parseInt(jumpPage)); //设置要跳转到哪一页
sp.setCountSql(countSql); //设置统计所有记录说的sql
sp.setSelectSql(objSql); //设置要查询的sql
sp.setFormName("item2"); //设置form表单的名字
java.util.Vector vector = sp.getResult(); //将查询结果放在vector中
//pageBean这个名字不要改变，否则分页无法使用。
%>
<body>
<form name="item2" method="post" action="page3.jsp">
<table border="1" bordercolor="blue">
<tr>
<td>顺号</td>
<td>帖子标题</td>
<td>发言人</td>
</tr>
<%
int start = (Integer.parseInt(jumpPage)-1)*sp.getRowsPerPage()+1;
String PostName = "";
String SpokesMan = "";
//out.println("vector="+vector);
out.println("vector.size()="+vector.size());
for(int i=0 ;i<vector.size();i++){
java.util.Hashtable hash =(java.util.Hashtable)vector.elementAt(i);
PostName = (String)hash.get("POSTNAME");
SpokesMan = (String)hash.get("SPOKESMAN");
%>
<tr>
<td><%=start+i%></td>
<td><%=PostName%></td>
<td><%=SpokesMan%></td>
</tr>
<%
}
%>
</table>
<%=sp.getPageInfo()%>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -