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\">發(fā)帖時間\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\">跟帖數(shù) \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\" >回復(fù)</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; //一頁顯示的記錄數(shù)
int intRowCount; //記錄總數(shù)
int intPageCount; //總頁數(shù)
int intPage; //待顯示頁碼
String strPage;
int i;

//設(shè)置一頁顯示的記錄數(shù)
intPageSize = 25;

//取得待顯示頁碼
strPage = request.getParameter("pages");
if(strPage==null){
//表明在QueryString中沒有page這一個參數(shù)，此時顯示第一頁數(shù)據(jù)
intPage = 1;
}
else
{
//將字符串轉(zhuǎn)換成整型
intPage = Integer.parseInt(strPage);
if(intPage<1){ intPage = 1;}
}
//獲取記錄總數(shù) 
rs.last(); 
intRowCount = rs.getRow(); 
//計算總頁數(shù)
intPageCount =(intRowCount+intPageSize-1) / intPageSize;

//調(diào)整待顯示的頁碼
if(intPage>intPageCount) intPage = intPageCount;
if(intPageCount>0){
//將記錄指針定位到待顯示頁的第一條記錄上 
rs.absolute((intPage-1) * intPageSize+1); 
//顯示數(shù)據(jù) 
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("                    當(dāng)前第<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> 歡迎到本論壇發(fā)表貼子！ </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商業(yè)版)</a> 版權(quán)歸飛天論壇所有. </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\">網(wǎng)管E-mail：<a class=map href=\"mailto:xmfangzi@126.com\">xmfangzi@126.com</a> \r\n");
      out.write("          投訴E-mail:<a class=map href=\"mailto:xmwuye@163.com\">xmwuye@163.com</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>業(yè)務(wù)聯(lián)系QQ:149501601,123291926 E-mail：cht21@163.com</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);
    }
  }
}