odk/examples/DevelopersGuide/Forms/RowSet.java

   1 /*
   2  * This file is part of the LibreOffice project.
   3  *
   4  * This Source Code Form is subject to the terms of the Mozilla Public
   5  * License, v. 2.0. If a copy of the MPL was not distributed with this
   6  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   7  *
   8  * This file incorporates work covered by the following license notice:
   9  *
  10  *   Licensed to the Apache Software Foundation (ASF) under one or more
  11  *   contributor license agreements. See the NOTICE file distributed
  12  *   with this work for additional information regarding copyright
  13  *   ownership. The ASF licenses this file to you under the Apache
  14  *   License, Version 2.0 (the "License"); you may not use this file
  15  *   except in compliance with the License. You may obtain a copy of
  16  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  17  */
  18
  19 import com.sun.star.beans.XPropertySet;
  20 import com.sun.star.container.XIndexAccess;
  21 import com.sun.star.container.XNameAccess;
  22 import com.sun.star.io.XInputStream;
  23 import com.sun.star.sdbc.SQLException;
  24 import com.sun.star.sdbc.XArray;
  25 import com.sun.star.sdbc.XBlob;
  26 import com.sun.star.sdbc.XClob;
  27 import com.sun.star.sdbc.XRef;
  28 import com.sun.star.sdbc.XRow;
  29 import com.sun.star.sdbc.XRowSet;
  30 import com.sun.star.sdbc.XRowSetListener;
  31 import com.sun.star.sdbcx.XColumnsSupplier;
  32 import com.sun.star.uno.UnoRuntime;
  33 import com.sun.star.uno.XComponentContext;
  34 import com.sun.star.util.Date;
  35 import com.sun.star.util.DateTime;
  36 import com.sun.star.util.Time;
  37
  38 public class RowSet implements XRowSet, XRow
  39 {
  40     private XRowSet                 m_rowSet;
  41     private XRow                    m_row;
  42     private XPropertySet            m_rowSetProps;
  43
  44     public RowSet( XComponentContext _context, String _dataSource, int _commandType, String _command )
  45     {
  46         try
  47         {
  48             m_rowSetProps = UnoRuntime.queryInterface(
  49                 XPropertySet.class, _context.getServiceManager().createInstanceWithContext( "com.sun.star.sdb.RowSet", _context ) );
  50             m_rowSetProps.setPropertyValue( "DataSourceName", _dataSource );
  51             m_rowSetProps.setPropertyValue( "CommandType", Integer.valueOf( _commandType ) );
  52             m_rowSetProps.setPropertyValue( "Command", _command );
  53
  54             m_rowSet = UnoRuntime.queryInterface( XRowSet.class, m_rowSetProps );
  55             m_row = UnoRuntime.queryInterface( XRow.class, m_rowSetProps );
  56         }
  57         catch ( Exception e )
  58         {
  59             e.printStackTrace(System.err);
  60             throw new java.lang.InstantiationError();
  61         }
  62     }
  63
  64     // misc
  65     public int getColumnCount()
  66     {
  67         XColumnsSupplier suppCols = UnoRuntime.queryInterface(
  68             XColumnsSupplier.class, m_rowSet );
  69         XIndexAccess columns = UnoRuntime.queryInterface(
  70             XIndexAccess.class, suppCols.getColumns() );
  71         return columns.getCount();
  72     }
  73
  74     // XRowSet
  75     public void execute() throws SQLException
  76     {
  77         m_rowSet.execute();
  78     }
  79
  80     public void addRowSetListener( XRowSetListener _listener )
  81     {
  82         m_rowSet.addRowSetListener( _listener );
  83     }
  84
  85     public void removeRowSetListener( XRowSetListener _listener )
  86     {
  87         m_rowSet.removeRowSetListener( _listener );
  88     }
  89
  90     public boolean next() throws SQLException
  91     {
  92         return m_rowSet.next();
  93     }
  94
  95     public boolean isBeforeFirst() throws SQLException
  96     {
  97         return m_rowSet.isBeforeFirst();
  98     }
  99
 100     public boolean isAfterLast() throws SQLException
 101     {
 102         return m_rowSet.isAfterLast();
 103     }
 104
 105     public boolean isFirst() throws SQLException
 106     {
 107         return m_rowSet.isFirst();
 108     }
 109
 110     public boolean isLast() throws SQLException
 111     {
 112         return m_rowSet.isLast();
 113     }
 114
 115     public void beforeFirst() throws SQLException
 116     {
 117         m_rowSet.beforeFirst();
 118     }
 119
 120     public void afterLast() throws SQLException
 121     {
 122         m_rowSet.afterLast();
 123     }
 124
 125     public boolean first() throws SQLException
 126     {
 127         return m_rowSet.first();
 128     }
 129
 130     public boolean last() throws SQLException
 131     {
 132         return m_rowSet.last();
 133     }
 134
 135     public int getRow() throws SQLException
 136     {
 137         return m_rowSet.getRow();
 138     }
 139
 140     public boolean absolute(int i) throws SQLException
 141     {
 142         return m_rowSet.absolute(i);
 143     }
 144
 145     public boolean relative(int i) throws SQLException
 146     {
 147         return m_rowSet.relative(i);
 148     }
 149
 150     public boolean previous() throws SQLException
 151     {
 152         return m_rowSet.previous();
 153     }
 154
 155     public void refreshRow() throws SQLException
 156     {
 157         m_rowSet.refreshRow();
 158     }
 159
 160     public boolean rowUpdated() throws SQLException
 161     {
 162         return m_rowSet.rowUpdated();
 163     }
 164
 165     public boolean rowInserted() throws SQLException
 166     {
 167         return m_rowSet.rowInserted();
 168     }
 169
 170     public boolean rowDeleted() throws SQLException
 171     {
 172         return m_rowSet.rowDeleted();
 173     }
 174
 175     // XRow
 176     public Object getStatement() throws SQLException
 177     {
 178         return m_rowSet.getStatement();
 179     }
 180
 181     public boolean wasNull() throws SQLException
 182     {
 183         return m_row.wasNull();
 184     }
 185
 186     public String getString(int i) throws SQLException
 187     {
 188         return m_row.getString(i);
 189     }
 190
 191     public boolean getBoolean(int i) throws SQLException
 192     {
 193         return m_row.getBoolean(i);
 194     }
 195
 196     public byte getByte(int i) throws SQLException
 197     {
 198         return m_row.getByte(i);
 199     }
 200
 201     public short getShort(int i) throws SQLException
 202     {
 203         return m_row.getShort(i);
 204     }
 205
 206     public int getInt(int i) throws SQLException
 207     {
 208         return m_row.getInt(i);
 209     }
 210
 211     public long getLong(int i) throws SQLException
 212     {
 213         return m_row.getLong(i);
 214     }
 215
 216     public float getFloat(int i) throws SQLException
 217     {
 218         return m_row.getFloat(i);
 219     }
 220
 221     public double getDouble(int i) throws SQLException
 222     {
 223         return m_row.getDouble(i);
 224     }
 225
 226     public byte[] getBytes(int i) throws SQLException
 227     {
 228         return m_row.getBytes(i);
 229     }
 230
 231     public Date getDate(int i) throws SQLException
 232     {
 233         return m_row.getDate(i);
 234     }
 235
 236     public Time getTime(int i) throws SQLException
 237     {
 238         return m_row.getTime(i);
 239     }
 240
 241     public DateTime getTimestamp(int i) throws SQLException
 242     {
 243         return m_row.getTimestamp(i);
 244     }
 245
 246     public XInputStream getBinaryStream(int i) throws SQLException
 247     {
 248         return m_row.getBinaryStream(i);
 249     }
 250
 251     public XInputStream getCharacterStream(int i) throws SQLException
 252     {
 253         return m_row.getCharacterStream(i);
 254     }
 255
 256     public Object getObject(int i, XNameAccess xNameAccess) throws SQLException
 257     {
 258         return m_row.getObject(i, xNameAccess);
 259     }
 260
 261     public XRef getRef(int i) throws SQLException
 262     {
 263         return m_row.getRef(i);
 264     }
 265
 266     public XBlob getBlob(int i) throws SQLException
 267     {
 268         return m_row.getBlob(i);
 269     }
 270
 271     public XClob getClob(int i) throws SQLException
 272     {
 273         return m_row.getClob(i);
 274     }
 275
 276     public XArray getArray(int i) throws SQLException
 277     {
 278         return m_row.getArray(i);
 279     }
 280 }