?? reader.cpp
字號:
#include "Reader.h"
#include "ways.h"
int Reader::select_Lost(Chaxun & se)//丟失書本查詢
{
MYSQL_RES * point;
int bb[3]={14,18,12};
string str="select items.book_name as '書名',concat(concat(loans.ISBN,'-'),char(ascii(FLOOR(loans.number/10)))) as '書號',lend_time as '借書時間' from items,loans where items.ISBN=loans.ISBN and (loans.number-FLOOR(loans.number/10)*10)=4";
point=se.Demand(str.c_str());
way->Show_data(point,bb);
return 0;
}
int Reader::select_Compens(Chaxun & se)//賠款書本查詢
{
MYSQL_RES * point;
int bb[3]={14,18,12};
string str="select items.book_name as '書名',concat(concat(loans.ISBN,'-'),char(ascii(FLOOR(loans.number/10)))) as '書號',lend_time as '借書時間' from items,loans where items.ISBN=loans.ISBN and (loans.number-FLOOR(loans.number/10)*10)=5";
point=se.Demand(str.c_str());
way->Show_data(point,bb);
return 0;
}
int Reader::select_Library(Chaxun & se)//圖書館在冊書查詢
{
MYSQL_RES * point;
int bb[7]={14,14,5,14,12,4,4};
string aa="select book_name as '書名',ISBN,writer as '作者',publish as '出版社',publish_time as '出版日期', price as '價格',maxbook-number as '可借量' from items";
point=se.Demand(aa.c_str());
way->Show_data(point,bb);
return 0;
}
int Reader::select_History(Chaxun & se)//借閱歷史查詢
{
MYSQL_RES * point;
int bb[4]={14,18,12,4};
string str="select items.book_name as '書名',concat(concat(loans.ISBN,'-'),char(ascii(FLOOR(loans.number/10)))) as '書號',lend_time as '借書時間',(loans.number-FLOOR(loans.number/10)*10) as '狀態' from items,loans where items.ISBN=loans.ISBN";
point=se.Demand(str.c_str());
cout<<"狀態值說明: 1:已借未還 2:已還 3:已掛失 4:已丟失 5.已賠款"<<endl;
way->Show_data(point,bb);
return 0;
}
int Reader::select_Book_now(Chaxun & se)//現借書及情況查詢
{
MYSQL_RES * point;
int bb[3]={14,18,12};
string str="select items.book_name as '書名',concat(concat(loans.ISBN,'-'),char(ascii(FLOOR(loans.number/10)))) as '書號',lend_time as '借書時間' from items,loans where items.ISBN=loans.ISBN and (loans.number-FLOOR(loans.number/10)*10)=1";
point=se.Demand(str.c_str());
way->Show_data(point,bb);
return 0;
}
int Reader::pwd_Change(Chaxun & se)//更改密碼操作
{
string pwd1,pwd2;
cout<<"**************************************"<<endl;
cout<<"* 請輸入你的新密碼 *"<<endl;
cin>>pwd1;
cout<<"* 請再次確認密碼 *"<<endl;
cin>>pwd2;
if(pwd1==pwd2)
{
pwd1="update reader set read_pwd = '" + pwd1 +"' where read_id= '"+Reader_id+"';";
int i=se.Run(pwd1.c_str());
way->Show_judge(i);
}
else
pwd_Change(se);
return 0;
}
int Reader::reserva_Book(Chaxun & se)//預定圖書操作
{
cout<<"**************************************"<<endl;
cout<<"* 請輸入你要預約的圖書名 *"<<endl;
string name;
cin>>name;
name="insert into reserve values ( '"+Reader_id+"','"+name+"','"+way->Now_time()+"','0','0');";
way->Show_judge(se.Run(name.c_str()));
return 0;
}
int Reader::cancel_reserva_Book(Chaxun & se)//取消預訂圖書操作
{
cout<<"**************************************"<<endl;
cout<<"* 請輸入你要取消預約的圖書名 *"<<endl;
string name;
cin>>name;
name="delete from reserve where book_name = '"+name+"' and state = '0';";
way->Show_judge(se.Run(name.c_str()));
return 0;
}
int Reader::select_reserva_Book(Chaxun & se)//預約情況查詢
{
string str="select book_name as '書名',time as '預約時間',state as '結果' from reserve";
MYSQL_RES * point;
int bb[3]={14,12,4};
point=se.Demand(str.c_str());
cout<<"結果值說明: 0:未處理 1:已批準 2:未批準"<<endl;
way->Show_data(point,bb);
return 0;
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -