disdet.jsp

来自「个人主页,包括登陆,注册,后台管理.邮件发送等.」· JSP 代码 · 共 70 行

JSP
70
字号
<%@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 + =
减小字号Ctrl + -
显示快捷键?