📄 queryfitmyjob.asp
字号:
<!--#include file=../conn.asp-->
<!--#include file=cookies.asp-->
<html>
<%
dim key,rs,sql,Pagesize,Allrecord,Allpage,ThisPage,id,rs1,sql1,username,selectedjob1,selectedjob2,selectedjob3
username=request.cookies("ijob")("username")
set rs=server.createobject("adodb.recordset")
sql="select username,selectedjob1,selectedjob2,selectedjob3 from [person] where username='"&username&"'"
rs.open sql,conn,1,1
selectedjob1=rs("selectedjob1")
selectedjob2=rs("selectedjob2")
selectedjob3=rs("selectedjob3")
rs.close
set rs=nothing
if request("page")="" then
ThisPage=1
else
ThisPage=request("page")
end if
set rs=server.createobject("adodb.recordset")
%>
<head>
<title>适合我的职位</title>
<link rel="stylesheet" type="text/css" href="../1.css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>适合我的职位</title>
<link rel="stylesheet" type="text/css" href="img/jobcn.css">
</head>
<SCRIPT language=JavaScript>
function showoperatealert(id)
{
if (id==1)
{
{
thisForm.target='_self';
thisForm.action="ijob.asp?oo=2";
thisForm.submit();
}
}
if (id==2)
{
{
thisForm.target='_self';
thisForm.action="../company/listalljob.asp";
thisForm.submit();
}
}
}
function CheckAll(form)
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
if (e.name != 'chkall' )
e.checked = form.chkall.checked;
}
}
//-->
</SCRIPT>
<body topmargin="0" leftmargin="0">
<!--#include file="top.asp"-->
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="778" height="146">
<tr>
<td width="171" height="146" valign="top">
<!--#include file="left.asp"--></td>
<td width="15" height="146"> </td>
<td width="588" height="146" valign="top">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="170">
<tr>
<td width="100%" height="147">
<p align="right">
<body topmargin="0" leftmargin="0">
<%
sql="select id,comid,jobs,s_WorkLocation,c_WorkLocation,llcs,tjsj,selectedjob,Adcontent,degree,Notice,renshu,zt from [jobs] where (selectedjob='"&selectedjob1&"' or selectedjob='"&selectedjob2&"' or selectedjob='"&selectedjob3&"') and zt<>1 order by id desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<table border=0 width=100% height=100 cellpadding=0><tr><td width='100%'><p align=center>对不起！没有找到任何职位</td></tr></table>"
'response.end
else
'########################################################################################
rs.Pagesize=20
Pagesize=rs.Pagesize
Allrecord=rs.Recordcount
Allpage=rs.Pagecount
if ThisPage<1 then
ThisPage=1
end if
rs.move (ThisPage-1)*Pagesize
dim k
k=0
%>
搜索记录数目：<b><font size="2" color="#FF6600"><%=AllRecord%></font></b>
<div align="center">
<FORM name=thisForm action="" method=POST>
<center>
<table width="588" border="0" cellspacing="0" cellpadding="0" class="font_9_c_black" style="border-collapse: collapse" bordercolor="#111111" height="46">
<tr>
<td bgcolor="#66CCFF" height="20" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-left-style:solid; border-left-width:1" width="48">
<p style="LETTER-SPACING: 2px; LINE-HEIGHT: 17px">
<font style="FONT-SIZE: 9pt; ">编号</font></td>
<td width="131" bgcolor="#66CCFF" height="20" align="left" style="border-bottom-style: solid; border-bottom-width: 1">
<p style="LINE-HEIGHT: 17px">招聘职位</td>
<td width="106" bgcolor="#66CCFF" height="20" align="left" style="border-bottom-style: solid; border-bottom-width: 1">
<font style="FONT-SIZE: 12px">
<span style="font-family: 宋体; ">
工作地区</span></font></td>
<td width="59" bgcolor="#66CCFF" height="20" align="left" style="border-bottom-style: solid; border-bottom-width: 1">
<p style="LINE-HEIGHT: 17px">
<span lang="zh-cn">招聘</span>人数</td>
<td width="70" bgcolor="#66CCFF" height="20" align="left" style="border-bottom-style: solid; border-bottom-width: 1">
<p style="LINE-HEIGHT: 17px" align="center">
要求学历</td>
<td width="140" bgcolor="#66CCFF" height="20" align="left" style="border-bottom-style: solid; border-bottom-width: 1">
<p align="center">
<span style="font-size: 12px; ">发</span><font style="FONT-SIZE: 12px"><span style="font-family: 宋体; ">布时间</span></font></td>
<td width="32" bgcolor="#66CCFF" height="20" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-right-style:solid; border-right-width:1">
选择</td>
</tr>
<%do while not rs.eof
set rs1=server.createobject("adodb.recordset")
sql1="select id,comid,companyName from [company] where comid='"&rs("comid")&"'"
rs1.open sql1,conn,1,1 %>
<tr>
<td width="48" bgcolor="#F9F9F9" height="25" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-left-style:solid; border-left-width:1; border-top-style:solid; border-top-width:1" bordercolor="#E0E0E0"><font color="#384249"><b><%=k+1%></b></font></td>
<td width="131" bgcolor="#F9F9F9" height="25" align="left" style="border-bottom-style: solid; border-bottom-width: 1; border-top-style:solid; border-top-width:1" bordercolor="#E0E0E0"><a target="_blank" href="../company/listalljob.asp?selectedid=<%=rs("id")%>"><%=rs("jobs")%></a></td>
<td width="106" bgcolor="#F9F9F9" height="25" align="left" style="border-bottom-style: solid; border-bottom-width: 1; border-top-style:solid; border-top-width:1" bordercolor="#E0E0E0"><%=rs("s_WorkLocation")%><%=rs("c_WorkLocation")%></td>
<td width="59" bgcolor="#F9F9F9" height="25" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-top-style:solid; border-top-width:1" bordercolor="#E0E0E0">
<p><%=rs("renshu")%>人</td>
<td width="70" bgcolor="#F9F9F9" height="25" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-top-style:solid; border-top-width:1" bordercolor="#E0E0E0">
<p>
<%dim degree
degree=rs("degree")
if degree=0 then
response.write "高中"
elseif degree=1 then
response.write "中专"
elseif degree=2 then
response.write "大专"
elseif degree=3 then
response.write "本科"
elseif degree=4 then
response.write "硕士"
elseif degree=5 then
response.write "博士"
end if
%>
</td>
<td width="140" bgcolor="#F9F9F9" height="25" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-top-style:solid; border-top-width:1" bordercolor="#E0E0E0">
<%=rs("tjsj")%></td>
<td width="32" bgcolor="#F9F9F9" height="25" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-right-style:solid; border-right-width:1; border-top-style:solid; border-top-width:1" bordercolor="#E0E0E0">
<INPUT type=checkbox value="<%=rs("id")%>" name=selectedid></td>
</tr>
<%
rs1.close
set rs1=nothing
k=k+1
if k>=Pagesize then exit do
rs.movenext
loop %>
<tr>
<td width="555" bgcolor="#FFFFFF" height="29" align="center" style="border-top-style: none; border-top-width: medium; border-bottom-style:none; border-bottom-width:medium" colspan="6" valign="bottom">
<p align="right">
<INPUT onclick=CheckAll(this.form) type=checkbox value=on name=chkall>选中所有招聘信息</td>
</tr>
<tr>
<td width="555" bgcolor="#FFFFFF" height="26" align="center" style="border-top-style: none; border-top-width: medium; border-bottom-style:none; border-bottom-width:medium" colspan="6">
<img style="CURSOR: hand" onclick=javascript:showoperatealert(1) border="0" src="../img/putfavorite_But.gif"><img style="CURSOR: hand" onclick=javascript:showoperatealert(2) border="0" src="../img/list.gif"></td>
</tr>
</table>
</center></form>
</div>
<div align="center">
<center>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="font_9_c_black" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td width="10">
</td>
<td width="200">共
<b><font color="#FF0000"><%=Allpage%></font></b>
页</td>
<td>
<table border="0" cellspacing="0" cellpadding="0" align="right" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<%
if ThisPage<2 then
response.write "<td width='10'><img name='link_r2_c1' src='../img/_1prev_.gif' width='22' height='18' border='0'></td><td width='10'><img name='link_r2_c1' src='../img/_prev_.gif' width='22' height='18' border='0'></td>"
else
response.write "<td width='10'><a href=QueryFitMyJob.asp?page=1><img name='_1prev' src='../img/_1prev.gif' width='22' height='18' border='0'></a></td>"
response.write "<td width='10'><a href=QueryFitMyJob.asp?page="&ThisPage-1&"><img name='_prev' src='../img/_prev.gif' width='22' height='18' border='0'></a></td>"
end if
%>
<td width="4">
<p align="right"> </td>
<td>
<div align="center">
<span style="font-size: 9pt">第<b><font color="#FF0000"> <%=ThisPage%> </font></b>页</span></div>
</td>
<td width="4"> </td>
<%
if Allpage-ThisPage<1 then
response.write "<td width='10'><img name='_next_' src='../img/_next_.gif' width='22' height='18' border='0'></td><td width='10'><img name='_next1_' src='../img/_next1_.gif' width='22' height='18' border='0'></td>"
else
response.write "<td width='10'><a href=QueryFitMyJob.asp?page="&(ThisPage+1)&"><img name='_prev' src='../img/_next.gif' width='22' height='18' border='0'></a></td>"
response.write "<td width='10'><a href=QueryFitMyJob.asp?page="&Allpage&"><img name='_next1' src='../img/_next1.gif' width='22' height='18' border='0'></a></td>"
end if
end if
conn.close
set conn=nothing
%>
</tr>
</table>
</td>
</tr>
</table></center>
</div>
</td>
</tr>
<tr>
<td width="100%" height="23"> </td>
</tr>
</table>
</td>
<td width="4" height="146"> </td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="778">
<tr>
<td width="100%">
<p align="center"><!--#include file="copyright.asp"--></td>
</tr>
</table>
</center>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -