1# ************************************************************* 2# 3# Licensed to the Apache Software Foundation (ASF) under one 4# or more contributor license agreements. See the NOTICE file 5# distributed with this work for additional information 6# regarding copyright ownership. The ASF licenses this file 7# to you under the Apache License, Version 2.0 (the 8# "License"); you may not use this file except in compliance 9# with the License. You may obtain a copy of the License at 10# 11# http://www.apache.org/licenses/LICENSE-2.0 12# 13# Unless required by applicable law or agreed to in writing, 14# software distributed under the License is distributed on an 15# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16# KIND, either express or implied. See the License for the 17# specific language governing permissions and limitations 18# under the License. 19# 20# ************************************************************* 21 22import uno 23 24from com.sun.star.sdb.CommandType import COMMAND 25 26def main(): 27 28 connectionString = "socket,host=localhost,port=2002" 29 30 url = "uno:"+connectionString + ";urp;StarOffice.ComponentContext" 31 32 localCtx = uno.getComponentContext() 33 localSmgr = localCtx.ServiceManager 34 resolver = localSmgr.createInstanceWithContext( 35 "com.sun.star.bridge.UnoUrlResolver", localCtx) 36 ctx = resolver.resolve( url ) 37 smgr = ctx.ServiceManager 38 39 rowset =smgr.createInstanceWithContext( "com.sun.star.sdb.RowSet", ctx ) 40 rowset.DataSourceName = "Bibliography" 41 rowset.CommandType = COMMAND 42 rowset.Command = "SELECT IDENTIFIER, AUTHOR FROM biblio" 43 44 rowset.execute(); 45 46 print("Identifier\tAuthor") 47 48 id = rowset.findColumn( "IDENTIFIER" ) 49 author = rowset.findColumn( "AUTHOR" ) 50 while rowset.next(): 51 print(rowset.getString( id ) + "\t" + repr( rowset.getString( author ) )) 52 53 54 rowset.dispose(); 55 56main() 57