main_jsp.java

做的非常好的论坛

      out.write("            <td width=\"20%\" valign=\"middle\"> \r\n");
      out.write("              <div align=\"center\">排序 \r\n");
      out.write("                <select name=\"menu1\" style=\"width:75px\" onChange=\"MM_jumpMenu('self',this,0)\">\r\n");
      out.write("                  <option value=\"main.jsp?order_key=date\">发帖时间\r\n");
      out.write("                  <option value=\"main.jsp?order_key=redate\">跟帖时间 \r\n");
      out.write("                  <option value=\"main.jsp?order_key=hit\">浏览量 \r\n");
      out.write("                  <option value=\"main.jsp?order_key=rep\">跟帖数 \r\n");
      out.write("                </select>\r\n");
      out.write("                  <input name=\"layer_2\" type=\"hidden\" id=\"layer_2\" value=\"");
      out.print(layer_2);
      out.write("\">\r\n");
      out.write("\t\t\t\t  <input name=\"layer_1\" type=\"hidden\" id=\"layer_1\" value=\"");
      out.print(layer_1);
      out.write("\">\r\n");
      out.write("                </div>\r\n");
      out.write("            </td>\r\n");
      out.write("          </form>\r\n");
      out.write("        </tr>\r\n");
      out.write("        </tbody> \r\n");
      out.write("      </table>\r\n");
      out.write("      <table width=\"100%\" border=0 cellpadding=2 cellspacing=1 bgcolor=\"#A4B6D7\" align=\"center\">\r\n");
      out.write("        <tbody>\r\n");
      out.write("          <tr align=middle> \r\n");
      out.write("            <td width=\"6%\" background=\"../images/bbs_bg1.gif\">点击</td>\r\n");
      out.write("            <td width=\"52%\" background=\"../images/bbs_bg1.gif\" >论坛主题</td>\r\n");
      out.write("            <td width=\"5%\" background=\"../images/bbs_bg1.gif\" >回复</td>\r\n");
      out.write("            <td width=\"11%\" background=\"../images/bbs_bg1.gif\" >作者</td>\r\n");
      out.write("            <td width=\"25%\" background=\"../images/bbs_bg1.gif\" >更新时间</td>\r\n");
      out.write("          </tr>\r\n");

if(layer_1!=null)
{
  if (layer_2!=null)
  {
  sql="select * from bbstitle where deleted=0 "+signstr+" "+huatistr+" "+searchkindstr+" and BoardID_1='" + layer_1 + "' and BoardID_2='" + layer_2 + "' order by "+order_key; //bbstop desc,redate desc";
  }
  else
  {
  sql="select * from bbstitle where deleted=0 "+signstr+" "+huatistr+" "+searchkindstr+" and BoardID_1='" + layer_1 + "' order by "+order_key;
  }
}
else
{
sql="select * from bbstitle where deleted=0 "+signstr+" "+huatistr+" "+searchkindstr+" order by "+order_key;
}
//out.print(sql);
ResultSet rs=stmt.executeQuery(sql);

int intPageSize; //一页显示的记录数
int intRowCount; //记录总数
int intPageCount; //总页数
int intPage; //待显示页码
String strPage;
int i;

//设置一页显示的记录数
intPageSize = 25;

//取得待显示页码
strPage = request.getParameter("pages");
if(strPage==null){
//表明在QueryString中没有page这一个参数，此时显示第一页数据
intPage = 1;
}
else
{
//将字符串转换成整型
intPage = Integer.parseInt(strPage);
if(intPage<1){ intPage = 1;}
}
//获取记录总数 
rs.last(); 
intRowCount = rs.getRow(); 
//计算总页数
intPageCount =(intRowCount+intPageSize-1) / intPageSize;

//调整待显示的页码
if(intPage>intPageCount) intPage = intPageCount;
if(intPageCount>0){
//将记录指针定位到待显示页的第一条记录上 
rs.absolute((intPage-1) * intPageSize+1); 
//显示数据 
i = 0; 

//if (rs.next()){
while(i< intPageSize && !rs.isAfterLast()){ 
int id=Integer.parseInt(rs.getObject("id").toString());
String repTime=rs.getObject("redate").toString();
String bbs_img_display=rs.getObject("bbs_img_display").toString();
String dTime=repTime.substring(2,16);

String stsql="select top 1 user_id,rename from bbsmenu where pid="+id+" order by id desc";
Statement stmt3=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs3=stmt3.executeQuery(stsql);

      out.write("\r\n");
      out.write("          <tr align=middle> \r\n");
      out.write("            <td bgcolor=\"#ECF5FF\" width=\"6%\" height=\"28\">");
      out.print(rs.getObject("hit"));
      out.write("</td>\r\n");
      out.write("            <td width=\"52%\" align=left valign=\"middle\" bgcolor=\"#F2F8FF\">\r\n");
      out.write("              ");
if(rs.getObject("bbstop").toString().equals("1")){
      out.write("\r\n");
      out.write("              <img src=\"images/ding.gif\" width=\"15\" height=\"13\" align=\"absmiddle\"> \r\n");
      out.write("              ");
}
      out.write("\r\n");
      out.write("              ");
if(rs.getObject("sign").toString().equals("1")){
      out.write("\r\n");
      out.write("              <img src=\"images/jian.gif\" width=\"15\" height=\"13\" align=\"absmiddle\">\r\n");
      out.write("              ");
}
      out.write("\r\n");
      out.write("              ");
if(rs.getObject("huati").toString().equals("1")){
      out.write("\r\n");
      out.write("              <img src=\"images/jing.gif\" width=\"15\" height=\"13\" align=\"absmiddle\"> \r\n");
      out.write("              ");
}
      out.write("\r\n");
      out.write("              ");
if(rs.getObject("P_display").toString().equals("0")){
      out.write("\r\n");
      out.write("              <img src=\"images/suo.gif\" width=\"12\" height=\"13\" align=\"absmiddle\"> \r\n");
      out.write("              ");
}
      out.write("\r\n");
      out.write("              ");
 
			  int p=Integer.parseInt(rs.getObject("P_display").toString());
			  int s=Integer.parseInt(rs.getObject("sign").toString());
			  int b=Integer.parseInt(rs.getObject("bbstop").toString());
			  int h=Integer.parseInt(rs.getObject("huati").toString());                     
		      if(/*rs.getInt("P_display")*/ p!=0 && /*rs.getInt("bbstop")*/ b!=1 && /*rs.getInt("sign")*/ s!=1 &&/* rs.getInt("huati")*/h!=1){
      out.write("                         \r\n");
      out.write("              <img src=\"../images/");
      out.print(rs.getObject("picture"));
      out.write("\" width=\"19\" height=\"19\" align=\"absmiddle\"> \r\n");
      out.write("              ");
}
      out.write("\r\n");
      out.write("\t\t\t  <a class=f14 href=\"checkasp.jsp?id=");
      out.print(id);
      out.write('"');
      out.write('>');
      out.print(rs.getObject("title"));
      out.write("</a>\r\n");
      out.write("\t\t\t  ");
if(rs.getObject("bbs_img").toString()!=null){
      out.write("\r\n");
      out.write("\t\t\t  <font color=red> [图]</font> \r\n");
      out.write("              ");
}
      out.write("\t\r\n");
      out.write("\t\t    </td>\r\n");
      out.write("            <td bgcolor=\"#ECF5FF\" width=\"7%\" >");
      out.print(rs.getObject("rep"));
      out.write("</td>\r\n");
      out.write("            <td bgcolor=\"#F2F8FF\" width=\"9%\" ><a href=\"main.jsp?searchkind=user_id&searchcontent=");
      out.print(rs.getObject("user_id"));
      out.write("&layer_1=");
      out.print(rs.getObject("boardid_1"));
      out.write('"');
      out.write('>');
      out.print(rs.getObject("user_id"));
      out.write("</a></td>\r\n");
      out.write("            <td bgcolor=\"#F2F8FF\" width=\"16%\" align=left>");
      out.print(dTime);
if(rs3.next()){
      out.write("<font color=red>|</font>");
      out.print(rs3.getObject("user_id"));
}
      out.write("\r\n");
      out.write("\t\t\t</td>\r\n");
      out.write("          </tr>\r\n");

rs.next(); 
i++; 
  } 
  }
rs.close();
stmt.close(); 
conn.close();

      out.write("\r\n");
      out.write("          <tr valign=\"top\"> \r\n");
      out.write("            <td colspan=\"6\"  background=\"../images/bbs_bg1.gif\"><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">\r\n");
      out.write("                <tr> \r\n");
      out.write("                  <td align=\"left\" width=\"322\">&nbsp; \r\n");
      out.write("                    ");
out.print("共<font color=red>"+intRowCount+"</font>个主题 <font color=red>"+intPageSize+"</font>/页 共<font color=red>"+intPageCount+"</font>页");
      out.write("\r\n");
      out.write("                    当前第<font color=red>");
      out.print(intPage);
      out.write("</font>页 \r\n");
      out.write("\t\t\t\t  </td>\r\n");
      out.write("                  <td width=\"439\" height=\"23\" align=\"right\">");
if(intPage<=1){
      out.write("\r\n");
      out.write("\t\t\t\t    首页\r\n");
      out.write("\t\t\t\t    ");
}else{
      out.write("\r\n");
      out.write("                    <a href=\"main.jsp?pages=1");
      out.print(lk1);
      out.print(lk2);
      out.write("\">首页</a>\r\n");
      out.write("\t\t\t\t\t");
}
      out.write("\r\n");
      out.write("                    ");
if(intPage>1){
      out.write("\r\n");
      out.write("                    <a href=\"main.jsp?pages=");
      out.print(intPage-1);
      out.print(lk1);
      out.print(lk2);
      out.write("\">上一页</a> \r\n");
      out.write("                    ");
}else{
      out.write("\r\n");
      out.write("                    上一页 \r\n");
      out.write("                    ");

	                }
      out.write("\r\n");
      out.write("                    ");
if(intPage<intPageCount){
      out.write("\r\n");
      out.write("                    <a href=\"main.jsp?pages=");
      out.print(intPage+1);
      out.print(lk1);
      out.print(lk2);
      out.write("\">下一页</a> \r\n");
      out.write("                    ");
}else{
      out.write("\r\n");
      out.write("                    下一页 \r\n");
      out.write("                    ");

	                }
      out.write("\r\n");
      out.write("\t\t\t\t    ");
if(intPageCount<=1||intPage==intPageCount){
      out.write("\r\n");
      out.write("\t\t\t\t    尾页\r\n");
      out.write("\t\t\t\t    ");
}else{
      out.write("\r\n");
      out.write("                    &nbsp;<a href=\"main.jsp?pages=");
      out.print(intPageCount);
      out.print(lk1);
      out.print(lk2);
      out.write("\">尾页</a>&nbsp;\r\n");
      out.write("\t\t\t\t\t");
}
      out.write("\r\n");
      out.write("\t\t\t\t  </td>\r\n");
      out.write("                </tr>\r\n");
      out.write("              </table></td>\r\n");
      out.write("          </tr>\r\n");
//}
//else{
/*

      out.write("\r\n");
      out.write("          <tr bgcolor=\"#EFF7FA\"> \r\n");
      out.write("            <td colspan=6 align=center height=20> 欢迎到本论坛发表贴子！ </td>\r\n");
      out.write("          </tr>\r\n");
//}
*/

      out.write("\r\n");
      out.write("       </tbody>\r\n");
      out.write("      </table>\r\n");
      out.write("    </td>\r\n");
      out.write("  </tr>\r\n");
      out.write("</table>\r\n");
      out.write("\r\n");
      out.write("\r\n");
      out.write("\r\n");
      out.write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n");
      out.write("<div align=\"center\">\r\n");
      out.write("  <hr width=99% size=1>\r\n");
      out.write("  <table width=99% align=center cellpadding=2 cellspacing=0>\r\n");
      out.write("    <tr> \r\n");
      out.write("      <td height=22 bgcolor=\"#F2F8FF\"> \r\n");
      out.write("        <div align=center><a class=map href=\"http://www.xmfangzi.com/bbs/\">飞天论坛（ftbbs \r\n");
      out.write("          SQL 2.0 JSP商业版)</a> 版权归飞天论坛所有. </div>\r\n");
      out.write("      </td>\r\n");
      out.write("    </tr>    \r\n");
      out.write("\t<tr> \r\n");
      out.write("      <td height=22 bgcolor=\"#F2F8FF\"> \r\n");
      out.write("        <div align=center> Copyright (C) 2004-2006 XMFANGZI.com,All Rights Reserved.</div>\r\n");
      out.write("      </td>\r\n");
      out.write("    </tr>\r\n");
      out.write("    <tr> \r\n");
      out.write("      <td height=22 bgcolor=\"#F2F8FF\"> \r\n");
      out.write("        <div align=\"center\">网管E-mail：<a class=map href=\"mailto:[e-mail]\">[e-mail]</a> \r\n");
      out.write("          投诉E-mail:<a class=map href=\"mailto:[e-mail]\">[e-mail]</a></div>\r\n");
      out.write("      </td>\r\n");
      out.write("    </tr>\r\n");
      out.write("    <tr> \r\n");
      out.write("      <td height=28 bgcolor=\"#F2F8FF\" valign=\"middle\"> \r\n");
      out.write("        <div align=center>业务联系QQ:149501601,123291926 E-mail：[e-mail]</div>\r\n");
      out.write("      </td>\r\n");
      out.write("    </tr>\r\n");
      out.write("  </table>\r\n");
      out.write("  \r\n");
      out.write("</div>\r\n");
    } 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);
    }
  }
}