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()为获取此时的{楼号}和{单元号}的值

posted @ 2011-06-21 17:57  爱测试的猫咪  阅读(1123)  评论(0编辑  收藏  举报