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

📄 favorite.asp

📁 数据库应用技术的实验代码及相关文档,供有需要的人使用
💻 ASP
字号:
<% Response.Buffer=True %>
<!--#include file="../inc/company.inc"-->
<!--#include file="../lib/inctop.asp"-->
<% uname=session("cuid")
   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 cfavorite where uname='"&uname&"' and fuid='"&request("del")&"'")
   end if
   sql="select * from cfavorite 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"this.location.href='main.asp';</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="zh-cn">
<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;人才中心—&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>

<center> 
<table border="0" cellpadding="0" cellspacing="0" width="760" height="358" bgcolor="#FFFFFF">
  <tr> 
    <td height="18" valign="top" colspan="5" bgcolor="#396BA5">   </td>
    <td width="1"></td>
  </tr>
  <tr> 
    <td width="186" valign="top" bgcolor="#396BA5" height="304">   
      <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="publish.asp">发布/更新招聘信息</a><br>
                <br>
                <a href="../changepwd.asp?stype=company" 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">我的收藏夹<br>
                <br><a href="mailbox.asp">
                我的信箱</a><br>
                <br>
                <a href="../exit.asp">退出登录</a> 
            </td>
          </tr>
        </table>
      </div>
      <p align="center"> </p>
      <p align="center">  
    </td>
    <td width="20" valign="top"><img border="0" src="../images/selfk.GIF"></td>
    <td width="82"></center>
    <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="7" valign="bottom" width="473"><font color="#000000">&nbsp;</font></td>
          </tr>
          <tr> 
            <td width="473" height="6" colspan="7" 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="7" bgcolor="#000000" width="473"> 
            </td>
          </tr>
          <tr> 
            <td width="56" height="18" bgcolor="#EBEEF3" valign="bottom">&nbsp;姓名</td>
            <td width="36" height="18" bgcolor="#EBEEF3" valign="bottom"> 
              <p align="center">性别
            </td>
            <td width="53" height="18" bgcolor="#EBEEF3" valign="bottom"> 
              <p align="center">学历
            </td>
            <td width="161" height="18" bgcolor="#EBEEF3" valign="bottom">&nbsp;应聘职位</td>
            <td height="18" bgcolor="#EBEEF3" valign="bottom" width="77"> 
              <p align="center">发布日期</p>
            </td>
            <td height="18" bgcolor="#EBEEF3" valign="bottom" width="36"> 
              <p align="center">发信
            </td>
            <td height="18" bgcolor="#EBEEF3" valign="bottom" width="30"> 
              <p align="center">删除
            </td>
          </tr>
          <% for i=0 to ubound(fuid)
		   sql="select * from person where uname='"&(fuid(i))&"'" 
		   rs.open sql,conn,1,1 %>
          <tr> 
            <td width="56" height="18" bgcolor="#EBEEF3" valign="bottom">&nbsp;<a href="javascript:openwin('../person.asp?uid=<%=rs("uname")%>','top=10,left=300,width=460,height=420')"><%=rs("iname")%></a></td>
            <td width="36" height="18" bgcolor="#EBEEF3" valign="bottom"> 
              <p align="center">[<%=rs("sex")%>]</p>
            </td>
            <td width="53" height="18" bgcolor="#EBEEF3" valign="bottom"> 
              <p align="center">[<%=rs("edu")%>]</p>
            </td>
            <td width="161" height="18" bgcolor="#EBEEF3" valign="bottom">&nbsp;<%=rs("job")%></td>
            <td width="77" height="18" bgcolor="#EBEEF3" valign="bottom"> 
              <p align="center">[<%=rs("idate")%>]</p>
            </td>
            <td width="36" height="18" bgcolor="#EBEEF3" valign="bottom"> 
              <p align="center"><a href="javascript:openwin('sendmail.asp?reid=<%=rs("uname")%>','top=10,left=300,width=460,height=420')"><font face="Wingdings" color="#000000" size="2">*</font></a>
            </td>
            <td width="30" height="18" bgcolor="#EBEEF3" valign="bottom"> 
              <p align="center"><a href="favorite.asp?del=<%=rs("uname")%>">删除</a>
            </td>
          </tr>
          <% rs.close                                                                    
             next %>
          <tr> 
            <td height="3" valign="top" colspan="7" bgcolor="#000000" width="473"> 
            </td>
          </tr>
          <tr> 
            <td width="473" height="8" valign="bottom" colspan="7"> 
              <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="74">
    <td valign="top" bgcolor="#00006A"></td>
  </tr>
  <tr> 
    <td height="12" valign="top" colspan="5" bgcolor="#396BA5"> 
      <p align="center"> 
    </td>
    <td></td>
  </tr>
</table>
  </body>
</html>
 

⌨️ 快捷键说明

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