edit_job_db.asp

源码：asp编写的大学生毕业就业招聘信息管理系统

<!--#include file="info.asp"-->
<!--#include file="conn.asp"-->
<%
if session("id")="" or session("ac")="" or session("user")<>"2" then
response.write "<script language=JavaScript>" & chr(13) & "alert('您不具备此权限！');" & "history.back()" & "</script>" 
Response.End
end if
if request("job")="0" then
response.write "<script language=JavaScript>" & chr(13) & "alert('请选择职位类型！');" & "history.back()" & "</script>" 
Response.End
end if
if trim(request("jtzw"))="" then
response.write "<script language=JavaScript>" & chr(13) & "alert('具体位置不能为空！');" & "history.back()" & "</script>" 
Response.End
end if
if request("hka")="0" then
response.write "<script language=JavaScript>" & chr(13) & "alert('请选择工作地区！');" & "history.back()" & "</script>" 
Response.End
end if
if trim(request("city"))="" then
response.write "<script language=JavaScript>" & chr(13) & "alert('所在城市不能为空！');" & "history.back()" & "</script>" 
Response.End
end if
if trim(request("zptext"))="" then
response.write "<script language=JavaScript>" & chr(13) & "alert('岗位职责描述不能为空！');" & "history.back()" & "</script>" 
Response.End
end if
sql="update job set job='"&request("job")&"',jtzw='"&request("jtzw")&"',hka='"&request("hka")&"',city='"&request("city")&"',zpnum='"&request("zpnum")&"',nianlings='"&request("nianlings")&"',zyes='"&request("zyes")&"',hkas='"&request("hkas")&"',edus='"&request("edus")&"',hkbs='"&request("hkbs")&"',languages='"&request("languages")&"',pthuas='"&request("pthuas")&"',sexs='"&request("sexs")&"',jobtypes='"&request("jobtypes")&"',marrys='"&request("marrys")&"',computers='"&request("computers")&"',shisus='"&request("shisus")&"',moneys='"&request("moneys")&"',youxiaos='"&request("youxiaos")&"',zptext='"&request("zptext")&"' where id="&clng(request("id"))&" and enid="&clng(session("id"))
rs.open sql,conn,1,1
set rs=nothing
set conn=nothing
response.write "<script language=JavaScript>" & chr(13) & "alert('修改成功,即将返回！');"&"window.location.href = 'enjob.asp'"&" </script>"
%>