Faculty Web Directory
****Andhra University****


<%@ page language="java" import="java.sql.*"%> <% boolean flag=false; String req=""; String st[]={"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"}; for(int i=0;i<=25;i++) { %>
<% out.println(st[i]); %> <% } %>
<% try{ req=request.getParameter("var"); if (req==null) {} else { Class.forName("org.gjt.mm.mysql.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://localhost/andhrau9_andhrauniv?user=andhrau9_andhra&password=andhra123"); Statement stm=con.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); ResultSet rst=stm.executeQuery("Select * from directory where name1 like '"+req+"%' and contact <>'admin'"); %>

<%=req%>


<% while(rst.next()) { String st1=rst.getString(1); if (st1.length()==0) { %> <% } if (flag==false) out.println("

"+"No Matching Records Found..."+"

"); } } catch(Exception e) { out.println(e); } %>
<%=rst.getString(1)%> <% out.println(rst.getString(8));%> <% } else { %>
<% out.println(rst.getString(8));%> <% } %> <% out.println(rst.getString(4)); flag=true; %>

Back | Home


Copyright © 2006 Andhra University. All Rights Reserved