数据库连接

)Sh;T;HaR"|9L0/*循环查询数据*/51Testing软件测试网@%r*g
XY'}

CG I,u;`0Action()51Testing软件测试网4Z$` J8~%I
{51Testing软件测试网9V&w&} c,bjz b
  int NumRows=0;51Testing软件测试网T`YMt"Q
  int i;51Testing软件测试网nJr.I(M1d:?|Qp
 //连接mysql数据库51Testing软件测试网Q*lB6k v
    lr_db_connect("StepName=Mysql",
9h+m8eTGnZo0s0                  "ConnectionString=Driver=MySQL ODBC 5.1 Driver;SERVER=localhost;"51Testing软件测试网Zcb}4eL!V2{
w
                  "PORT=3306;DATABASE=phpwind_db;USER=phpwind_user;PASSWORD=admin",
la ilL6KE&C9t0                  "ConnectionName=db1","ConnectionType=ODBC",LAST );

    //调用数据SQL51Testing软件测试网Y"d&l'l"d8f

   
L8i
n1Q X0 lr_start_transaction("sql");51Testing软件测试网3}3kzh
C~*`'dl%V

  NumRows=lr_db_executeSQLStatement("StepName=PerformQuery",51Testing软件测试网!\q8aI"B:Va;@8fi {
          "ConnectionName=db1",
*B|(Tl*S4_w$k4A]_0          "SQLStatement=SELECT * FROM `pw_members` ;",
&O)bg&kp5^|0            "DatasetName=MyDataset",
^hLP1d
zS0           LAST );51Testing软件测试网Up,hE@W)|;t
    51Testing软件测试网h(KlPF%V[
 lr_end_transaction("sql", LR_AUTO);

uO S|8S3HG@0    lr_output_message("The query returned %d rows.", NumRows);
4H5Tr9}7G:S'K?4idL|0 while (i<NumRows) {51Testing软件测试网F%\/?5\oE6Gz
  lr_db_getvalue("StepName=GetValue","DatasetName=MyDataset","Column=username","Row=next","OutParam=MyOutputParam",LAST);
app xiJ.@0  lr_output_message("The value is :%s",lr_eval_string("{MyOutputParam}"));
!t^1sA R*IY0  i=i+1;
n8SN#TgCnp0 }51Testing软件测试网 A6VWp+BnQ@
 lr_db_disconnect("StepName=Disconnect","ConnectionName=db1",LAST);

zG#c(K M/|F0 51Testing软件测试网 @ a[J(WVn jU^

 return 0;51Testing软件测试网MF Vb'H
}
9Ez`8~"t1B051Testing软件测试网6xE z ~2hkQp'C#l$fC