<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="top.jsp"%>

<TABLE id=Table1 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR id=main_section vAlign=top>
<TD>

      <TABLE height="100%" cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR >
          <TD   class=welcomeleft id=left_pane vAlign=top width=155 >
            <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0  background=../images/back.gif height=586>
              <TBODY>
               <TR>
                <TD   valign=top>



<%@ include file="bbs_mainmenu.jsp"%>



             </TD></TR>
             </TBODY></TABLE>




</TD><TD id=right_pane  valign=top background=../images/adminbodybg6.gif>

<br><br>
<!----------------------------------------->
<TABLE class="titletable" cellSpacing="0" cellPadding="0" width="99%" border="0">
<TR>
<TD><IMG height="32" src="../images/bbs.jpg" width="31" align="absMiddle">論壇交流</TD>
</TR>
</TABLE>

<TABLE class="ToolbarTable" width="100%" cellSpacing="0" cellPadding="0" border="0" align=center>
<tr>
<td colspan="6" class="toolbarsplitline"></td>
</tr>
<tr>
<td colspan="6" class="toolbarsplittr"></td>
</tr>
</TABLE>

<table class="datatable" cellSpacing="0" cellPadding="0" width="99%" border="0"  align=center>
<tr>
<td vAlign="top" align="center">

<table class="dgborder" cellspacing="0" align="Center" rules="rows" border="1" id="dgVehicleInfo" style="width:100%;border-collapse:collapse;">

<tr class="DgHeaderStyle">
<td align="Center" width=30>狀態(tài)</td><td align="Center"width=450>主題</td><td align="Center" width=40>查看</td><td align="Center" width=40>回復</td><td align="Center" width=50>發(fā)表人</td><td align="Center" width=80>最后回復</td><td align="Center" width=80>發(fā)表時間</td>
</tr>

<%int vm=0;
stmt = con.createStatement() ;
rs=stmt.executeQuery("SELECT * from bbs where ForR=0 order by status desc,pxtime desc");
String pages = request.getParameter("page") ;
int pageInt =  1 ,i=0 ,k=1;
if(pages==null){}else{pageInt = Integer.parseInt(pages);}
while(i<20*(pageInt-1)&&rs.next()){i++ ;}
i=0;
while(rs.next()&i<20){
i++ ;
%>


<tr  <%if(vm==0){%> class="DgAlterStyle"<%vm++;}else{vm--;}%> class="dgitemstyle">
<td align="Center">
<%if(Integer.parseInt((String)rs.getString("status"))==0){%><IMG src="../images/folderstate2.gif" title="普通帖子"><%}%>
<%if(Integer.parseInt((String)rs.getString("status"))==1){%><IMG src="../images/folderstate1.gif" title="置頂帖子"><%}%>
</td><td align="left"> <img src=../images/rd_4.gif> <a href="readbbs.jsp?id=<%=rs.getString("id")%>&space=<%=request.getParameter("space")%>"><%=rs.getString("title")%></a></td><td align="Center"><%=rs.getString("readnum")%></td><td align="Center"><%=rs.getString("replynum")%></td><td align="Center"><a href=user.jsp?username=<%=rs.getString("fbren")%>><%=rs.getString("fbren")%></a></td><td align=center><a href=user.jsp?username=<%=rs.getString("replymem")%>><%=rs.getString("replymem")%></a></td><td align="Center"><%=rs.getString("fbtime")%></td></tr>

<%
}
%>
<%
rs=stmt.executeQuery("SELECT count(*) from bbs where ForR=0 ");
%>
<tr class="dgpagestyle">
<td colspan="9"><span><%@ include file="page.jsp"%></span></td>
</tr>
</table>

</td>
</tr>
</table>
<!----------------------------------------->



</TD></TR></TBODY></TABLE></TD></TR>
</TBODY>
</table>






<%@ include file="end.jsp"%>
</BODY>
</HTML>