lr连接数据笔记

globals.h
#ifndef _GLOBALS_H
#define _GLOBALS_H

//--------------------------------------------------------------------
// Include Files
#include “lrun.h”
#include “web_api.h”
#include “lrw_custom_body.h”
#include “Ptt_Mysql.h”

#define MYSQLSERVER "ip"
#define MYSQLUSERNAME "user"
#define MYSQLPASSWORD "pwd"
#define MYSQLDB "xin"
#define MYSQLPORT 3306

MYSQL *Mconn;
int rc;

//--------------------------------------------------------------------
// Global Variables

#endif // _GLOBALS_H
vuser_init
vuser_init()
{

rc = lr_load_dll("libmysql.dll");

 if (rc != 0) {

 lr_error_message("Could not load libmysql.dll");

 lr_abort();

}

// 连接到MySQL数据库
Mconn = lr_mysql_connect(MYSQLSERVER, MYSQLUSERNAME, MYSQLPASSWORD, MYSQLDB, MYSQLPORT);

return 0;

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

Action
Action()
{
char *str;
char *old = “交易成功”;
char *dengdai = “任务正在等待处理,请稍后~”;
char *zhenxing = “查询未完成,请稍后~”;
char *ycldd;
int i,j;
char chQuery[128];

mysql_query(Mconn,lr_eval_string("SET NAMES gbk")); //遇到中文字符乱码，在插入带中文字的数据前，增加了如下语句：

sprintf(chQuery, "select t.userid,t.bank_id,t.username from xin.webank_apply_data t where  t.login_mobile=14725001445;");

lr_mysql_query(Mconn, chQuery); 

 lr_save_string(row[0][0].cell, "userid");
 lr_save_string(row[1][0].cell, "bank_id");
 lr_save_string(row[2][0].cell, "username");

lr_output_message(lr_eval_string("userid: {userid}; bank_id: {bank_id}; username:{username}"));

//[desc] => 

web_reg_save_param_ex(
"ParamName=yansi",
"LB=[desc] => ",
"RB=\n",
"Ordinal=1",
SEARCH_FILTERS,
LAST);

//验四
web_url("chouzhouyansi","URL=http://ip:3306/newCzCreditApply?user_ids={userid}",LAST);
str = lr_eval_string("{yansi}");   //取出关联字段与实际值做比较。
lr_output_message("关联字段: %s",str);
if(strcmp(str,old) == 0)   
{

lr_think_time(5);

i:  
web_reg_save_param_ex(
"ParamName=yuchuli",
"LB=[desc] => ",
"RB=\n",
"Ordinal=1",
SEARCH_FILTERS,
LAST);

ycldd = lr_eval_string("{yuchuli}"); 

//预处理
lr_output_message("预处理：%s","预处理");

lr_think_time(1);

 web_url("chouzhouyuchuli","URL=http://ip:3306/newCzCreditQuery?user_ids={userid}",LAST);
lr_think_time(5);

if((strcmp(ycldd,dengdai) == 0) && (strcmp(ycldd,zhenxing) == 0))
{
    lr_output_message("提示目前状态是: %s",lr_eval_string("{jiayichenggong}"));

    return 0;
}
else
{
    lr_output_message("这是显示结果：%s","eles中的语句");

lr_think_time(10);

web_reg_save_param_ex(
"ParamName=jiayichenggong",
"LB=[desc] => ",
"RB=\n",
"Ordinal=1",
SEARCH_FILTERS,
LAST);

 web_url("chouzhouyuchuli","URL=http://ip:3306/newCzCreditQuery?user_ids={userid}",LAST);

ycldd = lr_eval_string("{jiayichenggong}"); 

if(strcmp(old,ycldd) == 0)
{
    lr_output_message("交易成功");
    lr_think_time(1);

}
else 
{
    goto i;
}
}   

}

return 0;

}