#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',