summaryrefslogtreecommitdiff
path: root/odk/examples/DevelopersGuide/Database/Sales.java
diff options
context:
space:
mode:
Diffstat (limited to 'odk/examples/DevelopersGuide/Database/Sales.java')
-rw-r--r--odk/examples/DevelopersGuide/Database/Sales.java250
1 files changed, 0 insertions, 250 deletions
diff --git a/odk/examples/DevelopersGuide/Database/Sales.java b/odk/examples/DevelopersGuide/Database/Sales.java
deleted file mode 100644
index 92716578..00000000
--- a/odk/examples/DevelopersGuide/Database/Sales.java
+++ /dev/null
@@ -1,250 +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 java.io.*;
-
-// import com.sun.star.comp.helper.RegistryServiceFactory;
-// import com.sun.star.comp.servicemanager.ServiceManager;
-// import com.sun.star.lang.XMultiServiceFactory;
-// import com.sun.star.lang.XServiceInfo;
-import com.sun.star.lang.XComponent;
-// import com.sun.star.bridge.XUnoUrlResolver;
-import com.sun.star.uno.*;
-import com.sun.star.util.Date;
-import com.sun.star.beans.XPropertySet;
-import com.sun.star.container.XNameAccess;
-import com.sun.star.sdbc.*;
-
-public class Sales
-{
- private XConnection con;
-
- public Sales(XConnection connection )
- {
- con = connection;
- }
- // create the table sales.
- public void createSalesTable() throws com.sun.star.uno.Exception
- {
- String createTableSales = "CREATE TABLE SALES " +
- "(SALENR INTEGER NOT NULL, " +
- " COS_NR INTEGER, " +
- " SNR INTEGER, " +
- " NAME VARCHAR(50)," +
- " SALEDATE DATE," +
- " PRICE FLOAT(10), " +
- " PRIMARY KEY(SALENR)" +
- " )";
- XStatement stmt = con.createStatement();
- stmt.executeUpdate( createTableSales );
- }
-
- // drop the table sales.
- public void dropSalesTable() throws com.sun.star.uno.Exception
- {
- String createTableSalesman = "DROP TABLE SALES ";
- XStatement stmt = con.createStatement();
- stmt.executeUpdate( createTableSalesman );
- }
-
- // insert data into the table sales.
- public void insertDataIntoSales() throws com.sun.star.uno.Exception
- {
- XStatement stmt = con.createStatement();
- stmt.executeUpdate("INSERT INTO SALES " +
- "VALUES (1, '100', '1','Linux','2001-02-12',15)");
- stmt.executeUpdate("INSERT INTO SALES " +
- "VALUES (2, '101', '2','Beef','2001-10-18',15.78)");
- stmt.executeUpdate("INSERT INTO SALES " +
- "VALUES (3, '104', '4','orange juice','2001-08-09',1.5)");
- }
-
- // update the table sales with a prepared statement.
- public void updateSales() throws com.sun.star.uno.Exception
- {
- XStatement stmt = con.createStatement();
- String updateString = "UPDATE SALES " +
- "SET PRICE = 30 " +
- "WHERE SALENR = 1";
- stmt.executeUpdate(updateString);
- }
-
- // retrieve the data of the table sales.
- public void retrieveSalesData() throws com.sun.star.uno.Exception
- {
- XStatement stmt = con.createStatement();
- String query = "SELECT NAME, PRICE FROM SALES " +
- "WHERE SALENR = 1";
- XResultSet rs = stmt.executeQuery(query);
- XRow row = (XRow)UnoRuntime.queryInterface(XRow.class, rs);
- while (rs.next()) {
- String s = row.getString(1);
- float n = row.getFloat(2);
- System.out.println("The current price for " + s + " is: $" + n + ".");
- }
- }
-
- // create a scrollable resultset.
- public void retrieveSalesData2() throws com.sun.star.uno.Exception
- {
- // example for a programmatic way to do updates. This doesn't work with adabas.
- XStatement stmt = con.createStatement();
- XPropertySet xProp = (XPropertySet)UnoRuntime.queryInterface(XPropertySet.class,stmt);
-
- xProp.setPropertyValue("ResultSetType", new java.lang.Integer(ResultSetType.SCROLL_INSENSITIVE));
- xProp.setPropertyValue("ResultSetConcurrency", new java.lang.Integer(ResultSetConcurrency.UPDATABLE));
-
- XResultSet srs = stmt.executeQuery("SELECT NAME, PRICE FROM SALES");
- XRow row = (XRow)UnoRuntime.queryInterface(XRow.class,srs);
-
- srs.afterLast();
- while (srs.previous()) {
- String name = row.getString(1);
- float price = row.getFloat(2);
- System.out.println(name + " " + price);
- }
-
- srs.last();
- XRowUpdate updateRow = (XRowUpdate)UnoRuntime.queryInterface(XRowUpdate.class,srs);
- updateRow.updateFloat(2, (float)0.69);
-
- XResultSetUpdate updateRs = ( XResultSetUpdate )UnoRuntime.queryInterface(
- XResultSetUpdate.class,srs);
- updateRs.updateRow(); // this call updates the data in DBMS
-
- srs.last();
- updateRow.updateFloat(2, (float)0.99);
- updateRs.cancelRowUpdates();
- updateRow.updateFloat(2, (float)0.79);
- updateRs.updateRow();
- }
-
- // inserts a row programmatically.
- public void insertRow() throws com.sun.star.uno.Exception
- {
- // example for a programmatic way to do updates. This doesn't work with adabas.
- XStatement stmt = con.createStatement();
-// stmt.executeUpdate("INSERT INTO SALES " +
-// "VALUES (4, 102, 5, 'FTOP Darjeeling tea', '2002-01-02',150)");
-//
-// stmt = con.createStatement();
- XPropertySet xProp = (XPropertySet)UnoRuntime.queryInterface(XPropertySet.class,stmt);
- xProp.setPropertyValue("ResultSetType", new java.lang.Integer(ResultSetType.SCROLL_INSENSITIVE));
- xProp.setPropertyValue("ResultSetConcurrency", new java.lang.Integer(ResultSetConcurrency.UPDATABLE));
- XResultSet rs = stmt.executeQuery("SELECT * FROM SALES");
- XRow row = (XRow)UnoRuntime.queryInterface(XRow.class,rs);
-
- // insert a new row
- XRowUpdate updateRow = (XRowUpdate)UnoRuntime.queryInterface(XRowUpdate.class,rs);
- XResultSetUpdate updateRs = ( XResultSetUpdate )UnoRuntime. queryInterface(XResultSetUpdate.class,rs);
- updateRs.moveToInsertRow();
- updateRow.updateInt(1, 4);
- updateRow.updateInt(2, 102);
- updateRow.updateInt(3, 5);
- updateRow.updateString(4, "FTOP Darjeeling tea");
- updateRow.updateDate(5, new Date((short)1,(short)2,(short)2002));
- updateRow.updateFloat(6, 150);
- updateRs.insertRow();
- }
-
- // deletes a row programmatically.
- public void deleteRow() throws com.sun.star.uno.Exception
- {
- // example for a programmatic way to do updates. This doesn't work with adabas.
- XStatement stmt = con.createStatement();
- XPropertySet xProp = (XPropertySet)UnoRuntime.queryInterface(XPropertySet.class,stmt);
- xProp.setPropertyValue("ResultSetType", new java.lang.Integer(ResultSetType.SCROLL_INSENSITIVE));
- xProp.setPropertyValue("ResultSetConcurrency", new java.lang.Integer(ResultSetConcurrency.UPDATABLE));
- XResultSet rs = stmt.executeQuery("SELECT * FROM SALES");
- XRow row = (XRow)UnoRuntime.queryInterface(XRow.class,rs);
-
- XResultSetUpdate updateRs = ( XResultSetUpdate )UnoRuntime. queryInterface(XResultSetUpdate.class,rs);
- // move to the inserted row
- rs.absolute(4);
- updateRs.deleteRow();
- }
-
- // refresh a row
- public void refreshRow() throws com.sun.star.uno.Exception
- {
- // example for a programmatic way to do updates. This doesn't work with adabas.
- // first we need the 4 row
- insertRow();
-
- XStatement stmt = con.createStatement();
- XPropertySet xProp = (XPropertySet)UnoRuntime.queryInterface(XPropertySet.class,stmt);
- xProp.setPropertyValue("ResultSetType", new java.lang.Integer(ResultSetType.SCROLL_INSENSITIVE));
- xProp.setPropertyValue("ResultSetConcurrency", new java.lang.Integer(ResultSetConcurrency.READ_ONLY));
- XResultSet rs = stmt.executeQuery("SELECT NAME, PRICE FROM SALES");
- XRow row = (XRow)UnoRuntime.queryInterface(XRow.class, rs);
- rs.absolute(4);
- float price1 = row.getFloat(2);
-
- // modifiy the 4 row
- XRowUpdate updateRow = (XRowUpdate)UnoRuntime.queryInterface(XRowUpdate.class,rs);
- XResultSetUpdate updateRs = ( XResultSetUpdate )UnoRuntime. queryInterface(XResultSetUpdate.class,rs);
- updateRow.updateFloat(2, 150);
- updateRs.updateRow();
- // repositioning
- rs.absolute(4);
- rs.refreshRow();
- float price2 = row.getFloat(2);
- if (price2 != price1) {
- System.out.println("Prices are different.");
- }
- else
- System.out.println("Prices are equal.");
- deleteRow();
- }
-
- // displays the column names
- public void displayColumnNames() throws com.sun.star.uno.Exception
- {
- XStatement stmt = con.createStatement();
- XPropertySet xProp = (XPropertySet)UnoRuntime.queryInterface(XPropertySet.class,stmt);
- xProp.setPropertyValue("ResultSetType", new java.lang.Integer(ResultSetType.SCROLL_INSENSITIVE));
- xProp.setPropertyValue("ResultSetConcurrency", new java.lang.Integer(ResultSetConcurrency.READ_ONLY));
- XResultSet rs = stmt.executeQuery("SELECT NAME, PRICE FROM SALES");
- XResultSetMetaDataSupplier xRsMetaSup = (XResultSetMetaDataSupplier)
- UnoRuntime.queryInterface(XResultSetMetaDataSupplier.class,rs);
- XResultSetMetaData xRsMetaData = xRsMetaSup.getMetaData();
- int nColumnCount = xRsMetaData.getColumnCount();
- for(int i=1 ; i <= nColumnCount ; ++i)
- {
- System.out.println("Name: " + xRsMetaData.getColumnName(i) + " Type: " +
- xRsMetaData.getColumnType(i));
- }
- }
-}
-
generated by cgit v1.2.3 (git 2.39.1) at 2024-06-09 16:46:11 +0000