数据库编程

开发平台：
ASP/ASPX

getSearchCondition.asp：源码内容
							<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%> 
<% Option Explicit %>
<%Session.CodePage=936%> 
<!--#include file="../../FS_Inc/Const.asp" -->
<!--#include file="../../FS_Inc/Function.asp" -->
<!--#include file="../../FS_InterFace/MF_Function.asp" -->
<!--#include file="../lib/strlib.asp" -->
<!--#include file="../lib/UserCheck.asp" -->
<%
Response.Charset="GB2312"
Dim title,condition,rs,i,pid
condition=request.QueryString("condition")
pid=NoSqlHack(trim(request.QueryString("pid")))
if condition= "jobname" then
	title="请选择你要搜索的职位"
elseif condition= "workcity" then
	title="请选择你期望的工作地点"
elseif condition= "workcity2" then
	title="请选择你期望的工作地点"
else
	title="请选择要搜索的时间范围"
end if
%>
<table width="100%" border="0" align="center" cellpadding="1" cellspacing="1" class="table">
<tr class="xingmu">
<td align="center" colspan="9"><%=title%></td>
<td width="10%"><a href="#" onclick="javascript:this.parentNode.parentNode.parentNode.parentNode.parentNode.style.display='none'" class="sd">[关闭]</a></td>
</tr>
<%
	i=0
	if condition="jobname" then
		Set Rs=conn.execute("select distinct jobname from FS_AP_Job_Public")
		while not rs.eof
			if i Mod 10=0 then Response.Write("<tr>"&vbcrlf)
			i=i+1
			Response.Write("<td height='25' class='hback' onMouseOver=""this.className='hback_1'"" onMouseOut=""this.className='hback'"">&nbsp;")
			Response.Write("<a href='#' onClick=""chooseIt('JobName','"&Rs("jobname")&"')"">"&Rs("jobname")&"</a>")
			Response.Write("&nbsp;</td>")
			if i Mod 10=0 then Response.Write("</tr>"&vbcrlf)
			rs.movenext
		wend
		if i Mod 10<>0 then
			while  i Mod 10<>0
				Response.Write("<td class='hback'>&nbsp;</td>")
				i=i+1
			Wend
			Response.Write("</tr>")
		End if
	Elseif condition="workcity" then
		set Rs=Conn.execute("select pid,Province from FS_AP_Province" )
		while not rs.eof
			if i Mod 10=0 then Response.Write("<tr>"&vbcrlf)
			i=i+1
			Response.Write("<td height='25' class='hback' onMouseOver=""this.className='hback_1'"" onMouseOut=""this.className='hback'"">&nbsp;")
			Response.Write("<a href='#' onClick=""chooseIt('WorkCity','"&Rs("Province")&"','"&Rs("pID")&"')"">"&Rs("Province")&"</a>")
			Response.Write("&nbsp;</td>")
			if i Mod 10=0 then Response.Write("</tr>"&vbcrlf)
			rs.movenext
		wend
		if i Mod 10<>0 then
			while  i Mod 10<>0
				Response.Write("<td class='hback'>&nbsp;</td>")
				i=i+1
			Wend
		Response.Write("</tr>")
		End if
	Elseif condition="workcity2" then
		if pid="" then pid=0
		set Rs=Conn.execute("select City from FS_AP_City where pid="&pid )
		while not rs.eof
			if i Mod 10=0 then Response.Write("<tr>"&vbcrlf)
			i=i+1
			Response.Write("<td width='10%' height='25' class='hback' onMouseOver=""this.className='hback_1'"" onMouseOut=""this.className='hback'"">&nbsp;")
			Response.Write("<a href='#' onClick=""chooseIt('WorkCity','"&Rs("City")&"')"">"&Rs("City")&"</a>")
			Response.Write("&nbsp;</td>")
			if i Mod 10=0 then Response.Write("</tr>"&vbcrlf)
			rs.movenext
		wend
		if i Mod 10<>0 then
			while  i Mod 10<>0
				Response.Write("<td class='hback'>&nbsp;</td>")
				i=i+1
			Wend
		Response.Write("</tr>")
		End if
	Elseif condition="publicdate" then
		Response.Write("<tr>"&vbcrlf)
		Response.Write("<td width='10%' height='25' class='hback' onMouseOver=""this.className='hback_1'"" onMouseOut=""this.className='hback'"">&nbsp;")
		Response.Write("<a href='#' onClick=""chooseIt('PublicDate','近一天','','1')"">近一天</a>")
		Response.Write("&nbsp;</td>")
		
		Response.Write("<td width='10%' height='25' class='hback' onMouseOver=""this.className='hback_1'"" onMouseOut=""this.className='hback'"">&nbsp;")
		Response.Write("<a href='#' onClick=""chooseIt('PublicDate','近两天','','2')"">近两天</a>")
		Response.Write("&nbsp;</td>")
		
		Response.Write("<td width='10%' height='25' class='hback' onMouseOver=""this.className='hback_1'"" onMouseOut=""this.className='hback'"">&nbsp;")
		Response.Write("<a href='#' onClick=""chooseIt('PublicDate','近三天','','3')"">近三天</a>")
		Response.Write("&nbsp;</td>")		
		
		Response.Write("<td width='10%' height='25' class='hback' onMouseOver=""this.className='hback_1'"" onMouseOut=""this.className='hback'"">&nbsp;")
		Response.Write("<a href='#' onClick=""chooseIt('PublicDate','近一周','','7')"">近一周</a>")
		Response.Write("&nbsp;</td>")
	
		Response.Write("<td width='10%' height='25' class='hback' onMouseOver=""this.className='hback_1'"" onMouseOut=""this.className='hback'"">&nbsp;")
		Response.Write("<a href='#' onClick=""chooseIt('PublicDate','近两周','','14')"">近两周</a>")
		Response.Write("&nbsp;</td>")	
				
		Response.Write("<td width='10%' height='25' class='hback' onMouseOver=""this.className='hback_1'"" onMouseOut=""this.className='hback'"">&nbsp;")
		Response.Write("<a href='#' onClick=""chooseIt('PublicDate','近一月','','30')"">近一月</a>")
		Response.Write("&nbsp;</td>")	
				
		Response.Write("<td width='10%' height='25' class='hback' onMouseOver=""this.className='hback_1'"" onMouseOut=""this.className='hback'"">&nbsp;")
		Response.Write("<a href='#' onClick=""chooseIt('PublicDate','近六周','','42')"">近六周</a>")
		Response.Write("&nbsp;</td>")	
		
		Response.Write("<td width='10%' height='25' class='hback' onMouseOver=""this.className='hback_1'"" onMouseOut=""this.className='hback'"">&nbsp;")
		Response.Write("<a href='#' onClick=""chooseIt('PublicDate','近两月','','60')"">近两月</a>")
		Response.Write("&nbsp;</td>")	
	
		Response.Write("<td class='hback'>&nbsp;</td>")
		Response.Write("<td class='hback'>&nbsp;</td>")
		Response.Write("</tr>"&vbcrlf)
	End if
%>
</table>
<%
Conn.close
User_Conn.close
Set Conn=nothing
Set User_Conn=nothing
%>

						