读书人

vc++连接MYSQL数据库出现有关问题

发布时间: 2012-06-03 16:59:40 作者: rapoo

vc++连接MYSQL数据库出现问题
把mysql-connector-c++-1.1.0-win32装上了,但是在连接MYSQL数据库时到m_pCon = m_pDriver->connect( strHostName, struserName, strPassword);这一语句还是报错,参数变量的值都对,这有可能是哪方面的原因呢

[解决办法]

C/C++ code
    m_strHost = "tcp://127.0.0.1:3306";    m_strUser = "root";    m_strPassword = "123456";    m_pDriver = get_driver_instance();        if ( !m_pDriver )    {        return DBUnit_Fail_GetInstance;    }    //连接数据库并读取信息    Statement *pState = NULL;      ResultSet *pResult = NULL;    Connection*    pConnect = NULL;     try    {                        pConnect = m_pDriver->connect(m_strHost, m_strUser, m_strPassword);          pState = pConnect->createStatement();          pState->execute("use im_datacenter");          char szSql[1024]={0};        sprintf(szSql,"SELECT * FROM im_datacenter.tb_userinfo where id = %d and passwd='%s'",info.nUserId,info.cPasswd);        pResult = pState->executeQuery(szSql);                  int nRet = pResult->rowsCount();        if ( nRet == 1)        {                        SAFE_DELETE(pResult);            SAFE_DELETE(pState);            SAFE_DELETE(pConnect);            return DBUnit_Succeed;        }        else        {            printf("not find user!\n");            SAFE_DELETE(pResult);            SAFE_DELETE(pState);            SAFE_DELETE(pConnect);            return 1;        }    }    catch (...)    {        SAFE_DELETE(pState);        SAFE_DELETE(pResult);        SAFE_DELETE(pConnect);        printf("db exception!!!why?\n");        return DBUnit_Exception_GetSecondSrvStreamInfo;    } 

读书人网 >VC/MFC

热点推荐