bbslist_jsp.java

论坛源码

      out.print(iPageLast);
      out.write("&method=");
      out.print(method);
      out.write("&par=");
      out.print(par);
      out.write("\"><font color=\"#FFFFFF\">上页</font></a>\r\n");
      out.write("      ");
}
      out.write("\r\n");
      out.write("      ");
if (iPageNext!=0) {
      out.write("\r\n");
      out.write("      <a href=\"bbslist.jsp?boardid=");
      out.print(boardid);
      out.write("&pages=");
      out.print(iPageNext);
      out.write("&method=");
      out.print(method);
      out.write("&par=");
      out.print(par);
      out.write("\"><font color=\"#FFFFFF\">下页</font></a>\r\n");
      out.write("      ");
}
      out.write("\r\n");
      out.write("      ");
if (iPageCount>1) {
      out.write("\r\n");
      out.write("      <a href=\"bbslist.jsp?boardid=");
      out.print(boardid);
      out.write("&pages=");
      out.print(iPageCount);
      out.write("&method=");
      out.print(method);
      out.write("&par=");
      out.print(par);
      out.write("\"><font color=\"#FFFFFF\">尾页</font></a>\r\n");
      out.write("      ");
}
      out.write("\r\n");
      out.write("      <font color=\"#FFFFFF\">");
      out.print(iPageCurrent);
      out.write('/');
      out.print(iPageCount);
      out.write("</font></p></td>\r\n");
      out.write("    <td width=\"110\" valign=\"middle\" bgcolor=\"#99CC66\"><form method=\"GET\" action=\"bbslist.jsp\" style=\"margin-top: 0; margin-bottom: 0\">\r\n");
      out.write("      <p align=\"center\" style=\"margin-top: 0; margin-bottom: 0\"><font color=\"#FFFFFF\">转到:\r\n");
      out.write("              <input type=\"text\" name=\"pages\" size=\"3\" value=\"1\">\r\n");
      out.write("        页\r\n");
      out.write("        <input type=\"submit\" value=\"GO\" name=\"GO\">\r\n");
      out.write("      </font></p>\r\n");
      out.write("      <input type=\"hidden\" name=\"boardid\" value=\"");
      out.print(boardid);
      out.write("\">\r\n");
      out.write("      <input type=\"hidden\" name=\"method\" value=\"");
      out.print(method);
      out.write("\">\r\n");
      out.write("      <input type=\"hidden\" name=\"par\" value=\"");
      out.print(par);
      out.write("\">\r\n");
      out.write("    </form></td>\r\n");
      out.write("  </tr>\r\n");
      out.write("</table>\r\n");
      out.write("</div> \r\n");
if (iPageCurrent>0){
      out.write("\r\n");
      out.write("<div align=\"center\">\r\n");
      out.write("          \r\n");
      out.write("  <table   bgcolor=\"#EFFFCE\" border=\"2\" cellSpacing=1 cellPadding=4 width=\"761\"> \r\n");
      out.write("    <TR class=category>\r\n");
      out.write("\t<td>&nbsp;</td>\r\n");
      out.write("\t<td align=middle width=\"14%\">标题 </td>\r\n");
      out.write("\t<TD noWrap align=middle width=\"8%\">大小</TD>\r\n");
      out.write("    <TD align=middle width=\"12%\">作者</TD>\r\n");
      out.write("    <TD noWrap align=middle width=\"14%\">发表日期</TD>\r\n");
      out.write("    <TD noWrap align=middle width=\"13%\">作者ID</TD>\r\n");
      out.write("    <TD noWrap align=middle width=\"11%\">点击率</TD>\r\n");
      out.write("    <TD align=middle width=\"11%\">回复次数</TD>\r\n");
      out.write("    </TR>         \r\n");
      out.write("    <tr>          \r\n");
      out.write("      <td width=\"17%\">\r\n");
      out.write("\t          \r\n");

sqlRst=bbs.listBbs(method,iPageSize,iPageCurrent,boardid,par);
while(sqlRst.next()){
bbsid=sqlRst.getInt("bbsid");
parentid=sqlRst.getInt("parentid");
child=sqlRst.getInt("child");

username=sqlRst.getString("username");
useremail=sqlRst.getString("useremail");
userip=sqlRst.getString("userip");
expression=sqlRst.getString("expression");
usersign=sqlRst.getString("usersign");
bbstopic=sqlRst.getString("bbstopic");
bbscontent=sqlRst.getString("bbscontent");
//dateandtime=sqlRst.getString("dateandtime");
dateandtime=sqlRst.getDate("dateandtime");

bbshits=sqlRst.getInt("bbshits");
length=sqlRst.getInt("length");

bbshot=sqlRst.getString("bbshot");

      out.write("                                                             \r\n");
      out.write("<tr>                                                                               \r\n");
      out.write("<td align=middle > <p align=\"left\"><img src=\"images/06.gif\" width=\"45\" height=\"45\" border=\"0\"></td>\r\n");
      out.write("<td align=middle ><a href=\"bbsaddre.jsp?boardid=");
      out.print(boardid);
      out.write("&bbsid=");
      out.print(bbsid);
      out.write('"');
      out.write(' ');
      out.write('>');
      out.print(bbstopic);
      out.write("</a><img src=\"images/agree.gif\"></td>           \r\n");
      out.write("<td align=middle > <font color=\"#FF0000\">");
if (length==0){
      out.write('无');
      out.write('内');
      out.write('容');
}else{
      out.print(length);
      out.write("Bytes");
}
      out.write("</font></td>\r\n");
      out.write("<td align=middle >【<a href=\"mailto:");
      out.print(useremail);
      out.write("\"><b>");
      out.print(username);
      out.write("</b></a>】</td>\r\n");
      out.write("<td align=middle ><i>");
      out.print(dateandtime);
      out.write("</i></td>\r\n");
      out.write("<td align=middle >ID:");
      out.print(bbsid);
      out.write("</td>\r\n");
      out.write("<td align=middle >点击:");
      out.print(bbshits);
      out.write("</td>\r\n");
      out.write("<td align=middle >回复:");
      out.print(child);
      out.write("</td>\r\n");
      out.write("</tr>\r\n");
      out.write("           ");
if (bbshot.compareTo("ok")==0){
      out.write("<font color=\"#FF0000\">★</font>");
}
      out.write("          \r\n");
      out.write("           ");
if (delon=="true"){
      out.write("<a href=\"delete.jsp?bbsid=");
      out.print(bbsid);
      out.write("\">删除</a>            \r\n");
      out.write("           ###");
if (bbshot.compareTo("ok")!=0) {
      out.write("<a href=\"addfav.jsp?bbsid=");
      out.print(bbsid);
      out.write("\">加入精华区</a>                 \r\n");
      out.write("           ");
}else{
      out.write("<a href=\"subfav.jsp?bbsid=");
      out.print(bbsid);
      out.write("\">从精华区删除</a>");
}}
      out.write("\r\n");
      out.write("\t\t   \r\n");
      out.write("<!--跟贴开始----------------------->                                                                                                    \r\n");

if ((method==0)||(method==8)||(method==4)||(method==1)) {
//if (false){
//'0正常显示             //'4 精华区显示             //'8 管理员显示          //'1搜索主题    

rs=bbs.listBbsRe(bbsid);              //：列出某贴的所有跟贴

while(rs.next()){

bbsid=rs.getInt("bbsid");
parentid=rs.getInt("parentid");

username=rs.getString("username");
useremail=rs.getString("useremail");
userip=rs.getString("userip");
expression=rs.getString("expression");
usersign=rs.getString("usersign");
bbstopic=rs.getString("bbstopic");
bbscontent=rs.getString("bbscontent");
//dateandtime=rs.getString("dateandtime");
dateandtime=rs.getDate("dateandtime");
bbshits=rs.getInt("bbshits");
length=rs.getInt("length");

      out.write("\r\n");
      out.write("<ul>                                                                                                    \r\n");
      out.write("<li type=\"circle\">\r\n");
      out.write("           <p align=\"left\"><img src=\"images/06.gif\" width=\"45\" height=\"45\" border=\"0\"><a href=\"bbsaddre.jsp?boardid=");
      out.print(boardid);
      out.write("&bbsid=");
      out.print(parentid);
      out.write('"');
      out.write(' ');
      out.write('>');
      out.print(bbstopic);
      out.write("</a>\r\n");
      out.write("           &lt;<font color=\"#FF0000\">");
if (length==0){
      out.write('无');
      out.write('内');
      out.write('容');
}else{
      out.print(length);
      out.write("Bytes");
}
      out.write("</font>&gt;-【<a href=\"mailto:");
      out.print(useremail);
      out.write("\"><b>");
      out.print(username);
      out.write("</b></a>】=<i>");
      out.print(dateandtime);
      out.write("</i>=</li>[ID:");
      out.print(bbsid);
      out.write('点');
      out.write('击');
      out.write(':');
      out.print(bbshits);
      out.write("]\r\n");
      out.write("\t\t   ");
if (delon=="true") {
      out.write(" <a href=\"delete.jsp?bbsid=");
      out.print(bbsid);
      out.write("\">删除</a>");
}
      out.write("                                                                                                        \r\n");
      out.write("</ul>                                                                                                    \r\n");
      out.write("\r\n");

}  //end while
rs.close();
}	 //end if


      out.write(" \r\n");
      out.write("<!--跟贴结束-------------------------> \r\n");
      out.write("<hr size=\"0\" color=\"#808080\">                                           \r\n");

}  //全部记录结束
sqlRst.close();

      out.write("\r\n");
      out.write("\r\n");
      out.write("        </ul>              \r\n");
      out.write("                 \r\n");
      out.write("  </table>                \r\n");
      out.write("</div>               \r\n");
      out.write("<!--表头部分 -->\r\n");
      out.write("                                                                                 \r\n");
      out.write("<!--表头部分结束 -->\r\n");
}else{   //'屏蔽错误，如果页面数为0，显示如下信息

      out.write("\r\n");
      out.write("<table   bgcolor=\"#EFFFCE\" cellspacing=\"1\" cellpadding=\"4\" width=\"761\" align=\"center\" class=\"tableborder\">\r\n");
      out.write("<tr><td  align=middle height=\"32\" colspan=\"7\" class=\"header\">\r\n");
      out.write(" 很抱歉，没有找到您所需要的记录！请重新查询！\r\n");

}
      out.write("\r\n");
      out.write("</td>\r\n");
      out.write("</tr></table>\r\n");
      out.write("\r\n");
      out.write("</body>              \r\n");
      out.write("</html>        ");
    } catch (Throwable t) {
      if (!(t instanceof SkipPageException)){
        out = _jspx_out;
        if (out != null && out.getBufferSize() != 0)
          out.clearBuffer();
        if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
      }
    } finally {
      if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
    }
  }
}