loadrunner测试数据库性能sql语句的脚本例子

Loadrunner8CAPIVuserMySQLsql语句性能的B/Sviewincopytoclipboardprint?{intintdb_connection;intquery_result;MYSQL_RESchar**result_row;//查询的数据衕char*server="localhost";char*user="root";char*password="123456";char*database="test";intport=3306;intunix_socket=NULL;intflags=0;libmysql.dllrc=lr_load_dll("C:\\ProgramFiles\\MySQL\\MySQLServerif(rc!=0)lr_error_message("Couldnotloadlibmysql.dll");}MySQLdb_connection=mysql_init(NULL);if(db_connection==NULL){lr_error_message("Insufficientmemory");}MySQLrc=mysql_real_connect(db_connection,server,user,password,database,port,unix_socket,flags);if(rc==NULL)lr_error_message("%s",mysql_error(db_connection));}//此处的{ORDER_ID}是一个参数，简单测试时可以用一个常数代替lr_save_string(lr_eval_string("INSERTINTOtest_data(order_id)VALUES({ORDER_ID})"),"paramInsertQuery");rc=mysql_query(db_connection,if(rc!=0){lr_error_message("%s",mysql_error(db_connection));}//从数据库一个数据并显rc=mysql_query(db_connection,"SELECTorder_idFROMtest_dataWHEREstatusISFALSELIMIT1");if(rc!=0)lr_error_message("%s",mysql_error(db_connection));}query_result=mysql_use_result(db_connection);if(query_result==NULL){lr_error_message("%s",mysql_error(db_connection));}//如果结果集包含多行数据，需要多次调用mysql_fetch_rowresult_row=(char**)mysql_fetch_row(query_result);if(result_row==NULL){lr_error_message("Didnotexpecttheresultsettobe}//保存参数，用于删除这行数据lr_save_string(result_row[0],"paramOrderID");lr_output_message("OrderIDis:%s",InnoDBrcmysql_query(db_connection,"BEGIN");if(rc!=0){lr_error_message("%s",mysql_error(db_connection));}//使用"FORUPDATE"rc=mysql_query(db_connection,"SELECTorder_idFROMtest_dataWHEREstatusISFALSELIMIT1FORUPDATE");if(rc!=0)lr_error_message("%s",mysql_error(db_connection));}query_result=mysql_use_result(db_connection);if(query_result==NULL){lr_error_message("%s",mysql_error(db_connection));}result_row=(char**)mysql_fetch_row(query_result);if(result_row==NULL){}lr_save_string(result_row[0],"paramOrderID");lr_output_message("OrderIDis:%s",lr_save_string(lr_eval_string("UPDATEtest_dataSETstatus=TRUE,date_used=NOW()WHERErc=mysql_query(db_connection,if(rc!=0){lr_error_message("%s",mysql_error(db_connection));}rc=mysql_query(db_connection,"COMMIT");if(rc!=0)lr_error_message("%s",mysql_error(db_connection));}rc=mysql_query(db_connection,"SELECTorder_idFROMtest_dataWHEREstatusISFALSELIMIT1");if(rc!=0)lr_error_message("%s",mysql_error(db_connection));}query_result=mysql_use_result(db_connection);if(query_result==NULL){lr_error_message("%s",mysql_error(db_connection));}result_row=(char**)mysql_fetch_row(query_result);if(result_row==NULL){lr_output_message("Resultsetisemptyasexpected");}elselr_error_message("Didnotexpecttheresultsettocontainany}lr_save_string(lr_eval_string("DELETEFROMtest_dataWHEREorder_id=rc=mysql_query(db_connection,if(rc!=0){lr_error_message("%s",mysql_error(db_connection));}MySQLreturn0;}{intintdb_connection;intquery_result;MYSQL_RESchar**result_row;//查询的数据衕char*server="localhost";char*user="root";char*password="123456";char*database="test";intport=3306;intunix_socket=NULL;intflags=0;libmysql.dllrc=lr_load_dll("C:\\ProgramFiles\\MySQL\\MySQLServerif(rc!=0)lr_error_message("Couldnotloadlibmysql.dll");}MySQLdb_connection=mysql_init(NULL);if(db_connection==NULL){lr_error_message("Insufficientmemory");}MySQLrc=mysql_real_connect(db_connection,server,user,password,database,port,unix_socket,flags);if(rc==NULL)lr_error_message("%s",mysql_error(db_connection));}//此处的{ORDER_ID}是一个参数，简单测试时可以用一个常数代替lr_save_string(lr_eval_string("INSERTINTOtest_data(order_id)VALUES({ORDER_ID})"),"paramInsertQuery");rc=mysql_query(db_connection,if(rc!=0){lr_error_message("%s",mysql_error(db_connection));}//从数据库一个数据并显rc=mysql_query(db_connection,"SELECTorder_idFROMtest_dataWHEREstatusISFALSELIMIT1");if(rc!=0)lr_error_message("%s",mysql_error(db_connection));}query_result=mysql_use_result(db_connection);if(query_result==NULL){lr_error_message("%s",mysql_error(db_connection));}mysql_fetch_rowNULLresult_row=(char**)mysql_fetch_row(query_result);if(result_row==NULL)lr_error_message("Didnotexpecttheresultsettobeempty");}//保存参数，用于删除这行数据lr_save_string(result_row[0],"paramOrderID");lr_output_message("OrderIDis:%s",InnoDBrc=mysql_query(db_connection,"BEGIN");if(rc!=0)lr_error_message("%s",mysql_error(db_connection));}//使用"FORUPDATE"rc=mysql_query(db_connection,"SELECTorder_idFROMtest_dataWHEREstatusISFALSELIMIT1FORUPDATE");if(rc!=0)lr_error_message("%s",mysql_error(db_connection));}query_result=mysql_use_result(db_connection);if(query_result==NULL){lr_error_message("%s",mysql_error(db_connection));}result_row=(char**)mysql_fetch_row(query_result);if(result_row==NULL){}lr_save_string(result_row[0],"paramOrderID");lr_output_message("OrderIDis:%s",lr_save_string(lr_eval_string("UPDATEtest_dataSETstatus=TRUE,date_used=NOW()WHERErc=mysql_query(db_connection,if(rc!=0){lr_error_message("%s",mysql_error(db_connection));}rc=mysql_query(db_connection,"COMMIT");if(rc!=0)lr_error_message("%s",}rc=mysql_query(db_connection,"SELECTorder_idFROMtest_dataWHEREstatusISFALSELIMIT1");if(rc!=0)lr_error_message("%s",mysql_error(db_connection));}query_result=mysql_use_result(db_connection);if(query_result==NULL){lr_error_message("%s",mysql_error(db_connection));}result_row=(char**)mysql_fetch_row(query_result);if(result_row==