【JSP开源代码栏目提醒】:网学会员鉴于大家对JSP开源代码十分关注,论文会员在此为大家搜集整理了“admin_consul.jsp”一文,供大家参考学习
<%@ include file="admintop.jsp"%>
<%@ include file="isadmin.jsp"%>
<form name="form1" method="POST">
<table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
<tr>
<td height="30" colspan="4" bgcolor="#B1E1F3">
<div align="center"><strong>所有咨询留言</strong></div></td>
</tr>
<tr>
<td width="53%"><div align="center">留言者</div></td>
<td width="21%"><div align="center">回复状况</div></td>
<td width="16%"><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.contact";
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, guestname,reply from scott.contact 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="../discontact.jsp" target="_blank"><%=rs.getString("guestname")%></a></div></td>
<td width="21%"><div align="center">
<%if(rs.getString("reply")==null){
out.print("<font color='#FF0000'>未回复</font>");
}else{
out.print("已回复") ;
}%></div></td>
<td width="16%"><div align="center"><a href="replyconsul.jsp?id=<%=rs.getString("id")%>">回复编辑</a>/<a href="delconsul.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">
<input type="button" value="全 选" onclick="sltAll()" name=button1>
<input type="button" value="清 空" onclick="sltNull()" name=button2>
<input type="submit" value="删 除" name="tijiao" onclick="SelectChk('delconsul.jsp')">
</div></td></tr>
<tr>
<td colspan="4">
<div align="right">
<p align='center' vAlign='bottom'>
第<%=intPage%>页 共<%=intPageCount%>页
<%if(intPage<intPageCount){%>
<a href="admin_consul.jsp?page=<%=intPage+1%>">下一页</a>
<%}%>
<%if(intPage>1){%>
<a href="admin_consul.jsp?page=<%=intPage-1%>">上一页</a>
<%}%>
</div></td>
</tr>
</table>
</form>
</body>
</html>
上一篇:
admin_check.jsp
下一篇:
加强企业管理力度 提升产品绿色竞争力