⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 jobedit.asp

📁 本程序所有数据库文件都以.sql文件保存在Database文件夹里; 2、首先在SQL查询分析器中运行CreateDatabase.sql文件创建数据库; 3、运行其他所有的.sql文件即可创建好了本
💻 ASP
字号:
<!--#include file="../conndb.asp"-->
<!--#include file="isUser.asp"-->
<html>
<head>
<title>编辑招聘信息</title>
<link rel="stylesheet" href="../style.css">
<Script Language="JavaScript">
//域校验
function CheckFlds(){
  if (document.form1.title.value==""){
   alert("请输入招聘职位!");
   form1.title.focus;
   return false;
 } 
return true;
}
</Script>
</head>
<%
  Function changechr(str) 
   changechr = Replace(str,"&nbsp;"," ")
   changechr = Replace(changechr,"<br>",Chr(13))
  End Function

  Dim Uname,JobTitle,JobType,Education,Age,Sex,WkYear,WkPlace,Comment,Num,JobId,Company
  Dim Action
  '变量初始化
  Action = "add"
  JobTitle = ""
  JobType = ""
  Education = ""
  Age = ""
  Sex = ""
  WkYear = ""
  WkPlace = ""
  Comment = ""
  Num = 1
  Company = ""
  '读取参数jid
  JobId = Request.QueryString("jid")
  PDate = Now
  
  If JobId <> "" Then
    '编辑招聘记录
    Action = "edit"
    Set rs = Server.CreateObject("ADODB.RECORDSET")
    '设置SELECT语句,读取招聘记录数据
    sql = "Select j.*,c.Company From Job j,Company c Where j.UserName='"& Session("user_id") &"' And j.JobId="&JobId&" And j.UserName=c.CName"
    rs.Open sql,Conn,1,3
    If Not rs.EOF Then
      JobTitle = rs("Title")
      JobType = rs("Type")
      Education = rs("Education")
      Age = rs("Age")
      Sex = rs("Sex")
      WkYear = rs("WorkTime")
      WkPlace = rs("WorkPlace")
      Comment = changechr(rs("Comment"))
      Num = rs("JobNum")
      Company = rs("Company")
      PDate = rs("PostTime")
    End If
  Else
    '添加招聘记录时,读取企业信息
    sql = "Select * From Company Where CName='" & Session("user_id") & "'"
    Set rs = Conn.Execute(sql)
    If Not rs.EOF Then
      Company = rs("Company")
    End If

  End If
%>
<body leftmargin="1" topmargin="0">
<form name="form1" method="POST" action="JobSave.asp?action=<%=Action%>&jid=<%=JobId%>" onsubmit="return CheckFlds()">
 <table border="1" cellspacing="0" width="550" bordercolor="#64B9E1" bordercolorlight="#64B9E1" bordercolordark="#FFFFFF">
    <tr>
      <td bgcolor="#FFFFFF" colspan="2" background="../pic/job.gif" height="90">
      <p align="center"><b><font face="华文彩云" color="#000080" size="6">招聘信息</font></b></p>
      </td>
    </tr>
    <tr>
      <td width="20%" bgcolor="#CEE7FF">公司名称</td>
      <td width="80%"><%=Company%></td>
    </tr>
    <tr>
      <td bgcolor="#CEE7FF">发布日期</td>
      <td><%=Pdate%></td>
    </tr>
    <tr>
      <td bgcolor="#CEE7FF">招聘职位</td>
      <td><input type="text" name="title" size="20" value="<%=JobTitle%>"></td>
    </tr>
    <tr>
      <td bgcolor="#CEE7FF">职位类别</td>
      <td><select size="1" name="type">
          <option selected value="<%=JobType%>"><%=JobType%></option>
          <option value="计算机">计算机</option>
          <option value="信息管理">信息管理</option>
          <option value="医药卫生">医药卫生</option>
          <option value="机械设计">机械设计</option>
          <option value="生物化学">生物化学</option>
          <option value="文学编辑">文学编辑</option>
        </select></td>
    </tr>
    <tr>
      <td bgcolor="#CEE7FF">学历要求</td>
      <td><select size="1" name="education">
          <option selected value="<%=Education%>"><%=Education%></option>
          <option value="本科">本科</option>
          <option value="大专">大专</option>
          <option value="硕士">硕士</option>
          <option value="博士">博士</option>
          <option value="高中">高中</option>
          <option value="中专">中专</option>
          <option value="不限">不限</option>
         </select></td>
    </tr>
    <tr>
      <td bgcolor="#CEE7FF">性别要求</td>
      <td><select size="1" name="sex">
          <option selected value="<%=Sex%>"><%=Sex%></option>
          <option value="男">男</option>
          <option value="女">女</option>
          <option value="不限">不限</option>
        </select></td>
    </tr>
    <tr>
      <td bgcolor="#CEE7FF">年龄要求</td>
      <td><select size="1" name="age">
          <option selected value="<%=Age%>"><%=Age%></option>
          <option value="20-25岁">20-25岁</option>
          <option value="25-30岁">25-30岁</option>
          <option value="30-35岁">30-35岁</option>
          <option value="不限">不限</option>
        </select></td>
    </tr>
    <tr>
      <td bgcolor="#CEE7FF">工作年限</td>
      <td><select size="1" name="worktime">
          <option selected value="<%=WkYear%>"><%=WkYear%></option>
          <option value="一年以上">一年以上</option>
          <option value="二年以上">二年以上</option>
          <option value="三年以上">三年以上</option>
          <option value="五年以上">五年以上</option>
          <option value="十年以上">十年以上</option>
          <option value="不限">不限</option>
        </select></td>
    </tr>
    <tr>
      <td bgcolor="#CEE7FF">招聘人数</td>
      <td><input type="text" name="num" size="10" value="<%=Num%>"></td>
    </tr>
    <tr>
      <td bgcolor="#CEE7FF">工作地区</td>
      <td><input type="text" name="workplace" size="20" value="<%=WkPlace%>"></td>
    </tr>
    <tr>
      <td bgcolor="#CEE7FF">具体要求</td>
      <td><textarea rows="4" name="comment" cols="50"><%=Comment%></textarea></td>
    </tr>
  </table>
  <p align=center><input type="submit" value=" 提 交 " name="B1">
  <input type="reset" value=" 重 写 " name="B2"></p>
</form>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -