📄 disdet.jsp
字号:
<%@page language="java" import="java.io.*,java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<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>
<%
try
{
String q;
q=request.getParameter("s");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:wsm");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from registration where (expi is not null) and qualification='"+q+"'" );
%>
<TABLE id="Table1" style="BORDER-RIGHT: #ffffcc thin solid; BORDER-TOP: #ffffcc thin solid; FONT-WEIGHT: bold; BORDER-LEFT: #ffffcc thin solid; COLOR: #990000; BORDER-BOTTOM: #ffffcc thin solid; POSITION: absolute; TOP: 100px; BORDER-COLLAPSE: collapse"
cellSpacing="0" cellPadding="0" width="100%" border="0">
<TR>
<TD style="FONT-WEIGHT: bold; COLOR: #ffffcc ; BACKGROUND-COLOR: g1.bmp; TEXT-ALIGN: center"
colSpan="11">Resumes Availability Details</TD>
</TR>
<TR bgcolor=#ffffcc>
<TD>Name</TD>
<TD>Qualification</TD>
<TD>Phone</TD>
<TD>Email-Id</TD>
</TR>
<%
while(rs.next())
{
String n=rs.getString(1);
String q1=rs.getString(3);
String p=rs.getString(6);
String em=rs.getString(7);
String pwd=rs.getString(11);
%>
<TR>
<TD><font color=#ffffcc><a href="perdet.jsp?s=<%=pwd%>"><%=n%></font></TD>
<TD><%=q1%></TD>
<TD><%=p%></TD>
<TD><%=em%></TD> </TR>
<%
}
rs.close();
con.close();
}catch(Exception e)
{
out.println(""+e);
}
%>
</TABLE>
<a href="viewrestot.jsp" ><FONT color="#ffffcc">Back</FONT></a>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -