下面的是部分代碼，我發現最后輸出的結果為null，得不到一個字串，幫我看看哪里錯了
MYSQL_STMT* stmt = mysql_stmt_init(&mysql); //創建預處理陳述句句柄
char* query = "select account,password from c_table where account=(?) and password=(?);";
char *account,password;
if (mysql_stmt_prepare(stmt, query, strlen(query)))
{
fprintf(stderr, "mysql_stmt_prepare: %s\n", mysql_error(&mysql)); //如果預處理陳述句失敗
}
MYSQL_BIND params[2], bind[2];
memset(params, 0, sizeof(params)); //清空
memset(bind, 0, sizeof(bind));
params[0].buffer_type = MYSQL_TYPE_LONGLONG;
params[0].buffer = get_account;
params[0].buffer_length = 14;
params[1].buffer_type = MYSQL_TYPE_LONGLONG;
params[1].buffer = get_password;
params[1].buffer_length = 16;
mysql_stmt_bind_param(stmt, params);
MYSQL_RES* result = mysql_stmt_result_metadata(stmt);
mysql_stmt_execute(stmt);
bind[0].buffer_type = MYSQL_TYPE_LONGLONG;
bind[0].buffer = &account;
bind[1].buffer_type = MYSQL_TYPE_LONGLONG;
bind[1].buffer = &password;
mysql_stmt_bind_result(stmt, bind); //系結到緩沖區
mysql_stmt_store_result(stmt); //回傳結果集
mysql_stmt_fetch(stmt);
printf("%s", account);
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/214424.html
標籤：基礎類
上一篇：unity中瞄準倍鏡效果和原始碼