📄 index.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="connBean" scope="page" class="beans.connDB"/>
<%
ResultSet rs=connBean.executeQuery("select * from v_board");
ResultSet rs_user=connBean.executeQuery("select * from tb_user where username='"+session.getAttribute("username")+"'and status='版主'");
ResultSet rs_reply=null;
ResultSet rs_topic=connBean.executeQuery("select * from tb_topic");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="CSS/style.css" rel="stylesheet">
<title>在水一方留言簿</title>
</head>
<body onLoad="clockon()">
<jsp:include page="top.jsp"/>
<table width="777" height="197" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="53%" height="5" valign="top"></td>
</tr>
<tr>
<td valign="top"><table width="100%" height="171" border="0" cellpadding="0" cellspacing="0" class="table">
<tr>
<td width="2%" height="26" background="images/bg_banner.GIF"> </td>
<td width="98%" background="images/bg_banner.GIF" class="word">≡查看留言≡</td>
</tr>
<tr valign="top">
<td colspan="2">
<%
boolean tj=rs_user.next();
String str=(String)request.getParameter("Page");
if(str==null){
str="0";
}
int pagesize=5;
rs.last();
int RecordCount=rs.getRow();
int maxPage=0;
maxPage=(RecordCount%pagesize==0)?(RecordCount/pagesize):(RecordCount/pagesize+1);
int Page=Integer.parseInt(str);
if(Page<1){
Page=1;
}else{
if(((Page-1)*pagesize+1)>RecordCount){
Page=maxPage;
}
}
rs.absolute((Page-1)*pagesize+1);
for(int i=1;i<=pagesize;i++){
%>
<table width="100%" height="192" border="0" cellpadding="0" cellspacing="0" class="table_B">
<tr align="center">
<td width="115" rowspan="3" align="center"><%=rs.getString("UserName")%>(<%=rs.getString("status")%>)<p>
<%=rs.getString("sex")%>生
<p>
表情：<%=rs.getString("face")%>
</td>
<td width="2" rowspan="3" align="center" valign="bottom"><hr size="100%" width="1px" color="#FFCCCC"></td>
<td width="447" align="left" style="padding-left:10pt" class="word">
<img src="images/email.GIF" alt="Email:<%=rs.getString("email")%>" width="16" height="16">
<img src="images/home-menu.gif" alt="个人主页：<%=rs.getString("homepage")%>" width="26" height="20">
<img src="images/atusers.gif" alt="OICQ号码：<%=rs.getString("OICQ")%>" width="14" height="16">
<img src="images/datetime.gif" alt="<%=rs.getString("datetime")%>" width="18" height="18"> 留言时间：<%=rs.getString("datetime")%></td>
<td width="195" align="right" style="padding-left:10pt" class="word">
<% out.println("<a href='reply.jsp?TopicID="+rs.getInt("ID")+"'>回复 </a>");
if(tj){out.println("<a href='Del.jsp?TopicID="+rs.getInt("ID")+"'>删除</a>");}%></td>
<td width="14" align="right" style="padding-left:10pt" class="word"> </td>
</tr>
<tr>
<td height="20" colspan="3" style="padding-left:10pt"><hr width="98%" color="#FFCCCC" size="1"></td>
</tr>
<tr>
<td height="109" colspan="3" valign="top" style="padding-left:10pt"><pre><%=rs.getString("content")%></pre></td>
</tr>
<tr>
<td height="2" colspan="5" align="center" valign="top" class="word"><hr width="98%" color="#FFCCCC" size="1"></td>
</tr>
<%
rs_reply=connBean.executeQuery("select * from tb_reply where TopicID="+rs.getInt("ID")+"");
while(rs_reply.next()){
%>
<tr>
<td height="39" align="center" valign="top" class="word"><%=rs_reply.getString("replyuser")%>回复</td>
<td align="center" valign="top"><hr size="20%" width="1px" color="#FFCCCC"></td>
<td colspan="3" valign="top" class="word" style="padding-left:10pt"><%=rs_reply.getString("content")%>
<hr width="98%" color="#FFCCCC" size="1"></td>
</tr>
<tr>
<td height="20" colspan="3" style="padding-left:10pt"> </td>
</tr>
<%}%>
</table> <br>
<%
try{
if(!rs.next()){break;}
}catch(Exception e){}
}
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="right">当前页数：[<%=Page%>/<%=maxPage%>]
<%if(Page>1){%>
<a href="index.jsp?Page=1">第一页</a> <a href="index.jsp?Page=<%=Page-1%>">上一页</a>
<%
}
if(Page<maxPage){
%>
<a href="index.jsp?Page=<%=Page+1%>">下一页</a> <a href="index.jsp?Page=<%=maxPage%>">最后一页 </a>
<%}%>
</td>
</tr>
</table>
</td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -