。select count 的赋值有关问题

求助。。。select count 的赋值问题

代码是这样的

int32 CDataBase::CountRecord(TABLE_PARAM *pParam)

{

char str[512];

MYSQL_RES *p;

int32 cnt;

sprintf(str,”select count(*) as cnt from %s”,pParam->tab_name);

mysql_query(&m_Mysql,”set names gbk”);

p=GetResult(str);

 

  ？？？？？

return cnt;

}

求助！我应该怎么样才能将返回的记录总数值赋给变量cnt呢？

sigh，我还是写一个简单的demo，关于错误处理部分，你自己去完善吧。mysql的C-API还是蛮清晰的，比Oracle和Sybase ASE的简单多了。

C/C++ code

#include <iostream>
#include <windows.h>
#include <mysql.h>
#include <string>


static const char host[32] = "localhost";
static const char user[32] = "test";
static const char passwd[32] = "********";
static const char db[32] = "test";


//
// Just for demo only.
// 
int main()
{

    MYSQL*              mysql_ = NULL;
    MYSQL_RES*          result_ = NULL;
    MYSQL_ROW           row_;

    mysql_ = mysql_init(mysql_);

    if (mysql_real_connect(mysql_, host, user, passwd, db, 3306, NULL, 0) == NULL)
    {
        const char * error = mysql_error(mysql_);
        std::cout<<"*** Connection Error " << error << std::endl;

        return -1;
    }
    mysql_autocommit(mysql_, false);

    std::string encodeStr = "set names 'gbk'";
    mysql_real_query(mysql_, encodeStr.c_str(), encodeStr.size());
    

    const char* tmpTableName = "t";  // assume you are querying the table 't'
    char str[512];
    int cnt = 0;
    sprintf(str,"select count(*) as cnt from %s", tmpTableName);

    mysql_real_query(mysql_, str, strlen(str));
    result_ = mysql_store_result(mysql_);
    while (row_ = mysql_fetch_row(result_))
    {
        // get the field value
        if (row_[0])
        {
            std::cout<<"count = "<<row_[0]<<std::endl;
            // convert it into int
            cnt = atoi(row_[0]);
            std::cout<<"cnt value = "<<row_[0]<<std::endl;
        }
    }

    mysql_free_result(result_);
    mysql_close(mysql_);
    return 0;
}