1 files changed, 0 insertions, 162 deletions
diff --git a/odk/examples/DevelopersGuide/Database/OpenQuery.java b/odk/examples/DevelopersGuide/Database/OpenQuery.java
deleted file mode 100644
index 3f63651c..00000000
--- a/odk/examples/DevelopersGuide/Database/OpenQuery.java
+++ /dev/null
@@ -1,162 +0,0 @@
-/*************************************************************************
- *
- *  The Contents of this file are made available subject to the terms of
- *  the BSD license.
- *  
- *  Copyright 2000, 2010 Oracle and/or its affiliates.
- *  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 following disclaimer in the
- *     documentation and/or other materials provided with the distribution.
- *  3. Neither the name of Sun Microsystems, Inc. nor the names of its
- *     contributors may be used to endorse or promote products derived
- *     from this software without specific prior written permission.
- *
- *  THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
- *  "AS IS" AND ANY EXPRESS 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
- *  COPYRIGHT OWNER OR 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.
- *     
- *************************************************************************/
-
-import com.sun.star.bridge.XUnoUrlResolver;
-import com.sun.star.uno.UnoRuntime;
-import com.sun.star.uno.XComponentContext;
-import com.sun.star.lang.XMultiComponentFactory;
-import com.sun.star.beans.XPropertySet;
-
-
-
-/*
- * OpenQuery.java
- *
- * Created on 6. Juli 2002, 10:25
- */
-
-/**
- *
- * @author  dschulten
- */
-public class OpenQuery {
-
-    private XComponentContext xContext = null;
-    private XMultiComponentFactory xMCF = null;
-    
-    /** Creates a new instance of OpenQuery */
-    public OpenQuery() {
-    }
-    
-    /**
-     * @param args the command line arguments
-     */
-    public static void main(String[] args) {
-        OpenQuery openQuery1 = new OpenQuery();
-        try {
-            openQuery1.openQuery();
-        }
-        catch (java.lang.Exception e){
-            e.printStackTrace();
-        }
-        finally {
-            System.exit(0);
-        }
-    }
-
-    protected void openQuery() throws com.sun.star.uno.Exception, java.lang.Exception {
-        try {
-            // get the remote office component context
-            xContext = com.sun.star.comp.helper.Bootstrap.bootstrap();
-            System.out.println("Connected to a running office ...");
-            xMCF = xContext.getServiceManager();
-        }
-        catch( Exception e) {
-            System.err.println("ERROR: can't get a component context from a running office ...");
-            e.printStackTrace();
-            System.exit(1);
-        }
-        
-        // first we create our RowSet object and get its XRowSet interface
-        Object rowSet = xMCF.createInstanceWithContext(
-            "com.sun.star.sdb.RowSet", xContext);
-
-        com.sun.star.sdbc.XRowSet xRowSet = (com.sun.star.sdbc.XRowSet) 
-            UnoRuntime.queryInterface(com.sun.star.sdbc.XRowSet.class, rowSet);
-
-        // set the properties needed to connect to a database
-        XPropertySet xProp = (XPropertySet)UnoRuntime.queryInterface(XPropertySet.class, xRowSet);
-
-        // the DataSourceName can be a data source registered with [PRODUCTNAME], among other possibilities
-        xProp.setPropertyValue("DataSourceName","Bibliography");
-
-        // the CommandType must be TABLE, QUERY or COMMAND, here we use COMMAND
-        xProp.setPropertyValue("CommandType",new Integer(com.sun.star.sdb.CommandType.COMMAND));
-
-        // the Command could be a table or query name or a SQL command, depending on the CommandType
-        xProp.setPropertyValue("Command","SELECT IDENTIFIER, AUTHOR FROM biblio ORDER BY IDENTIFIER");
-
-        // if your database requires logon, you can use the properties User and Password
-        // xProp.setPropertyValue("User", "JohnDoe");
-        // xProp.setPropertyValue("Password", "mysecret");
-
-        xRowSet.execute();
-
-        // prepare the XRow and XColumnLocate interface for column access
-        // XRow gets column values
-        com.sun.star.sdbc.XRow xRow = (com.sun.star.sdbc.XRow)UnoRuntime.queryInterface(
-            com.sun.star.sdbc.XRow.class, xRowSet);
-        // XColumnLocate finds columns by name
-        com.sun.star.sdbc.XColumnLocate xLoc = (com.sun.star.sdbc.XColumnLocate)
-            UnoRuntime.queryInterface(
-                com.sun.star.sdbc.XColumnLocate.class, xRowSet);
-
-        // print output header
-        System.out.println("Identifier\tAuthor");
-        System.out.println("----------\t------");
-
-        // output result rows
-        while ( xRowSet != null && xRowSet.next() ) {
-            String ident = xRow.getString(xLoc.findColumn("IDENTIFIER"));
-            String author = xRow.getString(xLoc.findColumn("AUTHOR"));
-            System.out.println(ident + "\t\t" + author);
-        }
-
-        // XResultSetUpdate for insertRow handling
-        com.sun.star.sdbc.XResultSetUpdate xResultSetUpdate = (com.sun.star.sdbc.XResultSetUpdate)
-            UnoRuntime.queryInterface(
-                com.sun.star.sdbc.XResultSetUpdate.class, xRowSet);
-        
-        // XRowUpdate for row updates
-        com.sun.star.sdbc.XRowUpdate xRowUpdate = (com.sun.star.sdbc.XRowUpdate)
-            UnoRuntime.queryInterface(
-                com.sun.star.sdbc.XRowUpdate.class, xRowSet);
-        
-        // move to insertRow buffer
-        xResultSetUpdate.moveToInsertRow();
-        
-        // edit insertRow buffer
-        xRowUpdate.updateString(xLoc.findColumn("IDENTIFIER"), "GOF95");
-        xRowUpdate.updateString(xLoc.findColumn("AUTHOR"), "Gamma, Helm, Johnson, Vlissides"); 
-        
-        // write buffer to database
-        xResultSetUpdate.insertRow();
-        
-        // throw away the row set
-        com.sun.star.lang.XComponent xComp = (com.sun.star.lang.XComponent)UnoRuntime.queryInterface(
-            com.sun.star.lang.XComponent.class, xRowSet);
-        xComp.dispose();
-    }        
-    
-}