shopnews.asp

本源代码为大学生购物网的源代码,欢迎大家的下载,学习与交流

<TABLE cellSpacing=0 cellPadding=0 width=760 align=center border=0 class=page>
  <TBODY>
    <TR> <td><!--#include file="top.asp"-->
<%
if session("user_id")="" then
response.write "<script language='javascript'>" & VbCRlf
response.write "alert('非法操作!');" & VbCrlf
response.write "history.go(-1);" & vbCrlf
response.write "</script>" & VbCRLF
else
%>
<TABLE width=760 border=0 align=center cellSpacing=0 cellPadding=0 >
  <TBODY>
    <TR> 
      <td width=176 valign=top>
           
               <!--#include file="center.asp"--></td><td bgcolor="#dfdfdf" width="1"></td>
      <TD align="center" vAlign=top bgcolor="#FFFFFF"> 
          <%
dim sql,rs
set rs=server.createobject("adodb.recordset")
sql="select * from new where user_id="&session("user_id")&""
rs.open sql,conn,1,3

%><SCRIPT LANGUAGE="JavaScript">
<!--
function GoPage() {
window.location.href="?page_no="+ page.value;
}
//-->
</SCRIPT>

        <TABLE cellSpacing=1 cellPadding=0 width="570" border=0 bgcolor="#C0C0C0">
          <TBODY>
            <TR> 
              <TD bgColor=#EFEFEF height=21> <TABLE width="100%" border=0>
                  <TBODY>
                    <TR> 
                      <TD align=middle width=25>
						<img border="0" src="images/news.gif" width="15" height="15"></TD>
                      <TD>新闻管理</TD>
                      <TD align="right"><a href="shopnews_add.asp">发布新闻</a> </TD>
                    </TR>
                  </TBODY>
                </TABLE></TD>
            </TR>
            <TR> 
              <TD align="center" bgcolor="#FFFFFF">
<table width="98%" border="0">
                  <tr align="center"> 
                    <td width="15%"><font color="#FF00FF">新闻名称</font></td>
                    <td width="15%"><font color="#FF00FF">发布时间</font></td>
                    <td width="8%"><font color="#FF00FF">修改</font></td>
                    <td width="8%"><font color="#FF00FF">删除</font></td>
                  </tr>
                <%
	  IF not rs.eof and not rs.bof then
	  dim page_size
	  dim page_no
	  dim page_total
	  page_size=8
	  if request.QueryString("page_no")="" then
	  page_no=1
	  else
	  page_no=cint(request.QueryString("page_no"))
	  end if
	  rs.pagesize=page_size
	  page_total=rs.pagecount
	  rs.absolutepage=page_no
	  dim I,J
	  I=0
	  J=page_size
	  do while not rs.eof and J>0
	  J=J-1
	  I=I+1
      %>
                  <tr> 
                    <td align="center"><a href="shopnewsinfor.asp?id=<%=rs("id")%>" target="_blank"><%=rs("name")%></a></td>
                    <td align="center"><%=rs("date")%></td>
                    <td align="center"><a href="shopnews_edit.asp?id=<%=rs("id")%>">修改</a></td>
                    <td align="center"><a href="shopnews_del.asp?id=<%=rs("id")%>">删除</a></td>
                  </tr>
 <%
	      Rs.MoveNext
		Loop      
	  End IF
	  %>         </table>
              </TD>
            </TR>
          </TBODY>
        </TABLE>
     <table  width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="page" >
              <tr>
                <td><div align="center">[本页是<%=int(page_no)%>/<%=int(page_total)%>] [<a href="?page_no=1">第一页</a>]
              <%if int(page_no)>1 then%>
              [<a href="?page_no=<%=cstr(int(page_no-1))%>">前一页</a>]
              <%elseif int(page_no)<=1 then%>
              [<a href="?page_no=1">前一页</a>]
              <%end if%>
              <%if int(page_no)<int(page_total) then%>
              [<a href="?page_no=<%=cstr(int(page_no+1))%>">后一页</a>]
              <%elseif int(page_no)>=int(page_total) then%>
              [<a href="?page_no=<%=cstr(int(page_total))%>">后一页</a>]
              <%end if%>
              [<a href="?page_no=<%=page_total%>">最后一页</a>] 转到
              <input name="page" type="text" value="<%=page_no%>" size="5">页
			<input type="button" class=input name="Submit" value="转到" onclick="GoPage()"></div></td>
              </tr>
</table>
      </TD>
    </TR>
  </TBODY>
</TABLE>
<%end if%>
<!--#include file="bottom.asp"--></TD>
    </TR>
  </TBODY>
</TABLE>