<%@ page language="java" %> <%@ page session="true" %> <%@ page import="java.sql.*,java.io.*,java.util.Random"%>

<% Connection con; ResultSet rs=null; Statement stmt=null; try{ con=(Connection)session.getAttribute("connection"); stmt = con.createStatement(); String Query = "Select * from login order by `userid`"; rs = stmt.executeQuery(Query); %> <% int rCount=0; while(rs.next()) { %> > <% rCount++; } if( rCount == 0) {%>

Sorry No records Found

<% } }catch(Exception e){%><%=e%><%} %>
UserIDPasswordAuth
<%=rs.getString(1)%><%=rs.getString(2)%><%=rs.getString(3)%>