left.jsp
上传用户:helenhuo66
上传日期:2007-06-01
资源大小:865k
文件大小:13k
源码类别:

百货/超市行业

开发平台:

Java

  1. <%@ include file="top.jsp"%>
  2. <td width="181"> 
  3.   <!--'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
  4.   '''''''''''''''''''''用户信息和登陆''''''''''''''''''''''''''''''''''''
  5.   ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''-->
  6.       <table width="180" border="0" cellspacing="0" cellpadding="0" align="center">
  7.         <tr> 
  8.           <td valign="top"> 
  9.             <table border="0" width="180" cellspacing="0" cellpadding="0" height="18">
  10.               <%
  11. //是否登陆
  12. if((String)session.getValue("user_name")!=null) 
  13.                {
  14.   %>
  15.               <tr> 
  16.  <%     sql="select * from member where user_name='"+(String)session.getValue("user_name")+"'";
  17.         rs=mdb.executeQuery(sql);
  18.   %>
  19.               </tr>
  20.               <tr> 
  21.                 <td width="100%" height="18"> 
  22.                   <table width="100%" border="0" cellspacing="1" cellpadding="0">
  23.                     <tr> 
  24.                       <td> 
  25.                         <table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#F5EFE7" style="border-collapse: collapse" bordercolor="#111111">
  26.                           <tr> 
  27.                             <td> 
  28.                               <img border="0" src="img/promo_list_top.gif" width="100%" height="4"></td>
  29.                           </tr>
  30.                           <tr> 
  31.                             <td width="86%" height="20" bgcolor="#DBC2B0"> 
  32.                               <div align="center"><b>用户信息</b></div>
  33.                             </td>
  34.                           </tr>
  35.                           <tr> 
  36.                             <td> 
  37.                               <table border="0" width="100%" cellspacing="0" bgcolor="#F5EFE7" style="border-collapse: collapse" bordercolor="#111111" cellpadding="0">
  38.                                 <tr> 
  39.                                   <td width="100%" colspan="2" bgcolor="#FFFFFF"> 
  40.                                   </td>
  41.                                 </tr>
  42.                                 <tr> 
  43.                                   <td height="25" bgcolor="#F5EFE7" valign="top"> 
  44.                                     <img src="img/pics/main_head_menu002.gif" width="13" height="13" align="absmiddle"> 
  45.                                     用户名:</td>
  46.                                   <td height="25" bgcolor="#F5EFE7"><%=rs.getString("user_name")%></td>
  47.                                 </tr>
  48.                                 <tr> 
  49.                                   <td height="25" bgcolor="#F5EFE7" valign="top"><img src="img/pics/main_head_menu004.gif" width="13" height="13" align="absmiddle"> 
  50.                                     地址:</td>
  51.                                   <td height="25" bgcolor="#F5EFE7"><%=rs.getString("user_adds")%></td>
  52.                                 </tr>
  53.                                 <tr> 
  54.                                   <td height="25" bgcolor="#F5EFE7" valign="top"><img src="img/pics/main_head_menu001.gif" width="13" height="13" align="absmiddle"> E-mail:</td>
  55.                                   <td height="25" bgcolor="#F5EFE7"><%=rs.getString("user_mail")%></td>
  56.                                 </tr>
  57.                                 <tr> 
  58.                                   <td height="25" bgcolor="#F5EFE7" valign="top"><img src="img/pics/main_head_menu005.gif" width="13" height="13" align="absmiddle"> 
  59.                                     电话:</td>
  60.                                   <td height="25" bgcolor="#F5EFE7"><%=rs.getString("user_tel")%></td>
  61.                                 </tr>
  62.                               </table>
  63.                             </td>
  64.                           </tr>
  65.                         </table>
  66.                       </td>
  67.                     </tr>
  68.                   </table>
  69.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  70.                     <tr> 
  71.                       <td height="5"></td>
  72.                     </tr>
  73.                   </table>
  74.                 </td>
  75.               </tr>
  76. <%
  77.  }else
  78.  //没有登陆
  79.  {
  80.  %>
  81.               <tr> 
  82.                 <td width="100%" height="18"> 
  83.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  84.                     <tr> </tr>
  85.                   </table>
  86.                   <table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#F5EFE7" style="border-collapse: collapse" bordercolor="#111111">
  87.                     <tr> 
  88.                       <td align="center">
  89.                       <img border="0" src="img/promo_list_top.gif" width="100%" height="4"></td>
  90.                     </tr>
  91.                     <tr> 
  92.                       <td width="86%" align="center" height="20" bgcolor="#DBC2B0"><b>用户登陆</b></td>
  93.                     </tr>
  94.                     <form method="POST" action="login.jsp">
  95.                       <tr> 
  96.                         <td height="110" bgcolor="#F5EFE7"> 
  97.                           <table width="95%" border="0" align="center" cellpadding="0" cellspacing="5">
  98.                             <tr> 
  99.                               <td width="32%" bgcolor="#F5EFE7"> 
  100.                                 <div align="center">客户:</div>
  101.                               </td>
  102.                               <td width="68%" bgcolor="#F5EFE7"> 
  103.                                 <div align="center"> 
  104.                                   <input name="user_name" type="text" class=input id="user_name" style="FONT-SIZE: 12px; WIDTH: 110px" size="10" maxlength="18">
  105.                                 </div>
  106.                               </td>
  107.                             </tr>
  108.                             <tr> 
  109.                               <td bgcolor="#F5EFE7"> 
  110.                                 <div align="center">密码:</div>
  111.                               </td>
  112.                               <td bgcolor="#F5EFE7"> 
  113.                                 <div align="center"> 
  114.                                   <input style="FONT-SIZE: 12px; WIDTH: 110px" type="password" name="user_pass" size="10" class=input maxlength="18">
  115.                                 </div>
  116.                               </td>
  117.                             </tr>
  118.                           </table>
  119.                           <div align="center"></div>
  120.                           <div align="center">
  121.                             <center>
  122.                           <table width="90%" border="0" cellspacing="0" cellpadding="0" bgcolor="#F5EFE7" style="border-collapse: collapse" bordercolor="#111111">
  123.                             <tr> 
  124.                               <td width="80"><a href="reg.jsp" target="_blank"><img src="img/pics/reg.gif" width="81" height="25" border="0"></a></td>
  125.                               <td> 
  126.                                 <div align="center"> 
  127.                                   <input 
  128.       align=absMiddle alt=进入 cache name=submit2 
  129.       src="img/pics/login.gif" type=image tppabs="" width="56" height="25">
  130.                                 </div>
  131.                               </td>
  132.                             </tr>
  133.                           </table>
  134.                             </center>
  135.                           </div>
  136.                         </td>
  137.                       </tr>
  138.                     </form>
  139.                   </table>
  140.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  141.                     <tr> 
  142.                       <td height="5"></td>
  143.                     </tr>
  144.                   </table>
  145. <%
  146. }//判断登陆结束
  147. %>
  148.                 </td>
  149.               </tr>
  150.             </table>
  151.           </td>
  152.         </tr>
  153.       </table>
  154.   
  155.   <!--'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
  156.   ''''''''''''''''''''''''''''用户信息和登陆结束''''''''''''''''''''''''''''''''''''''''''
  157.   ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''-->
  158.       <table width="100%" border="0" cellspacing="0" cellpadding="0" height="5">
  159.         <tr> 
  160.           <td></td>
  161.         </tr>
  162.         <tr> 
  163.           <td></td>
  164.         </tr>
  165.       </table>
  166.       <table width="100%" border="0" cellspacing="0" cellpadding="0">
  167.         <tr> 
  168.           <td  align="center">
  169.           <img border="0" src="img/promo_list_top.gif" width="100%" height="4"></td>
  170.         </tr>
  171.         <tr> 
  172.           <td bgcolor="#DBC2B0" height="20" align="center"><b>型号搜索</b></td>
  173.         </tr>
  174.         <tr> 
  175.           <td> 
  176.             <table width="100%" border="0" cellspacing="0" cellpadding="0">
  177.               <tr> 
  178.                 <td> 
  179.                   <table border="0" width="100%" cellspacing="0" height="70">
  180.                     <tr> 
  181.                       <td height="28" bgcolor="#F5EFE7" align="center">输入商品关键字查询商品信息</td>
  182.                     </tr>
  183.                     <tr> 
  184.                       <form method="POST" action="search.jsp">
  185.                         <td valign="top" bgcolor="#F5EFE7"> 
  186.                           <input type="text" name="hw_name" size="15" class=input>
  187.                           <input type="image" border="0" name="imageField" src="img/serarch.gif" width="34" height="20">
  188.                         </td>
  189.                       </form>
  190.                     </tr>
  191.                   </table>
  192.                 </td>
  193.               </tr>
  194.             </table>
  195.           </td>
  196.         </tr>
  197.       </table>
  198.       <table width="100%" border="0" cellspacing="0" cellpadding="0" height="5">
  199.         <tr> 
  200.           <td> 
  201.             <table width="100%" border="0" cellspacing="0" cellpadding="0">
  202.               <tr> 
  203.                 <td> </td>
  204.               </tr>
  205.             </table>
  206.             <table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#F5EFE7" style="border-collapse: collapse" bordercolor="#111111">
  207.               <tr> 
  208.                 <td height="18"> 
  209.                   <table width="100%" border="0" cellspacing="0" cellpadding="0" height="23">
  210.                     <tr> 
  211.                       <td align="center" height="4"> 
  212.                       <img border="0" src="img/promo_list_top.gif" width="100%" height="4"></td>
  213.                     </tr>
  214.                     <tr> 
  215.                       <td align="center" height="19" bgcolor="#DBC2B0"> <b>商品分类</b></td>
  216.                     </tr>
  217.                   </table>
  218.                 </td>
  219.               </tr>
  220.               <tr> 
  221.                 <td valign="top"> 
  222.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  223.                     <tr> 
  224.                       <td> 
  225.                         <table width="100%" border="0" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111" height="16">
  226.                           <tr> 
  227.                             <td valign="top" height="16"> 
  228.                               <%
  229. sql="select * from sort";
  230. rs=mdb.executeQuery(sql);
  231. if(!rs.next()){
  232. out.print("没有任何分类"); 
  233. }
  234. else 
  235. {
  236.   while(rs.next()) 
  237.    {
  238. %>
  239.                               <table cellspacing=0 cellpadding=0 width=95% background="" 
  240.                   border=0>
  241.                                 <tbody> 
  242.                                 <tr height=22> 
  243.                                   <td width=34 align="center"><img 
  244.                       src="img/dot.gif" width="15" height="15"></td>
  245.                                   <td width="124"><a href="sort.jsp?sort_id=<%=rs.getInt("sort_id")%>"><u><%=rs.getString("sort_name")%></u></a></td>
  246.                                 </tr>
  247.                                 </tbody> 
  248.                               </table>
  249. <% 
  250.    }
  251. }
  252.  
  253. %>
  254.                             </td>
  255.                           </tr>
  256.                         </table>
  257.                       </td>
  258.                     </tr>
  259.                   </table>
  260.                 </td>
  261.               </tr>
  262.             </table>
  263.             <table width="100%" border="0" cellspacing="0" cellpadding="0">
  264.               <tr> 
  265.                 <td> </td>
  266.               </tr>
  267.               <tr> 
  268.                 <td align="center"><table width="100%" border="0" cellspacing="0" cellpadding="0" height="18">
  269.                     <tr> 
  270.                       <td align="center"> 
  271.                       <img border="0" src="img/promo_list_top.gif" width="100%" height="4"></td>
  272.                     </tr>
  273.                     <tr> 
  274.                       <td align="center" height="20" bgcolor="#DBC2B0"> <b>站内公告</b></td>
  275.                     </tr><tr>
  276.                       <td bgcolor="#F5EFE7">
  277. <% 
  278. sql="select top 3 * from pub order by ID DESC";
  279. rs=mdb.executeQuery(sql);
  280. if(!rs.next())
  281.  {
  282.             %>
  283.                                 <p style="margin:0 5; ">暂无公告<br>
  284.                                 <%
  285.  }
  286.  int i=0;
  287. while(rs.next())
  288.  {
  289. i=i+1;
  290. %>
  291.                                 <p style="margin:5; "><b><%=rs.getString("title")%></b><br>
  292.                               <%=rs.getString("msg")%> <br>
  293.                               <%=rs.getDate("date")%></p>
  294. <%
  295. if(i>=3){
  296.    break;
  297.    } 
  298. }
  299. %></td></tr></table>
  300.                
  301.                
  302.                  </td>
  303.               </tr>
  304.   <tr> 
  305.             </table>
  306.           </td>
  307.         </tr>
  308.       </table>
  309.     </td>
  310. <%@ include file="top.jsp"%>