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

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

Applet

开发平台：

Java

links.jsp：源码内容
  1. <%@ page contentType="text/html;charset=GBK" language="java" import="java.sql.*" errorPage="" %>
  2. <%@ include file="conn.jsp"%>
  3. <%
  4. if(session.getAttribute("admin_name")==null){
  5. ;}else{
  6. %>
  7. <html>
  8. <head>
  9. <title>Untitled Document</title>
  10. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  11. <link href="../img/css.css" rel="stylesheet" type="text/css">
  12. <style>
  13. td{font-size:9pt;line-height:120%;color:#353535} 
  14. body{font-size:9pt;line-height:120%} 
  16. a:link          { color: #000000; text-decoration: none }
  17. a:visited       { color: #000000; text-decoration: none }
  18. a:active        { color: #000000; text-decoration: none }
  19. a:hover         { color: #336699; text-decoration: none; position: relative; right: 0px; top: 1px }
  20. </style>
  21. </head>
  23. <body>
  24. <div align="center">
  25.   <center>
  26. <table width="80%" border="1" cellspacing="0" cellpadding="0" bordercolor="#808080" style="border-collapse: collapse">
  27.   <tr> 
  28.     <td> 
  29.       <table width="100%" border="0" cellspacing="0" cellpadding="0">
  30.         <tr> 
  31.           <td width="9" rowspan="2"></td>
  32.           <td class="12v"> 
  33.             <table width="100%" border="0" cellspacing="0" cellpadding="0" class="12v">
  34.               <tr> 
  35.                 <td class="12v" > 
  36.                   <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" id="AutoNumber3" height="0" width="100%">
  37.                     <tr> 
  38.                       <td> 
  39.                         <table width="100%" border="0" align="center" cellpadding="1" cellspacing="1">
  40.                           <tr> 
  41.                             <td bgcolor="#808080"> 
  42.                               <div align="center"><font color="#FFFFFF">管理合作伙伴</font></div>
  43.                             </td>
  44.                           </tr>
  45.                           <tr> 
  46.                             <td height="99" valign="top" bgcolor="#FFFFFF"><br>
  47.                               <%
  48. sql="select * from ad order by bs";
  49.   rs=mdb.executeQuery(sql);
  51. %>
  52.                               <table width="80%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC">
  53.                                 <tr> 
  54.                                   <td width="26%" height="16" bgcolor="#FFFFFF">
  55.                                     <div align="center">网站名称</div>
  56.                                   </td>
  57.                                   <td width="42%" height="16" bgcolor="#FFFFFF">
  58.                                     <div align="center">网站地址</div>
  59.                                   </td>
  60.                                   <td width="9%" bgcolor="#FFFFFF">
  61.                                     <div align="center">排 序</div>
  62.                                   </td>
  63.                                   <td width="23%" bgcolor="#FFFFFF">
  64.                                     <div align="center">操 作</div>
  65.                                   </td>
  66.                                 </tr>
  67.                                 <%if(!rs.next())
  68.   out.print("还没有数据，请添加！");
  69.   else{
  70.   rs.previous();
  71.   while(rs.next()){
  72.   int id=rs.getInt("id");%>
  73.                                 <tr> 
  74.                                   <form name="form1" method="post" action="savelinks.jsp?action=edit&id=<%=id%>">
  75.                                     <td height="35" bgcolor="#FFFFFF">
  76.                                       <div align="center"> 
  77.                                         <input name="wordlink" type="text" id="linkname" value="<%=rs.getString("wordlink")%>" size="16">
  78.                                       </div>
  79.                                     </td>
  80.                                     <td bgcolor="#FFFFFF">
  81.                                       <div align="center"> 
  82.                                         <input name="url" type="text" id="linkurl" value="<%=rs.getString("url")%>" size="26">
  83.                                       </div>
  84.                                     </td>
  85.                                     <td bgcolor="#FFFFFF">
  86.                                       <div align="center"> 
  87.                                         <input name="bs" type="text" id="linkidorder" value=<%=rs.getInt("bs")%> size="3">
  88.                                       </div>
  89.                                     </td>
  90.                                     <td bgcolor="#FFFFFF">
  91.                                       <div align="center"> 
  92.                                         <input type="submit" name="Submit" value="修 改">
  93.                                         &nbsp;&nbsp;<a href=savelinks.jsp?action=del&id=<%=id%>><font color="#FF0000">删除</font></a> 
  94.                                       </div>
  95.                                     </td>
  96.                                   </form>
  97.                                 </tr>
  98.                                 <%}
  99.   }
  100.   %>
  101.   <%sql="select * from ad order by bs";
  102.   rs=mdb.executeQuery(sql);
  103.   int i=0;
  104.   if(rs.next()){
  105. rs.last();
  106. i=rs.getRow();}else i=0;%>
  107.                               </table>
  108.                             </td>
  109.                           </tr>
  110.                         </table>
  111.                       </td>
  112.                     </tr>
  113.                   </table>
  114.                 </td>
  115.               </tr>
  116.             </table>
  117.           </td>
  118.           <td class="12v" background="../img/back_3.gif" width="9" rowspan="2"></td>
  119.         </tr>
  120.       </table>
  121.     </td>
  122.   </tr>
  123. </table>
  124.   </center>
  125. </div>
  126. <br>
  127. <div align="center">
  128.   <center>
  129. <table width="80%" border="1" cellspacing="0" cellpadding="0" bordercolor="#808080" style="border-collapse: collapse">
  130.   <tr> 
  131.     <td> 
  132.       <table width="100%" border="0" cellspacing="0" cellpadding="0">
  133.         <tr> 
  134.           <td width="9"  rowspan="2"></td>
  135.           <td class="12v"> 
  136.             <table width="100%" border="0" cellspacing="0" cellpadding="0" class="12v">
  137.               <tr> 
  138.                 <td class="12v" > 
  139.                   <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" id="AutoNumber3" height="0" width="100%">
  140.                     <tr> 
  141.                       <td> 
  142.                         <table width="100%" border="0" align="center" cellpadding="1" cellspacing="1">
  143.                           <tr> 
  144.                             <td bgcolor="#808080"> 
  145.                               <div align="center"><font color="#FFFFFF">添加合作伙伴</font></div>
  146.                             </td>
  147.                           </tr>
  148.                           <tr>
  149.                             <form name="form2" method="post" action="savelinks.jsp?action=add">
  150.                               <td height="98" bgcolor="#FFFFFF"> 
  151.                                 <table width="80%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
  152.                                   <tr> 
  153.                                     <td height="15" bgcolor="#FFFFFF">
  154.                                       <div align="center">网站名称</div>
  155.                                     </td>
  156.                                     <td bgcolor="#FFFFFF">
  157.                                       <div align="center">网站地址</div>
  158.                                     </td>
  159.                                     <td bgcolor="#FFFFFF">
  160.                                       <div align="center">排 序</div>
  161.                                     </td>
  162.                                     <td bgcolor="#FFFFFF">
  163.                                       <div align="center">操 作</div>
  164.                                     </td>
  165.                                   </tr>
  166.                                   <tr> 
  167.                                     <td height="15" bgcolor="#FFFFFF">
  168.                                       <div align="center"> 
  169.                                         <input name="wordlink" type="text" id="wordlink" size="16">
  170.                                       </div>
  171.                                     </td>
  172.                                     <td bgcolor="#FFFFFF">
  173.                                       <div align="center"> 
  174.                                         <input name="url" type="text" id="url" size="26">
  175.                                       </div>
  176.                                     </td>
  177.                                     <td bgcolor="#FFFFFF">
  178.                                       <div align="center"> 
  179.                                         <input name="bs" type="text" id="bs" value=<%=i+1%> size="3">
  180.                                       </div>
  181.                                     </td>
  182.                                     <td bgcolor="#FFFFFF">
  183.                                       <div align="center"> 
  184.                                         <input type="submit" name="Submit2" value="添 加">
  185.                                       </div>
  186.                                     </td>
  187.                                   </tr>
  188.                                 </table>
  189.                               </td>
  190.                             </form>
  191.                           </tr>
  192.                         </table>
  193.                       </td>
  194.                     </tr>
  195.                   </table>
  196.                 </td>
  197.               </tr>
  198.             </table>
  199.           </td>
  200.           <td class="12v" background="../img/back_3.gif" width="9" rowspan="2"></td>
  201.         </tr>
  202.       </table>
  203.     </td>
  204.   </tr>
  205. </table>
  207.   </center>
  208. </div>
  210. </body>
  211. </html>
  212. <%mdb.Close();
  213. }%>