数据库设计作业

1、数据库设计：班级通讯录一班级通讯录程序设计（C语言）：#include<conio.h> #include<stdio.h> #include <iostream>#include <string>#include <iomanip>#include <fstream>#include <cstdlib>using namespace std;class bookpublic: book();/默认构造函数 char inter_face();/首页 void add_person();/添加联系人 void

2、del_person();/删除联系人 void show_all();/显示所有联系人 void alter();/修改信息 void select();/查询联系人 void save_new();/保存新增加的联系人private: string name;/姓名 string address;/地址 string number;/电话号码 string post;/邮编 string qq;/QQ号;struct record book object;/双向链表中的数据域是是一个记录类 record *prior;/指向前躯 record *next;/指向后继;book:book()

3、 name = "0" address = "0" number = "0" post = "0" qq = "0"/首页char book:inter_face() system("cls"); cout <<endl; cout<<"tt" <<endl <<"tt " <<endl <<"tt 班 级 通 迅 录 " <<end

4、l <<"tt " <<endl <<"tt 1. 添加新联系人. 4. 修改信息. " <<endl <<"tt " <<endl <<"tt 2. 删除联系人. 5. 查询联系人. " <<endl <<"tt " <<endl <<"tt 3. 显示所有联系人. 6. 关闭通迅录. " <<endl <<"

5、tt " <<endl <<"tt" <<endl <<endl <<"ttt选择 :" ; char choose; cin >>choose; fflush(stdin); return choose;/添加联系人void book:add_person() cout <<endl <<"根据下面提示输入新联系人信息" <<endl <<endl <<"姓名 :" ; c

6、in >>name; fflush(stdin); cout <<"电话 : " cin >>number; fflush(stdin); cout <<"QQ : " cin >>qq; fflush(stdin); cout <<"邮编 : " cin >>post; fflush(stdin); cout <<"地址 : " cin >>address; fflush(stdin); save_new(

7、); cout <<endl <<endl <<"新联系人信息已经保存好!" <<endl <<endl; system("pause");/删除联系人void book:del_person() ofstream outData("temp.txt", ios:out); ifstream inData("pbook.txt", ios:in); if (!outData | !inData) cout <<endl <<&quo

8、t;对不起!找不到文件!" <<endl; system("pause"); return; string sign; cout <<endl <<"你要删除输入姓名或电话号 :" cin >>sign; string str1; bool flag = true; string str; while (inData >>name >>number) getline(inData, str); if (sign=name) | (sign=number) cout <

9、<endl <<"你想删除的联系人:" <<endl <<endl; cout <<str1 <<endl; cout <<setiosflags(ios:left) <<setw(17) <<name <<" " <<number <<str <<endl; flag = false; break; outData <<setiosflags(ios:left) <<setw(17

10、) <<name <<" " <<number <<str <<endl; if (flag) cout <<endl <<"对不起!联系人中没你找的人!" <<endl <<endl; else while (getline(inData, str) outData <<str <<endl; outData.close(); inData.close(); ofstream out("pbook.txt&quo

11、t;, ios:out); ifstream in("temp.txt", ios:in); if (!out | !in) cout <<endl <<"对不起不能打开文件!" <<endl <<endl; system("pause"); return; while (getline(in, str) out <<str <<endl; out.close(); in.close(); cout <<endl <<"这个人的信

12、息已经从你的通迅录中删除!" <<endl <<endl; system("pause"); /显示所有联系人void book:show_all() ifstream inData("pbook.txt",ios:in); if (!inData) cout <<endl <<"对不起!没有找到文件!" <<endl; system("pause"); return; bool flag = true; string record; while

13、 (getline(inData, record) if (flag) cout <<endl <<"所有联系人信息如下: "<<endl; cout <<record <<endl; flag = false; if (flag) cout <<endl <<"你的通迅录中没有联系人!" <<endl <<endl; else cout <<endl <<"所有联系人已经全部显示出来!" <<

14、;endl <<endl; system("pause");/修改信息void book:alter() ifstream inData("pbook.txt", ios:in); if (!inData) cout <<endl <<"对不起不能打开文件!" <<endl <<endl; system("pause"); return; string sign; cout <<endl <<"请输入你想要修改的联系人的姓

15、名或电话号码 :" cin >>sign; fflush(stdin); string str1; getline(inData, str1); record *H = new record; record *p = H; record *q = H; bool flag = true; while (inData >>p-> >>p->object.number >>p->object.qq >>p->object.post >>p->object.addre

16、ss) p->next = new record; p = p->next; p->prior = q; q->next = p; q = p; p->next = NULL; inData.close(); p = H; while (p) if (p->=sign) | (p->object.number=sign) if (flag) cout <<endl <<"你想修改你联系人的信息如下: " <<endl <<endl; cout <<en

17、dl <<str1 <<endl; cout <<setiosflags(ios:left) <<setw(17) <<p-> <<" " <<setw(16) <<p->object.number <<" " <<setw(18) <<p->object.qq <<" " <<setw(14) <<p->object.po

18、st <<" " <<setw(20) <<p->object.address <<endl; flag = false; cout <<endl <<"请根据下面提示修改信息 : " <<endl; cout <<"姓名 :" ; cin >>p->; fflush(stdin); cout <<"电话号:" cin >>p->object.n

19、umber; fflush(stdin); cout <<"QQ :" cin >>p->object.qq; fflush(stdin); cout <<"邮编 :" cin >>p->object.post; fflush(stdin); cout <<"地址 :" cin >>p->object.address; fflush(stdin); break; p = p->next; if (flag) cout <<end

20、l <<"你的通迅录中没有你找的联系人!" <<endl <<endl; system("pause"); return; else ofstream out("pbook.txt",ios:out); if (!out) cout <<endl <<"对不起!不能打开文件!" <<endl; system("pause"); return; out <<str1 <<endl; p = H->

21、next; while (p) out <<setiosflags(ios:left) <<setw(17) <<p-> <<" " <<setw(16) <<p->object.number <<" " <<setw(18) <<p->object.qq <<" " <<setw(14) <<p->object.post <<&quo

22、t; " <<setw(20) <<p->object.address <<endl; p = p->next; out.close(); cout <<endl <<"信息已经修改完成!" <<endl <<endl; system("pause"); /查询联系人void book:select() ifstream inData("pbook.txt",ios:in); if (!inData) cout <<e

23、ndl <<"对不起!文件找不到!" <<endl; system("pause"); return; string sign; cout <<endl <<"输入你想查找的联系人的姓名或电话号码: " cin >>sign; fflush(stdin); string str1; bool flag = true; string str; while (inData >>name >>number) getline(inData, str); if

24、(name=sign) | (number=sign) cout <<endl <<"你要查找的联系人是: " <<endl <<endl; cout <<str1 <<endl; cout <<setiosflags(ios:left) <<setw(17) <<name <<number <<str <<endl; flag = false; break; void book:save_new() ofstream outData("pbook.txt", ios:app); if (!outData) cout <<endl <<"对不起!打开文件失败!" <<endl <<endl; system("pause"); return; outData << setiosflags(ios:left) << setw(17) << name <<" " << setw(16) <<