add_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="select id from job where enid="&clng(session("id"))
rs.open sql,conn,1,1
if session("vip")=false then
if rs.recordcount>=en_max2 then
rs.close
set rs=nothing
set conn=nothing
response.write "<script language=JavaScript>" & chr(13) & "alert('普通用户招聘发布上限为"&en_max2&"个，若您需要更多的发布量，请与管理员联系！');" & "history.back()" & "</script>" 
Response.End
end if
else
if rs.recordcount>=en_vip_max2 then
rs.close
set rs=nothing
set conn=nothing
response.write "<script language=JavaScript>" & chr(13) & "alert('抱歉，您发布数量已满！');" & "history.back()" & "</script>" 
Response.End
end if
end if
rs.close
sql="insert into job(enid,job,jtzw,hka,city,zpnum,nianlings,zyes,hkas,edus,hkbs,languages,pthuas,sexs,jobtypes,marrys,computers,shisus,moneys,youxiaos,zptext) values("&session("id")&",'"&request("job")&"','"&request("jtzw")&"','"&request("hka")&"','"&request("city")&"','"&request("zpnum")&"','"&request("nianlings")&"','"&request("zyes")&"','"&request("hkas")&"','"&request("edus")&"','"&request("hkbs")&"','"&request("languages")&"','"&request("pthuas")&"','"&request("sexs")&"','"&request("jobtypes")&"','"&request("marrys")&"','"&request("computers")&"','"&request("shisus")&"','"&request("moneys")&"','"&request("youxiaos")&"','"&request("zptext")&"')"
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>"

%>