「Libroffice BASIC」:修訂間差異
跳至導覽
跳至搜尋
| 第1行: | 第1行: | ||
==程式碼== | ==資料庫程式碼== | ||
*取得現有資料庫名稱 | *取得現有資料庫名稱 | ||
Dim DatabaseContext As Object | Dim DatabaseContext As Object | ||
| 第14行: | 第14行: | ||
DatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext") | DatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext") | ||
DataSource = DatabaseContext.getByName("Customers") | 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 | |||
==相關連結== | ==相關連結== | ||
[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] | ||
於 2015年2月2日 (一) 09:19 的修訂
資料庫程式碼
- 取得現有資料庫名稱
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