// 再次查找数据,应该为空了,因为前面的事务更新了标志 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(); } query_result = mysql_use_result(db_connection); if (query_result == NULL) { lr_error_message("%s", mysql_error(db_connection)); mysql_free_result(query_result); mysql_close(db_connection); lr_abort(); } result_row = (char **)mysql_fetch_row(query_result); if (result_row == NULL) { lr_output_message("Result set is empty as expected"); mysql_free_result(query_result); } else { lr_error_message("Did not expect the result set to contain any rows"); mysql_free_result(query_result); mysql_close(db_connection); lr_abort(); }
// 删除数据 lr_save_string(lr_eval_string("DELETE FROM test_data WHERE order_id = '{paramOrderID}'"),"paramDeleteQuery"); rc = mysql_query(db_connection, lr_eval_string("{paramDeleteQuery}")); if (rc != 0) { lr_error_message("%s", mysql_error(db_connection)); mysql_close(db_connection); lr_abort(); }
// 释放MySQL资源 mysql_close(db_connection); return 0; } |