?? resumelist.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" />
<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">
<script language="JavaScript" type="text/javascript"></script>
</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">
<a href="list.jsp" ><font color="#FFFFFF">返回</font></a><img src="../ima/divider.gif" width="2" height="19"></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="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">
<tbody>
<tr>
<td bgcolor="#8C8A84"><table width="100%" border="0" cellspacing="1" cellpadding="2">
<tr align="center" bgcolor="#DEDFD6" class="text-login">
<td width="4%"> </td>
<td width="20%">應 聘 職 位</td>
<td width="10%">姓 名</td>
<td width="10%">年 齡</td>
<td width="25%">簡 歷 片 斷</td>
<td width="5%">回 復 狀 態</td>
<td width="12%">操 作</td>
</tr>
<%
ResultSet rs = null;
try
{
String sql = "select a.id from COMPANY a, USERS b where b.id = "+(String)session.getAttribute("user_id")+" and a.user_id = b.id";
rs = db.executeQuery(sql);
int id = -1;
if(rs.next())
{
id = rs.getInt(1);
}
rs = null;
sql = "select a.id, c.job_name,b.name,b.age,c.intro, c.id, b.id from JOBS a,USERS b, RESUME c where a.cop_id = "+String.valueOf(id)+" and c.job_id = a.id and b.id = c.user_id";
rs = db.executeQuery(sql);
int i = 0;
while(rs.next())
{
i++;
int job_id = rs.getInt(1);
%>
<tr align="center" bgcolor="#FFFFF7" class="text-login">
<td width="4%" align="center"><%=i%></td>
<td width="20%" align="center"><%=rs.getString(2)%></td>
<td width="10%" align="center"><%=rs.getString(3)%></td>
<td width="10%" align="center"><%=rs.getInt(4)%></td>
<td width="25%" align="center"><%=(rs.getString(5)).substring(0,5)+"......"%></td>
<td width="5%" align="center">
<%
if(db.ifReply(String.valueOf(job_id),String.valueOf(rs.getInt(7))) == 1)
{
out.print("已回復");
%>
</td>
<td width="12%" align="center">
<a href="action.jsp?action=showre&jobid=<%=job_id%>&id=<%=rs.getInt(6)%>"><img src="../ima/edit.gif" alt="查看" width="16" height="16" border="0"></a></td>
<%
}
else
{
out.print("未回復");
%>
</td>
<td width="12%" align="center"><a href="action.jsp?action=re&jobid=<%=job_id%>&id=<%=rs.getInt(6)%>"><img src="../ima/edit.gif" alt="回復" width="16" height="16" border="0"></a></td>
<%
}
%>
</tr>
<%
}
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
try
{
db.closeDB();
rs = null;
}
catch(Exception ee)
{
ee.printStackTrace();
}
}
%>
</tbody>
</table></td>
</tr>
</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>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -