📄 add.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" %>
<%@ page import="java.sql.*,qiuzhi.*" %>
<jsp:useBean id="job" class="qiuzhi.personaljob"/>
<jsp:useBean id="data" class="qiuzhi.personaljobdata"/>
<jsp:useBean id="db" class="qiuzhi.connectDB" />
<%
String action = request.getParameter("action");
if(action == null || action.length() == 0)
{
if((db.copBind((String)session.getAttribute("user_id"))) == 1)
{
ResultSet rs = db.getCopInfo((String)session.getAttribute("user_id"));
String cop_name = "";
String cop_mann = "";
String cop_cont = "";
String cop_tel = "";
String cop_mail = "";
String cop_fax = "";
String cop_addr = "";
String cop_zip = "";
String cop_www = "";
String cop_desc = "";
int cop_id = 0;
if(rs.next())
{
cop_id = rs.getInt("id");
cop_name = rs.getString("COP_NAME");
cop_mann = data.cop_mann[rs.getInt("COP_MANN")];
cop_cont = rs.getString("name");
cop_tel = rs.getString("COP_TEL");
cop_mail = rs.getString("COP_MAIL");
cop_fax = rs.getString("COP_TEX");
cop_addr = rs.getString("COP_ADDR");
cop_zip = rs.getString("COP_ZIP");
cop_www = rs.getString("COP_WWW");
cop_desc = rs.getString("COP_DESC");
}
String job_mann = null;
String job_lang = null;
String job_grad = null;
String job_expe = null;
int i=0;
for(i=0; i<data.job_grad.length; i++)
{
job_grad += "<option value=\""+i+"\">"+data.job_grad[i]+"</option>\n";
}
for(i=0; i<data.job_lang.length; i++)
{
job_lang += "<option value=\""+i+"\">"+data.job_lang[i]+"</option>\n";
}
for(i=0; i<data.job_expe.length; i++)
{
job_expe += "<option value=\""+i+"\">"+data.job_expe[i]+"</option>\n";
}
for(i=0; i<data.job_mann.length; i++)
{
job_mann += "<option value=\""+i+"\">"+data.job_mann[i]+"</option>\n";
}
%>
<html>
<head>
<title>个人求职管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css_js/style.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!-- 新版表格 -->
<table width="100%" height="100%" cellpadding="0" cellspacing="0">
<tr>
<td colspan="3" valign="top">
<!-- 新版表格结束 -->
<table width="100%" height="50" border="0" cellpadding="0" cellspacing="0" bgcolor="#30483C">
<tr>
<td width="290" valign="middle"><img src="../ima/title.gif" width="290" height="50" border="0"></td>
<td align="right" valign="bottom"><font color="#FFFFFF"> </font></td>
</tr>
</table>
<table width="100%" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="80%" align="center" background="../ima/header_bg.gif"><img src="../ima/header_arrows.gif" width="206" height="35"></td>
<td width="20%" align="center" background="../ima/header_bg.gif"> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="2">
<tr>
<td align="center">
<form action="add.jsp?action=insert&copid=<%=cop_id%>" method="post" name="form" id="form">
<table width="99%" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td background="../ima/info_bg.gif" class="text-login"> <font color="#FFFFFF"><strong>修改工作信息</strong></font></td>
</tr>
</table>
<table width="99%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#8C8A84"><table width="100%" border="0" cellspacing="1" cellpadding="2">
<tr align="center" class="text-login">
<td height="25" colspan="2" bgcolor="#EEEEEE"><strong>公司信息</strong></td>
<td height="25" colspan="2" bgcolor="#EEEEEE"><strong>职位信息</strong></td>
</tr>
<tr class="text-login">
<td width="8%" bgcolor="#FFFFFF">公司名称</td>
<td width="42%" bgcolor="#FFFFFF"><input name="cop_name" type="text" class="addinput" id="cop_name" value="<%=cop_name%>" disabled></td>
<td width="8%" bgcolor="#FFFFFF">职位名称</td>
<td width="42%" bgcolor="#FFFFFF"><input name="job_name" type="text" class="addinput" id="job_name" ></td>
</tr>
<tr class="text-login">
<td width="8%" bgcolor="#EEEEEE">公司性质</td>
<td width="42%" bgcolor="#EEEEEE"><input type="text" name="cop_mann" class="addlinput" id="cop_mann" disabled value="<%=cop_mann%>"></select></td>
<td width="8%" bgcolor="#EEEEEE">职位性质</td>
<td width="42%" bgcolor="#EEEEEE"><select name="job_mann" class="addlist" id="job_mann"><%=job_mann%></select></td>
</tr>
<tr class="text-login">
<td width="8%" bgcolor="#FFFFFF">联系人</td>
<td width="42%" bgcolor="#FFFFFF"><input name="cop_cont" type="text" class="addinput" id="cop_cont" value="<%=cop_cont%>" disabled></td>
<td width="8%" bgcolor="#FFFFFF">工作地点</td>
<td width="42%" bgcolor="#FFFFFF"><input name="job_addr" type="text" class="addinput" id="job_addr" ></td>
</tr>
<tr class="text-login">
<td width="8%" bgcolor="#EEEEEE">联系电话</td>
<td width="42%" bgcolor="#EEEEEE"><input name="cop_tel" type="text" class="addinput" id="cop_tel" value="<%=cop_tel%>" maxlength="20" disabled></td>
<td width="8%" bgcolor="#EEEEEE">招聘人数</td>
<td width="42%" bgcolor="#EEEEEE"><input name="job_num" type="text" class="addinput" id="job_num"></td>
</tr>
<tr class="text-login">
<td width="8%" bgcolor="#FFFFFF">E-mail</td>
<td width="42%" bgcolor="#FFFFFF"><strong>
<input name="cop_mail" type="text" class="addinput" id="cop_mail" value="<%=cop_mail%>" maxlength="100" disabled>
</strong></td>
<td width="8%" bgcolor="#FFFFFF">工资待遇</td>
<td width="42%" bgcolor="#FFFFFF"><input name="job_get" type="text" class="addinput" id="job_get" maxlength="20"></td>
</tr>
<tr class="text-login">
<td width="8%" bgcolor="#EEEEEE">传真</td>
<td width="42%" bgcolor="#EEEEEE"><input name="cop_fax" type="text" class="addinput" id="cop_fax" value="<%=cop_fax%>" disabled></td>
<td width="8%" bgcolor="#EEEEEE">有效期</td>
<td width="42%" bgcolor="#EEEEEE"><input name="job_sta" type="text" class="addinputtime" id="job_sta" maxlength="8">
至
<input name="job_end" type="text" class="addinputtime" id="job_end"></td>
</tr>
<tr class="text-login">
<td width="8%" bgcolor="#FFFFFF">地址</td>
<td width="42%" bgcolor="#FFFFFF"><input name="cop_addr" type="text" class="addinput" id="cop_addr" value="<%=cop_addr%>" disabled></td>
<td width="8%" bgcolor="#FFFFFF">年龄</td>
<td width="42%" bgcolor="#FFFFFF"><input name="job_age1" type="text" class="addinputtime" id="job_age1" maxlength="2">
至
<input name="job_age2" type="text" class="addinputtime" id="job_age2" maxlength="2"></td>
</tr>
<tr class="text-login">
<td width="8%" bgcolor="#EEEEEE">邮政编码</td>
<td width="42%" bgcolor="#EEEEEE"><input name="cop_zip" type="text" class="addinput" id="cop_zip" value="<%=cop_zip%>" maxlength="6" disabled></td>
<td width="8%" bgcolor="#EEEEEE">学历要求</td>
<td width="42%" bgcolor="#EEEEEE"><select name="job_grad" class="addlist" id="job_grad">
<%=job_grad%> </select></td>
</tr>
<tr class="text-login">
<td width="8%" bgcolor="#FFFFFF">网址</td>
<td width="42%" bgcolor="#FFFFFF"><input name="cop_www" type="text" class="addinput" id="cop_www" value="<%=cop_www%>" disabled></td>
<td width="8%" bgcolor="#FFFFFF">语言要求</td>
<td width="42%" bgcolor="#FFFFFF"><select name="job_lang" class="addlist" id="job_lang">
<%=job_lang%> </select></td>
</tr>
<tr class="text-login">
<td width="8%" rowspan="3" valign="top" bgcolor="#FFFFFF">公司简介</td>
<td width="42%" rowspan="3" valign="top" bgcolor="#EEEEEE"><textarea name="cop_desc" class="addtextarea" id="cop_desc" disabled><%=cop_desc%></textarea></td>
<td bgcolor="#EEEEEE">工作经验</td>
<td bgcolor="#EEEEEE"><select name="job_expe" class="addlist" id="job_expe"><%=job_expe%>
</select></td>
</tr>
<tr bgcolor="#FFFFFF" class="text-login">
<td width="8%">其它待遇</td>
<td width="42%"><input name="job_oget" type="text" class="addinput" id="job_oget" ></td>
</tr>
<tr bgcolor="#FFFFFF" class="text-login">
<td width="8%" valign="top" bgcolor="#EEEEEE">其它要求</td>
<td width="42%" valign="top" bgcolor="#EEEEEE"><textarea name="job_odem" class="addtextarea" id="job_odem"></textarea></td>
</tr>
</table></td>
</tr>
</table>
<table width="99%" border="0" cellspacing="1" cellpadding="2">
<tr>
<td height="40" align="right"><input name="Submit" type="submit" class="logbutton" value="添加">
<input type="button" class="logbutton" onClick="window.location.href='list.jsp'" value="关闭">
</td>
</tr>
</table></form>
</td>
</tr>
</table>
<!-- 新版表格 -->
</td>
</tr>
<tr>
<td height="35" background="../ima/bottom_bg.gif"><table width="110" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><img src="../ima/bottom.gif" width="110" height="35"></td>
</tr>
</table></td>
</tr>
</table>
<!-- 新版表格结束 -->
</body>
</html>
<%
}
else
{
%>
<script language="javascript">
alert("没有绑定公司");
self.location.href="list.jsp";
window.open("company.jsp");
</script>
<%
}
}
else
{
if("insert".equals(action))
{
String cop_id = request.getParameter("copid");
String job_name = request.getParameter("job_name");
if(job_name == null || job_name.equals(""))
job_name = "无";
else
job_name = new String(job_name.getBytes("ISO8859_1"));
String job_mann = request.getParameter("job_mann");
if(job_mann == null || job_mann.equals("") ||job_mann.equals("no"))
job_mann = "0";
else
job_mann = new String(job_mann.getBytes("ISO8859_1"));
String job_addr = request.getParameter("job_addr");
if(job_addr == null || job_addr.equals(""))
job_addr = "无";
else
job_addr = new String(job_addr.getBytes("ISO8859_1"));
String job_num = request.getParameter("job_num");
if(job_num == null || job_num.equals(""))
job_num = "0";
else
job_num = new String(job_num.getBytes("ISO8859_1"));
String job_get = request.getParameter("job_get");
if(job_get == null || job_get.equals(""))
job_get = "面议";
else
job_get = new String(job_get.getBytes("ISO8859_1"));
String job_sta = request.getParameter("job_sta");
if(job_sta == null || job_sta.equals(""))
job_sta = "0";
else
job_sta = new String(job_sta.getBytes("ISO8859_1"));
String job_end = request.getParameter("job_end");
if(job_end == null || job_end.equals(""))
job_end = "0";
else
job_end = new String(job_end.getBytes("ISO8859_1"));
String job_age1 = request.getParameter("job_age1");
if(job_age1 == null || job_age1.equals(""))
job_age1 = "0";
String job_age2 = request.getParameter("job_age2");
if(job_age2 == null || job_age2.equals(""))
job_age2 = "0";
String job_grad = request.getParameter("job_grad");
if(job_grad == null || job_grad.equals("") ||job_grad.equals("no"))
job_grad = "0";
String job_lang = request.getParameter("job_lang");
if(job_lang == null || job_lang.equals("") ||job_lang.equals("no"))
job_lang = "0";
String job_expe = request.getParameter("job_expe");
if(job_expe == null || job_expe.equals("") ||job_expe.equals("no"))
job_expe = "0";
String job_oget = request.getParameter("job_oget");
if(job_oget == null || job_oget.equals(""))
job_oget = "无";
else
job_oget = new String(job_oget.getBytes("ISO8859_1"));
String job_odem = job.HtmlSpecialChars(request.getParameter("job_odem"));
if(job_odem == null || job_odem.equals(""))
job_odem = "无";
else
job_odem = new String(job_odem.getBytes("ISO8859_1"));
jobTable jt = new jobTable();
jt.setCopid(cop_id);
jt.setJobname(job_name);
jt.setJobmann(job_mann);
jt.setJobget(job_get);
jt.setJobsta(job_sta);
jt.setJobend(job_end);
jt.setJobage1(job_age1);
jt.setJobage2(job_age2);
jt.setJobgrad(job_grad);
jt.setJoblang(job_lang);
jt.setJobexpe(job_expe);
jt.setJobodem(job_odem);
jt.setJoboget(job_oget);
jt.setJobnum(job_num);
jt.setJobaddr(job_addr);
int re = db.insertJob(jt);
if(re == 1)
{
%>
<script language="javascript">
alert("成功");
self.location.href="list.jsp";
</script>
<%
}
else
{
%>
<script language="javascript">
alert("失败");
self.location.href="list.jsp";
</script>
<%
}
}
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -