資源描述:
《vc連接mysql的方法總結(jié)》由會員上傳分享,免費在線閱讀,更多相關(guān)內(nèi)容在應(yīng)用文檔-天天文庫。
1、#include導入一個#pragmacomment(lib,"libmysql.lib")ADO連接mysqlCoInitialize(NULL);_ConnectionPtrpConn(__uuidof(Connection));_RecordsetPtrpRst(__uuidof(Recordset));pConn->Open("Driver={MySQLODBC5.1Driver};Server=127.0.0.1;Database=test;uid=root;pwd=weiwen;","","",-1
2、);//DSN,User,PwdpRst=pConn->Execute("select*fromuser",NULL,adCmdText);while(!pRst->wenEOF){cout<<"ID:"<<(_bstr_t)pRst->GetCollect("id");cout<<"Name:"<<(_bstr_t)pRst->GetCollect("name")<MoveNext();}pRst->Close();pConn->Close();pRst.Release();pConn.Release(
3、);CoUninitialize();//ADO法訪問Mysql數(shù)據(jù)庫*/2.VC環(huán)境下使用mysqlAPI函數(shù)訪問MySQL數(shù)據(jù)庫1.安裝MySQL的完整版;(在安裝過程中可以選擇)2.將C:ProgramFilesMySQLMySQLServer5.0libopt目錄下的“l(fā)ibmysql.lib”文件復制到創(chuàng)建的VC工程目錄下;3.程序中包括頭文件,連入庫文件:#include#include"C:ProgramFilesMySQLMySQLServer5.0includemysq
4、l.h"(數(shù)據(jù)庫的安裝路徑)#pragmacomment(lib,"libmysql.lib")4.程序例子#include"stdafx.h"#include#include"C:ProgramFilesMySQLMySQLServer5.0includemysql.h"#pragmacomment(lib,"libmysql.lib")intmain(intargc,char*argv[]){MYSQLmysql;MYSQL_RES*result;MYSQL_ROWrow;mysql_init
5、(&mysql);//初始化mysql結(jié)構(gòu)if(!mysql_real_connect(&mysql,"MyXp","UserDB","123456","userdata",0,NULL,0))//連接服務(wù)器{fprintf(stderr,"Failedtoconnecttodatabase:Error:%s",mysql_error(&mysql));}//////////////////////////////////////////////////////////////////////////////////////
6、/////////////插入數(shù)據(jù)/////////////////////////////////////////if(mysql_query(&mysql,"insertintoUserDataTablevalues('rm','209','209','2153@qq.com','23213','yjiang','26.222.171.2','2010-04-0110:53:12')"))//進行查詢{fprintf(stdout,"mysql_query()insertfailed!");}//////////////
7、///////////////////////////////////////////////////////////////////////////////////////////查詢數(shù)據(jù)///////////////////////////////if(mysql_query(&mysql,"select*fromUserDataTable")){fprintf(stdout,"mysql_query()selectfailed!");}result=mysql_store_result(&mysql);//讀取一個到客
8、戶的查詢的全部結(jié)果,//分配一個MYSQL_RES結(jié)構(gòu),并且把結(jié)果放進這個結(jié)構(gòu)中。(獲得結(jié)果集)while(row=mysql_fetch_row(result))//取出結(jié)果集中記錄{fprintf(stdout,"UserName:%spassword:%s