#include?“Borrow_book.h“



CBorrow_book::CBorrow_book（）
{
		cout?<		cin?>>?book_name;
		MYSQL?*mysql?=?NULL;
		mysql?=?mysql_init（（MYSQL?*）0）;
		char?strsql[1000]?=?“select?*?from?library?where?book_name?=?‘“;
		strcat_s（strsql?sizeof（strsql）?book_name）;
		strcat_s（strsql?sizeof（strsql）?“‘or?book_id?=?‘“）;
		strcat_s（strsql?sizeof（strsql）?book_name）;
		strcat_s（strsql?sizeof（strsql）?“‘“）;
		char*?command?=?strsql;

		//sprintf_s（commandsizeof（command）?“select?book_name?from?library?where?book_name?=?‘%s‘“?book_name）;
		mysql_real_connect
		（
			mysql
			“l(fā)ocalhost“?//數(shù)據(jù)庫(kù)地址
			“root“?//數(shù)據(jù)庫(kù)用戶名
			“123456“?//數(shù)據(jù)庫(kù)密碼
			“l(fā)ibrary“?//數(shù)據(jù)庫(kù)名稱
			0?//數(shù)據(jù)庫(kù)端口，0表示默認(rèn)端口（即3306）
			NULL?//如果unix_socket不是NULL，字符串指定套接字或應(yīng)該被使用的命名管道。注意host參數(shù)決定連接的類型
			0?//CLIENT_MULTI_STATEMENTS??//0?//通常是0
		）;
		cout?<		if?（!mysql）?//連接失敗
		{
			printf（“Connection?error:%d?%s\n“?mysql_errno（mysql）?mysql_error（mysql））;
		}
		int?flag?=?mysql_real_query（mysql?command?strlen（command））;

		if?（flag）
		{
			printf（“Select?error:%d?%s\n“?mysql_errno（mysql）?mysql_error（mysql））;
			exit（-1）;
		}

		MYSQL_RES?*res?=?mysql_store_result（mysql）;?//讀取將查詢結(jié)果???
		MYSQL_FIELD?*field?=?mysql_fetch_fields（res）;?//獲取所有列名
		int?field_count?=?mysql_field_count（mysql）;?//獲取列數(shù)

													//輸出所有列名
		for?（int?i?=?0;?i?		{
			printf（“%s\t“?field[i].name）;
		}

		printf（“\n“）;

		//遍歷輸出每一行數(shù)據(jù)??
		MYSQL_ROW?row;
		int?i?=?0;
		int?j?=?0;
		char?*ch_num[10]?=?{?“\0“?};
		while?（row?=?mysql_fetch_row（res））
		{
			i?=?0;
			ch_num[j]?=?row[i];
			printf（“%s\t“?row[i]）;
			i++;
			bookname[j]?=?row[i];
			printf（“%s\t“?row[i]）;
			i++;
			bookid[j]?=?row[i];
			printf（“%s\t“?row[i]）;
			i++;
			bookauthor[j]?=?row[i];
			printf（“%s\t“?row[i]）;
			i++;
			bookpress[j]?=?row[i];
			printf（“%s\t“?row[i]）;
			i++;
			booktime[j]?=?row[i];
			printf（“%s\t“?row[i]）;
			i++;
			printf（“%s\t“?row[i]）;
			i++;
			printf（“%s\t“?row[i]）;
			i++;
			bookamount[j]?=?row[i];
			printf（“%s\t“?row[i]）;
			j++;
			printf（“\n“）;
		}
		
		for（int?j?=?0;?bookname[j]?!=?NULL?;?j++?）
		{?
			booknum[j]?=?strtod（bookamount[j]?&ptr）;
		}
		
		if?（bookname[0]?==?NULL?）
		{
			cout?<		}
		else?if?（booknum[0]?		{
			cout?<		}
		else
		{
			for?（int?j?=?0;?bookname[j]?!=?NULL;?j++）
			{
				booknum[j]?--;
				bookamount[j]?=?number_change_string（booknum[j]）;
				cout?<			}
			
			cout?<			cin?>>?reader_id;
			
			MYSQL?*mysql?=?NULL;
			mysql?=?mysql_init（（MYSQL?*）0）;
			strcpy_s（strsql?sizeof（strsql）?“select?reader_id?reader_name?from?reader?where?reader_id?=?‘“）;
			strcat_s（strsql?sizeof（strsql）?reader_id）;
			strcat_s（strsql?sizeof（strsql）?“‘“）;
			mysql_real_connect
			（
				mysql
				“l(fā)ocalhost“?//數(shù)據(jù)庫(kù)地址
				“

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-11-07?00:14??library\
?????目錄???????????0??2017-10-31?15:29??library\.vs\
?????目錄???????????0??2017-10-31?15:29??library\.vs\library\
?????目錄???????????0??2017-10-31?15:29??library\.vs\library\v14\
?????文件???????81408??2017-11-07?00:14??library\.vs\library\v14\.suo
?????目錄???????????0??2017-11-09?15:22??library\Debug\
?????目錄???????????0??2017-11-03?20:44??library\library\
?????文件????????5887??2017-11-03?14:34??library\library\Borrow_book.cpp
?????文件?????????134??2017-11-02?11:16??library\library\Borrow_book.h
?????文件????????5133??2017-11-03?20:44??library\library\Library.cpp
?????文件????????1299??2017-11-03?14:13??library\library\Library.h
?????文件???????14618??2017-11-02?14:33??library\library\Manage_book.cpp
?????文件?????????196??2017-10-31?20:02??library\library\Manage_book.h
?????文件???????13325??2017-11-02?21:12??library\library\Reader.cpp
?????文件?????????187??2017-10-31?21:50??library\library\Reader.h
?????文件????????4149??2017-11-03?14:36??library\library\Return.cpp
?????文件?????????116??2017-10-31?21:50??library\library\Return.h
?????文件????????4426??2017-11-03?17:20??library\library\Search.cpp
?????文件?????????247??2017-11-03?16:08??library\library\Search.h
?????文件????????6854??2017-10-31?21:50??library\library\library.vcxproj
?????文件????????2066??2017-10-31?21:50??library\library\library.vcxproj.filters
?????文件?????????690??2017-11-01?00:23??library\library\main.cpp
?????目錄???????????0??2017-10-31?15:29??library\library\x64\
?????目錄???????????0??2017-11-04?18:26??library\library\x64\Debug\
?????文件??????135040??2017-11-03?14:34??library\library\x64\Debug\Borrow_book.obj
?????文件???????91531??2017-11-04?18:26??library\library\x64\Debug\Library.obj
?????文件??????155077??2017-11-03?14:13??library\library\x64\Debug\Manage_book.obj
?????文件??????314697??2017-11-03?14:13??library\library\x64\Debug\Reader.obj
?????文件??????132946??2017-11-03?14:36??library\library\x64\Debug\Return.obj
?????文件??????297115??2017-11-03?17:20??library\library\x64\Debug\Search.obj
?????文件??????134748??2017-11-03?13:30??library\library\x64\Debug\borrow_book.obj.enc
............此處省略23個(gè)文件信息