?? action.jsp
字號:
</tr>
</tbody>
</form>
</table>
</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>
<%
}
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
try
{
db.closeDB();
rs = null;
}
catch(Exception ee)
{
ee.printStackTrace();
}
}
}
else
{
if("showre".equals(action))
{
ResultSet rs = null;
try
{
String id = request.getParameter("id");
String sql = "select a.job_name, c.name, c.age, a.intro, a.cop_name, b.intro from Resume a, Reply b, USERS c where resume_id = "+id+" and a.id = "+id +" and c.id = a.user_id";
rs = db.executeQuery(sql);
if(rs.next())
{
%>
<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%" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="right" background="../ima/top_bg.gif"></td>
</tr>
</table>
<table width="100%" height="25" border="0" cellpadding="0" cellspacing="0">
<tr>
<td background="../ima/shadow.gif"> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="2">
<tr>
<td align="center"><table width="700" border="0" cellspacing="1" cellpadding="1">
<form action="action.jsp?action=reing" id="form" name="form" method="post">
<tbody>
<tr class="text-login">
<td height="20" colspan="2"><strong>顯示公司回復</strong></td>
</tr>
<tr class="text-login">
<td width="60" height="20" bgcolor="#EEEEEE">公司名稱</td>
<td width="290" height="20" bgcolor="#EEEEEE"> <%=rs.getString(5)%></td>
</tr>
<tr class="text-login">
<td width="60" height="20">職位名稱</td>
<td width="290" height="20"> <%=rs.getString(1)%></td>
</tr>
<tr class="text-login">
<td width="60" height="20">應聘者姓名</td>
<td width="290" height="20"> <%=rs.getString(2)%></td>
</tr>
<tr class="text-login">
<td width="60" height="20">應聘者年齡</td>
<td width="290" height="20"> <%=rs.getString(3)%></td>
</tr>
<tr class="text-login">
<td width="60" height="135" valign="top">簡歷內容</td>
<td width="290" height="135" align="center" valign="top"><textarea name="re_cont" class="addtextarea" id="re_cont" disabled><%=rs.getString(4)%></textarea></td>
</tr>
<tr class="text-login">
<td width="60" height="20" bgcolor="#EEEEEE"> </td>
<td width="290" height="20" bgcolor="#EEEEEE"> </td>
</tr>
<tr class="text-login">
<td width="60" height="135" valign="top">回復內容</td>
<td width="290" height="135" align="center" valign="top"><textarea name="re_cont" class="addtextarea" id="re_cont" disabled><%=rs.getString(6)%></textarea></td>
</tr>
<tr align="right" valign="middle" class="text-login">
<td height="30" colspan="2" bgcolor="#EEEEEE">
<input type="button" class="logbutton" value="返回" onClick="window.location.href='resumelist.jsp'">
</td>
</tr>
</tbody>
</form>
</table>
</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>
<%
}
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
try
{
db.closeDB();
rs = null;
}
catch(Exception ee)
{
ee.printStackTrace();
}
}
}
else
{
if("reing".equals(action))
{
ResultSet rs = null;
try
{
String intro = request.getParameter("re_cont");
if(intro == null)
intro = "無";
else
intro = new String(intro.getBytes("ISO8859_1"));
String user_id = request.getParameter("user_id");
String job_id = request.getParameter("job_id");
String resume_id = request.getParameter("resume_id");
String sql = "select MAX(id) from Reply";
rs = db.executeQuery(sql);
int id = 0;
if(rs.next())
{
id = rs.getInt(1) + 1;
}
sql = "insert into Reply(id,user_id,intro,resume_id,job_id) values("+String.valueOf(id)+","+user_id+",'"+intro+"',"+resume_id+","+job_id+")";
db.executeUpdate(sql);
response.sendRedirect("resumelist.jsp");
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
try
{
db.closeDB();
rs.close();
}
catch(Exception ee)
{
ee.printStackTrace();
}
}
}
else
{
/*
if("delete".equals(action))
{
String id = request.getParamter("id");
try
{
String sql = "delete from JOBS where id = "+id;
db.executeUpdate(sql);
sql = "delete from RESUME where job_id = "+id;
db.executeUpdate(sql);
sql = "delete from REPLY where job_id = "+id;
db.executeUpdate(sql);
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
try
{
db.closeDB();
}
catch(Exception ee)
{
ee.printStackTrace();
}
}
}
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 + -