message.jsp

这是一个用JAVA语言编写的BBS论坛程序

<%
/*
 * Copyright:  Copyright (c) 2004 
 * @author http://hi.baidu.com/lael80*/
%>
<%@ page contentType="text/html; charset=gb2312" errorPage=""%>
<%@ include file="head.jsp"%>
<br>
<%
if(!workFC.cNULL(String.valueOf(session.getAttribute("u_name")))){
  response.sendRedirect("result.jsp?errcodes="+workFC.GBtoUni("<li>您还没注册或登录,没权查看留言"));
  return;
}
//标志msg_type=1为已读,0为未读
workDB.executeUpdate("update user_msg set msg_type=1 where user_name='"+session.getAttribute("u_name")+"' and msg_type<>3");
if(workFC.cNULL(request.getParameter("del"))){
  if(workDB.queryCount("select count(msg_id) from user_msg where msg_id="+request.getParameter("del")+" and user_name='"+session.getAttribute("u_name")+"'")==0){
    response.sendRedirect("result.jsp?errcodes="+workFC.GBtoUni("<li>您不能删除其它会员的留言"));
    return;    
  }else{
    workDB.executeUpdate("delete from user_msg where msg_id="+request.getParameter("del"));
  }
}

try{
 pageid=Integer.parseInt(request.getParameter("pageid"));
}catch(Exception e){pageid=1;}

String send=request.getParameter("send");
if(workFC.cNULL(send)){
 sql="select msg_id,msg_content,user_name,msg_date from user_msg where msg_author='"; 
 workDB.PageInfo("select count(msg_id) from user_msg where msg_author='"+session.getAttribute("u_name")+"'",20,pageid); 
 urlpath="send=1&";
}else{
 sql="select msg_id,msg_content,msg_author,msg_date from user_msg where user_name='";
 workDB.PageInfo("select count(msg_id) from user_msg where user_name='"+session.getAttribute("u_name")+"'",20,pageid); 
}
if(pageid<1||pageid>workDB.getPageCount())pageid=1;

if(workFC.cNULL(send)){
 workDB.PageInfo("select count(msg_id) from user_msg where msg_author='"+session.getAttribute("u_name")+"'",20,pageid); 
}else{
 workDB.PageInfo("select count(msg_id) from user_msg where user_name='"+session.getAttribute("u_name")+"'",20,pageid); 
}
String msgdata[]=workDB.queryData(sql+session.getAttribute("u_name")+"' order by msg_id desc",4,pageid,20);

%>
<%=tabletop%>
<table width="100%" border="0" align="center" cellpadding="5" cellspacing="1">
  <tr>
   <td height="25" class="b1" colspan="5">&nbsp;</td>
  </tr>
  <tr>
   <td align="center" colspan="5">
    <a href="message.jsp"><img src="images/msgbox.gif"></a>&nbsp;
    <a href="message.jsp?send=1"><img src="images/msgsend.gif"></a>&nbsp;
    <a href="directory.jsp"><img src="images/msgdirectory.gif"></a>&nbsp;
    <a href="sendmsg.jsp"><img src="images/msgnew.gif"></a>
   </td>
  </tr>
  <tr height="25" class="style3">
   <td width="4%" align="center">&nbsp;</td>
   <td width="18%" align="center"><b><%=workFC.cNULL(send)?"收件人":"发件人"%></b></td>
   <td width="40%" align="center"><b>内容</b></td>
   <td width="18%" align="center"><b>日期</b></td>
   <td width="20%" align="center"><b>操作</b></td>
  </tr>
<%
for(int i=0;i<msgdata.length/4;i++){
  out.println("<tr><td width='4%' align='center'><img src='images/topic");
  if(workFC.cNULL(send)){
    out.println("3");
  }else out.println("1");
  out.println(".gif' width='17' height='12'></td>");
  out.println("<td width='18%' align='center'>"+msgdata[4*i+2]+"</td>");
  out.println("<td width='40%' align='left'>"+msgdata[4*i+1]+"</td>");
  out.println("<td width='18%' align='center'>"+msgdata[4*i+3]+"</td>");
  out.println("<td width='20%' align='center'>");
  if(!workFC.cNULL(send)){
    out.println("<a href='sendmsg.jsp?name="+msgdata[4*i+2]+"'><img src='images/replynow.gif'></a>");
  }else out.println("<a href='sendmsg.jsp?name="+msgdata[4*i+2]+"'>留言</a>");
  if(!workFC.cNULL(send))out.println("<a href='message.jsp?del="+msgdata[4*i]+"'><img src='images/del.gif'></a>");
  out.println("</td></tr>");
}
%>

  <tr>
    <td height="25" colspan="5">
      <table width="100%" border="0" cellpadding="2" cellspacing="0">
      <tr valign="middle" class="style3"><td width="50%">
      <%="&nbsp;页次:"+pageid+"/"+workDB.getPageCount()+"页&nbsp;本页:"+workDB.getPageNowCount()+"&nbsp;留言:"+workDB.getDataCount()%>  
      </td><td align="right">
      <%=workFC.ShowPage(workDB.getPageCount(),pageid,"message.jsp?"+urlpath+"pageid")%>
    &nbsp;
       </td></tr>
      </table>
   </td>
  </tr>
  <tr>
    <td height="25" colspan="5">
      <li>为了节省有限空间,请随时清理留言,您最多可以保留200条留言
   </td>
  </tr>
</table>
<%=tablebottom%>
<br>
<%@ include file="footer.jsp"%>
</body>
</html>