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

📄 xueli_chk.asp

📁 人才招聘系统,用asp做的
💻 ASP
字号:
🔍 
<!--#include file=../conn.asp-->
<%
dim rs,id,sql,comid,rs1,sql1,jilu,ThisPage,k,cmdTemp
dim Allrecord,Pagesize,Allpage
if request("page")="" then
      ThisPage=1		
else
      ThisPage=request("page")
end if
id=trim(request("id"))
if not isnumeric(id) or len(id)>1 then
response.write "参数错误！"
response.end
end if
if id>5 then
response.write "参数错误！"
response.end
end if
Set cmdTemp = Server.CreateObject("ADODB.Command")
set rs1 = server.CreateObject ("adodb.recordset")
sql1="select id,jobs,dysp,sex,s_WorkLocation,degree,tjsj from [jobs] where degree>='"&id&"' and zt<>1"
cmdTemp.CommandText = sql1
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = conn   
rs1.Open cmdTemp, , 1, 1
set cmdTemp=nothing
Allrecord=rs1.Recordcount
rs1.Pagesize=15
Pagesize=rs1.Pagesize
Allrecord=rs1.Recordcount
Allpage=rs1.Pagecount
if ThisPage<1 then                          
ThisPage=1                           
end if   
k=0
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">

<title>按要求学历搜索的结果</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<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_nbGroup(event, grpName) { //v6.0
var i,img,nbArr,args=MM_nbGroup.arguments;
  if (event == "init" && args.length > 2) {
    if ((img = MM_findObj(args[2])) != null && !img.MM_init) {
      img.MM_init = true; img.MM_up = args[3]; img.MM_dn = img.src;
      if ((nbArr = document[grpName]) == null) nbArr = document[grpName] = new Array();
      nbArr[nbArr.length] = img;
      for (i=4; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) != null) {
        if (!img.MM_up) img.MM_up = img.src;
        img.src = img.MM_dn = args[i+1];
        nbArr[nbArr.length] = img;
    } }
  } else if (event == "over") {
    document.MM_nbOver = nbArr = new Array();
    for (i=1; i < args.length-1; i+=3) if ((img = MM_findObj(args[i])) != null) {
      if (!img.MM_up) img.MM_up = img.src;
      img.src = (img.MM_dn && args[i+2]) ? args[i+2] : ((args[i+1])?args[i+1] : img.MM_up);
      nbArr[nbArr.length] = img;
    }
  } else if (event == "out" ) {
    for (i=0; i < document.MM_nbOver.length; i++) { img = document.MM_nbOver[i]; img.src = (img.MM_dn) ? img.MM_dn : img.MM_up; }
  } else if (event == "down") {
    nbArr = document[grpName];
    if (nbArr) for (i=0; i < nbArr.length; i++) { img=nbArr[i]; img.src = img.MM_up; img.MM_dn = 0; }
    document[grpName] = nbArr = new Array();
    for (i=2; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) != null) {
      if (!img.MM_up) img.MM_up = img.src;
      img.src = img.MM_dn = (args[i+1])? args[i+1] : img.MM_up;
      nbArr[nbArr.length] = img;
  } }
}

function MM_preloadImages() { //v3.0
 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
   var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
   if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

//-->
</script>
</head>
<body bgcolor="#ffffff" onLoad="MM_preloadImages('mb/index_r2_c1_f2.jpg','mb/index_r2_c1_f3.jpg','mb/index_r4_c1_f2.jpg','mb/index_r4_c1_f3.jpg','mb/index_r6_c1_f2.jpg','mb/index_r6_c1_f3.jpg','mb/index_r8_c1_f2.jpg','mb/index_r8_c1_f3.jpg','mb/index_r10_c1_f2.jpg','mb/index_r10_c1_f3.jpg');">
<div align="center">
  <center>
<table border="0" cellpadding="0" cellspacing="0" width="760" style="border-collapse: collapse" bordercolor="#111111">
  <tr>
   <td style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1" bordercolor="#D1D1D1"><table border="0" cellpadding="0" cellspacing="0" width="760">
	  <tr>
	   <td>
       <img name="index_r1_c1" src="mb/index_r1_c1.jpg" border="0" alt=""></td>
	   <td>
       <map name="FPMap0">
       <area href="../index.asp" shape="rect" coords="175, 132, 234, 151">
       <area href="../person" shape="rect" coords="264, 131, 335, 150">
       <area href="../company" shape="rect" coords="368, 132, 441, 150">
       <area href="../company/Section" shape="rect" coords="469, 131, 544, 151">
       </map>
       <img name="index_r1_c3" src="mb/index_r1_c3.jpg" border="0" alt="" usemap="#FPMap0"></td>
	  </tr>
	</table></td>
  </tr>
  <tr>
   <td style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1" bordercolor="#D1D1D1"><table border="0" cellpadding="0" cellspacing="0" width="760">
	  <tr>
	   <td>
       <a onMouseOut="MM_nbGroup('out');" onMouseOver="MM_nbGroup('over','index_r2_c1','mb/index_r2_c1_f2.jpg','mb/index_r2_c1_f3.jpg',1);" onClick="MM_nbGroup('down','navbar1','index_r2_c1','mb/index_r2_c1_f3.jpg',1);" href="index.asp">
       <img name="index_r2_c1" src="mb/index_r2_c1.jpg" border="0" alt=""></a></td>
	   <td>
       <img name="index_r2_c2" src="mb/index_r2_c2.jpg" border="0" alt=""></td>
	   <td background="mb/index_r2_c3.jpg" width="560" height="22">
       <p align="right"><span style="font-size: 9pt">记录总数：<font color="#FF0000"><%=Allrecord%></font></span></td>
	   <td>
       <img name="index_r2_c4" src="mb/index_r2_c4.jpg" border="0" alt=""></td>
	  </tr>
	</table></td>
  </tr>
  <tr>
   <td style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1" bordercolor="#D1D1D1"><table border="0" cellpadding="0" cellspacing="0" width="760">
	  <tr>
	   <td valign="top">
       <table border="0" cellpadding="0" cellspacing="0" width="155" height="183">
		  <tr>
		   <td height="2">
           <img name="index_r3_c1" src="mb/index_r3_c1.jpg" border="0" alt=""></td>
		  </tr>
		  <tr>
		   <td valign="top" height="22">
           <a onMouseOut="MM_nbGroup('out');" onMouseOver="MM_nbGroup('over','index_r4_c1','mb/index_r4_c1_f2.jpg','mb/index_r4_c1_f3.jpg',1);" onClick="MM_nbGroup('down','navbar1','index_r4_c1','mb/index_r4_c1_f3.jpg',1);" href="xueli.asp">
           <img name="index_r4_c1" src="mb/index_r4_c1.jpg" border="0" alt=""></a></td>
		  </tr>
		  <tr>
		   <td height="2">
           <img name="index_r5_c1" src="mb/index_r5_c1.jpg" border="0" alt=""></td>
		  </tr>
		  <tr>
		   <td height="22">
           <a onMouseOut="MM_nbGroup('out');" onMouseOver="MM_nbGroup('over','index_r6_c1','mb/index_r6_c1_f2.jpg','mb/index_r6_c1_f3.jpg',1);" onClick="MM_nbGroup('down','navbar1','index_r6_c1','mb/index_r6_c1_f3.jpg',1);" href="daiyu.asp">
           <img name="index_r6_c1" src="mb/index_r6_c1.jpg" border="0" alt=""></a></td>
		  </tr>
		  <tr>
		   <td height="2">
           <img name="index_r7_c1" src="mb/index_r7_c1.jpg" border="0" alt=""></td>
		  </tr>
		  <tr>
		   <td height="22">
           <a onMouseOut="MM_nbGroup('out');" onMouseOver="MM_nbGroup('over','index_r8_c1','mb/index_r8_c1_f2.jpg','mb/index_r8_c1_f3.jpg',1);" onClick="MM_nbGroup('down','navbar1','index_r8_c1','mb/index_r8_c1_f3.jpg',1);" href="diqu.asp">
           <img name="index_r8_c1" src="mb/index_r8_c1.jpg" border="0" alt=""></a></td>
		  </tr>
		  <tr>
		   <td height="2">
           <img name="index_r9_c1" src="mb/index_r9_c1.jpg" border="0" alt=""></td>
		  </tr>
		  <tr>
		   <td height="22">
           <a onMouseOut="MM_nbGroup('out');" onMouseOver="MM_nbGroup('over','index_r10_c1','mb/index_r10_c1_f2.jpg','mb/index_r10_c1_f3.jpg',1);" onClick="MM_nbGroup('down','navbar1','index_r10_c1','mb/index_r10_c1_f3.jpg',1);" href="shijian.asp">
           <img name="index_r10_c1" src="mb/index_r10_c1.jpg" border="0" alt=""></a></td>
		  </tr>
		  <tr>
		   <td height="32">
           <img name="index_r11_c1" src="mb/index_r11_c1.jpg" border="0" alt=""></td>
		  </tr>
		  <tr>
		   <td background="mb/index_r12_c1.jpg" width="155" height="55" valign="top" style="border-bottom-style: solid; border-bottom-width: 1">
           <p>　</td>
		  </tr>
		</table></td>
	   <td background="mb/index_r3_c2.jpg" width="23" height="152">　</td>
	   <td width="560" height="152" valign="top">
       <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="560">
   <%
   if rs1.eof or rs1.bof then
   response.write "<span style=""font-size: 9pt""><li>没有找到相关职位！</span>"
   else
   %>
         <tr>
           <td width="155" height="25" background="../mb/bg.gif"><font color="#008000"><span style="font-size: 9pt">
           职位名称</span></font></td>
           <td width="62" height="25" background="../mb/bg.gif">
           <p align="center"><font color="#008000"><span style="font-size: 9pt">工作地区</span></font></td>
           <td width="56" height="25" background="../mb/bg.gif">
           <p align="center"><font color="#008000"><span style="font-size: 9pt">要求性别</span></font></td>
           <td width="69" height="25" background="../mb/bg.gif">
           <p align="center"><font color="#008000"><span style="font-size: 9pt">要求学历</span></font></td>
           <td width="75" height="25" background="../mb/bg.gif">
           <p align="center"><font color="#008000"><span style="font-size: 9pt">工资待遇</span></font></td>
           <td width="143" height="25" background="../mb/bg.gif">
           <p align="center"><font color="#008000"><span style="font-size: 9pt">发布时间</span></font></td>
         </tr>
   <%
   do while not rs1.eof
   %>
         <tr>
           <td width="155" height="25"><span style="font-size: 9pt"><a target="_blank" href="../company/listalljob.asp?selectedid=<%=rs1("id")%>"><%=rs1("jobs")%></a></span></td>
           <td width="62" height="25">
           <p align="center"><span style="font-size: 9pt"><%=rs1("s_WorkLocation")%></span></td>
           <td width="56" height="25">
           <p align="center"><span style="font-size: 9pt">
<%dim sex1
sex1=rs1("sex")
if sex1="0" then
  response.write "不限"
elseif sex1="1" then
  response.write "男"
elseif sex1="2" then
  response.write "女"
end if
%>
</span></td>
           <td width="69" height="25">
           <p align="center"><span style="font-size: 9pt">
<%
dim xueli
xueli=rs1("degree")
if xueli=0 then
  response.write "高中"
elseif xueli=1 then
  response.write "中专"
elseif xueli=2 then
  response.write "大专"
elseif xueli=3 then
  response.write "本科"
elseif xueli=4 then
  response.write "硕士"
elseif xueli=5 then
  response.write "博士"
end if
%>
           </span></td>
           <td width="75" height="25">
           <p align="center"><span style="font-size: 9pt"><%if rs1("dysp")<>0 then%><%=rs1("dysp")%><%else%>面议<%end if%></span></td>
           <td width="143" height="25">
           <p align="center"><span style="font-size: 9pt"><%=rs1("tjsj")%></span></td>
         </tr>
<%
   k=k+1
   if k>=Pagesize+1 then exit do
   rs1.movenext
   loop
   rs1.close
   set rs1=nothing
%>
        <tr>
           <td width="560" colspan="6">

           <p>
<span style="font-size: 9pt"></span>
           </td>
         </tr>
         <tr>
           <td width="560" colspan="6" height="10"></td>
         </tr>
         <tr>
           <td width="280" colspan="3" background="../mb/bg.gif" height="22">
<p align="center"><span style="font-size: 9pt"><font color="#FF0000">总共<%=Allpage%>页</font>&nbsp;&nbsp;&nbsp;&nbsp; 
</span></td>
           <td width="280" colspan="3" background="../mb/bg.gif" height="22"><span style="font-size: 9pt">
<%
  if ThisPage<2 then
  response.write "<font color=""#000000"">首页</font>&nbsp;&nbsp;"
  response.write "<font color=""#000000"">上一页</font>&nbsp;&nbsp;"
  else
  response.write "<a style=""text-decoration: none"" href=?page=1&id="&id&"><font color=""#000000"">首页</font></a>&nbsp;&nbsp;"
  response.write "<a style=""text-decoration: none"" href=?page="&ThisPage-1&"&id="&id&"><font color=""#000000"">上一页</font></a>&nbsp;&nbsp;"  
  end if
  response.write "<font color=""#ff0000"">当前第"&ThisPage&"页</font>&nbsp;&nbsp;"
  if Allpage-ThisPage<1 then
  response.write "<font color=""#000000"">下一页</font>&nbsp;&nbsp;"   
  response.write "<font color=""#000000"">末页</font>"
  else
  response.write "<a style=""text-decoration: none"" href=?page="&(ThisPage+1)&"&id="&id&"><font color=""#000000"">下一页</font></a>&nbsp;&nbsp;"   
  response.write "<a style=""text-decoration: none"" href=?page="&Allpage&"&id="&id&"><font color=""#000000"">末页</font></a>"  
  end if 
  end if  
  %>
  
  </span></td>
         </tr>
         <tr>
           <td width="560" colspan="6">
　</td>
         </tr>
       </table>
       </td>
	   <td background="mb/index_r3_c4.jpg" width="22" height="152">　</td>
	  </tr>
	</table></td>
  </tr>
  </table>
  </center>
</div>
</body>
</html>
<!--#include file=eof.asp-->
<%
closedb
%>

⌨️ 快捷键说明

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