Robot GUI腳本操作SQL SERVER數據庫

發表于:2007-04-29來源:作者:點擊數: 標簽:sql腳本操作robotgui
代碼如下(手工編寫): '$Include "sqautil.sbh" Sub Main Dim Result As Integer Dim connection As Long Dim retcode As Vari ant dim outputstr,query as string Dim out(1 To 1,1 to 1) As Variant '通過ODBC連接到 java script:;" onClick="javascript:t

代碼如下(手工編寫):

'$Include "sqautil.sbh"
Sub Main
    Dim Result As Integer
    Dim connection As Long
    Dim retcode As Variant
    dim outputstr,query as string   
    Dim out(1 To 1,1 to 1)  As Variant  
    '通過ODBC連接到javascript:;" onClick="javascript:tagshow(event, '%CA%FD%BE%DD%BF%E2');" target="_self">數據庫,要先創建ODBC
    connection = SQLOpen("DSN=server;UID=sa;PWD=998855", outputstr,)
    '查詢語句
    query = "select password from customerinfo where userid=100"
    '執行查詢
    retcode = SQLExecQuery(connection,query)
    '取回結果,結果存入二維數組
    retcode = SQLRetrieve(connection,out())
    '取回結果,如果結果存入文件請使用
    'retcode = SQLRetrieveToFile(connection,"c:\test.txt")
    '顯示結果
    msgbox  out(1,1) 
    '關閉數據庫連接
    retcode = SQLClose(connection)       
End Sub
  
    詳細的命令用法,可以查閱Robot');" target="_self">Robot在線幫助。


原文轉自:http://www.anti-gravitydesign.com

...

熱門標簽

国产97人人超碰caoprom_尤物国产在线一区手机播放_精品国产一区二区三_色天使久久综合给合久久97