QTP使用总结(全)（QTP use summary (all)）.doc

QTP使用总结(全)（QTP use summary (all)） QTP connect to oracle and operate the database. Here is an example of oracle 9i, and other database connection methods are interlinked. A. First of all, it is important to recommend the ODBC data source to the native. This is a basic operation. B. Access to oracles connection string method to create a new one locally. *. TXT file, modify the extension name udl, double click on the *. Udl file, open the database link attributes, locate the provider selected graphics card, select the oracle connection oracle provider for OLE DB, click next, the input data, the database user name and password, check the save password, click the test connection, and then use UE or notepad to open *. Udl file, the oracle connection string have been generated, for example The Provider = OraOLEDB. Oracle. 1; Persist Security Info = False; User ID = test; Password = test; Data Source = 192.168.13.19 C. Connect to the database in QTP Dim Cnn defines a database connection string Set Cnn = CreateObject ( ADODB. Connection ) parameter brackets must be in parentheses ConnectionString = Provider = OraOLEDB. Oracle. 1; Persist Security Info = False; User ID = test; Password = test; Data Source = 31 Open Open database connection If Cnn. State = 0 Then determine If the database connection is successful Reporter. ReportEvent micFail, testing, fail to connect database The else Reporter. ReportEvent micPass, testing, connection database success End the If If Cnn. State 0 then Set Rs = CreateObject ( adodb.recordset ) generates a Recordset object STRSQL = Select * from t_sys_user to query all records of t_sys_user from the database RRS. Open STRSQL, Cnn, 1, 3 execute SQL statements, records can be moved freely, and single-digit records are in read-only mode Ydl = Rs ( USER_ID ) takes the record of the field as USER_ID, and the cursor is defined in the first row, so it is the first row of the row that the field is in Msgbox ydl Dim a, A = 1188 the database can be obtai