#include?
#include?
#include?
#include?
#include?
#pragma?comment（lib“libmysql.lib“）
//庫名為??borrow
//庫存信息表為book
//借閱信息表為borrowbook
//讀者信息表為reader
//mysql中密碼要設定為123456
	MYSQL?mysql*sock;????//?定義數據庫連接的句柄，它被用于幾乎所有的?MySQL?函數
	MYSQL_RES?*res;???????//?查詢結果集，結構類型
	MYSQL_FIELD?*fd?;?????//?包含字段信息的結構
	MYSQL_ROW?row?;???????//?存放一行查詢結果的字符串數組
	char??qbuf[256];
typedef?struct{
?int?booknumber;
?char?bookname[50];
?char?bookauthor[50];
?char?bookpulisher[50];
?char?bookdate[50];
?int??bookmoney;
?char?booktype[50];
?int??booksumnumber;
?int??booknownumber;
?int??bookborrownumber;

}SSM;//庫存信息結構體

typedef?struct{
int?Number;
??char?Name[50];
??int?Money;
??int?IDCard;
??int??date;
??int??fine;
?int??DueDate;



}SSG;//定義借閱結構體
typedef?struct{

int?sno;
char?name[50];
char?classroom[50];
int??number;?//學號
char??type[50];
int??time;
int??borrownumber;


}SSN;//定義學生結構體


void?SSM_Init（）//庫存初始化
{
	mysql_init（&mysql）;
	if?（!（sock?=?mysql_real_connect（&mysql“localhost““root““123456““Borrow“0NULL0）））
	{
		fprintf（stderr“Couldn‘t?connect?to?engine!/n%s/n/n“?mysql_error（&mysql））;
		perror（““）;
		exit（1）;
	}
int?i=0j;
?SSM?MY[50];
?printf（“請輸入庫存總數目“）;
?scanf（“%d“&j）;
for（i=0;i	{
?????printf（“請輸入圖書編號“）;
	?scanf（“%d“&MY[i].booknumber）;
?????printf（“請輸入圖書書名“）;
?????scanf（“%s“&MY[i].bookname）;
	?printf（“請輸入圖書作者“）;
	?scanf（“%s“&MY[i].bookauthor）;
	?printf（“請輸入圖書出版社“）;
	?scanf（“%s“&MY[i].bookpulisher）;
	?printf（“請輸入圖書出版日期（格式為：年.月.日）“）;
	?scanf（“%s“&MY[i].bookdate）;
	?printf（“請輸入圖書金額“）;
	?scanf（“%d“&MY[i].bookmoney）;
	?printf（“請輸入圖書類別（報刊、書籍、期刊）“）;
	?scanf（“%s“&MY[i].booktype）;
	?printf（“請輸入圖書總入庫數量“）;
	?scanf（“%d“&MY[i].booksumnumber）;
	?printf（“請輸入圖書當前庫存量“）;
	?scanf（“%d“&MY[i].booknownumber）;
?????MY[i].bookborrownumber=MY[i].booksumnumber-MY[i].booknownumber;
?????sprintf（qbuf?“insert?into?book?（booknumberbooknamebookauthorbookpulisherbookdatebookmoneybooktypebooksumnumberbooknownumberbookborrownumber）values?（%d‘%s‘‘%s‘‘%s‘‘%s‘%d‘%s‘%d%d%d）;“MY[i].booknumberMY[i].booknameMY[i].bookauthorMY[i].bookpulisherMY[i].bookdateMY[i].bookmoneyMY[i].booktypeMY[i].booksumnumberMY[i].booknownumberMY[i].bookborrownumber）;
???????????mysql_query（&mysql?qbuf）;
		???printf（“庫存信息寫入成功！“）;
?}
	//?field?number

}
void?SSN_Init（）//讀者信息初始化
{
	mysql_init（&mysql）;
	if?（!（sock?=?mysql_real_connect（&mysql“localhost““root““123456““Borrow“0NULL0）））
	{
		fprintf（stderr“Couldn‘t?connect?to?engine!/n%s/n/n“?mysql_error（&mysql））;
		perror（““）;
		exit（1）;
	}

???int?i=0j;
??SSN?SM[50];
???printf（“請輸入總數：“）;
???scanf（“%d“&j）;
??for（i=0;i{
	printf（“請輸入借書證號：“）;
	scanf（“%d“&SM[i].sno）;
	printf（“請輸入姓名：“）;
	scanf（“%s“&SM[i].name）;
	printf（“請輸入班級：“）;
	scanf（“%s“&SM[i].classroom）;
	printf（“請輸入學號：“）;
	scanf（“%d“&SM[i].number）;
	printf（“請輸入類型（學生或教師）“）;
	scanf（“%s“&SM[i].