<%@page import="java.sql.*"%>
<%@ page pageEncoding="utf-8"%>

<HTML><BODY>

<hr align="center" width="55%" color="#991111" size="5"/>
<%

Class.forName("oracle.jdbc.driver.OracleDriver");

String url="jdbc:oracle:thin:@172.3.15.123:1521:orcl";
Connection conn=DriverManager.getConnection(url,"scott","ORCL");
PreparedStatement stmt=conn.prepareStatement("select * from emp");

ResultSet rs=stmt.executeQuery();
out.print("<TABLE BORDER='1' width='55%' cellpadding='3' align=center>");
out.print("<TR><TD>"+"<b>Empno</b>"+"</TD>");
out.print("<TD>"+"<b>Ename</b>"+"</TD>");
out.print("<TD>"+"<b>Job</b>"+"</TD>");
out.print("<TD>"+"<b>Mgr</b>"+"</TD>");
out.print("<TD>"+"<b>hiredate</b>"+"</TD>");
out.print("<TD align=center>"+"<b>Sal</b>"+"</TD>");
out.print("<TD>"+"<b>Comm</b>"+"</TD>");
out.print("<TD>"+"<b>Deptno</b>"+"</TD></TR>");


while(rs.next()){
out.print("<TR><TD>"+rs.getString(1)+"</TD>");
out.print("<TD>"+rs.getString(2)+"</TD>");
out.print("<TD >"+rs.getString(3)+"</TD>");
out.print("<TD>"+rs.getString(4)+"</TD>");
out.print("<TD>"+rs.getString(5)+"</TD>");
out.print("<TD>"+rs.getString(6)+"</TD>");
out.print("<TD>"+rs.getString(7)+"</TD>");
out.print("<TD>"+rs.getString(8)+"</TD></TR>");
}

out.print("</TABLE>");

rs.close();
stmt.close();
conn.close();

%>
</BODY></HTML>