sql server性能测试

小喜子898

测试工具：loadrunner   数据库  ：sql server  协议：http+web services


/*
查询数据库方法
*/
sql()
{
        int NumRows=0;
        int i;
        lr_db_connect("StepName=DatabaseConnection",
        "ConnectionString=Data Source=127.0.0.1;Initial Catalog=waimai;Persist Security Info=True;User ID=sa;Password=123456",
        "ConnectionName=MeCon",
        "ConnectionType=SQL",
        LAST );

        //执行SQL
        NumRows = lr_db_executeSQLStatement("StepName=PerformQuery",
        "ConnectionName=MeCon",
        // 数据库语句

        //"SQLStatement=update dbo.yun_waimaibill set billstate=1,billremark='接单成功'where orderid=371218",
         "SQLStatement=select orderid from dbo.yun_waimaibill where billstate=0",
        "DatasetName=waimai",
          LAST );
         lr_output_message("The query returned %d rows.", NumRows);

  //打印查询结果

  //lr_db_dataset_action("StepName=PrintDataset",
// "DatasetName=waimai",
//  "Action=PRINT",
//        LAST );

//输出每一行的数据
         while(i<NumRows) {
lr_db_getvalue("StepName=GetValue",
           "DatasetName=waimai",
           "Column=orderid",
           "Row=next",
           "OutParam=OrderId",
           LAST);

lr_output_message("The value is: %s", lr_eval_string("{OrderId}") );
i=i+1;
   }         //关闭链接
        lr_db_disconnect("stepname=Disconnect","connectionname=MeCon",LAST);

}

/*
数据库更新方法
*/
select()
{
        int NumRows=0;
        int i;
        lr_db_connect("StepName=DatabaseConnection",
        "ConnectionString=Data Source=127.0.0.1;Initial Catalog=waimai;Persist Security Info=True;User ID=sa;Password=123456",
        "ConnectionName=MeCon",
        "ConnectionType=SQL",
        LAST );

        //执行SQL
        NumRows = lr_db_executeSQLStatement("StepName=PerformQuery",
        "ConnectionName=MeCon",
        // 数据库语句

        "SQLStatement=update dbo.yun_waimaibill set billstate=1,billremark='接单成功'where orderid={OrderId}",
        "DatasetName=waimai",
          LAST );
        lr_output_message("<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<:%s",lr_eval_string("{OrderId}"));


        //关闭链接
        lr_db_disconnect("stepname=Disconnect","connectionname=MeCon",LAST);

}