c++连接mysql示例

/* * ===================================================================================== * * Filename: dbhandler.cpp * * Description: mysql * * Version: 1.0 * Created: 2012年07月12日 23时23分05秒 * Revision: none * Compiler: g++ * * Author: zhuzhongmeng (zhuzhongmeng@gmail.com), * Company: suiee * * ===================================================================================== */ #include "dbhandler.h" #include <fstream> #include <sstream> dbhandler::dbhandler() { ifstream fin("conn.ini"); string properties; int pos; while(fin>>properties) { if((pos=properties.find("username"))!= string::npos) { username = properties.substr(8+pos+1,properties.length()-1); } else if((pos=properties.find("passord"))!= string::npos) { passord = properties.substr(8+pos+1,properties.length()-1); } else if((pos=properties.find("host"))!= string::npos) { host = properties.substr(4+pos+1,properties.length()-1); } else if((pos=properties.find("dbname"))!= string::npos) { dbname = properties.substr(6+pos+1,properties.length()-1); } else if((pos=properties.find("port"))!= string::npos) { string tmp = properties.substr(4+pos+1,properties.length-1); stringstream ss; ss << tmp; ss >> port; } } mysql_init(&mysql); mysql_real_connection(&mysql,host.c_str(), username.c_str(), passord.c_str(), dbname.c_str(), 0,NULL,0); } MYSQL * dbhandler::get_conn() { return &mysql; } dbhandler::~dbhandler() { if(dbhandler::single_instance !=NULL) { delete dbhandler::single_instance; } close_server(); } map<string,string> dbhandler::query_for_object(string sql, string * params) { map<string,string> ret_map; return ret_map; } vector<map<string,string>> dbhandler::query_for_list(string sql,string * params) { vector<map<string,string>> vt; return vt; } int dbhandler::update_data(string sql,string * params) { int ret = 0; return ret; } int dbhandler::insert_data(string sql, string * params) { int ret = 0; return ret; } int dbhandler::delete_data(string sql,string * params) { int ret = 0; return ret; } void dbhandler::close_server() { mysql_free_result(result); mysql_close(&mysql); }