sqlres.jsp

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

<%@page language="java" import="java.io.*,java.sql.*"%>
<%

int x=0;
String s="";
String o="";
  try
   {
//s=request.getParameter("s");
o=request.getParameter("o");
//String s="select * from registration";
if(o.equals("1"))
s="select * from registration where qualification='BTECH'";
else if(o.equals("2"))
s="select * from registration where qualification='MTECH'";
else if(o.equals("3"))
s="select * from registration where qualification='BCA'";
else if(o.equals("4"))
s="select * from registration where qualification='MCA'";
else if(o.equals("5"))
s="select * from registration where expi>='1'";
else if(o.equals("6"))
s="select * from registration where expi is null or expi='0'";

else if(o.equals("7"))
s="select * from registration where qualification='BTECH'  or qualification='MCA'";
else if(o.equals("8"))
s="select * from registration where qualification='BTECH'   and expi>='1' ";
else if(o.equals("9"))
s="select * from registration where qualification='BTECH'  or qualification='MTECH'";
else if(o.equals("10"))
s="select * from registration where qualification='MTECH'  or qualification='MCA'";
else if(o.equals("11"))
s="select * from registration where qualification='MCA'  or qualification='BCA'"; 

   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     Connection      con=DriverManager.getConnection("jdbc:odbc:wsm");
      Statement st=con.createStatement();
      ResultSet rs=st.executeQuery(s );
ResultSetMetaData  md= rs.getMetaData();
out.println("hello");
%>
<TABLE id="Table1" style="BORDER-RIGHT: #009999 thin solid; BORDER-TOP: #009999 thin solid; FONT-WEIGHT: bold;  BORDER-LEFT: #009999 thin solid; COLOR: #009999; BORDER-BOTTOM: #009999 thin solid; POSITION: absolute; TOP: 100px; BORDER-COLLAPSE: collapse"
	cellSpacing="0" cellPadding="0" width="100%" border="0">
			<TR>
				<TD style="FONT-WEIGHT: bold; COLOR: #99ffcc; BACKGROUND-COLOR: #009999; TEXT-ALIGN: center"
					colSpan="11"> User Details</TD>
			</TR>


<tr>
<%
for(x=1;x<=md.getColumnCount();x++)
{
%>
<td><font color=red><strong><%=md.getColumnLabel(x)%></strong></font>
<%
}
%></tr>
<%
while(rs.next())
{
%>
<tr> 
<%
for(x=1;x<=md.getColumnCount();x++)
{
%>
<td><%=rs.getString(x)%>
<%
}
%></tr>



<%
}
con.close();

}catch(Exception e)
{
out.println(""+e);
response.sendRedirect("confirmpage.jsp?mesg=Invalid SQL stmt  "+ s);

}


%>
		</TABLE>
	</body>
</html>