📄 howtousesimplepagedb2.txt

📁 Java案例开发集锦,里面提供了很好的学习例子
💻 TXT
字号:
<%@ 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(5); //设置每页显示多少行记录
	sp.setCurPage(Integer.parseInt(jumpPage)); //设置要跳转到哪一页
	sp.setCountSql(countSql); //设置统计所有记录说的sql
	sp.setSelectSql(objSql); //设置要查询的sql
	java.util.Vector  vector = sp.getResult(); //将查询结果放在vector中
	//pageBean这个名字不要改变，否则分页无法使用。
%>
<body>
	<form name="item2" method="post" action="page2.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>
<%@ include file="includepage2.jsp"%>
	</form>	
</body>
</html>
--------------------------------------------------------------------------------------
<%@ page contentType="text/html;charset=gb2312" %>
<script languange="javascript">	
	function Jumping(){
		document.item2.submit();
		return;
	}
	function gotoPage(pagenum){
		document.item2.jumpPage.value=pagenum;
		document.item2.submit();
		return;
	}
</script>
<table>
	<tr>
		<td>
			每页<%=sp.getRowsPerPage()%>行
			共<%=sp.getMaxRowCount()%>行
			第<%=sp.getCurPage()%>页
			共<%=sp.getMaxPage()%>页
			<br>
<%
	if(sp.getCurPage()==1){
		out.println(" 首页 上一页");
	}else{
%>
			<a href="javascript:gotoPage(1)">首页</a>
			<a href="javascript:gotoPage(<%=sp.getCurPage()-1%>)">上一页</a>
<%	
	}
	if(sp.getCurPage()==sp.getMaxPage()){
		out.println(" 下一页 尾页");
	}else{
%>
			<a href = "javascript:gotoPage(<%=sp.getCurPage()+1%>)">下一页</a>
			<a href = "javascript:gotoPage(<%=sp.getMaxPage()%>)">尾页</a>
<%	
	}
%>	
			转到第
			<select name="jumpPage" onchange="Jumping()">
<%
	for(int i = 1;i<=sp.getMaxPage();i++){
		if(i==sp.getCurPage()){
%>
			<option selected value="<%=i%>" ><%=i%></option>
<%
		}else{
%>
	<option value="<%=i%>"><%=i%></option>
<%		
		}
	}
%>			
			</select>页
		</td>
	</tr>
</table>
-------------------------------------------------------------------------------
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -