index.jsp

基于B/S的商贸管理系统

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


<TABLE cellSpacing=0 cellPadding=0 width="750" align=center border=0>
<TBODY>
<TR>
<TD><A onfocus=this.blur() href="../let" target=_blank>
<IMG src="../images/banner2.gif" width=750 border=0></A></TD></TR>
</TBODY></TABLE>


<TABLE cellSpacing=0 cellPadding=0 width=750 align=center border=0>
<TBODY>
<TR>
<TD style="PADDING-LEFT: 20px" bgColor=#ff8000 colSpan=2 height=28>
<IMG height=8 src="../images/ico_oval.gif" width=5 align=absMiddle>
<FONT color=#ffffff size=4><b>商人话题</b></FONT></TD></TR>
<TR>
<TD bgColor=#b25900 colSpan=2 height=2></TD>
</TR>
</TBODY>
</TABLE>





<TABLE cellPadding=0 cellSpacing=0 align=center width=750>
<tr>
<td align=left valign=middle width="7%" height=25  class="norightbuttonborder">
<a href="addbook.jsp"><img src="images/postnew.gif" border="0" alt="发表一个新话题"></a>
</td>
<td width=50% class="norightbuttonborder">&nbsp;</td>
<th width=15% align=right class="norightbuttonborder">
<img src="images/team2.gif" align="absmiddle"> 本版版主：<a href=../info/sendmsg.jsp?recemem=<%=banzuid%>&memname=<%=banzu%>><%=banzu%></a>&nbsp;&nbsp;
</th>
</tr>
</table>





<TABLE  cellSpacing=0 align=center width=750>
<TBODY>
<TR>
<TD class=outtd>


      <TABLE cellSpacing=1 cellPadding=4  width=750>
        <TBODY>
        <TR align=center>
          <TD  class="buttoncolor" align=middle width=5%>状态</TD>
          <TD class="buttoncolor" align=middle width=40% >主题</TD>
          <TD class="buttoncolor" align=middle width=5%>查看</TD>
          <TD class="buttoncolor"  align=middle width=5%>回复</TD>
          <TD class="buttoncolor"  align=middle width=13%>发表人</TD>
          <TD class="buttoncolor"  align=middle width=13%>最后回复</TD>
          <TD class="buttoncolor"  align=middle width=13%>最后发表时间</TD>
	</TR>





<%
stmt = con.createStatement() ;
rs=stmt.executeQuery("SELECT * from book 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>
          <TD  class="norightbuttonborder">

<%if(Integer.parseInt((String)rs.getString("status"))==0){%><IMG src="images/folderstate2.gif"><%}%>
<%if(Integer.parseInt((String)rs.getString("status"))==1){%><IMG src="images/folderstate1.gif"><%}%>
<%if(Integer.parseInt((String)rs.getString("status"))==2){%><IMG src="images/folderstate3.gif"><%}%>


</TD>
          <TD  class="norightbuttonborder" align=left><A  href="read.jsp?id=<%=rs.getString("id")%>" class=nav ><font color=000000><%=rs.getString("topic")%></font></A></TD>
          <TD  class="norightbuttonborder"><%=rs.getString("readnum")%></TD>
          <TD class="norightbuttonborder"><%=rs.getString("replynum")%></TD>
          <TD  class="norightbuttonborder"><A href="../info/sendmsg.jsp?recemem=<%=rs.getString("fbmemid")%>&memname=<%=rs.getString("fbmem")%>" title="点击给<%=rs.getString("fbmem")%>留言"><%=rs.getString("fbmem")%></A></TD>
          <TD  class="norightbuttonborder"><%=rs.getString("replymem")%></TD>
          <TD  class="norightbuttonborder"><%=rs.getString("fbtime")%></TD>
	</TR>

<%
}
%>
              
        </TBODY>
        </TABLE>
        </TD>


  

<%
rs=stmt.executeQuery("SELECT count(*) from book where ForR=0");
while(rs.next()) i = rs.getInt(1) ;
%>

					         
	              <tr>
                        <td><div align="center">
                            <table width="750" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td><img src="../images/product_15.gif" width="750" height="1"></td>
                              </tr>
                              <tr>
                                <td height="25"><table width="100%" height="25" border="0" cellpadding="0" cellspacing="0">
                                    <tr>
                                      <td width="350" class="zl">共有话题<font color="#FF0000"><%=i%></font>个 
                                        分<%=(i+20)/20%>页 当前为第<%=pageInt%>页</td>
                                      <td valign="middle">
<div align="right"> 
                                          <p class="zl">
										  
									转到第&nbsp;<%for(int j=1;j<(i+40)/20;j++){%><a href="index.jsp?page=<%=j%>"><font color=red><%=j%></font></a>&nbsp;<%}%>页
																	  
																	                                    </p>
                                        </div></td>
                                    </tr>
                                  </table></td>
                              </tr>
                            </table>
                          </div></td>
                       </tr>




        


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


<table ><tr><td height=5></td></tr></table>
<%@ include file="../end.jsp"%>