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);
}
}
}