action.jsp

个人求职管理系统》可以让你在找工作的过程中方便地记录你所选中的公司信息、职位信息、发送的简历和公司的回复

<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<jsp:useBean id="td_pjm" class="td.personaljob"/>
<jsp:useBean id="td_pjm_data" class="td.personaljobdata"/>
<%@ include file="lib/config.jsp" %>
<%
		if(!td_pjm.init(mysqlDriver,mysqlUrl,mysqlUser,mysqlPsw))
		{
		    out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert(\"Fail to Connect MySQL Server!  Please check the settings!\");window.close();</script>");
		}
		
%>
<%@ include file="lib/everyinc.jsp" %>
<%
		
		String action = request.getParameter("action");
		if(action == null || action.equals(""))
		{
		    out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert(\"Wrong action!\");window.location.href=\"list.jsp\";</script>");
		}
		else if(action.equals("edit"))
		{
		    String id = request.getParameter("id");
				if(id == null || id.equals(""))
				{
				    out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert(\"Miss job ID!\");window.location.href=\"list.jsp\";</script>");
				}
				else
				{
				    ResultSet res = td_pjm.getAllInfo(id);
						if(res == null)
						{
						    out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert(\"没有对应的信息！\");window.location.href=\"list.jsp\";</script>");
						}
						else
						{
						    res.next();
						    String cop_name = res.getString("cop_name");
								
								String cop_mann = null;
								int i = 0;
								for(i = 0;i<td_pjm_data.cop_mann.length;i++)
								{
								    if(i == res.getInt("cop_mann"))
										    cop_mann += "<option value=\""+i+"\" selected>"+td_pjm_data.cop_mann[i]+"</option>\n";
										else
										    cop_mann += "<option value=\""+i+"\">"+td_pjm_data.cop_mann[i]+"</option>\n";
								}
								
								String cop_cont = res.getString("cop_cont");
								String cop_tel = res.getString("cop_tel");
								String cop_mail = res.getString("cop_mail");
								String cop_fax = res.getString("cop_fax");
								String cop_addr = res.getString("cop_addr");
								String cop_zip = res.getString("cop_zip");
								String cop_www = res.getString("cop_www");
								String cop_desc = res.getString("cop_desc");
								
								String job_name = res.getString("job_name");
								String job_mann = null;
								for(i = 0;i<td_pjm_data.job_mann.length;i++)
								{
								    if(i == res.getInt("job_mann"))
										    job_mann += "<option value=\""+i+"\" selected>"+td_pjm_data.job_mann[i]+"</option>\n";
										else
										    job_mann += "<option value=\""+i+"\">"+td_pjm_data.job_mann[i]+"</option>\n";
								}
								
								String job_addr = res.getString("job_addr");
								int job_num = res.getInt("job_num");
								String job_get = res.getString("job_get");
								int job_sta = res.getInt("job_sta");
								int job_end = res.getInt("job_end");
								int job_age1 = res.getInt("job_age1");
								int job_age2 = res.getInt("job_age2");
								String job_grad = null;
								for(i = 0;i<td_pjm_data.job_grad.length;i++)
								{
								    if(i == res.getInt("job_grad"))
										    job_grad += "<option value=\""+i+"\" selected>"+td_pjm_data.job_grad[i]+"</option>\n";
										else
										    job_grad += "<option value=\""+i+"\">"+td_pjm_data.job_grad[i]+"</option>\n";
								}
								
								String job_lang = null;
								for(i = 0;i<td_pjm_data.job_lang.length;i++)
								{
								    if(i == res.getInt("job_lang"))
										    job_lang += "<option value=\""+i+"\" selected>"+td_pjm_data.job_lang[i]+"</option>\n";
										else
										    job_lang += "<option value=\""+i+"\">"+td_pjm_data.job_lang[i]+"</option>\n";
								}
								
								String job_expe = null;
								for(i = 0;i<td_pjm_data.job_expe.length;i++)
								{
								    if(i == res.getInt("job_expe"))
										    job_expe += "<option value=\""+i+"\" selected>"+td_pjm_data.job_expe[i]+"</option>\n";
										else
										    job_expe += "<option value=\""+i+"\">"+td_pjm_data.job_expe[i]+"</option>\n";
								}
								String job_odem = res.getString("job_odem");
								String job_oget = res.getString("job_oget");
								%>
								<%@ include file="lib/edit.htm" %>
								<%
						}
				}
		}
		else if(action.equals("editing"))
		{
				String id = request.getParameter("id");
				if(id == null || id.equals(""))
				{
				    out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert(\"Miss Job ID!\");window.location.href=\"list.jsp\";</script>");
				}
				String cop_name = request.getParameter("cop_name"); if(cop_name == null || cop_name.equals("")) cop_name = "无";
				String cop_mann = request.getParameter("cop_mann"); if(cop_mann == null || cop_mann.equals("") ||cop_mann.equals("no")) cop_mann = "0";
				String cop_cont = request.getParameter("cop_cont"); if(cop_cont == null || cop_cont.equals("")) cop_cont = "无";
				String cop_tel  = request.getParameter("cop_tel");  if(cop_tel == null || cop_tel.equals("")) cop_tel = "无";
				String cop_mail = request.getParameter("cop_mail"); if(cop_mail == null || cop_mail.equals("")) cop_mail = "无";
				String cop_fax  = request.getParameter("cop_fax");  if(cop_fax == null || cop_fax.equals("")) cop_fax = "无";
				String cop_addr = request.getParameter("cop_addr"); if(cop_addr == null || cop_addr.equals("")) cop_addr = "无";
				String cop_zip  = request.getParameter("cop_zip");  if(cop_zip == null || cop_zip.equals("")) cop_zip = "无";
				String cop_www  = request.getParameter("cop_www");  if(cop_www == null || cop_www.equals("")) cop_www = "无";
				String cop_desc = request.getParameter("cop_desc"); if(cop_desc == null || cop_desc.equals("")) cop_desc = "无";
				
				String job_name = request.getParameter("job_name"); if(job_name == null || job_name.equals("")) job_name = "无";
				String job_mann = request.getParameter("job_mann"); if(job_mann == null || job_mann.equals("") ||job_mann.equals("no")) job_mann = "0";
				String job_addr = request.getParameter("job_addr"); if(job_addr == null || job_addr.equals("")) job_addr = "无";
				String job_num  = request.getParameter("job_num");  if(job_num == null || job_num.equals("")) job_num = "0";
				String job_get  = request.getParameter("job_get");  if(job_get == null || job_get.equals("")) job_get = "面议";
				String job_sta  = request.getParameter("job_sta");  if(job_sta == null || job_sta.equals("")) job_sta = "0";
				String job_end  = request.getParameter("job_end");  if(job_end == null || job_end.equals("")) job_end = "0";
				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 = "无";
				String job_odem = request.getParameter("job_odem"); if(job_odem == null || job_odem.equals("")) job_odem = "无";
				
				if(td_pjm.editJob(id,cop_name,cop_mann,cop_cont,cop_tel,cop_mail,cop_fax,cop_addr,cop_zip,cop_www,cop_desc,job_name,job_mann,job_addr,job_num,job_get,job_sta,job_end,job_age1,job_age2,job_grad,job_lang,job_expe,job_oget,job_odem))
				{
				    //OK
						out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert(\"成功更新！\");window.location.href=\"list.jsp\";</script>");
				}
				else
				{
				    out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert('更新失败！"+td_pjm.error+"');window.location.href=\"list.jsp\";</script>");
				}
		}
		else if(action.equals("delete"))
		{
				String id = request.getParameter("id");
				if(id == null || id.equals(""))
				{
				    out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert(\"Miss job ID!\");window.location.href=\"list.jsp\";</script>");
				}
				else
				{
				    if(td_pjm.deleteJob(id))
						{
						    out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert(\"成功删除！\");window.location.href=\"list.jsp\";</script>");
						}
						else
						{
						    out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert(\"删除失败！\");window.location.href=\"list.jsp\";</script>");
						}
				}
		}
		else
		{
		    out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert(\"Wrong action!\");window.location.href=\"list.jsp\";</script>");
		}
%>