C/C++连接数据库MySQL（自己写的一个通讯录软件，供大家学习交流）

#include <iostream>
#include <cstdlib>
#include <windows.h>
#include <cstring>
#include <iomanip>
#include "mysql.h"

using namespace std;

static MYSQL my_connection;//数据库连接
static MYSQL_RES *res_ptr;
static MYSQL_ROW data;

char item[][13]={"name:","sex:","mobile:","telephone:",
                "QQ:","Email:","fax:","personWeb:",
                "MSN:","address:","company:","department:",
                "position:","officePhone:","officeFax:",
                "companyAdd:","companyWeb:"};
class Notebook
{
    public:
            bool init(char code[]);//初始化操作
            void notebookAdd(Notebook *mybook);//添加

            void notebookSearch(Notebook *mybook);//查询
            void notebookScan();//浏览
            void notebookQuickSearch();//快速查询
            void notebookSearchName();//名字查询
            void notebookSearchMobile();//手机查询
            void notebookUserSearch();//自定义查询

            void notebookAlter(Notebook *mybook);//修改
            void notebookAlterName();//修改名字
            void notebookAlterMobile();//修改手机
            void notebookAlterQQ();//修改qq
            void notebookAlterEmail();//修改邮箱
            void notebookUserAlter();//自定义修改

            void notebookDelete();//删除
            void notebookQuit(Notebook *mybook);//退出
            void notebookSave();//导出
    private:
            char name[20];
            char sex;
            char mobile[12];
            char telephone[16];
            char fax[16];
            char QQ[11];
            char Email[30];
            char personWeb[30];
            char MSN[11];
            char address[100];
            char company[30];
            char department[30];
            char position[30];
            char officePhone[16];
            char officeFax[16];
            char companyAdd[100];
            char companyWeb[30];
};
void menu_1(void)
{
    cout<<endl;
    for(int i=0;i<40;i++)
        cout<<"--";
    cout<<setw(10)<<"1-添加  "<<"|★|"<<setw(10)<<"2-查询  ";
    cout<<"|★|"<<setw(10)<<"3-修改  "<<"|★|"<<setw(10)<<"4-删除  ";
    cout<<"|★|"<<setw(10)<<"5-备份  "<<"|★|"<<setw(10)<<"0-退出";
    for(int i=0;i<40;i++)
        cout<<"--";
    cout<<endl;
}
void menu_2(void)
{
    cout<<endl;
    for(int i=0;i<40;i++)
        cout<<"--";
    cout<<setw(10)<<"1-浏览 "<<"★"<<setw(10)<<" 2-快速查询 ";
    cout<<"★"<<setw(10)<<"  3-名字查找 "<<"★"<<setw(10)<<"  4-手机查找 ";
    cout<<"★"<<setw(10)<<"  5-自定义 "<<"★"<<setw(10)<<" 0-返回  ";
    for(int i=0;i<40;i++)
        cout<<"--";
    cout<<endl;
}
void menu_3(void)
{
    cout<<endl;
    for(int i=0;i<40;i++)
        cout<<"--";
    cout<<setw(10)<<"1-修改名字 "<<"★"<<setw(10)<<"  2-修改手机 ";
    cout<<"★"<<setw(10)<<"  3-修改QQ "<<"★"<<setw(10)<<"  4-修改邮箱 ";
    cout<<"★"<<setw(10)<<"  5-自定义  "<<"★"<<setw(10)<<"0-返回 ";
    for(int i=0;i<40;i++)
        cout<<"--";
    cout<<endl;
}
bool Notebook::init(char code[])//初始化操作
{
    mysql_init(&my_connection);
    if (mysql_real_connect(&my_connection, "localhost", "root", code,"notebook",0,NULL,CLIENT_FOUND_ROWS))
      //连接模式:mysql_real_connect(&mysql,address,user,passwd,dbname,0,NULL,0) == NULL)
    {
        cout<<"Connection success/n";
        return true;
    }
    else
    return false;
}
void Notebook::notebookAdd(Notebook *mybook)//添加
{
    int res;//Zero if the statement was successful. Nonzero if an error occurred.
    char sqlcmd3[300];
    cout<<"个人信息添加：/n";
    cout<<"name->";cin>>mybook->name;
    cout<<"sex(W/M)->";cin>>mybook->sex;
    cout<<"mobile->";cin>>mybook->mobile;
    cout<<"telephone->";cin>>mybook->telephone;
    cout<<"QQ->";cin>>mybook->QQ;
    cout<<"Email->";cin>>mybook->Email;
    cout<<"fax->";cin>>mybook->fax;
    cout<<"personWeb->";cin>>mybook->personWeb;
    cout<<"MSN->";cin>>mybook->MSN;
    cout<<"address->";cin>>mybook->address;
    sprintf(sqlcmd3,"insert into person values('%s','%c',