<%@page language="java" %> <%@page import="java.sql.*" %> Test

Testing

<%! String DRIVER = "oracle.jdbc.driver.OracleDriver"; String URL = "jdbc:oracle:thin:@unixapps1.wright.edu:1521:ORA2"; String USERNAME = "YOUR USERNAME"; String PASSWORD = "YOUR PASSWORD"; java.sql.Connection conn; java.sql.Statement st; java.sql.ResultSet rec; %> <% Class.forName(DRIVER); conn = DriverManager.getConnection(URL, USERNAME, PASSWORD); st = conn.createStatement(); String SQL = "SELECT * FROM lab6_Student"; rec = st.executeQuery(SQL); %> <% while(rec.next()) { %> <% } %>

SID	sname
<%=rec.getString("sid") %>	<%=rec.getString("sname")%>

<% rec.close(); st.close(); conn.close(); %>