?? 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>");
}
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -