c mysql封装类_C++ MySQL封装类

//ConsoleApplication2.cpp : Defines the entry point for the console application.//#include"stdafx.h"#include#include#include#include#include"ManageSQL.h"#include

using namespacestd;intmain()

{

mysql_db mydb;//打开.. 连接

if (-1 == mydb.mysql_open("Localhost", "root", "123456", "electronicpolice", MYSQL_PORT))

cout<< mydb.mysql_lasterror() <

string sql = "create database if not exists database_test";if ( -1 ==mydb.mysql_noResult_query(sql.c_str()))

cout<< mydb.mysql_lasterror() <

sql = "use database_test";if ( -1 ==mydb.mysql_noResult_query(sql.c_str()))

cout<< mydb.mysql_lasterror() <

sql = "create table if not exists table_test(id int not null auto_increment, name varchar(20) not null, age int not null ,primary key (id) )";if ( -1 ==mydb.mysql_noResult_query(sql.c_str()))

cout<< mydb.mysql_lasterror() <

sql = "insert into table_test (name,age) values('newsoul','25')";if ( -1 ==mydb.mysql_noResult_query(sql.c_str()))

cout<< mydb.mysql_lasterror() <

sql= "insert into table_test (name,age) values('百度','100')";if ( -1 ==mydb.mysql_noResult_query(sql.c_str()))

cout<< mydb.mysql_lasterror() <

sql = "select * from table_test where id=1";

vectorvResults;if (-1 ==mydb.mysql_select_SingleLine_query(sql.c_str(),vResults))

cout<< mydb.mysql_lasterror() <

cout << "select * from table_test where id=1的结果:" <::iterator it = vResults.begin(); it != vResults.end(); it++)

cout<< (*it) <

cout<< endl <

sql = "select * from table_test";int i = 0;while (i++ < 100){

map>map_res;if (-1 ==mydb.mysql_select_query(sql.c_str(),map_res))

cout<< mydb.mysql_lasterror() <

cout << "select * from table_test的结果:" <>::iterator it = map_res.begin(); it != map_res.end(); it++){

cout<< "第" << it->first+1<< "条 :";for (int i=0;isecond.size();i++)

{

cout<< it->second[i] << "\t";

}

cout<

}

}

system("pause");return 0;

}