forked from maxliaops/Java_Web_Examples
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsjob.jsp
More file actions
57 lines (57 loc) · 1.72 KB
/
sjob.jsp
File metadata and controls
57 lines (57 loc) · 1.72 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="com.bwm.db.Conn" %>
<%@ include file="include.jsp"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css/left.css" rel="stylesheet" type="text/css">
</head>
<body topmargin="0px">
<table width="98%" height="500" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td height="50" align="center"><div id="font">求职信息管理</div></td>
</tr>
<tr>
<td valign="top"><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#F5f7f7">
<tr align="center" bgcolor="#21536A">
<td height="22"><div id="reg">用户名</div></td>
<td><div id="reg">求职行业</div></td>
<td><div id="reg">所求职位</div></td>
<td><div id="reg">所求薪水</div></td>
<td ><div id="reg">发布日期</div></td>
<td ><div id="reg">有效日期</div></td>
<td ><div id="reg">其他说明</div></td>
<td ><div id="reg">删除</div></td>
</tr>
<tr>
<td colspan="8" height="8"></td>
</tr>
<%
Conn con=new Conn();
ResultSet rs=con.getRs("SELECT * FROM tb_sjob");
while(rs.next()){
String strSname=rs.getString(1);
%>
<tr align="center" valign="baseline">
<td height="22"><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
<td><%=rs.getString(5)%></td>
<td><%=rs.getDate(6)%></td>
<td><%=rs.getDate(7)%></td>
<td width="150" align="left"><%=rs.getString(8)%></td>
<td><a href="dsjob.jsp?jobid=<%=strSname%>">删除</a></td>
</tr>
<%
}
con.close();
%>
<tr>
<td colspan="8"> </td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>