//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;
}