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;
}