Libroffice BASIC

出自TSK WIKI
跳至導覽 跳至搜尋

資料庫程式碼

  • 取得現有資料庫名稱
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

相關連結