<%----------------------------------------------------------- Copyright © 1999, Oracle Corporation. All rights reserved. ------------------------------------------------------------%> <%@ page import = "java.sql.*,oracle.xml.sql.query.OracleXMLQuery" %> The XMLQuery Demo

XMLQuery Demo

Employee List in XML

(View Page Source in your browser to see XML output) <% Connection conn = null; Statement stmt = null; ResultSet rset = null; try { // determine JDBC driver name from session value // if null, use JDBC kprb driver if in JServer, JDBC oci otherwise String dbURL = request.getParameter("connStr"); if (dbURL == null) { if (System.getProperty("oracle.jserver.version") != null) { dbURL = "jdbc:oracle:kprb:@"; } else { %> <% } } DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); conn = DriverManager.getConnection(dbURL, "scott", "tiger"); stmt = conn.createStatement (); rset = stmt.executeQuery ("SELECT ename, sal " + "FROM scott.emp ORDER BY ename"); OracleXMLQuery xq = new OracleXMLQuery(conn, rset); %>
 <%=   xq.getXMLString()  %>  
<% } catch (java.sql.SQLException e) { %>

SQL error:

 <%= e %> 

<% } finally { if (stmt != null) stmt.close(); if (rset != null) rset.close(); if (conn != null) conn.close(); } %>