editnews.asp
上传用户:btntkt
上传日期:2021-04-16
资源大小:5296k
文件大小:6k
源码类别:

WEB源码(ASP,PHP,...)

开发平台:

DOS

  1. <!--#include file="conn.asp"-->
  2. <%
  3. dim cls
  4. if session("admin")="" then
  5. Response.Redirect("admin.asp")
  6. else
  7. if session("flag")<>"0" then
  8. cls = Instr(session("flag"), "mannewfig")
  9. if cls <= 0 then
  10. %>
  11. <script language="javascript">
  12. if (confirm("您的操作权限不够,系统拒绝你的访问,请点确定返回,或者点取消退出重新登录"))
  13.   location.href="login.asp";
  14. else
  15.   location.href="index.asp";
  16. </script>
  17. <%
  18. end if
  19. end if
  20. end if
  21. %>
  22. <%
  23.  if request.QueryString("action")="del" then
  24. conn.execute "delete from news where newsid in ("&request("selectdel")&")"
  25. response.Redirect "editnews.asp"
  26. end if %>
  27. <html><head><title>Untitled Document</title>
  28. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  29. <link href="../images/css.css" rel="stylesheet" type="text/css">
  30. </head>
  31. <body>
  32. <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  33. <tr> 
  34. <td height="100" valign="top">
  35.                               <%'开始分页
  36. Const MaxPerPage=20 
  37.     dim totalPut   
  38.     dim CurrentPage
  39.     dim TotalPages
  40.     dim j
  41.     dim sql
  42.      if Not isempty(request("page")) then
  43.        currentPage=Cint(request("page"))
  44.     else
  45.        currentPage=1
  46.     end if 
  47.  set rs=server.createobject("adodb.recordset")
  48. rs.open "select newsid,newsname,addname,adddate from news order by adddate desc",conn,1,1
  49. if err.number<>0 then
  50. response.write "数据库中无数据"
  51. end if
  52.    if rs.eof And rs.bof then
  53.         Response.Write "<p align='center' class='contents'> 您还没有添加新闻!</p>"
  54.     else
  55.    totalPut=rs.recordcount
  56.        if currentpage<1 then
  57.            currentpage=1
  58.        end if
  59.        if (currentpage-1)*MaxPerPage>totalput then
  60.     if (totalPut mod MaxPerPage)=0 then
  61.       currentpage= totalPut  MaxPerPage
  62.     else
  63.        currentpage= totalPut  MaxPerPage + 1
  64.     end if
  65.        end if
  66.         if currentPage=1 then
  67.              showContent
  68.              showpage totalput,MaxPerPage,"editnews.asp"
  69.         else
  70.            if (currentPage-1)*MaxPerPage<totalPut then
  71.              rs.move  (currentPage-1)*MaxPerPage
  72.              dim bookmark
  73.              bookmark=rs.bookmark
  74.              showContent
  75.               showpage totalput,MaxPerPage,"editnews.asp"
  76.          else
  77.          currentPage=1
  78.             showContent
  79.             showpage totalput,MaxPerPage,"editnews.asp"
  80.        end if
  81.     end if
  82.         end if
  83.     sub showContent
  84.         dim i
  85.     i=0
  86. %>
  87.                             <table class="tableBorder" width="90%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
  88.                                 <form name="form1" method="post" action="editnews.asp?action=del">
  89. <tr> 
  90.           <td colspan="4" align="center" background="../images/admin_bg_1.gif"><b><font color="#ffffff">首页新闻管理</font></b></td>
  91.          </tr>
  92.                                 <tr > 
  93.                                 <td align="center">新闻主题</td>
  94.                                 <td align="center">发布人</td>
  95.                                 <td align="center">发布时间</td>
  96.                                 <td align="center">选 择</td>
  97.                                   </tr>
  98.                                   <%do while not rs.eof%>
  99.                                   <tr> 
  100.                                     <td  style="PADDING-LEFT: 6px"><a href=newsedit.asp?id=<%=rs("newsid")%>><%=trim(rs("newsname"))%></a></td>
  101.                                     <td  align="center"><%=trim(rs("addname"))%></td>
  102.                                     <td  align="center"><%=rs("adddate")%></td>
  103.                                     <td  align="center">
  104. <input name="selectdel" type="checkbox" id="selectdel" value=<%=rs("newsid")%>>
  105.                                     </td>
  106.                                   </tr>
  107.                                   <%i=i+1
  108. if i>=MaxPerPage then Exit Do
  109. rs.movenext
  110.   loop
  111.   rs.close
  112.   set rs=nothing%>
  113.                                   <tr> 
  114.                                     <td height="30" colspan="4"  align="center"> 
  115. <input type="submit" name="Submit" value="删除所选新闻">
  116. 全选
  117. <input type="checkbox" name="checkbox" value="Check All" onClick="mm()">
  118.                                     </td>
  119.                                   </tr>
  120.                                 </form>
  121.                               </table>
  122.                               <%  
  123. End Sub   
  124. Function showpage(totalnumber,maxperpage,filename)  
  125.    Dim n
  126. If totalnumber Mod maxperpage=0 Then  
  127. n= totalnumber  maxperpage  
  128. Else
  129. n= totalnumber  maxperpage+1  
  130. End If
  131. Response.Write "<form method=Post action="&filename&">"  
  132. Response.Write "<p align='center' class='contents'> "  
  133. If CurrentPage<2 Then  
  134. Response.Write "<font class='contents'>首页 上一页</font> "  
  135. Else  
  136. Response.Write "<a href="&filename&"?page=1 class='contents'>首页</a> "  
  137. Response.Write "<a href="&filename&"?page="&CurrentPage-1&" class='contents'>上一页</a> "  
  138. End If
  139. If n-currentpage<1 Then  
  140. Response.Write "<font class='contents'>下一页 尾页</font>"  
  141. Else  
  142. Response.Write "<a href="&filename&"?page="&(CurrentPage+1)&" class='contents'>"  
  143. Response.Write "下一页</a> <a href="&filename&"?page="&n&" class='contents'>尾页</a>"  
  144. End If  
  145. Response.Write "<font class='contents'> 页次:</font><font class='contents'>"&CurrentPage&"</font><font class='contents'>/"&n&"页</font> "  
  146. Response.Write "<font class='contents'> 共有"&totalnumber&"条新闻 " 
  147. Response.Write "<font class='contents'>转到:</font><input type='text' name='page' size=2 maxlength=10 class=smallInput value="&currentpage&">"  
  148. Response.Write "&nbsp;<input type='submit'  class='contents' value='GO' name='cndok'></form>"  
  149. End Function  
  150. %>
  151. </td>
  152. </tr>
  153. </table>
  154. <!--#include file="foot.asp"-->
  155. </body>
  156. </html>
  157. <script language=javascript>
  158. function mm()
  159. {
  160.    var a = document.getElementsByTagName("input");
  161.    if(a[0].checked==true){
  162.    for (var i=0; i<a.length; i++)
  163.       if (a[i].type == "checkbox") a[i].checked = false;
  164.    }
  165.    else
  166.    {
  167.    for (var i=0; i<a.length; i++)
  168.       if (a[i].type == "checkbox") a[i].checked = true;
  169.    }
  170. }
  171. </script>