用mysql數(shù)據(jù)庫(kù)實(shí)現(xiàn)的c圖書(shū)管理系統(tǒng)-在線(xiàn)瀏覽
2024-10-28 14:36本頁(yè)面
【正文】 tu_name。2）用戶(hù)管理string stu_phone。//學(xué)號(hào)（登錄帳號(hào)）string password。//欠費(fèi)額LendBook lendbook。//把此人所有信息（包括借書(shū)）顯示出來(lái)void Stu::show_stu(){ coutclass StuNode { public: Stu stu。}。void savestu(StuNode *p)。//將讀者信息從數(shù)據(jù)庫(kù)中刪除class StuManage:public BookManage { private: int totolstu。} void addstu()。//刪除用戶(hù)void findstu(string s,int flag)。//借書(shū)void backbook(string ss,string s,int flag)。//還款void mux_stu_book()。void StuManage::addstu(){ string h。if(h==“1”)return。else if(h==“0”){string na,num,p1,pa,pa1,pa2。coutcinna。coutp1。coutnum。p=0。while(1){coutpa1。if(pa1==pa2){ pa=pa2。break。pnext=headstu。savestu(p)。//用戶(hù)總數(shù)加一couth。if(headstu!=NULL){switch(flag){case 0:if(headstu==s)//當(dāng)要?jiǎng)h除的用戶(hù)位于鏈表的頭結(jié)點(diǎn)位置 { headstu=pnext。del_sql_stu(p)。}else if(pnext)//非頭結(jié)點(diǎn)位置 {for(p=headstu。amp。p=pnext){if(pnext==s){pnext=pnextnext。del_sql_stu(pnext)。break。case 1:if(headstu==s){headstu=pnext。del_sql_stu(p)。}else if(pnext){for(p=headstu。amp。p=pnext){if(pnext==s){pnext=pnextnext。del_sql_stu(pnext)。break。default:cout} } }void StuManage::findstu(string s,int flag){ StuNode *p。switch(flag){case 0:for(p=headstu。p=pnext){if(p==s)break。p!=NULL。} if(h0)coutnext){ if(p==s){p()。if(i0)”NONEcoutwhile(i){cout[i1]}cout}else{int i=p。case 1:}coutfor(p=headstu。p=pnext){if(p==s){p()。cout//輸出用戶(hù)所借書(shū)的名字 cout[i1]}cout}else{int i=p。}}if(p==NULL)coutbreak。BookNode *q。for(p=headstu。p=pnext)i++。j+=q。break。p!=NULL。//從數(shù)據(jù)庫(kù)中刪除 int i=q。amp。amp。time_t now。now)。now)。//所借書(shū)數(shù)目加一p。}}if(p==NULL)coutbreak。p!=NULL。//從數(shù)據(jù)庫(kù)中刪除int i=q。amp。amp。time_t now。now)。now)。p。} } if(p==NULL)coutbreak。StuNode *q。q!=NULL。break。p!=NULL。//從數(shù)據(jù)庫(kù)中刪除time_t now。now)。now)。p++。if(s2592000)//2592000為一個(gè)月的秒數(shù){int t=ceil((s2592000)/86400)。}break。case 1:for(p=headbook。p=pnext){if(p==s){del_sql_book(p)。time(amp。q=time(amp。q。//同樣的書(shū)的個(gè)數(shù)加一//計(jì)算借用圖書(shū)的時(shí)間，超過(guò)一個(gè)月，開(kāi)始計(jì)費(fèi)time_t s=difftime(q,q)。q=t*。} } if(p==NULL)cout}void StuManage::paydebt(string s){ StuNode *p。p!=NULL。coutstream stream stu_str。}void savestu(StuNode *p)//保存讀者信息到數(shù)據(jù)庫(kù) {memset((void*)strSQL,0,200)。if(mysql_real_query(amp。}void savebook(BookNode *p)//保存圖書(shū)信息到數(shù)據(jù)庫(kù) { memset((void*)strSQL,0,200)。if(mysql_real_query(amp。}void del_sql_stu(StuNode *p)//將讀者信息從數(shù)據(jù)庫(kù)中刪除 {memset((void*)strSQL,0,200)。%s39。if(mysql_real_query(amp。}void del_sql_book(BookNode *p)//將圖書(shū)信息從數(shù)據(jù)庫(kù)中刪除 { memset((void*)strSQL,0,200)。%s39。if(mysql_real_query(amp。} /* void savestu()//保存讀者信息文件 { ofstream outfile(“./”,ios::out)。} StuNode *p。p!=NULL。outfile。outfile。outfile。}void savebook()//保存圖書(shū)信息文件 { ofstream outfile(“./”,ios::out)。} BookNode *p。p!=NULL。outfile。outfile。memset((void*)strSQL,0,100)。mysql_query(amp。//查詢(xún)r(jià)esults = mysql_store_result(amp。//獲取記錄num_fields = mysql_num_fields(results)。//獲取字段數(shù)組while((rows = mysql_fetch_row(results))!= NULL)//循環(huán)顯示{while(i num_fields){StuNode *p=new StuNode。p =(rows[i]?rows[i++]:“NULL”)。p =(rows[i]?rows[i++]:“NULL”)。p =(time_t)(rows[i]?rows[i++]:“NULL”)。p = atoi(rows[i]?rows[i++]:“NULL”)。//建立用戶(hù)鏈表headstu=p。} }void loadbook()//從書(shū)數(shù)據(jù)庫(kù)中讀取 { int i = 0。strcpy(strSQL,“select * from book”)。mysql,strSQL)。mysql)。//獲取字段數(shù)fileds = mysql_fetch_fields(results)。p =(rows[i]?rows[i++]:“NULL”)。p =(rows[i]?rows[i++]:“NULL”)。p = atoi(rows[i]?rows[i++]:“NULL”)。pnext=headbook。}i = 0。if(!infile){coutreturn。} else {while(()!=EOF)//數(shù)據(jù)從文件讀出{StuNode *p=new StuNode。infilepp。infilepp。//建立用戶(hù)鏈表headstu=p。}()。if(!infile){} coutwhile(()!=EOF)//數(shù)據(jù)從文件讀出{BookNode *p=new BookNode。infilepp。if(p!=”“){ pnext=headbook。} else delete p。/****************************************（*******************************************/void MenuAdmin(){4）界面部分 cout歡迎來(lái)到圖書(shū)管理系統(tǒng)$“NONE$“NO
范文總結(jié)相關(guān)推薦
鄂ICP備17016276號(hào)-1