mysql 批量插入 c_C API 连接MySQL及批量插入

CMySQLMgr.h：

#ifndef _CMYSQLMGR_H_

#define _CMYSQLMGR_H_

#include

#include "mysql.h"

using namespace std;

class CMySQLMgr

{

public:

CMySQLMgr();

~CMySQLMgr();

bool Connect(const char * sHost, const char * sUser, const char * sPwd, const char * sDbName, const char * sPort);

void CloseConnect();

bool excute(const char * sQuery);

MYSQL * GetpMysql();

private:

MYSQL * m_pMysql;

};

#endif

CMySQLMgr.cpp：

#include "CMySQLMgr.h"

CMySQLMgr::CMySQLMgr()

{

m_pMysql = NULL;

}

CMySQLMgr::~CMySQLMgr()

{

}

bool CMySQLMgr::Connect( const char * sHost, const char * sUser, const char * sPwd, const char * sDbName, const char * sPort )

{

bool bReturn = true;

do

{

CloseConnect();

m_pMysql = mysql_init(NULL);

if (!m_pMysql)

{

bReturn = false;

//can write log

break;

}

//参数设置

char optvalue = 6;

mysql_options(m_pMysql, MYSQL_OPT_CONNECT_TIMEOUT, (char*)&optvalue);

optvalue = 1;

mysql_options(m_pMysql, MYSQL_OPT_RECONNECT, (char*)&optvalue);

optvalue = 2;

mysql_options(m_pMysql, MYSQL_OPT_READ_TIMEOUT, (char*)&optvalue);

if (!mysql_real_connect(m_pMysql, sHost, sUser, sPwd, sDbName, atoi(sPort), NULL, 0) )

{

bReturn = false;