【JSP开源代码栏目提醒】:以下是网学会员为您推荐的JSP开源代码-admin_policy.jsp,希望本篇文章对您学习有所帮助。
<%@ include file="admintop.jsp"%>
<%@ include file="isadmin.jsp"%>
<form name="form1" method="POST">
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">
<tr bgcolor="#B1E1F3">
<td height="30" colspan="4">
<div align="center"><strong>所有<国家政策>文件</strong></div></td>
</tr>
<tr>
<td width="53%"><div align="center">政策文件名</div></td>
<td width="27%"><div align="center">上传日期</div></td>
<td width="10%"><div align="center">操作</div></td>
<td width="10%"><div align="center">选择</div></td>
</tr>
<%String sqlname;
int intPageSize;
int intRowCount;//记录总数
int intPageCount;//总页数
int intPage;//页面参数
String strPage;//定义变量用来传递page
int i,j;
intPageSize=8;//定义每页显示8条记录
strPage=request.getParameter("page");//取得当前的页码
if(strPage==null){//判断初始页面,如果没有显示记录,就置为第一页
intPage=1;
}else{
intPage=Integer.parseInt(strPage);//将strPage转化为整数
if(intPage<1) intPage=1;
}
sqlname="select count(id) from scott.policy order by times desc";
ResultSet rt=stmt.executeQuery(sqlname);
rt.next();
intRowCount=rt.getInt(1);//取得整数保存与intRowCount变量中
intPageCount=(intRowCount+intPageSize-1)/intPageSize;//计算出总页数(记录总数+每页显示的记录-1)/每页显示的记录)
if(intPage>intPageCount)
intPage=intPageCount;
sqlname="select id, pytitle,times from scott.policy order by times desc";
ResultSet rs=stmt.executeQuery(sqlname);//执行sql,按照时间先后排序显示
i=(intPage-1)*intPageSize;
for(j=0;j<i;j++)
rs.next();
%>
<%-- 设置intPage参数 --%>
<%if(intRowCount==0){%>
<tr><td colspan='4'>暂无内容</td></tr>
<%}else{%>
<%-- 显示每页的数据 (根据i的值判断每页的5条记录) --%>
<%i=0;
while(i<intPageSize && rs.next()){%>
<tr>
<td width="53%"><div align="center"><a href="../listpy.jsp?id=<%=rs.getString("id")%>" target="_blank"><%=rs.getString("pytitle")%></a></div></td>
<td width="27%"><div align="center"><%=rs.getString("times")%></div></td>
<td width="10%"><div align="center"><a href="editpolicy.jsp?id=<%=rs.getString("id")%>">修改</a>/<a href="delpolicy.jsp?id=<%=rs.getString("id")%>">删除</a></div></td>
<td width="10%"><div align="center">
<input type="checkbox" name="Board" id="<%=rs.getString("id")%>" style="font-size: 9pt">
</div></td>
</tr>
<% i++;}
}%>
<tr>
<td colspan="4"> <div align="center"> <a href="addpolicy.jsp" target="_blank">添加内容</a>
<input type="button" value="全 选" onclick="sltAll()" name=button1>
<input type="button" value="清 空" onclick="sltNull()" name=button2>
<input type="submit" value="删 除" name="tijiao" onclick="SelectChk('delpolicy.jsp')">
</div></td></tr>
<tr>
<td colspan="4">
<div align="right">
<p align='center' vAlign='bottom'>
第<%=intPage%>页 共<%=intPageCount%>页
<%if(intPage<intPageCount){%>
<a href="admin_policy.jsp?page=<%=intPage+1%>">下一页</a>
<%}%>
<%if(intPage>1){%>
<a href="admin_policy.jsp?page=<%=intPage-1%>">上一页</a>
<%}%>
</div>
</td>
</tr>
</table>
</form>
</body>
</html>