您好,登錄后才能下訂單哦!
#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()
{
rc = lr_load_dll("libmysql.dll");
if (rc != 0) {
lr_error_message("Could not load libmysql.dll");
lr_abort();
}
// 連接到MySQL數(shù)據(jù)庫(kù)
Mconn = lr_mysql_connect(MYSQLSERVER, MYSQLUSERNAME, MYSQLPASSWORD, MYSQLDB, MYSQLPORT);
return 0;
}
{
lr_mysql_disconnect(Mconn);
return 0;
}
Action()
{
char *str;
char *old = "交易成功";
char *dengdai = "任務(wù)正在等待處理,請(qǐng)稍后~";
char *zhenxing = "查詢未完成,請(qǐng)稍后~";
char *ycldd;
int i,j;
char chQuery[128];
mysql_query(Mconn,lr_eval_string("SET NAMES gbk")); //遇到中文字符亂碼,在插入帶中文字的數(shù)據(jù)前,增加了如下語(yǔ)句:
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);
//驗(yàn)四
web_url("chouzhouyansi","URL=http://ip:3306/newCzCreditApply?user_ids={userid}",LAST);
str = lr_eval_string("{yansi}"); //取出關(guān)聯(lián)字段與實(shí)際值做比較。
lr_output_message("關(guān)聯(lián)字段: %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}");
//預(yù)處理
lr_output_message("預(yù)處理:%s","預(yù)處理");
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("提示目前狀態(tài)是: %s",lr_eval_string("{jiayichenggong}"));
return 0;
}
else
{
lr_output_message("這是顯示結(jié)果:%s","eles中的語(yǔ)句");
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;
}
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。