软件测试工具robot里连接数据库的例子

发表于:2009-12-17来源:作者:点击数: 标签:
软件测试工具 robot 里连接 数据库 的例子 Sub Main Dim Result As Integer dim strconn as string dim conn as Object dim rs as Object dim testnumber1 as integer dim testnumber2 as integer 'Initially Recorded: 2006-3-27 11:14:23 'scrīpt Name: a

 

软件测试工具robot里连接数据库的例子

clearcase/" target="_blank" >cccccc cellSpacing=0 cellPadding=1 width="80%" align=center bgColor=#ffffff border=1 heihgt="">

        Sub Main
            Dim Result As Integer
            dim strconn as string
            dim conn as Object
            dim rs as Object
            dim testnumber1 as integer
            dim testnumber2 as integer
            'Initially Recorded: 2006-3-27  11:14:23
            'scrīpt Name: ado
            on error goto qq
            StartApplication "C:\WINNT\system32\calc.exe"
            Window SetContext, "Caption=计算器", ""
            strconn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\ado.mdb;Persist Security Info=False"
            set conn=createobject("ADODB.Connection")
            conn.open strconn
            set rs=createobject("ADODB.Recordset")
            rs.open "select number1,number2 from test\", conn
            rs.MoveFirst
            Window SetContext, "Caption=计算器", ""
            do while not rs.eof
               testnumber1=rs.fields(0).value
               testnumber2=rs.fields(1).value
               msgbox testnumber1
               msgbox testnumber2
               inputkeys str(testnumber1)
               inputkeys "{+}"
               inputkeys str(testnumber2)
               inputkeys "{=}"
               rs.MoveNext
            loop
            Window CloseWin, "", ""
            rs.close
            conn.close
            set rs=nothing
            set conn=nothing
            exit sub
        qq:
         resume          '恢复到出错位置下一个记录
        End Sub

原文转自:http://www.ltesting.net