C++操作MySQL,有用的朋友頂下,辛苦的原創(chuàng)啊. - 天下 - C++博客

C++操作MySQL,有用的朋友頂下,辛苦的原創(chuàng)啊.

向google大神搜 :
mysql-connector
得
http://www.mysql.com/products/connector/

這些就是mysql所謂的連接器吧.
一路向下看到:
C++ Wrapper for MySQL C API (MySQL++) Download
http://gna.org/projects/mysqlpp/
下載手冊(cè)慢慢慢慢看吧你.

1. 先到http://tangentsoft.net/mysql++/ 下載mysql++源碼.
2. 將mysql++的VS2008的PRO打開(kāi)后編譯成msyqlpp.lib,mysqlpp.dll等幾個(gè)動(dòng)態(tài)或靜態(tài)庫(kù)。
需要注意的是mysql的頭文件及相關(guān)庫(kù)文件需指定地方或加到VS工具的option->vc directories中.
3.請(qǐng)把相應(yīng)的DEBUG及RELEASE版本的DLL及LIB放到相應(yīng)的目錄.否則調(diào)試報(bào)異常.

#include? < afxwin.h >
#include? < iostream >
#include? " lib/mysql++.h "
using ? namespace ?std;
int ?main(){
???? char ?name[ 50 ];
????mysqlpp::Connection?conn( false );
???? if ?(conn.connect( " test " , " 192.168.0.175 " , " root " , " aaaaaa " )?)?{
????????mysqlpp::Query?SetCharacterSetQuery? = ?conn.query( " SET?names?'utf8' " );
????????SetCharacterSetQuery.exec();? // 注意這里還要SetCharacterSetQuery.exec()?,和C語(yǔ)言的API不同.
????????mysqlpp::Query?query? = ?conn.query( " select?*?from?doc_threads " );
????????mysqlpp::StoreQueryResult?res? = ?query.store();
???????? if ?(res)?{
????????????cout? << ?res[ 0 ][ " id " ]? << ? ' ? ' ? << ?CW2A(CA2W(res[ 0 ][ " name " ],CP_UTF8),CP_ACP)? << ? ' ? ' ? << endl;
????????????cout? << ?res[ 1 ][ " id " ]? << ? ' ? ' ? << ?CW2A(CA2W(res[ 1 ][ " name " ],CP_UTF8),CP_ACP)? << ? ' ? ' ? << endl;
????????}
????}
????conn.disconnect();
???? return ? 0 ;
}

C++操作MySQL,有用的朋友頂下,辛苦的原創(chuàng)啊. - 天下 - C++博客