#include?
#include?
#include?“function.h“

void?print_status（int?errorcode）{
????if（errorcode）{
????????printf（“failed\n“）;
????}?else?{
????????printf（“successed\n“）;
????}
}

int?add_license（MYSQL*?conn?int?id）{
????char?sql[100];
????sprintf（sql?“insert?into?license?values（%d）;“?id）;
????return?mysql_query（conn?sql）;
}

int?delete_license（MYSQL*?conn?int?id）{
????char?sql[100];
????sprintf（sql?“delete?from?license?where?id?=?（%d）;“?id）;
????return?mysql_query（conn?sql）;
}

int?show_license（MYSQL*?conn）{
????char?sql[100];
????sprintf（sql?“select?*?from?license;“）;
????return?mysql_query（conn?sql）;
}

int?add_book（MYSQL*?conn?int?id?int?count）{
????char?sql[100];
????sprintf（sql?“insert?into?book?values（%d?%d）;“?id?count）;
????if（mysql_query（conn?sql））{
????????sprintf（sql?“update?book?set?count?=?count?+?（%d）?where?id?=?（%d）;“?count?id）;
????????return?mysql_query（conn?sql）;
????}
????return?0;
}

int?show_book（MYSQL*?conn）{
????char?sql[100];
????sprintf（sql?“select?*?from?book;“）;
????return?mysql_query（conn?sql）;
}

int?show_book_id（MYSQL*?conn?int?id）{
????char?sql[100];
????sprintf（sql?“select?*?from?book?where?id?=?%d;“?id）;
????return?mysql_query（conn?sql）;
}

int?lend_book（MYSQL*?conn?int?license_id?int?book_id）{
????char?sql[100];
????sprintf（sql?“insert?into?lend?values（%d?%d?0）;“?license_id?book_id）;
????return?mysql_query（conn?sql）;
}

int?return_book（MYSQL*?conn?int?license_id?int?book_id）{
????char?sql[100];
????sprintf（sql?“update?lend?set?returned?=?1?where?license_id?=?%d?and?book_id?=?%d;“?license_id?book_id）;
????return?mysql_query（conn?sql）;
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-04-29?10:32??library-management-system-master\
?????文件?????????246??2016-04-29?10:32??library-management-system-master\.gitignore
?????文件????????1073??2016-04-29?10:32??library-management-system-master\LICENSE
?????文件?????????513??2016-04-29?10:32??library-management-system-master\README.md
?????文件?????????389??2016-04-29?10:32??library-management-system-master\schema.sql
?????目錄???????????0??2016-04-29?10:32??library-management-system-master\src\
?????文件?????????363??2016-04-29?10:32??library-management-system-master\src\Makefile
?????文件?????????222??2016-04-29?10:32??library-management-system-master\src\db_config_sample.h
?????文件????????1657??2016-04-29?10:32??library-management-system-master\src\function.c
?????文件?????????381??2016-04-29?10:32??library-management-system-master\src\function.h
?????文件????????1073??2016-04-29?10:32??library-management-system-master\src\main.c
?????文件?????????414??2016-04-29?10:32??library-management-system-master\src\parser.c
?????文件??????????89??2016-04-29?10:32??library-management-system-master\src\parser.h