import oracle.jdbc.driver.*;
import oracle.xml.sql.query.OracleXMLQuery;
import java.lang.*;
import java.sql.*;

// class to test XML document generation as String
class testXMLSQL {

public static void main(String[] args)
{
try {
// Create the connection
Connection conn = getConnection("scott","tiger");

// Create the query class
OracleXMLQuery qry = new OracleXMLQuery(conn,
"SELECT * FROM Bank");

// Get the XML string
String str = qry.getXMLString();

// Print the XML output
System.out.println("The XML output is:\n"+str);

// Always close the query to get rid of any resources..
qry.close();
} catch(SQLException e) {
System.out.println(e.toString());
}
}

// Get the connection given the user name and password.!
private static Connection getConnection(String username,
String password)
throws SQLException
{
// register the JDBC driver..
DriverManager.registerDriver(new
oracle.jdbc.driver.OracleDriver());

// Create the connection using the OCI8 driver
Connection conn =
DriverManager.getConnection(
"jdbc:oracle:thin:@dlsun489:1521:ORCL",
username,password);

return conn;
}
}