在Loadrunner中也提供了C对数据库操作的相关功能函数，以下这些数据库功能函数只能用于Web Services协议。

lr_db_connect

连接数据库

lr_db_disconnect

断开数据库的连接

lr_db_executeSQLStatement

执行SQL语句

lr_db_dataset_action

对数据库执行操作

lr_db_getValue

从数据集中检索值

各函数语法如下：

lr_db_connect("StepName", "ConnectionString=<connection_string>", "ConnectionName=<connection_name>", "ConnectionType=<connection_type>", LAST);

lr_db_disconnect("StepName=<step_name>", "ConnectionName=<connection_name>", LAST);

lr_db_executeSQLStatement("StepName=<step_name>", "ConnectionName=<connection_name>", "SQLStatement=<statement>", ["DatasetName=<dataset_name>",] LAST);

lr_db_dataset_action("StepName=<step_name>", "DatasetName=<dataset_name>", "Action=<action>", LAST);

lr_db_getValue("StepName=<step_name>", "DatasetName=<dataset_name>", "Column=<column>", "Row=<row>", "OutParam=<output_parm>", LAST);

下面以oracle数据库为例：

Action()
{
    int NumRows=0; 
    int i=1; 

    //建立数据库连接
    lr_db_connect("StepName=DatabaseConnection", 
                  "ConnectionString=Provider=OraOLEDB.Oracle.1;Password = test ;Persist Security Info=True; User ID  = test ; Data Source = betadb ; Server = 172.19.188.191", 
                  "ConnectionName=InvDatabaseConnection", 
                  "ConnectionType=OLEDB", 
                  LAST); 

     //执行SQL语句
     NumRows = lr_db_executeSQLStatement("StepName=PerformQuery", 
                                          "ConnectionName=InvDatabaseConnection", 
                                          "SQLStatement=SELECT cons_no,cons_id FROM c_cons where rownum<10", 
                                          "DatasetName=MyDataset", 
                                          LAST); 
      lr_output_message("The query returned %d rows.", NumRows); 

      //打印出结果
      lr_db_dataset_action("StepName=PrintDataset", 
                            "DatasetName=MyDataset",
                            "Action=PRINT", 
                           LAST);


      //利用循环检索数据值
      while (i<10) { 
          lr_db_getvalue("StepName=GetValue", 
                         "DatasetName=MyDataset", 
                         "Column=CONS_NO",
                         "Row=next",
                         "OutParam=MyOutputParam",
                         LAST); 
          lr_output_message("The value is: %s", lr_eval_string("{MyOutputParam}") ); 
          i=i+1; }


          //释放结果
            lr_db_dataset_action("StepName=RemoveDataset", 
                            "DatasetName=MyDataset",
                            "Action=REMOVE", 
                            LAST);


     //断开数据库连接
      lr_db_disconnect("StepName=Disconnect",
                       "ConnectionName=InvDatabaseConnection",
                       LAST); 

    return 0;
}

作者: dfine.sqa 发表于 2011-06-29 14:12 原文链接

Tag loadrunner,如何访问数据库
推荐.NET配套的通用数据层ORM框架：CYQ.Data 通用数据层框架