%@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 MeetingTable"; ResultSet Rs=st.executeQuery(vsql); %>
| MEETING NAME | DESCRIPTION | MEETING TYPE | TIME | DURATION | DATE | OPTIONS | PARTICIPANTS | MEETING ID | COLLEGE ID | E-MAIL ID | <% while(Rs.next()) {%>
|---|---|---|---|---|---|---|---|---|---|---|
| <%out.println(Rs.getString(1));%> | <%out.println(Rs.getString(2));%> | <%out.println(Rs.getString(3));%> | <%out.println(Rs.getString(4));%> | <%out.println(Rs.getString(5));%> | <%out.println(Rs.getString(6));%> | <%out.println(Rs.getString(7));%> | <%out.println(Rs.getString(8));%> | <%out.println(Rs.getString(9));%> | <%out.println(Rs.getString(10));%> | <%out.println(Rs.getString(11));%> |