1：需要安裝數(shù)據(jù)庫的各種頭文件以及動(dòng)態(tài)庫如：
MySQL-server-community-5.1.58-1.rhel4.i386.rpm
MySQL-client-community-5.1.58-1.rhel4.i386.rpm
MySQL-devel-community-5.1.58-1.rhel4.i386.rpm
MySQL-shared-compat-5.1.58-1.rhel4.i386.rpm （否則安裝mysql++會(huì)報(bào)錯(cuò)，說鏈接客戶端失敗）
2：安裝mysql++
./configure -> make -> make install
3：編譯測試程序
[zhichen@localhost src]$ vi test.cpp
#include "mysql++.h"
using namespace mysqlpp;
using namespace std;
int main()
{
//構(gòu)造一個(gè)Connection類的對象
Connection con(false);
const char* db = "mysql", *server = "127.0.0.1", *user = "pos", *pass = "pos";
if (con.connect(db, server, user, pass))
{
cout << "success" << endl;
string sql = "select * from users";
Query query = con.query(sql);
if (StoreQueryResult rs = query.store())
{
StoreQueryResult::const_iterator it;
for (it = rs.begin(); it != rs.end(); ++it)
{
Row row = *it;
cout << "/t" << row[0] << "/t" << row[1] << endl;
}
}
else
{
cerr << "Failed to get item list: " << endl;
return -1;
}
}
else
{
cout << "Failed to connect DB" << con.error() << endl;
return -1;
}
return 0;
}
g++ -o test test.cpp -I/usr/include/mysql -I/usr/local/include/mysql++/ -L/usr/local/lib -lmysqlpp -lmysqlclient
4：執(zhí)行./test
如果報(bào)錯(cuò)說
./test: error while loading shared libraries: libmysqlpp.so.3: cannot open shared object file: No such file or directory
man ldconfig
vi /etc/ld.so.conf
把mysq++動(dòng)態(tài)庫 /usr/local/lib的路徑加進(jìn)去
5：再次執(zhí)行測試程序