Action
()
{
int rc ;
int db_connection ; // 数据库连接
int query_result ; // 查询结果集 MYSQL_RES
char ** result_row ; // 查询的数据衕
char *server = "192.168.1.201" ;
char *user = "fds" ;
char *password = "dfslocal" ;
char *database = "EWS" ;
int port = 3306 ;
int unix_socket = NULL ;
int flags = 0 ;
// 找到libmysql.dll的所在位置.
rc = lr_load_dll ( "E:\\loadrunner-lsh\\lib\\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} 是一个参数,简单测试时可以用一个常数代替 ,现在我用23
lr_save_string ( lr_eval_string ( "INSERT INTO test_data (order_id) VALUES (23)" ), "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 ();
}
return 0 ;
{
int rc ;
int db_connection ; // 数据库连接
int query_result ; // 查询结果集 MYSQL_RES
char ** result_row ; // 查询的数据衕
char *server = "192.168.1.201" ;
char *user = "fds" ;
char *password = "dfslocal" ;
char *database = "EWS" ;
int port = 3306 ;
int unix_socket = NULL ;
int flags = 0 ;
// 找到libmysql.dll的所在位置.
rc = lr_load_dll ( "E:\\loadrunner-lsh\\lib\\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} 是一个参数,简单测试时可以用一个常数代替 ,现在我用23
lr_save_string ( lr_eval_string ( "INSERT INTO test_data (order_id) VALUES (23)" ), "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 ();
}
return 0 ;
}
mysql脚本
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';