c mysql操作库_c/c++操作mysql数据库

1.用到的数据结构

#ifndef GLOBAL_H

#define GLOBAL_H

#include

using std::string;

struct Data_Param //数据库操作参数

{

string db_name; //数据库名

string tab_name; //表名

string col_name; //列名

string select_exp; //选择表达式

string where_def; //选择限定条件

string insert_val; //插入值

string set_exp; //更新数据库内容的表达式

};

struct Database_Param //数据库参数

{

string host; //主机名

string user; //用户名

string password; //密码

string db; //数据库名

unsigned int port; //端口，一般为0

const char* unix_socket; //套接字，一般为NULL

unsigned int client_flag; //一般为0

Database_Param(string host, string user, string password, string db, unsigned int port, const char* unix_socket, unsigned int client_flag)

{

this->host = host;

this->user = user;

this->password = password;

this->db = db;

this->port = port;

this->unix_socket = unix_socket;

this->client_flag = client_flag;

}

};

#endif

2.CMysql类的声名

/*This is a C++ incapsulation of the mysql C API

*In order to use this:

* 1.set the project include directory includes the include directory under mysql directory

* 2.set the project library directory includes the lib/opt directory under mysql directory

* 3.set the addtional dependency of the linker of the project 'libmysql.lib'

*After all of the above work, you can simply add this CMysql class in your project,and can conviently use it

*If you find any bugs, please connect me : gswzsh@126.com, thank you

*/

#ifndef CMYSQL_H

#define CMYCQL_H

#include

#include

#include "global.h"

#include

class CMysql

{

public:

string GetState(); //服务器状态

string GetServerInfo(); //服务器信息

int GetProtocolInfo(); //协议信息

string GetHostInfo(); //主机信息

string GetClientInfo(); //客户机信息

string GetFieldName(int FieldNum);

bool IsEnd(); //是否最后

void SeekData(int offset); //查找指定数据

unsigned int GetFieldNum(); //得到字段数

bool ConnectDB(Database_Param* p); //连接数据库

MYSQL_ROW GetRecord(); //得到结果(一个记录)

my_ulonglong GetRowNum(); //得到记录数

bool SelectDB(Data_Param* para); //选择数据库

bool UpdateRecord(Data_Param* para); //更新记录

bool SelectRecord(Data_Param* para); //选择记录

bool InsertRecord(Data_Param* para); //插入记录

bool DelRecord(Data_Param* para); //删除记录

bool SelectAll(Data_Param* para); //选择所有记录

string OutErrors(); //输出错误信息

bool MysqlEx(MYSQL* mysql, string str);

CMysql();

virtual ~CMysql();

private:

bool FindSave(string str); //查找并保存结果集

private:

MYSQL mysql; //数据库链接句柄

MYSQL_FIELD* field; //字段信息(结构体)

public:

MYSQL_RES* query; //结果集

MYSQL_ROW row; //记录集

};

#endif

3.CMysql类的实现

#include "CMysql.h"

using std::ostringstream;

CMysql::CMysql()

{

mysql_init(&mysql);

}

CMysql::~CMysql()

{

mysql_close(&mysql);

}

//Connect to the DB host

bool CMysql::ConnectDB(Database_Param* p)

{

if(!mysql_real_connect(&mysql,(p->host).c_str(),p->user.c_str(),p->password.c_str(),p->db.c_str(),p->port,p->unix_socket,p->client_flag))

{

return false;

}

return true;

}

//Select DB

bool CMysql::SelectDB(Data_Param* para)

{

if(mysql_select_db(&mysql,para->db_name.c_str()))

return false;

else

return true;

}

//Get the record and store it int 'row'

MYSQL_ROW CMysql::GetRecord()

{

return (row=mysql_fetch_row(query));

}

//A utility to select all the records

bool CMysql::SelectAll(Data_Param* para)

{

unsigned int i=0;

ostringstream Ostr;

Ostr << "select * from " << para->tab_name;

if(!FindSave(Ostr.str()))

{

return false;

}

return true;

}

//Seek the row

void CMysql::SeekData(int offset)

{

mysql_data_seek(query,offset);

}

//Execute the query and store the results in 'query'

bool CMysql::FindSave(string str)

{

if(mysql_query(&mysql,str.c_str()))

return false;

query=mysql_store_result(&mysql);

return true;

}

//A utility to delete the records

bool CMysql::DelRecord(Data_Param* para)

{

ostringstream Ostr;

Ostr << "delete from " << para->tab_name << " where " << para->where_def;

if(mysql_query(&mysql,Ostr.str().c_str()))

{

return false;

}

return true;

}

//A utility to insert records

bool CMysql::InsertRecord(Data_Param* para)

{

ostringstream Ostr;

Ostr << "insert into " << para->tab_name << " values(" << para->insert_val << ")";

if(mysql_query(&mysql,Ostr.str().c_str()))

{

return false;

}

return true;

}

//A utility to select records

bool CMysql::SelectRecord(Data_Param* para)

{

unsigned int i=0;

ostringstream Ostr;

Ostr << "select " << para->select_exp << " from " << para->tab_name << " where " << para->where_def;

if(!FindSave(Ostr.str()))

{

return false;

}

return true;

}

//A utility to update records

bool CMysql::UpdateRecord(Data_Param* para)

{

ostringstream Ostr;

Ostr << "update " << para->tab_name << " set " << para->set_exp << " where " << para->where_def;

if(mysql_query(&mysql,Ostr.str().c_str()))

{

return false;

}

return true;

}

bool CMysql::IsEnd()

{

if(mysql_eof(query))

{

return true;

}

else

{

return false;

}

}

//Get number of rows

my_ulonglong CMysql::GetRowNum()

{

return (mysql_num_fields(query));

}

//Get the name of the FieldNumth Field

string CMysql::GetFieldName(int FieldNum)

{

field=mysql_fetch_field_direct(query,FieldNum);

return string(field->name);

}

string CMysql::GetClientInfo()

{

return string(mysql_get_client_info());

}

string CMysql::GetServerInfo()

{

return string(mysql_get_server_info(&mysql));

}

string CMysql::GetHostInfo()

{

return string(mysql_get_host_info(&mysql));

}

int CMysql::GetProtocolInfo()

{

return mysql_get_proto_info(&mysql);

}

string CMysql::GetState()

{

string state(mysql_stat(&mysql));

if(!state.empty())

return string(OutErrors());

return state;

}

/*void CMysql::FreeRecord()

{

mysql_free_result(query);

}*/

string CMysql::OutErrors()

{

return string(mysql_error(&mysql));

}

bool CMysql::MysqlEx(MYSQL* mysql, string str)

{

if(!FindSave(str))

{

return false;

}

return true;

}

unsigned int CMysql::GetFieldNum()

{

return (mysql_num_fields(query));

}