#define MYSQLSERVER
"IP"
#define MYSQLUSERNAME
"**"
#define MYSQLPASSWORD
"**"
#define MYSQLDB
"**"
#define MYSQLPORT
"3306"
#include
"Ptt_Mysql.h"
#include
"mysql.h"
#include
"mysql_com.h"
#include
"mysql_time.h"
#include
"mysql_version.h"
#include
"typelib.h"
#include
"my_list.h"
#include
"my_alloc.h"
vuser_init
()
{
return
0
;
}
#include
"globals.h"
Action
()
{
char sqQuery
[
512
];
//定义一个字符数组存储查询的sql语句
int i
;
MYSQL
*Mconn
;
//mysql连接字符串
lr_load_dll
(
"libmysql.dll"
);
Mconn
=
lr_mysql_connect
(MYSQLSERVER
, MYSQLUSERNAME
, MYSQLPASSWORD
, MYSQLDB
,
atoi
(MYSQLPORT
));
//创建连接
想将连接和释放放在init和end中时,需要将mconn 放在外面,因为是全局变量,如果放在init中,action和end中报错。说没有定义参数
。
/*
sprintf(sqQuery, "SELECT * FROM pn_note; ");//查询某表数据
lr_mysql_query(Mconn, sqQuery);//执行sql语句
lr_save_string(row[2][0].cell,"content");//取第一行的第三个数值,保存到参数content中。
lr_save_string(row[15][0].cell,"promoter_name");
lr_output_message(lr_eval_string("content:{content}"));//打印查询出来的结果
lr_output_message(lr_eval_string("promoter_name:{promoter_name}"));
*/
/*
for(i=0;i<5;i++)
{
web_save_timestamp_param("tStamp",LAST); //获取当前时间戳
sprintf(sqQuery,"INSERT INTO pn_note (id,content,promoter)VALUES('%x','bb','393');",lr_eval_string("{tStamp}"),i);//插入数据
lr_mysql_query(Mconn, sqQuery);
}
*/
sprintf
(
sqQuery
,
"
UPDATE pn_note SET content
=
'aaa' WHERE id
=
'32862079aa8347689effa833c6729f9f'
;"
);
//更改描述为aaa
lr_mysql_query
(
Mconn
,
sqQuery
);
/*
sprintf(sqQuery,"DELETE FROM test1 WHERE id=1;");//删除
lr_mysql_query(Mconn, sqQuery);
*/
//断开数据库连接
lr_mysql_disconnect
(
Mconn
);
return
0
;
}