Employee List

<%@ page import=" weblogic.db.jdbc.*, weblogic.html.*, java.sql.* " %>

<% Connection conn = null; try { Class.forName("weblogic.jdbc.pool.Driver").newInstance(); conn = DriverManager.getConnection("jdbc:weblogic:pool:demoPool"); // Fetch all records from the database in a TableDataSet DataSet dSet = new TableDataSet(conn, "emp").fetchRecords(); TableElement tE = new TableElement(dSet); tE.setBorder(1); out.print(tE); } catch (SQLException sqle) { out.print("Sorry, the database is not available."); out.print("Exception: " + sqle); } catch (Exception e) { out.print("Exception occured: " + e); } finally { if(conn != null) try { conn.close(); } catch(SQLException sqle) {} } %>

Please call Mary with any updates ASAP!