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;

}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值