listnews.asp

人才招聘系统,用asp做的

<!--#include file=../conn.asp-->
<!--#include file=usercookies.asp-->
<!--#include file=onlinerz.asp-->
<%
	dim sql
	dim rs
	dim biaoti
	dim neirong,Allrecord
	set rs=server.createobject("adodb.recordset")
	sql="select * from [news] order by id"
	rs.open sql,conn,1,1
	Allrecord=rs.Recordcount
%>

<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
  <tr>
    <td width="100%" valign="top" height="71">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="20">
      <tr>
        <td width="20%" valign="top"></td>
        <td width="80%" valign="top" height="20">
        记录总数:<font color="#FFFF00"><span style="background-color: #800000"><%=Allrecord%></span></font><table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="101%" height="22">
     <%do while not rs.eof%>
          <tr>
            <td width="6%" height="22" style="border-bottom-style: solid; border-bottom-width: 1">
            <p align="center"><b><font color="#808080"><%=rs("id")%></font></b></td>
            <td width="62%" height="22" style="border-bottom-style: solid; border-bottom-width: 1"><A href="javascript:win=open('../news.asp?id=<%=rs("id")%>','offer','width=560,height=450,status=no,menubar=yes,scrollbars=yes,top=0,left=0'); win.focus()"><FONT color=#000000><%=rs("biaoti")%></FONT></A></td>
            <td width="6%" style="border-bottom-style: solid; border-bottom-width: 1" height="22">
            <a href="editnews.asp?id=<%=rs("id")%>">修改</a></td>
            <td width="22%" style="border-bottom-style: solid; border-bottom-width: 1" height="22">
            <a onclick='{if(confirm("您确定删除吗?此操作将不能恢复!")){return true;}return false;}' href="delnews.asp?id=<%=rs("id")%>">删除</a></td>
          </tr>
     <%
     rs.movenext
	 loop
	 %>
        </table>
        </td>
      </tr>
    </table>
    </td>
  </tr>
</table>
<p align="center">
    <font color="#FFFFFF"><a href="addnews.asp"><font color="#384249">增加新闻</font></a></font></p>

<%
	rs.close
	conn.close
	set rs=nothing
	set conn=nothing
%>