None <%@ page import="java.sql.*" %> <%@ page import="oracle.jdbc.driver.OracleDriver" %> <% DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); %> <% Connection con = DriverManager.getConnection("jdbc:oracle:thin:@216.138.240.10:1530:CVRPROD1", "onebanner", "onebanner"); %> <% Statement stmt = con.createStatement(); %> <% String Sql = "Select firstname,lastname,salesrepid from salesrep where salesrepid !='null' order by firstname";%> <% try{ %> <% ResultSet rs = stmt.executeQuery(Sql); %> <% if(rs.next()){ %> <% rs = stmt.executeQuery(Sql); %> <% while(rs.next()){ %> <%= rs.getString("firstname") + " " + rs.getString("lastname") %> <% } %> <% } %> <% rs.close(); %> <% stmt.close(); %> <% con.close(); %> <% }catch(Exception e){ %> <%= e.toString() %> Error in Retreiving Data from Database <% } %>