main.jsp

本论坛开发环境：jdk1.5+Tomcat5.5.17+sql server2000+Windows 2000 1、支持HTML内容编辑,支持网络贴图与附件上传等,支持多种版面风格. 2、论坛

    window.location.href='main.jsp';
    parent.left.document.location.reload();
}
</script>
<script>
var stylecook = getCookie("STYLESHOW");
var style;
var tmpstylecook;
function setcookies()
{
 tmpstylecook = stylecook;
}

function  reloadcook()
{
   var scooks = getCookie("STYLESHOW");
   if(scooks != tmpstylecook)
   {
 	window.location.reload();
   }
}
setcookies();
setInterval('reloadcook()',1000);
</script>
<script language="JavaScript" type="text/JavaScript">
function MM_jumpMenu(targ,selObj,restore){ 
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
</script>
<table width="99%" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td class="maintbtr3"> <table width="100%" border=0 cellpadding=2 cellspacing=1 class="maintbbg">
        <tbody>
          <tr> 
            <td height="25" class="f12bg">&nbsp;<%=userinfo%> - <a href="main.jsp?layer_1=<%=layer_1%>&layer_2=<%=layer_2%>&huati=1">本版精华</a> 
              - <a href="main.jsp?layer_1=<%=layer_1%>&layer_2=<%=layer_2%>&sign=1">本版推荐</a></td>
          </tr>
          <tr> 
            <td height="26" class="maintbtr3"><table width="100%" border=0 cellpadding=0 cellspacing=0>
                <tbody>
                  <tr> 
                    <td width="68%" class=f12><img src="../images/bbs_t1.gif" align="absmiddle"> 
                      <a href="../default.jsp">论坛首页</a><%=nar1%><a href="main.jsp<%=tlk1%>"><%=BBS_Cate_Name_1%></a><%=nar2%><a href="main.jsp<%=tlk1%><%=lk2%>"><%=BBS_Cate_Name_2%></a></td>
                    <td width="19%" class=f12><div align="right">版主:ftbbs </div></td>
                    <td width="13%" class=f12> <div align="right"> 
                        <table cellspacing=1 cellpadding=1 style="font-family: Tahoma, Verdana;BORDER: #8C8E7B 1px solid;background:#FFFFFF;">
                          <tr> 
                            <td style="background:#FF6500;font-size: 7pt;color:#ffffff;">&nbsp;XML&nbsp;</td>
                            <td style="background:#8C8E7B;font-size: 7pt;">&nbsp;<a href="rss.jsp?layer_1=<%=layer_1%>&layer_2=<%=layer_2%>" target="_blank" title="订阅本版面最新帖子"><font color='#ffffff'>RSS 
                              2.0</font></a>&nbsp;</td>
                          </tr>
                        </table>
                      </div></td>
                  </tr>
                </tbody>
              </table></td>
          </tr>
        </tbody>
      </table>
      <table cellspacing=0 cellpadding=0 width="100%" border=0>
        <tbody> 
        <tr> 
            <td width="12%" height="40"><a href="fbht.jsp<%=tlk1%><%=lk2%>"><img src="../images/bbs_add.gif" width="81" height="21" border="0"></a> 
              <!--&nbsp;<a href="bbspoll.jsp<%=tlk1%><%=lk2%>"><img src="../images/poll_add.gif" width="81" height="21" border="0"></a>-->
            </td>
          <FORM METHOD=POST ACTION="main.jsp" onsubmit="return check_search(this)">
            <td width="67%" align=right> 
              <div align="center"><img src="../images/bbs_find.gif" width="16" height="16"><%if(layer_1!=null||layer_1.equals("")){%><input type="hidden" name="layer_1" value="<%=layer_1%>"><%}%>
                  <input type=text name="searchcontent" size=24 class=p1 value="">
                <select name="searchkind" style="width:70">
                  <option value="title" selected>按主题</option>
                  <option value="user_id" >按用户名</option>
                </select>
                <input name="search" src="images/d_search.gif" type="image" value="Submit" width="37" height="21" border="0" align="absmiddle">
      <select name=select3  style="background-color:#ffffff;FONT-FAMILY: Arial; FONT-SIZE: 9pt; FONT-STYLE: normal; WIDTH: 85px" size=1 onChange="javascript:changeCssStyle();">
        <option  value="1" selected style="color:#799AE1">■标准风格</option>
        <option value="0" style="color:66ABD9">■浅蓝风格</option>
        <option value="2" style="color:#FA71C0">■女性风格</option>
        <option value="3" style="color:#D56BDE">■紫色风格</option>
        <option value="4" style="color:#EC8205">■黄色风格</option>
      </select>
           </div>
            </td>
          </form>
          <form name="form1" method="post" style="MARGIN-BOTTOM: 0px">     
            <td width="21%" valign="middle" class="f12"> 
              <div align="center">排序 
                <select name="menu1" style="width:75px" onChange="MM_jumpMenu('self',this,0)">
                  <option value="main.jsp?order_key=date">发帖时间
                  <option value="main.jsp?order_key=redate">跟帖时间 
                  <option value="main.jsp?order_key=hit">浏览量 
                  <option value="main.jsp?order_key=rep">跟帖数 
                </select>
                  <input name="layer_2" type="hidden" id="layer_2" value="<%=layer_2%>">
				  <input name="layer_1" type="hidden" id="layer_1" value="<%=layer_1%>">
                </div>
            </td>
          </form>
        </tr>
        </tbody> 
      </table>
      <table width="100%" border=0 cellpadding=2 cellspacing=1 align="center" class="maintbbg">
        <tbody>
          <tr align=middle class=f12> 
            <td width="6%" height="25" class="f12bg">点击</td>
            <td width="52%" class="f12bg" >论坛主题</td>
            <td width="5%" class="f12bg" >回复</td>
            <td width="11%" class="f12bg" >作者</td>
            <td width="25%" class="f12bg" >更新时间</td>
          </tr>
<%
if(layer_1==null||layer_1.equals(""))
{
sql="select * from bbstitle where deleted=0 "+signstr+" "+huatistr+" "+searchkindstr+" order by "+order_key;
}
else
{
  if (layer_2==null||layer_2.equals(""))
  {
  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+" and BoardID_1='" + layer_1 + "' and BoardID_2='" + layer_2 + "' order by "+order_key; //bbstop desc,redate desc";
  }
}
//out.print(sql);
//out.close();
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 (intRowCount>0){
while(i< intPageSize && !rs.isAfterLast()){ 
int id=rs.getInt("id");
String repTime=rs.getString("redate");
String bbs_img_display=rs.getString("bbs_img_display");
String dTime=repTime.substring(2,16);
String ReTime;

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);
if(rs3.next()){
ReTime=rs3.getString("user_id");
}
else{
ReTime="";
}
%>
          <tr align=middle> 
            <td width="6%" height="28" class="maintbtr1"><%=rs.getString("hit")%></td>
            <td width="52%" align=left valign="middle" class="maintbtr2">
              <%if(rs.getString("bbstop").equals("1")){%>
              <img src="images/ding.gif" width="15" height="13" align="absmiddle"> 
              <%}%>
              <%if(rs.getString("sign").equals("1")){%>
              <img src="images/jian.gif" width="15" height="13" align="absmiddle"> 
              <%}%>
              <%if(rs.getString("huati").equals("1")){%>
              <img src="images/jing.gif" width="15" height="13" align="absmiddle"> 
              <%}%>
              <%if(rs.getString("P_display").equals("0")){%>
              <img src="images/suo.gif" width="12" height="13" align="absmiddle"> 
              <%}%>
              <%if(rs.getInt("P_display")!=0 && rs.getInt("bbstop")!=1 && rs.getInt("sign")!=1 && rs.getInt("huati")!=1){%>
              <img src="../images/<%=rs.getString("picture")%>" width="19" height="19" align="absmiddle"> 
              <%}%>
			  <a class=f14 href="ftbbs.jsp?id=<%=id%>" target="_blank"><%=rs.getString("title")%></a>
			  <%if(rs.getString("bbs_img")!=null){%>
              <font color=red> [图]</font> 
              <%}%>
			</td>
            <td class="maintbtr1" width="7%" ><%=rs.getString("rep")%></td>
            <td class="maintbtr3" width="9%" ><a href="main.jsp?searchkind=user_id&searchcontent=<%=rs.getString("user_id")%>&layer_1=<%=rs.getString("boardid_1")%>"><%=rs.getString("user_id")%></a></td>
            <td class="maintbtr3" width="16%" align=left><%=dTime%><font color=red>|</font><%=ReTime%>
			</td>
          </tr>
<%
rs.next(); 
i++; 
  }  
rs.close();
stmt.close(); 
conn.close();
//}
%>
          <tr valign="top"> 
            <td colspan="6" class="f12bg"><table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
                <tr> 
                  <td align="left" width="322" class="f12bg">&nbsp; 
                    <%out.print("共<font color=red>"+intRowCount+"</font>个主题 <font color=red>"+intPageSize+"</font>/页 共<font color=red>"+intPageCount+"</font>页");%>
                    当前第<font color=red><%=intPage%></font>页 </td>
                  <td height="23" align="right" class="f12bg">&nbsp;
				    <%if(intPage<=1){%>
				    首页
				    <%}else{%>
                    <a href="main.jsp?pages=1<%=lk1%><%=lk2%>">首页</a>
					<%}%>
                    <%if(intPage>1){%>
                    <a href="main.jsp?pages=<%=intPage-1%><%=lk1%><%=lk2%>">上一页</a> 
                    <%}else{%>
                    上一页 
                    <%
	                }%>
                    <%if(intPage<intPageCount){%>
                    <a href="main.jsp?pages=<%=intPage+1%><%=lk1%><%=lk2%>">下一页</a> 
                    <%}else{%>
                    下一页 
                    <%
	                }%>
				    <%if(intPageCount<=1||intPage==intPageCount){%>
				    尾页
				    <%}else{%>
                    &nbsp;<a href="main.jsp?pages=<%=intPageCount%><%=lk1%><%=lk2%>">尾页</a>&nbsp;
					<%}%>					
                    </td>
                </tr>
              </table></td>
          </tr>
<%}else{%>
          <tr class="maintbtr3"> 
            <td colspan=6 align=center height=25> 欢迎到本论坛发表贴子！ </td>
          </tr>
<%}%>
        </tbody>
      </table>
    </td>
  </tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="1" class="maintbbg">
  <tr> 
    <td height=25 class="maintbtr1">&nbsp;在线用户:
      <script language="JavaScript" src="online.jsp?dis=yes&stats=<%=stats%>"></script>
	</td>
  </tr>
</table>
<script>
if(stylecook=='' || stylecook == '0' )
{
stylecook=0;
}
document.all.select3.value=stylecook;
</script>
<%@ include file="../inc/bbstail.jsp"%>
</BODY>
</HTML>