1*cdf0e10cSrcweir /************************************************************************* 2*cdf0e10cSrcweir * 3*cdf0e10cSrcweir * The Contents of this file are made available subject to the terms of 4*cdf0e10cSrcweir * the BSD license. 5*cdf0e10cSrcweir * 6*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 7*cdf0e10cSrcweir * All rights reserved. 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * Redistribution and use in source and binary forms, with or without 10*cdf0e10cSrcweir * modification, are permitted provided that the following conditions 11*cdf0e10cSrcweir * are met: 12*cdf0e10cSrcweir * 1. Redistributions of source code must retain the above copyright 13*cdf0e10cSrcweir * notice, this list of conditions and the following disclaimer. 14*cdf0e10cSrcweir * 2. Redistributions in binary form must reproduce the above copyright 15*cdf0e10cSrcweir * notice, this list of conditions and the following disclaimer in the 16*cdf0e10cSrcweir * documentation and/or other materials provided with the distribution. 17*cdf0e10cSrcweir * 3. Neither the name of Sun Microsystems, Inc. nor the names of its 18*cdf0e10cSrcweir * contributors may be used to endorse or promote products derived 19*cdf0e10cSrcweir * from this software without specific prior written permission. 20*cdf0e10cSrcweir * 21*cdf0e10cSrcweir * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS 22*cdf0e10cSrcweir * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT 23*cdf0e10cSrcweir * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS 24*cdf0e10cSrcweir * FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE 25*cdf0e10cSrcweir * COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, 26*cdf0e10cSrcweir * INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, 27*cdf0e10cSrcweir * BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS 28*cdf0e10cSrcweir * OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND 29*cdf0e10cSrcweir * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR 30*cdf0e10cSrcweir * TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE 31*cdf0e10cSrcweir * USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. 32*cdf0e10cSrcweir * 33*cdf0e10cSrcweir *************************************************************************/ 34*cdf0e10cSrcweir 35*cdf0e10cSrcweir import com.sun.star.bridge.XUnoUrlResolver; 36*cdf0e10cSrcweir import com.sun.star.uno.UnoRuntime; 37*cdf0e10cSrcweir import com.sun.star.uno.XComponentContext; 38*cdf0e10cSrcweir import com.sun.star.lang.XMultiComponentFactory; 39*cdf0e10cSrcweir import com.sun.star.beans.XPropertySet; 40*cdf0e10cSrcweir 41*cdf0e10cSrcweir 42*cdf0e10cSrcweir 43*cdf0e10cSrcweir /* 44*cdf0e10cSrcweir * OpenQuery.java 45*cdf0e10cSrcweir * 46*cdf0e10cSrcweir * Created on 6. Juli 2002, 10:25 47*cdf0e10cSrcweir */ 48*cdf0e10cSrcweir 49*cdf0e10cSrcweir /** 50*cdf0e10cSrcweir * 51*cdf0e10cSrcweir * @author dschulten 52*cdf0e10cSrcweir */ 53*cdf0e10cSrcweir public class OpenQuery { 54*cdf0e10cSrcweir 55*cdf0e10cSrcweir private XComponentContext xContext = null; 56*cdf0e10cSrcweir private XMultiComponentFactory xMCF = null; 57*cdf0e10cSrcweir 58*cdf0e10cSrcweir /** Creates a new instance of OpenQuery */ 59*cdf0e10cSrcweir public OpenQuery() { 60*cdf0e10cSrcweir } 61*cdf0e10cSrcweir 62*cdf0e10cSrcweir /** 63*cdf0e10cSrcweir * @param args the command line arguments 64*cdf0e10cSrcweir */ 65*cdf0e10cSrcweir public static void main(String[] args) { 66*cdf0e10cSrcweir OpenQuery openQuery1 = new OpenQuery(); 67*cdf0e10cSrcweir try { 68*cdf0e10cSrcweir openQuery1.openQuery(); 69*cdf0e10cSrcweir } 70*cdf0e10cSrcweir catch (java.lang.Exception e){ 71*cdf0e10cSrcweir e.printStackTrace(); 72*cdf0e10cSrcweir } 73*cdf0e10cSrcweir finally { 74*cdf0e10cSrcweir System.exit(0); 75*cdf0e10cSrcweir } 76*cdf0e10cSrcweir } 77*cdf0e10cSrcweir 78*cdf0e10cSrcweir protected void openQuery() throws com.sun.star.uno.Exception, java.lang.Exception { 79*cdf0e10cSrcweir try { 80*cdf0e10cSrcweir // get the remote office component context 81*cdf0e10cSrcweir xContext = com.sun.star.comp.helper.Bootstrap.bootstrap(); 82*cdf0e10cSrcweir System.out.println("Connected to a running office ..."); 83*cdf0e10cSrcweir xMCF = xContext.getServiceManager(); 84*cdf0e10cSrcweir } 85*cdf0e10cSrcweir catch( Exception e) { 86*cdf0e10cSrcweir System.err.println("ERROR: can't get a component context from a running office ..."); 87*cdf0e10cSrcweir e.printStackTrace(); 88*cdf0e10cSrcweir System.exit(1); 89*cdf0e10cSrcweir } 90*cdf0e10cSrcweir 91*cdf0e10cSrcweir // first we create our RowSet object and get its XRowSet interface 92*cdf0e10cSrcweir Object rowSet = xMCF.createInstanceWithContext( 93*cdf0e10cSrcweir "com.sun.star.sdb.RowSet", xContext); 94*cdf0e10cSrcweir 95*cdf0e10cSrcweir com.sun.star.sdbc.XRowSet xRowSet = (com.sun.star.sdbc.XRowSet) 96*cdf0e10cSrcweir UnoRuntime.queryInterface(com.sun.star.sdbc.XRowSet.class, rowSet); 97*cdf0e10cSrcweir 98*cdf0e10cSrcweir // set the properties needed to connect to a database 99*cdf0e10cSrcweir XPropertySet xProp = (XPropertySet)UnoRuntime.queryInterface(XPropertySet.class, xRowSet); 100*cdf0e10cSrcweir 101*cdf0e10cSrcweir // the DataSourceName can be a data source registered with [PRODUCTNAME], among other possibilities 102*cdf0e10cSrcweir xProp.setPropertyValue("DataSourceName","Bibliography"); 103*cdf0e10cSrcweir 104*cdf0e10cSrcweir // the CommandType must be TABLE, QUERY or COMMAND, here we use COMMAND 105*cdf0e10cSrcweir xProp.setPropertyValue("CommandType",new Integer(com.sun.star.sdb.CommandType.COMMAND)); 106*cdf0e10cSrcweir 107*cdf0e10cSrcweir // the Command could be a table or query name or a SQL command, depending on the CommandType 108*cdf0e10cSrcweir xProp.setPropertyValue("Command","SELECT IDENTIFIER, AUTHOR FROM biblio ORDER BY IDENTIFIER"); 109*cdf0e10cSrcweir 110*cdf0e10cSrcweir // if your database requires logon, you can use the properties User and Password 111*cdf0e10cSrcweir // xProp.setPropertyValue("User", "JohnDoe"); 112*cdf0e10cSrcweir // xProp.setPropertyValue("Password", "mysecret"); 113*cdf0e10cSrcweir 114*cdf0e10cSrcweir xRowSet.execute(); 115*cdf0e10cSrcweir 116*cdf0e10cSrcweir // prepare the XRow and XColumnLocate interface for column access 117*cdf0e10cSrcweir // XRow gets column values 118*cdf0e10cSrcweir com.sun.star.sdbc.XRow xRow = (com.sun.star.sdbc.XRow)UnoRuntime.queryInterface( 119*cdf0e10cSrcweir com.sun.star.sdbc.XRow.class, xRowSet); 120*cdf0e10cSrcweir // XColumnLocate finds columns by name 121*cdf0e10cSrcweir com.sun.star.sdbc.XColumnLocate xLoc = (com.sun.star.sdbc.XColumnLocate) 122*cdf0e10cSrcweir UnoRuntime.queryInterface( 123*cdf0e10cSrcweir com.sun.star.sdbc.XColumnLocate.class, xRowSet); 124*cdf0e10cSrcweir 125*cdf0e10cSrcweir // print output header 126*cdf0e10cSrcweir System.out.println("Identifier\tAuthor"); 127*cdf0e10cSrcweir System.out.println("----------\t------"); 128*cdf0e10cSrcweir 129*cdf0e10cSrcweir // output result rows 130*cdf0e10cSrcweir while ( xRowSet != null && xRowSet.next() ) { 131*cdf0e10cSrcweir String ident = xRow.getString(xLoc.findColumn("IDENTIFIER")); 132*cdf0e10cSrcweir String author = xRow.getString(xLoc.findColumn("AUTHOR")); 133*cdf0e10cSrcweir System.out.println(ident + "\t\t" + author); 134*cdf0e10cSrcweir } 135*cdf0e10cSrcweir 136*cdf0e10cSrcweir // XResultSetUpdate for insertRow handling 137*cdf0e10cSrcweir com.sun.star.sdbc.XResultSetUpdate xResultSetUpdate = (com.sun.star.sdbc.XResultSetUpdate) 138*cdf0e10cSrcweir UnoRuntime.queryInterface( 139*cdf0e10cSrcweir com.sun.star.sdbc.XResultSetUpdate.class, xRowSet); 140*cdf0e10cSrcweir 141*cdf0e10cSrcweir // XRowUpdate for row updates 142*cdf0e10cSrcweir com.sun.star.sdbc.XRowUpdate xRowUpdate = (com.sun.star.sdbc.XRowUpdate) 143*cdf0e10cSrcweir UnoRuntime.queryInterface( 144*cdf0e10cSrcweir com.sun.star.sdbc.XRowUpdate.class, xRowSet); 145*cdf0e10cSrcweir 146*cdf0e10cSrcweir // move to insertRow buffer 147*cdf0e10cSrcweir xResultSetUpdate.moveToInsertRow(); 148*cdf0e10cSrcweir 149*cdf0e10cSrcweir // edit insertRow buffer 150*cdf0e10cSrcweir xRowUpdate.updateString(xLoc.findColumn("IDENTIFIER"), "GOF95"); 151*cdf0e10cSrcweir xRowUpdate.updateString(xLoc.findColumn("AUTHOR"), "Gamma, Helm, Johnson, Vlissides"); 152*cdf0e10cSrcweir 153*cdf0e10cSrcweir // write buffer to database 154*cdf0e10cSrcweir xResultSetUpdate.insertRow(); 155*cdf0e10cSrcweir 156*cdf0e10cSrcweir // throw away the row set 157*cdf0e10cSrcweir com.sun.star.lang.XComponent xComp = (com.sun.star.lang.XComponent)UnoRuntime.queryInterface( 158*cdf0e10cSrcweir com.sun.star.lang.XComponent.class, xRowSet); 159*cdf0e10cSrcweir xComp.dispose(); 160*cdf0e10cSrcweir } 161*cdf0e10cSrcweir 162*cdf0e10cSrcweir } 163