loadrunner11连接mysql数据库操作

#include "Ptt_MySQL.h"
#include "mysql.h"
#include "mysql_com.h"
#include "mysql_time.h"


#define MYSQLSERVER "127.0.0.1"
#define MYSQLUSERNAME "root"
#define MYSQLPASSWORD "123456"
#define MYSQLPORT     "3306"
#define MYSQLDB       "mytest"
char chQuery[512];
int statu=1;
int status=0;
MYSQL *Mconn;
int conn_fail=0;conn_iter=0;
                    
vuser_init()
{


lr_load_dll("libmysql.dll");
lr_start_transaction("mysql_connection");
     Mconn=mysql_init(NULL);
   if(Mconn==NULL){


      lr_message("Error -1:error init mysql-%s",mysql_error(Mconn));
      statu=0;
      lr_end_transaction("mysql_connection",LR_FAIL);
}


   do{
 if(!mysql_real_connect(Mconn,MYSQLSERVER,MYSQLUSERNAME,MYSQLPASSWORD,MYSQLDB,atoi(MYSQLPORT),NULL,0))
 {
     conn_fail=-2;
     conn_iter++;
     sleep(100);


              
 }else
     conn_fail=0;


   }while(conn_fail<0 && conn_iter<10);


   if(conn_fail<0){
       lr_message("ERROR -2:%s",mysql_error(Mconn));
       
      statu=0;
      lr_end_transaction("mysql_connection",LR_FAIL);
   }
   else{
       statu=1;
       lr_message("mysql database connect success.");
       lr_end_transaction("mysql_connection",LR_PASS);
   }


return 0;

}

Action()
{
  if(statu){
   lr_start_transaction("mysql_insert");
   sprintf(chQuery,"insert into customer(name,password) value('%s','%s')",lr_eval_string("lxx{user}"),lr_eval_string("{pwd}"));
   status=lr_mysql_query(Mconn,chQuery);
  }
if(status!=0){
lr_end_transaction("mysql_insert",LR_FAIL);
}
else{


lr_end_transaction("mysql_insert",LR_PASS);
}
if(statu){


lr_start_transaction("mysql_query");
sprintf(chQuery,"select * from customer");
status=lr_mysql_query(Mconn,chQuery);
}


if(status!=0)
{
lr_end_transaction("mysql_query",LR_FAIL);
}
else{


lr_end_transaction("mysql_query",LR_PASS);
}


if(statu){


lr_start_transaction("mysql_update");
sprintf(chQuery,"update customer set password='123456' where name='lxx2'");
status=lr_mysql_query(Mconn,chQuery);
}


if(status!=0)
{
lr_end_transaction("mysql_update",LR_FAIL);
}
else{


lr_end_transaction("mysql_update",LR_PASS);
}

return 0;
}

vuser_end()
{
lr_mysql_disconnect(Mconn);
return 0;
}