⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 index.jsp

📁 基于B/S的商贸管理系统
💻 JSP
字号:
<%@ 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 width="750"  border="0" cellpadding="0" cellspacing="0" align=center>
      <tr>
        <td height="80" background="../images/search_bg.gif"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="87"><img src="../images/search_01.gif" width="87" height="80"></td>
            <td><table width="98%"  border="0" align="center" cellpadding="2" cellspacing="1">
              <form name="searchInfo" method="post" action="showsearch.jsp" ><tr>
                <td align="right"><input name="gjz" type="text" id="keyword" onfocus="this.value=''" value="在此输入搜索关键字" size="25">


<select name="hy" class="zh" id="hy">
<option value="">所有行业列表</option>

<option value="工业用品">工业用品</option>

<option value="建材">建材</option>

<option value="化工">化工</option>

<option value="冶金矿产">冶金矿产</option>

<option value="纺织皮革">纺织皮革</option>

<option value="服饰">服饰</option>

<option value="安全、防护">安全、防护</option>

<option value="能源">能源</option>

<option value="环保">环保</option>

<option value="电子电工">电子电工</option>

<option value="电脑、软件">电脑、软件</option>

<option value="通讯">通讯</option>

<option value="交通运输 ">交通运输 </option>

<option value="汽摩及配件">汽摩及配件</option>

<option value="农业">农业</option>

<option value="包装、纸 ">包装、纸 </option>

<option value="印刷、出版">印刷、出版</option>

<option value="办公、文教">办公、文教</option>

<option value="家用电器">家用电器</option>

<option value="家居用品">家居用品</option>

<option value="食品、饮料">食品、饮料</option>

<option value="商业服务">商业服务</option>

<option value="医药、保养">医药、保养</option>

<option value="运动、休闲">运动、休闲</option>

<option value="工艺、礼品">工艺、礼品</option>

<option value="玩具">玩具</option>

<option value="房地产">房地产</option>

<option value="库存积压品">库存积压品</option>

<option value="人才、教育">人才、教育</option>

<option value="其他">其他</option>

</select>

                </td>
                <td><input type="image" name="Submit" src="../images/search_go.gif" width="35" height="35" border="0" align="absmiddle"></td>
                <td width=200></td>
              </tr>
              <tr>
                        <td colspan="3" align=right><strong>热门产品检索: </strong><a href="showsearch.jsp?gjz=化工&hy=" class="linkline">化工</a>、<a href="showsearch.jsp?gjz=灯&hy=" class="linkline">灯</a>、<a href="showsearch.jsp?gjz=牙刷&hy=" class="linkline">牙刷</a>、<a href="showsearch.jsp?gjz=车&hy="  class="linkline">车</a>、<a href="showsearch.jsp?gjz=%CC%A8%B5%C6&hy=" class="linkline">台灯</a>、<a href="showsearch.jsp?gjz=%CE%FC%B6%A5%B5%C6&hy=" class="linkline">吸顶灯</a>、<a href="showsearch.jsp?gjz=%C2%E4%B5%D8%B5%C6&hy=" class="linkline">落地灯</a></td>
              </tr></form>
            </table>              </td>
            <td width="15"><img src="../images/search_02.gif" width="15" height="80"></td>
          </tr>
        </table></td>
      </tr>
    </table>
<table width="750" border="0" cellspacing="0" cellpadding="0" align=center>
                      
                    
					  









					  
					  
					  <tr>
                        <td><div align="center">
                            <table width="750" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td><table width="750" border="0" cellspacing="0" cellpadding="0">
                                    <tr>
                                      <td height="7" bgcolor="EBEBEB"><img src="../images/spacer.gif" width="1" height="1"></td>
                                    </tr>
                                    <tr>
                                      <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                                          <tr>





<%
stmt = con.createStatement() ;
rs=stmt.executeQuery("SELECT * from showbar order by id 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++ ;
%>









                                            <td width="7" valign="top" background="../images/product_10.gif"><img src="../images/product_1.gif" width="7" height="202"></td>
                                            <td width="125" valign="top">
<div align="center">
                                                <table width="118" border="0" cellspacing="0" cellpadding="0">
                                                  <tr> 
                                                    <td height="150">

<DIV align=center>

<a href=show.jsp?id=<%=rs.getString("id")%> target="_blank"><IMG height=160 width=140 src="../<%=rs.getString("showphoto")%>" width=73 
border=0></A>

</td>
                                                  </tr>
                                                  <tr> 
                                                    <td><div align="right"><img src="../images/product_7.gif" width="11" height="8"></div></td>
                                                  </tr>
                                                  <tr> 
                                                    <td height="20" class="zl"><font color="515050">产品名:</font><font color="FF4E0D"><a href=show.jsp?id=<%=rs.getString("id")%> target="_blank"><%=rs.getString("showname")%></a></font></td>
                                                  </tr>
                                                  <tr> 
                                                    <td background="../images/product_8.gif"><img src="../images/product_8.gif" width="2" height="3"></td>
                                                  </tr>
                                                 
                                                  <tr> 
                                                    <td background="../images/product_8.gif"><img src="../images/product_8.gif" width="2" height="3"></td>
                                                  </tr>
                                                 
                                                </table>
												
                                              </div></td>
                                            <td width="15" valign="top" background="../images/product_11.gif"><img src="../images/product_2.gif" width="15" height="202"></td>





<%if (k==4){k=1 ;%></tr><tr><%}else{%></td><%k++ ;}%>
                       
<%
}
%>




                                          </tr>
                                        </table></td>
                                    </tr>
                                    <tr>
                                      <td><img src="images/product_6.gif" width="562" height="6"></td>
                                    </tr> <tr>
                                      <td height="20" background="../images/product_9.gif"><img src="../images/product_9.gif" width="3" height="23"></td>
                                    </tr>
                                  </table></td>
                              </tr>
                            </table>
                          </div></td>
                      </tr>
					  
	

				  

   


<%
rs=stmt.executeQuery("SELECT count(*) from showbar order by id desc");
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+20)/20%></font>页 
                                        <%=i%>个展图 当前为第<%=pageInt%>页</td>
                                      <td valign="middle">
<div align="right"> 
                                          <p class="zl">
										  
									转到第&nbsp;<%for(int j=1;j<(i+40)/20;j++){%><a href="glshow.jsp?page=<%=j%>"><font color=red><%=j%></font></a>&nbsp;<%}%>页
																	  
																	  </p>
                                        </div></td>
                                    </tr>
                                  </table></td>
                              </tr>
                              <tr>
                                <td><img src="../images/product_15.gif" width="562" height="1"></td>
                              </tr>
                            </table>
                          </div></td>
                      </tr>
					  <tr>
                        <td height="20">&nbsp;</td>
                      </tr>
                    </table></td>
                </tr>
              </table>













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

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -