<%@page import="java.sql.*"%> <% Connection conn=null; try{ Class.forName("oracle.jdbc.driver.OracleDriver"); conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","INVCTLSYS","FUSION"); Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery("SELECT * FROM TBL_PURCHASED_INVOIE_REGISTER"); while(rs.next()) { out.println(rs.getInt("SYS_ID")+" -> "+rs.getInt("VENDOR_SYS_ID")+" -> "+rs.getString("VENDOR_NAME")+" -> "+rs.getString("INVOICE_ID")+"<br>"); } }catch(Exception e){out.println(e.getMessage());} %>