%@page import="java.sql.*" %> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("Jdbc:Odbc:orads","scott","tiger"); String vsql ; try{ Statement st=con.createStatement(); vsql="select * from wbmslogin"; ResultSet Rs=st.executeQuery(vsql); %>
| USER NAME | E-MAIL ID | COLLEGE ID | DEPARTMENT | <% while(Rs.next()) {%>
|---|---|---|---|
| <%out.println(Rs.getString(1));%> | <%out.println(Rs.getString(3));%> | <%out.println(Rs.getString(4));%> | <%out.println(Rs.getString(5));%> |