mfc mysql odbc 并发_LR实现mysql语句并发（走ODBC）

//在此之前请先安装Mysql的ODBC驱动 #include "lrd.h" Action() { static LRD_INIT_INFO InitInfo = {LRD_INIT_INFO_EYECAT}; static LRD_DEFAULT_DB_VERSION DBTypeVersion[] = {   {LRD_DBTYPE_ODBC, LRD_DBVERSION_ODBC_30},   {LRD_DBTYPE_NONE, LRD_DBVERSION_NONE} }; static LRD_CONTEXT FAR * Ctx1; static LRD_CONNECTION FAR * Con1; static LRD_CURSOR FAR *     Csr1; //上面的定义的代码如果录制脚本，在vdf.h中就有定义，同时还有一些其他文件 //如果手写脚本，则需要手工添加，主要是定义各种变量 //查询行数 unsigned long count=0; //初始 lrd_init(&InitInfo, DBTypeVersion); //打开上下文 lrd_open_context(&Ctx1, LRD_DBTYPE_ODBC, 0, 0, 0); //申请连接的内存 lrd_alloc_connection(&Con1, LRD_DBTYPE_ODBC, Ctx1, 0 /*Unused*/, 0); //打开连接，注意DRIVER就是上面安装的 lrd_open_connection(&Con1, LRD_DBTYPE_ODBC, "", "","", "DRIVER=MySQL ODBC 5.1 Driver;UID=replication;PWD=123456;SERVER=192.168.2.123;DATABASE=rms_219_pt_20; PORT=3308", Ctx1, 1, 0); //打开游标 lrd_open_cursor(&Csr1, Con1, 0); lr_rendezvous("vchbf"); lr_start_transaction("dggg"); //Sql语句，注意1代表的意思是，立马执行 lrd_stmt(Csr1, "SELECT COUNT(1) FROM (SELECT COUNT(1) FROM `consumption_history` c INNER JOIN (SELECT cp.`payment_money_rmb`, cp.`business_date` FROM consumption_payment_history cp  INNER JOIN payment_pattern p ON p.`payment_pattern_id`=cp.`payment_type_id`  WHERE p.`payment_property`=1 GROUP BY cp.business_date) p1 ON c.`business_date`=p1.`business_date` WHERE c.`status_code` = 1 AND c.`business_date`>='2010-02-01' AND c.`business_date`<='2014-02-21' GROUP BY DATE_FORMAT(c.`business_date`,'%Y-%m-%d')) a;", -1, 1, 0 /*None*/, 0); lrd_stmt(Csr1, "select * from tableA", -1, 1, 0 /*None*/, 0); lr_end_transaction("dggg", LR_AUTO); //统计行数到count变量中 lrd_row_count(Csr1, &count, 0);  //打印消息 lr_message("count= %d",count); //先关闭游标 lrd_close_cursor(&Csr1, 0); //再关闭连接 lrd_close_connection(&Con1, 0, 0); //释放连接，和alloc相呼应，否则有内存泄露 lrd_free_connection(&Con1, 0 /*Unused*/, 0); //再关闭上下文 lrd_close_context(&Ctx1, 0, 0); //完毕，返回0 return 0; }