Java tutorial
/*-- Copyright (C) 2000 Brett McLaughlin & Jason Hunter. All rights reserved. Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: 1. Redistributions of source code must retain the above copyright notice, this list of conditions, and the following disclaimer. 2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions, and the disclaimer that follows these conditions in the documentation and/or other materials provided with the distribution. 3. The name "JDOM" must not be used to endorse or promote products derived from this software without prior written permission. For written permission, please contact license@jdom.org. 4. Products derived from this software may not be called "JDOM", nor may "JDOM" appear in their name, without prior written permission from the JDOM Project Management (pm@jdom.org). In addition, we request (but do not require) that you include in the end-user documentation provided with the redistribution and/or in the software itself an acknowledgement equivalent to the following: "This product includes software developed by the JDOM Project (http://www.jdom.org/)." Alternatively, the acknowledgment may be graphical using the logos available at http://www.jdom.org/images/logos. THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE JDOM AUTHORS OR THE PROJECT CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. This software consists of voluntary contributions made by many individuals on behalf of the JDOM Project and was originally created by Brett McLaughlin <brett@jdom.org> and Jason Hunter <jhunter@jdom.org>. For more information on the JDOM Project, please see <http://www.jdom.org/>. */ import java.sql.*; import java.io.*; import java.util.*; import org.jdom2.*; import org.jdom2.output.*; import org.jdom2.contrib.input.ResultSetBuilder; /** * A simple sample harness for JDOM ResultSetBuilder * * @author R.Sena (raff@aromatic.org) */ @SuppressWarnings("javadoc") public class sxql { /** * Return a connection (i.e. from a connection pool) */ public static Connection getConnection(String driver, String jdbcURL, String user, String pass) throws Exception { Class.forName(driver); return DriverManager.getConnection(jdbcURL, user, pass); } /** * Execute a SQL query and return the result as XML * (as a String. But this can be changed to return a DOM/SAX/JDOM tree, * to be used, for example, as input to an XSLT processor) */ public static String query(Connection con, String query, String root, String row, String ns, int maxRows, Vector<String> attributes, Vector<String> elements) throws Exception { // Execute SQL Query Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(query); // Create a ResultSetBuilder ResultSetBuilder builder = new ResultSetBuilder(rs); // Configure some parameters... if (root != null) { builder.setRootName(root); } if (row != null) { builder.setRowName(row); } if (ns != null) { String namespace = null; String url = null; int sep = ns.indexOf("/"); if (sep > 0) { namespace = ns.substring(0, sep); url = ns.substring(sep + 1); builder.setNamespace(Namespace.getNamespace(namespace, url)); } } if (maxRows > 0) { builder.setMaxRows(maxRows); } for (int i = 0; i < attributes.size(); i++) { String colName = attributes.get(i); String attrName = null; if (colName.indexOf("/") >= 0) { String col = colName; int sep = col.indexOf("/"); colName = col.substring(0, sep); attrName = col.substring(sep + 1); } try { // If it looks like an integer, is the column number int colNum = Integer.parseInt(colName); if (attrName == null) { builder.setAsAttribute(colNum); // attrName = column Name } else { builder.setAsAttribute(colNum, attrName); } } catch (NumberFormatException e) { // Otherwise it's the column name if (attrName == null) { builder.setAsAttribute(colName); // attrName = column Name } else { builder.setAsAttribute(colName, attrName); } } } // Rename element for (int i = 0; i < elements.size(); i++) { String colName = elements.get(i); String elemName = null; if (colName.indexOf("/") >= 0) { String col = colName; int sep = col.indexOf("/"); colName = col.substring(0, sep); elemName = col.substring(sep + 1); } try { // If it looks like an integer, is the column number int colNum = Integer.parseInt(colName); if (elemName != null) { // It must have an element name builder.setAsElement(colNum, elemName); } } catch (NumberFormatException e) { // Otherwise it's the column name if (elemName != null) { // It must have an element name builder.setAsElement(colName, elemName); } } } // Build a JDOM tree Document doc = builder.build(); // Convert the result to XML (as String) XMLOutputter outputter = new XMLOutputter(Format.getPrettyFormat()); ByteArrayOutputStream output = new ByteArrayOutputStream(); outputter.output(doc, output); return output.toString(); } /** * Usage */ public static void usage() { System.err.println("usage: sxql [--root=root-element] [--row=row-element]"); System.err.println(" [--namespace=namespace/url] [--maxrows=max-rows]"); System.err.println(" [--attribute=column/attr] [--element=column/element]"); System.err.println(" driver url user pass query"); System.err.println("where:"); System.err.println(" --root: set root element name (root-element)"); System.err.println(" --row: set row element name (root-element)"); System.err.println(" --namespace: set namespace (namespace, url)"); System.err.println(" --maxrows: set maximum number of rows (max-rows)"); System.err.println(" --attribute: column as attribute (column name/number, attribute-name)"); System.err.println(" --element: rename column (column name/number, element-name)"); System.err.println(" driver: driver class name"); System.err.println(" url: JDBC url"); System.err.println(" user: database user"); System.err.println(" pass: database password"); System.err.println(" query: SQL query"); } /** * Main entry point */ public static void main(String[] args) throws Exception { String root = null; String row = null; String ns = null; int maxRows = 0; Vector<String> attributes = new Vector<String>(); Vector<String> elements = new Vector<String>(); int i; // Read configuration parameters for (i = 0; i < args.length; i++) { if (args[i].startsWith("--")) { if (args[i].startsWith("--attribute=")) attributes.add(args[i].substring(12)); else if (args[i].startsWith("--element=")) elements.add(args[i].substring(10)); else if (args[i].startsWith("--root=")) root = args[i].substring(7); else if (args[i].startsWith("--row=")) row = args[i].substring(6); else if (args[i].startsWith("--namespace=")) ns = args[i].substring(12); else if (args[i].startsWith("--maxrows=")) maxRows = Integer.parseInt(args[i].substring(10)); } else { break; } } if (args.length - i != 5) { usage(); } else { System.out.println(query(getConnection(args[i + 0], args[i + 1], args[i + 2], args[i + 3]), args[i + 4], root, row, ns, maxRows, attributes, elements)); } } }