⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 favorite.asp

📁 数据库应用技术的实验代码及相关文档,供有需要的人使用
💻 ASP
字号:
<% Response.Buffer=True %>
<!--#include file="../inc/person.inc"-->
<!--#include file="../lib/inctop.asp"-->
<% uname=session("puid")
   if not isempty(request("page")) then   
	pagecount=cint(request("page"))   
    else   
	pagecount=1   
    end if
   set rs=server.createobject("adodb.recordset")
   if request("del")<>"" then 
   conn.Execute("delete * from pfavorite where uname='"&uname&"' and fuid='"&request("del")&"'")
   end if
   sql="select * from pfavorite where uname='"&uname&"' order by id desc"
   rs.open sql,conn,1,1
   if rs.eof and rs.bof then   
   response.write"<SCRIPT language=JavaScript>alert('对不起,你的收藏夹为空!');"
   response.write"javascript:history.go(-1);</SCRIPT>"
   end if
   fnum=rs.recordcount
   rs.pagesize=10
   fpnum=rs.pagecount
   if pagecount>rs.pagecount or pagecount<=0 then              
   pagecount=1              
   end if              
   rs.AbsolutePage=pagecount
   page_start=(pagecount-1)*rs.pagesize
   if pagecount=1 then page_start=1
   page_end=rs.pagesize*pagecount
   if pagecount*rs.pagesize=>rs.recordcount then page_end=rs.recordcount end if
   do while not rs.eof  
   id=rs("id")
   if fuid="" then
      fuid=rs("fuid")
   else
      fuid=fuid & "," & rs("fuid")
   end if
   i=i+1
   rs.movenext
   if i>=rs.PageSize then exit do
   loop
   rs.close                                                                    
   set rs=nothing
   fuid=split(fuid,",")
   set rs=server.createobject("adodb.recordset") %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../inc/index.css" type="text/css">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>学生社会实践信息管理系统—&gt;我的收藏夹</title>
<script language="JavaScript">
<!--
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_showHideLayers() { //v3.0
  var i,p,v,obj,args=MM_showHideLayers.arguments;
  for (i=0; i<(args.length-2); i+=3) if ((obj=MM_findObj(args[i]))!=null) { v=args[i+2];
    if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v='hide')?'hidden':v; }
    obj.visibility=v; }
}
//-->
</script>
</head>
<SCRIPT language=JavaScript src="../inc/window.js"></SCRIPT>
<body topmargin="0" leftmargin="0" bgcolor="#666666">
<table align=center background=../inmegs/bgline.gif border=0 cellpadding=0 
cellspacing=0 width=762>

<table border="0" cellpadding="0" cellspacing="0" width="760" height="358" bgcolor="#FFFFFF" align="center">
  <tr> 
    <td height="18" valign="top" colspan="6" bgcolor="#396BA5">   </td>
    </tr>
  <tr> 
    <td width="118" valign="top" bgcolor="#396BA5" height="340">   
      <div align="center"> 
        <table border="0" cellpadding="0" cellspacing="0" width="118" height="280">
          <tr> 
            <td width="100%" height="163" background="../images/stat-bg.GIF" valign="top"> 
              <p align="center"><br>
                <a href="main.asp">登录首页</a><br>
                <br>
                <a href="register.asp">登录求职简历</a><br>
                <br>
                <a href="modify.asp">更新求职简历</a><br>
                <br>
                <a href="../changepwd.asp?stype=person" target="_blank">修改登录密码</a><br>
                <br>
                <a href="search.asp">全部职位列表</a> 
            </td>
          </tr>
          <tr> 
            <td width="100%" height="117" background="../images/stat-bg.GIF" valign="top"> 
              <p align="center"><br>
                <br>
                <a href="favorite.asp">我的收藏夹</a><br>
                <br>
                <a href="mailbox.asp">我的信箱</a><br>
                <br>
                <a href="../exit.asp">退出登录</a> 
            </td>
          </tr>
        </table>
      </div>
      <p align="center">&nbsp; </p>
      <p align="center">  
    </td>
    <td width="20" valign="top"><img border="0" src="../images/selfk.GIF"></td>
    <td width="82"> 
    <td width="477" valign="top"> 
      <div align="left"> 
        <table border="1" cellpadding="0" cellspacing="0" width="477" bordercolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF">
          <tr> 
            <td height="1" colspan="5" valign="bottom" width="473"><font color="#000000">&nbsp;</font></td>
          </tr>
          <tr> 
            <td width="473" height="6" colspan="5" valign="bottom"><font color="#000000"></font><font color="#000000"> 
              您的收藏夹内共有[<font color="#ff0000"><%=fnum%></font>]条记录</font>&nbsp;以下是[<font color="red"><%=page_start%>~<%=page_end%></font>]条 
              页次:[<font color="#0000AE"><%=pagecount%></font>/<%=fpnum%>]</td>
          <tr> 
            <td height="3" valign="top" colspan="5" bgcolor="#000000" width="473"> 
            </td>
          </tr>
          <tr> 
            <td width="144" height="18" bgcolor="#EBEEF3" valign="bottom">&nbsp;公司名称</td>
            <td width="162" height="18" bgcolor="#EBEEF3" valign="bottom">&nbsp;招聘职位</td>
            <td height="18" bgcolor="#EBEEF3" valign="bottom" width="78"> 
              <p align="center">发布日期</p>
            </td>
            <td height="18" bgcolor="#EBEEF3" valign="bottom" width="37"> 
              <p align="center">发信
            </td>
            <td height="18" bgcolor="#EBEEF3" valign="bottom" width="32"> 
              <p align="center">删除
            </td>
          </tr>
          <% for i=0 to ubound(fuid)
		   sql="select * from company where uname='"&(fuid(i))&"'" 
		   rs.open sql,conn,1,1 %>
          <tr> 
            <td width="144" height="18" bgcolor="#EBEEF3" valign="bottom">&nbsp;<a href="javascript:openwin('../company.asp?uid=<%=rs("uname")%>','top=10,left=300,width=460,height=420')"> 
              <% if len(rs("cname"))>10 then%>
              <%=Left(rs("cname"),10)%>... 
              <%else%>
              <%=rs("cname")%> 
              <%end if%>
              </a></td>
            <td width="162" height="18" bgcolor="#EBEEF3" valign="bottom">&nbsp;<a 
    href="javascript:openwin('../job.asp?uid=<%=rs("uname")%>','top=10,left=300,width=460,height=420')"><%=rs("job")%> 
              </a></td>
            <td width="78" height="18" bgcolor="#EBEEF3" valign="bottom"> 
              <p align="center">[<%=rs("idate")%>]</p>
            </td>
            <td width="37" height="18" bgcolor="#EBEEF3" valign="bottom"> 
              <p align="center"><a href="javascript:openwin('sendmail.asp?reid=<%=rs("uname")%>','top=20,left=200,width=450,height=400')"><font face="Wingdings" color="#000060" size="2">*</font></a>
            </td>
            <td width="32" height="18" bgcolor="#EBEEF3" valign="bottom"> 
              <p align="center"><a href="favorite.asp?del=<%=rs("uname")%>"> <font color="#000060">删除</font></a>
            </td>
          </tr>
          <% rs.close                                                                    
             next %>
          <tr> 
            <td height="3" valign="top" colspan="5" bgcolor="#000000" width="473"> 
            </td>
          </tr>
          <tr> 
            <td width="473" height="8" valign="bottom" colspan="5"> 
              <p align="center"><br>
                <%if pagecount=1 and fpnum<>pagecount then%>
                <a href="favorite.asp?page=<%=cstr(pagecount+1)%>"> <font color="#000000">下一页>>></font></a><a> 
                <% end if %>
                <% if fpnum>1 and fpnum=pagecount then %>
                </a><a href="favorite.asp?page=<%=cstr(pagecount-1)%>"> <font color="#000000"><<<上一页</font></a><a> 
                <%end if%>
                <%if pagecount<>1 and fpnum<>pagecount then%>
                </a><a href="favorite.asp?page=<%=cstr(pagecount-1)%>"> <font color="#000000"><<<上一页</font></a><a> 
                </a> <a href="favorite.asp?page=<%=cstr(pagecount+1)%>"> <font color="#000000">下一页>>></font></a><a> 
                <% end if                                                                                               
        set rs=nothing                                                                                                
        conn.close                                                                                                
         set conn=nothing %>
                </a> 
            </td>
          </tr>
        </table>
      </div>
    </td>
    <td width="63"> 
    <td width="1" valign="top" bgcolor="#00006A"></td>
  </tr>
  <tr> 
    <td height="12" valign="top" colspan="5" bgcolor="#396BA5"> 
      <p align="center"> 
    </td>
    <td width="1"></td>
  </tr>
  <tr> 
    <td height="12" width="118"> 
    <td width="20"></td>
    <td width="82"></td>
    <td width="477"></td>
    <td width="63"></td>
    <td width="1"></td>
  
</table>
  
<div align="center"></div>
</body>
</html>
 

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -