c mysql封装类_MySQL-C++封装类

#include

using namespace std;

#include "MySQLInterface.h"

int _tmain(int argc, _TCHAR* argv[])

{

MySQLInterface MySQLInterface;

MySQLInterface.SetMySQLConInfo("localhost", "root", "123456", "world", 337);

if (!MySQLInterface.Open())

{

std::cout << MySQLInterface.ErrorNum << " : " << MySQLInterface.ErrorInfo << std::endl;

}

// 读取数据

std::vector<:vector> > data;

std::string sqlstr = "SELECT `ID`,`Name`,`CountryCode`,`District` FROM `world`.`city` LIMIT 10";

MySQLInterface.Select(sqlstr, data);

// 显示数据

for (unsigned int i = 0; i < data.size(); ++i)

{

for (unsigned int j = 0; j < data[0].size(); ++j)

{

cout << data[i][j] << "\t\t";

}

cout << endl;

}

// 其他操作

sqlstr = "CREATE TABLE IF NOT EXISTS `new_paper` (";

sqlstr += " `NewID` int(11) NOT NULL AUTO_INCREMENT,";

sqlstr += " `NewCaption` varchar(40) NOT NULL,";

sqlstr += " `NewContent` text,";

sqlstr += " `NewTime` datetime DEFAULT NULL,";

sqlstr += " PRIMARY KEY(`NewID`)";

sqlstr += " ) ENGINE = InnoDB DEFAULT CHARSET = utf8";

if (!MySQLInterface.Query(sqlstr))

{

std::cout << MySQLInterface.ErrorNum << " : " << MySQLInterface.ErrorInfo << std::endl;

}

MySQLInterface.Close();

system("pause");

return 0;

}