Loadrunner 参数化sql语句
lrd_db_option(Con5, OT_ODBC_CURRENT_QUALIFIER, "jf", 0);
lrd_open_cursor(&Csr41, Con5, 0);
lrd_db_option(Csr41, OT_ODBC_SS_HIDDEN_COLUMNS, "ON", 0);
lrd_db_option(Csr41, OT_ODBC_QUERY_TIMEOUT, (void FAR const *)30, 0);
lrd_stmt(Csr41, "select distinct c_bjbh ,c_azwz,c_yhbh,c_yhxm from bjzc WHERE c_bjlx "
"like '01%' and c_azwz like '北京方舟6号{楼号}号楼{单元号}单元%' order "
"by c_bjbh asc", -1, 1, 0 /*None*/, 0);
//lr_eval_string("{楼号}");
lr_output_message("楼号是 %s,单元号是 %s",lr_eval_string("{楼号}"),lr_eval_string("{单元号}"));
{楼号}和{单元号}是参数化的参数,楼号和单元号随机取。lr_output_message()作用是在log日志中打印信息,lr_eval_string()为获取此时的{楼号}和{单元号}的值