各位高手,我的网站有个应聘申请程序,想把申请的职位直接从数据库中调出,测试了半天不知道怎么办。看下图:
就是那个应聘岗位,我想把它跟数据库结合,自动选择。 有两个表:一个表名Jobbook 一个为Job Job 中工作岗位的字段名Duix :Jobbook工作岗位的字段名为jobname.后台加的岗位信息全部提交在Job 这个表中 上图提交表上的的部分代码为: <form method="post" action="SaveAcceptJob.asp"> <table width="80%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="100%"> <div align="center"> <table width="100%" height="79" border="0" align="center" cellpadding="0" cellspacing="3"> <tr> <%job=request("job")%> <td width="23%" height="25" align="right">应聘岗位: </td> <td width="77%" height="25"><b><%=Duix%></b><input name="jobname" type="hidden" value="<%=Duix%>"></td> </tr> 关键是红色的部分,提交的时候由SaveAcceptJob.asp 验证会出现没有输入应聘岗位的错误提示 SaveAcceptJob.asp 的代码: <!--#include file="Inc/Conn.asp"--> <!--#include file="Inc/articleCHAR.INC"--> <% If request.form("Duix")="" Then Response.Write("<script language=""JavaScript"">alert(""错误:您没输入应聘岗位,请返回检查!!"");history.go(-1);</script>") response.end end if If request.form("mane")="" Then Response.Write("<script language=""JavaScript"">alert(""错误:您没输入姓名,请返回检查!!"");history.go(-1);</script>") response.end end if If request.form("sex")="" Then Response.Write("<script language=""JavaScript"">alert(""错误:您没输入性别,请返回检查!!"");history.go(-1);</script>") response.end end if If request.form("birthday")="" Then Response.Write("<script language=""JavaScript"">alert(""错误:您没输入出生日期,请返回检查!!"");history.go(-1);</script>") response.end end if If request.form("marry")="" Then Response.Write("<script language=""JavaScript"">alert(""错误:您没输入婚姻状况,请返回检查!!"");history.go(-1);</script>") response.end end if If request.form("school")="" Then Response.Write("<script language=""JavaScript"">alert(""错误:您没输入毕业院校,请返回检查!!"");history.go(-1);</script>") response.end end if If request.form("studydegree")="" Then Response.Write("<script language=""JavaScript"">alert(""错误:您没输入学 历,请返回检查!!"");history.go(-1);</script>") response.end end if If request.form("specialty")="" Then Response.Write("<script language=""JavaScript"">alert(""错误:您没输入专 业,请返回检查!!"");history.go(-1);</script>") response.end end if If request.form("gradyear")="" Then Response.Write("<script language=""JavaScript"">alert(""错误:您没输入毕业时间,请返回检查!!"");history.go(-1);</script>") response.end end if If request.form("telephone")="" Then Response.Write("<script language=""JavaScript"">alert(""错误:您没输入电 话,请返回检查!!"");history.go(-1);</script>") response.end end if If request.form("email")="" Then Response.Write("<script language=""JavaScript"">alert(""错误:您没输入E-mail,请返回检查!!"");history.go(-1);</script>") response.end end if If request.form("address")="" Then Response.Write("<script language=""JavaScript"">alert(""错误:您没输入联系地址,请返回检查!!"");history.go(-1);</script>") response.end end if If request.form("ability")="" Then Response.Write("<script language=""JavaScript"">alert(""错误:您没输入水平与能力,请返回检查!!"");history.go(-1);</script>") response.end end if If request.form("resumes")="" Then Response.Write("<script language=""JavaScript"">alert(""错误:您没输入个人简历,请返回检查!!"");history.go(-1);</script>") response.end end ifSet rs = Server.CreateObject("ADODB.Recordset") sql="select * from jobbook" rs.open sql,conn,1,3
rs.addnew rs("jobname")=request.form("Duix") rs("mane")=request.form("mane") rs("sex")=request.form("sex") rs("birthday")=request.form("birthday") rs("marry")=request.form("marry") rs("school")=request.form("school") rs("studydegree")=request.form("studydegree") rs("specialty")=request.form("specialty") rs("gradyear")=request.form("gradyear") rs("telephone")=request.form("telephone") rs("email")=request.form("email") rs("address")=request.form("address") rs("ability")=htmlencode2(request.form("ability")) rs("resumes")=htmlencode2(request.form("resumes")) rs("time")=now() rs.update rs.close response.write"<SCRIPT language=JavaScript>alert('应聘申请已提交成功!');" response.write"javascript:history.go(-2)</SCRIPT>" %> 请各位高手帮忙修改以下,看能不能是后台加的岗位信息全部在上图应聘岗位后面自动显示出来 万分感谢啊!!!!!!!!!! 急!!
[此贴子已经被作者于2005-6-30 2:31:51编辑过]