「Libroffice BASIC」:修訂間差異
跳至導覽
跳至搜尋
| 第51行: | 第51行: | ||
==相關連結== | ==相關連結== | ||
[https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide OpenOffice.org BASIC Programming Guide] | *[https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide OpenOffice.org BASIC Programming Guide] | ||
*[http://ycfu.blog.mypc.tw/2011/04/openoffice-basic-macro2.html 阿呆的blog] | |||
於 2015年2月2日 (一) 09:20 的最新修訂
資料庫程式碼
- 取得現有資料庫名稱
Dim DatabaseContext As Object
Dim Names
Dim I As Integer
DatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext")
Names = DatabaseContext.getElementNames()
For I = 0 To UBound(Names())
MsgBox Names(I)
Next I
- 使用指定之資料庫名稱
Dim DatabaseContext As Object
Dim DataSource As Object
DatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext")
DataSource = DatabaseContext.getByName("Customers")
- 完整程式碼
Sub Main
REM 連結 DataSource
Dim DatabaseContext As Object
Dim DataSource As Object
DatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext")
DataSource = DatabaseContext.getByName("OOoTEST")
REM 取得查詢
Dim QueryDefinitions As Object
QueryDefinitions = DataSource.getQueryDefinitions()
QueryDefinition = QueryDefinitions("ProductQuery")
REM 連結SQL伺服器
Dim InteractionHandler As Object
Dim Connection As Object
InteractionHandler = createUnoService("com.sun.star.task.InteractionHandler")
Connection = DataSource.ConnectWithCompletion(InteractionHandler)
REM 從查詢中取得SQL Code,並查詢SQL伺服器
Dim Statement As Object
Statement = Connection.createStatement()
ResultSet = Statement.executeQuery(QueryDefinition.Command)
REM 查詢完成,取出查詢結果
Dim DATA_ID As String
Dim DATA_NAME As String
Dim DATA_PRICE As String
If Not IsNull(ResultSet) Then
While ResultSet.next
DATA_ID = ResultSet.getString(1)
DATA_NAME = ResultSet.getString(2)
DATA_PRICE = ResultSet.getString(3)
MsgBox "ID:"+ DATA_ID + " 名稱:" + DATA_NAME + " 價格:" + DATA_PRICE
Wend
End If
REM 關閉SQL伺服器連線
Connection.Close()
End Sub