📄 job1.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<%@ page language="java" import="java.sql.*"%>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection("jdbc:odbc:wsm");
Statement st = c.createStatement();
ResultSet rs = st.executeQuery("select * from job");
%>
<html>
<head>
<title></title>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</head>
<body background="g1.bmp" ms_positioning="GridLayout">
<TABLE id="Table1" style="Z-INDEX: 101; LEFT: 192px; WIDTH: 392px; POSITION: absolute; TOP: 248px; HEIGHT: 72px"
cellSpacing="1" cellPadding="1" width="392" border="1">
<TR style="COLOR: #ffffcc; BACKGROUND-COLOR: g1.bmp; TEXT-ALIGN: center">
<TD style="HEIGHT: 22px" colSpan="2"><STRONG>Job Opportunities</STRONG></TD>
</TR>
<TR>
<TD style="COLOR: #ffffcc; HEIGHT: 17px; BACKGROUND-COLOR:g1.bmp; TEXT-ALIGN: center"><STRONG>Job
Type</STRONG></TD>
<TD style="COLOR: #ffffcc; HEIGHT: 17px; TEXT-ALIGN: center"><STRONG>Qualification</STRONG></TD>
</TR>
<%
while(rs.next())
{
%>
<tr><td align= center><font color=#ffffcc><%=rs.getString(1)%></font></td>
<td align= center><font color=#ffffcc><%=rs.getString(2)%></font></td>
</tr>
<%
}
%>
<tr><b><td COLOR: #ffffcc colspan=2 align="center"><a href="mainpage1.jsp"><font color=#ffffcc>Back</font></a> <a href="Applicationform1.htm"><font color=#ffffcc>New User</font></a> <a href="login2.html"><font color=#ffffcc>Old User</font></a> </td></b></tr>
</TABLE>
</body>
</html>
<%
}
catch(Exception e)
{
out.println(e);
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -