view plaincopy to clipboardprint?
/*需要的表结构如下
CREATE TABLE `test_data` (
`order_id` BIGINT UNSIGNED NOT NULL COMMENT 'Order numbers. Must be unique.',
`status` BOOL NOT NULL DEFAULT '0' COMMENT 'Whether data has been used or not. A value of 0 means FALSE.',
`date_used` DATETIME NULL COMMENT 'Date/time that the data was used.',
UNIQUE (
    `order_id`
)
) ENGINE = innodb COMMENT = 'LoadRunner test data';
*/
Action()  
{  
int rc;   
int db_connection; // 数据库连接  
int query_result; // 查询结果集 MYSQL_RES  
char** result_row; // 查询的数据衕  
   
char *server = "localhost";  
char *user = "root";  
char *password = "123456";  
char *database = "test";  
int port = 3306;  
int unix_socket = NULL;   
int flags = 0;   
   
// 找到libmysql.dll的所在位置.  
rc = lr_load_dll("C:\\Program Files\\MySQL\\MySQL Server 5.1\\bin\\libmysql.dll");  
if (rc != 0) {  
    lr_error_message("Could not load libmysql.dll");  
    lr_abort();  
}  
   
// 创建MySQL对象  
db_connection = mysql_init(NULL);  
if (db_connection == NULL) {  
    lr_error_message("Insufficient memory");  
    lr_abort();  
}  
   
// 连接到MySQL数据库  
rc = mysql_real_connect(db_connection, server, user, password, database, port, unix_socket, flags);  
if (rc == NULL) {  
    lr_error_message("%s", mysql_error(db_connection));  
    mysql_close(db_connection);  
    lr_abort();  
}  
   
// 向数据库插入数据  
// 此处的 {ORDER_ID} 是一个参数，简单测试时可以用一个常数代替  
lr_save_string (lr_eval_string("INSERT INTO test_data (order_id) VALUES ({ORDER_ID})"),"paramInsertQuery");   
rc = mysql_query(db_connection, lr_eval_string("{paramInsertQuery}"));  
if (rc != 0) {  
    lr_error_message("%s", mysql_error(db_connection));  
    mysql_close(db_connection);  
    lr_abort();  
}

// 从数据库读取一个数据并显示  
rc = mysql_query(db_connection, "SELECT order_id FROM test_data WHERE status IS FALSE LIMIT 1");  
if (rc != 0) {  
    lr_error_message("%s", mysql_error(db_connection));  
    mysql_close(db_connection);  
    lr_abort();  
}