开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Java编程 > Applet > 查看源码
left.jsp
资源名称：jspgouwushop.rar　[点击查看]
上传用户：szlmxq
上传日期：2014-01-31
资源大小：740k
文件大小：13k
源码类别：

Applet

开发平台：

Java

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