index.jsp

一个留言板程序

<%@ page contentType="text/html; charset=gb2312"  import="java.util.*" import="java.sql.*"%>
<%@ page errorPage="index_error.jsp" %>
<jsp:useBean id="db" scope="request" class="com.msg.db.DBConnect">
</jsp:useBean>
<jsp:useBean id="m_pages" scope="page" class="com.msg.bean.Pagination">
</jsp:useBean>
<jsp:include page="inc/head.jsp"></jsp:include>
<SCRIPT language=javascript>
function ConfirmDel()
{
   if(confirm("确定要删除选中的留言吗？一旦删除将不能恢复！"))
     return true;
   else
     return false;

}
</SCRIPT>
<BR><!----Navigation Bar Begin---->
<TABLE cellSpacing=0 cellPadding=0 width="75%" align=center border=0>
  <TBODY>
  <TR>
    <TD vAlign=center align=left width="70%"><IMG alt=""
      src="image/closedfold.gif" border=0>AndyMsgBoard
      &gt;&gt; 首页</TD>
    <TD vAlign=bottom align=right width="30%"><a href="send.jsp"><img src="image/t_new.gif" border="0"></a>&nbsp;&nbsp;<a href="publish.jsp"><img src="image/t_new2.gif" border="0"></a></TD>
  </TR></TBODY></TABLE><!----Navigation Bar End-----><BR>

<TABLE cellSpacing=0 cellPadding=0 width="75%" align=center border=0>
  <TBODY>
  <TR>
    <TD width=55 height=20><IMG src="image/left.gif"></TD>
    <TD align=middle width=* background=image/middle.gif><FONT
      color=#ffffff><B>AndyMsgBoard</B></FONT></TD>
    <TD width=55><IMG src="image/right.gif"></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="95%" align=center border=0>
  <TBODY>
  <TR>
    <TD>
      <TABLE width="80%" border=0 align="center" cellPadding=5 cellSpacing=1 bgColor="#005fba">
	  <TBODY>
        <TR align=middle bgColor="#ebeff5" height=22>
          <TD width=110 background=image/bbs><div align="center">用户信息</div></TD>
          <TD width=464 background=image/bbs><div align="center">留言内容</div></TD>

          </TR>
<%
Connection con=db.getConn();
Statement stmt=con.createStatement();
int ComSet=10;
   int curPages = m_pages.curPages(m_pages.strPage(request,"page"));//Pagination.strPage(request,"page")取page值传递给curPages()方法
   m_pages.setRows(ComSet);//设置每页显示10条
   String sql1="select count(*) as t from message";
   ResultSet rs_count=stmt.executeQuery(sql1);//传递进数据库处理的javabean
   rs_count.next();
   int resultconts=rs_count.getInt("t");//取得总的数据数
   int totalPages = m_pages.getPages(resultconts);//取出总页数
   String sql2="select * from message order by id desc";
   ResultSet rs2=stmt.executeQuery(sql2);
   ResultSet rs=m_pages.getPageSet(rs2,curPages);//获取指针的结果集参数是(结果集，页数)
   int i=1;
        while(rs.next()){
          String id=rs.getString("id");
          String name=rs.getString("name");
          String sex=rs.getString("sex");
          String content=rs.getString("content");
          String recontent=rs.getString("recontent");
          String qq=rs.getString("qq");
          String email=rs.getString("email");
          String http=rs.getString("http");
          String ltime=rs.getString("ltime");
          String ip=rs.getString("ip");
%>
        <TR vAlign=center align=middle bgColor=#ffffff>
          <TD>
<span class="style2"><span class="style4"><span class="style7"><%=name%><span style="font-family: &quot;??&quot;;" #invalid_attr_id="none"></span></span><span class="style3">留言于</span><font color="#000099"><font color="#FF0000"><br><%=ltime%>&nbsp;&nbsp;</font></font></span></span>
		  </TD>
          <TD align=right bgColor=#ffffff>
<a href="http://search.tencent.com/cgi-bin/friend/user_show_info?ln=<%=qq%>" target="_blank"><img src="image/icon_editor_oicq.gif" alt="<%=name%>的QQ是：<%=qq%>" width="16" height="16" border="0"></a><a href="<%=http%>" target="_blank"><img src="image/icon_homepage.gif" alt="<%=name%>的主页" width="16" height="16" border="0"></a><a href="mailto:<%=email%>"><img src="image/icon_email.gif" alt="<%=name%>的Email是：<%=email%>" width="16" height="16" border="0"></a><a href="edit.jsp?id=<%=id%>"><img src="image/icon_edit_topic.gif" width="16" height="16" border="0" alt="编辑该留言[只有版主才有的权利]"></a><a href="del_pro.jsp?id=<%=id%>" onclick="return ConfirmDel();"><img src="image/icon_delete_reply.gif" alt="删除该留言[只有版主才有的权利]" width="16" height="16" border="0"></a>
		  </TD>
        </TR>
        <TR vAlign=center align=middle bgColor=#ffffff>
          <TD>
<div align="center">
        <%
		if(sex.equals("男")){
		%>
        <img src="image/1.gif">
        <%
		}else{
		%>
        <img src="image/2.gif">
        <%
		}
	%>
        <br>
        <%=name%><br>
<%
if(session.getAttribute("adminname")==null){
%>
<span class="style4"><font color="#000099">IP:</font><font color="#FF0000">保密</font></span>
<%
}else{
%>
<span class="style4"><font color="#000099">IP:</font><font color="#FF0000"><%=ip%></font></span>
<%
}
%>
		</div>
		  </TD>
		  <%
		  if(recontent.equals("无")){
		  %>
		          <TD align=left valign="top" bgColor=#ffffff><pre><%=content%></pre></TD>
		 <%
		  }
		  else{ %>
		            <TD align=left valign="top" bgColor=#ffffff style="word-break:break-all"><pre><%=content%></pre><br><hr><font color="#FF0000">版主回复：<%=recontent%></font></TD>
		  <%}
		  %>


        </TR>
		<tr height="2"><td colspan="2"></td></tr>
  <%
i=i+1;
if(i>ComSet)
break;
}
%>
        <TR  bgColor=#ffffff>
          <TD align=right colspan="2" valign="top" bgColor=#ffffff>
      <%
  if(curPages>1)
  {
  %>
      <a href="index.jsp?page=<%=curPages-1%>">上一页</a>
      <%}
  else{%>
      上一页
      <%}
 if(curPages<totalPages)
 {
  %>
      <a href="index.jsp?page=<%=curPages+1%>">下一页</a>
      <%}
  else{%>
      下一页
      <%}%>
      <!---->
      当前第<%=curPages%>页 共<%=totalPages%>页
      <!---->
      <%
  if(curPages>1)
  {
  %>
      <a href="index.jsp?page=<%=totalPages-(totalPages-1)%>">首页</a>
      <%}
  else{%>
      首页
      <%}
 if(curPages<totalPages)
 {
  %>
      <a href="index.jsp?page=<%=totalPages%>">尾页</a>
      <%}
  else{%>
      尾页
      <%}%>
      <%
        try{
          rs_count.close();
          rs2.close();
          rs.close();
          stmt.close();
          con.close();
        }
        catch(Exception e){

          }
%>		  </TD>
        </TR>
       </TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="75%" align=center border=0>
  <TBODY>
  <TR>
    <TD width=40 height=6><IMG src="image/botleft.gif"></TD>
    <TD background=image/botmid.gif><IMG height=6></TD>
    <TD width=40><IMG
src="image/botright.gif"></TD></TR></TBODY></TABLE>
<br>
<TABLE cellSpacing=0 cellPadding=0 width="95%" align=center border=0>
  <TBODY>
  <TR>
    <TD align="center">
<jsp:include page="inc/link.jsp"></jsp:include>
<jsp:include page="inc/footer.jsp"></jsp:include>
	</TD></TR></TBODY></TABLE>
</BODY></HTML>