📄 viewrestotnot.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>
<%
String q="";
String hl="";
try
{
String topic;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:wsm");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select qualification , count(*) from registration where expi is null or expi ='0' group by qualification " );
%>
<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><font color=#990000>Qualification</font></TD>
<TD><font color=#990000>No Of Resumes</font></TD>
</TR>
<%
while(rs.next())
{
q=rs.getString(1);
%>
<TR>
<TD><a href="disdetnot.jsp?s=<%=q%>" ><font color=#ffffcc><%=q%></font></a></TD>
<TD><font color=#ffffcc><%=rs.getString(2)%></font></TD>
</TR>
<%
}
rs.close();
con.close();
}catch(Exception e)
{
out.println(""+e);
}
%>
</TABLE>
<p><u><a href="resumetypes.html"><font color="#FFFFCC">Back</font></a></u></p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -