/**************************************************************
*
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership. The ASF licenses this file
* to you under the Apache License, Version 2.0 (the
* "License"); you may not use this file except in compliance
* with the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing,
* software distributed under the License is distributed on an
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
* KIND, either express or implied. See the License for the
* specific language governing permissions and limitations
* under the License.
*
*************************************************************/
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 SalesMan
{
private XConnection con;
public SalesMan(XConnection connection )
{
con = connection;
}
// create the table salesman.
public void createSalesManTable() throws com.sun.star.uno.Exception
{
String createTableSalesman = "CREATE TABLE SALESMAN " +
"(SNR INTEGER NOT NULL, "+
" FIRSTNAME VARCHAR(50)," +
" LASTNAME VARCHAR(100)," +
" STREET VARCHAR(50)," +
" STATE VARCHAR(50)," +
" ZIP INTEGER," +
" BIRTHDATE DATE," +
" PRIMARY KEY(SNR)" +
" )";
XStatement stmt = con.createStatement();
stmt.executeUpdate( createTableSalesman );
}
// drop the table salesman
public void dropSalesManTable() throws com.sun.star.uno.Exception
{
String createTableSalesman = "DROP TABLE SALESMAN ";
XStatement stmt = con.createStatement();
stmt.executeUpdate( createTableSalesman );
}
// insert data into the table salesman
public void insertDataIntoSalesMan() throws com.sun.star.uno.Exception
{
XStatement stmt = con.createStatement();
stmt.executeUpdate("INSERT INTO SALESMAN " +
"VALUES (1, 'Joseph', 'Smith','Bond Street','CA',95460,"
+ "'1946-07-02')");
stmt.executeUpdate("INSERT INTO SALESMAN " +
"VALUES (2, 'Frank', 'Jones','Lake Silver','CA',95460,"
+ "'1963-12-24')");
stmt.executeUpdate("INSERT INTO SALESMAN " +
"VALUES (3, 'Jane', 'Esperansa','23 Hollywood drive','CA',95460,"
+ "'1972-04-01')");
stmt.executeUpdate("INSERT INTO SALESMAN " +
"VALUES (4, 'George', 'Flint','12 Washington street','CA',95460,"
+ "'1953-02-13')");
stmt.executeUpdate("INSERT INTO SALESMAN " +
"VALUES (5, 'Bob', 'Meyers','2 Moon way','CA',95460,"
+ "'1949-09-07')");
}
// update the table sales man with a prepared statement.
public void updateSalesMan() throws com.sun.star.uno.Exception
{
XPreparedStatement updateStreet = con.prepareStatement(
"UPDATE SALESMAN SET STREET = ? WHERE SNR = ?");
XParameters setPara = (XParameters)UnoRuntime.queryInterface(XParameters.class,updateStreet);
setPara.setString(1, "34 Main Road");
setPara.setInt(2, 1);
updateStreet.executeUpdate();
setPara.setString(1, "Marryland");
setPara.setInt(2, 4);
updateStreet.executeUpdate();
// changes STREET column of salesman George to Marryland
setPara.setString(1, "Michigan road");
updateStreet.executeUpdate();
// changes again STREET column of salesman George to
// Michigan road
// parameter 2 stayed 4, and the first parameter was reset
// to "Michigan road")
setPara.setString(1, "Bond Street");
setPara.setInt(2, 3);
int n = updateStreet.executeUpdate();
System.out.println("executeUpdate returns: " + n);
// n = 1 because one row had a change in it
}
// retrieve the data of the table salesman
public void retrieveSalesManData() throws com.sun.star.uno.Exception
{
XStatement stmt = con.createStatement();
XResultSet rs = stmt.executeQuery("SELECT FIRSTNAME, LASTNAME, BIRTHDATE FROM SALESMAN");
XRow row = (XRow)UnoRuntime.queryInterface(XRow.class,rs);
while ( rs != null && rs.next() ) {
String fn = row.getString( 1 );
String ln = row.getString( 2 );
Date dt = row.getDate( 3 );
System.out.println(fn + " " + ln + " " + dt.Month + "/" + dt.Day + "/" + dt.Year);
}
}
}