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

📄 jobsearlt.asp

📁 本程序所有数据库文件都以.sql文件保存在Database文件夹里; 2、首先在SQL查询分析器中运行CreateDatabase.sql文件创建数据库; 3、运行其他所有的.sql文件即可创建好了本
💻 ASP
字号:
<!--#include file="../conndb.asp"-->
<!--#include file="isAdmin.asp"-->
<html>
<head>
<title>招聘信息管理</title>
<link rel="stylesheet" href="../style.css">
<script language="JavaScript">
function newwin(url) {
  var newwin=window.open(url,"newwin","toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,width=500,height=500");
  newwin.focus();
  return false;
}
</script>
</head>
<body link="#000080" vlink="#008080">
<h3><p align="center">招聘信息查询结果</p></h3>
<table width='83%' align=center cellspacing=1 cellpadding=2 border=1 bordercolor="#5A8FF0">
  <tr>
    <td align="center" width='15%' bgcolor="#5A8FF0"><b>职位ID</b></td>
    <td align="center" width='15%' bgcolor="#5A8FF0"><b>企业ID</b></td>
    <td align="center" width='20%' bgcolor="#5A8FF0"><b>企业名称</b></td>
    <td align="center" width='20%' bgcolor="#5A8FF0"><b>招聘职位</b></td>
    <td align="center" width='20%' bgcolor="#5A8FF0"><b>发布时间</b></td>
    <td align="center" width='15%' bgcolor="#5A8FF0"><b>删 除</b></td>
  </tr>
<%
  Dim sltCnd,sql,sKey
  sltCnd = Request("slt")
  sKey = Request("key")
  
  If sltCnd="company" Then
    sql = "Select j.*,c.* From Job j,Company c Where j.UserName=c.CName And c.Company Like '%"&sKey&"%' Order By j.PostTime Desc"
  ElseIf sltCnd="username" Then
    sql = "Select * From Job Where UserName like '%"&sKey&"%' Order By PostTime Desc"
  End If
%>  
<%
  Set rs = Server.CreateObject("ADODB.RECORDSET")
  rs.Open sql,Conn,1,3
  If Not rs.EOF Then
    rs.PageSize=20
    rs.AbsolutePage =1
    If Request("page")<>"" Then rs.AbsolutePage =Request("page") 
    RowCount =rs.PageSize
%> 
<%
    Do While Not rs.EOF And RowCount>0
%>
  <tr>
    <td><%=rs("JobId")%></td>
    <td><%=rs("CName")%></td>
    <td><a href="../CompView.asp?uid=<%=rs("Cname")%>" onClick="return newwin(this.href)"><%=rs("Company")%></a></td>
    <td><a href='../JobView.asp?jid=<%=rs("JobId")%>' onClick='return newwin(this.href)'><%=rs("Title")%></a></td>
    <td><%=rs("PostTime")%></td>
    <td align="center"><a href=JobDelt.asp?jobid=<%=rs("JobId")%> onClick="return newwin(this.href)">删除</a></td>
  </tr>
  <%
      rs.MoveNext
      RowCount = RowCount-1
    Loop
%>
<%
		If rs.PageCount>1 Then

			Response.Write "<table border='0'>"
			Response.Write "<tr>"
			Response.Write "<td><b>分页:</b></td>"
			For i=1 To rs.PageCount
			Response.Write "<td><a href='../Information.asp?m="&flg&"&page=" & i & "'>"
			Response.Write "[<b>" & i & "</b>]</a>"
			Response.Write "</td>"
			Next

			Response.Write "</tr></table>"
		End If

  Else
    Response.Write "没有符合条件的职位信息"
  End If
%>
</table>
<p align=center><a href="javascript:history.go(-1);">[ 返 回 ]</a>
</body>
</html>

⌨️ 快捷键说明

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