圖書管理系統(tǒng)MySQLC

1、電子科技大學成都學院C語言編程實踐課程設計報告小組： 學號： 院系： 專業(yè)： 年 月 日圖書管理系統(tǒng)作者：袁琦工具：Visual Studio 2012、MySQL Server 5.5、Navicat Premium語言：C、SQL程序功能介紹： 圖書信息錄入功能 圖書信息瀏覽功能 圖書信息查詢功能 查詢方式 按書名查詢 按作者名查詢 瀏覽全部信息 修改圖書信息并保存 系統(tǒng)功能結構圖 刪除圖書信息程序設計：1. 編程環(huán)境配置： 需先安裝 Visual studio 2012、MySQL、Navicat Premium 把mysql.h、libmysql.lib添加到vs項目中再把libmys

2、ql.lib放入項目資源文件夾中，把libmysql.lib復制到Windowssystem32和WindowsSysWOW64中 用Navicat Premium 建立好數(shù)據(jù)庫新建一個名為bookinfos的數(shù)據(jù)庫，字符集：utf-8排序方式：utf8_general_ci新建一個名為book的表格，其中id為主鍵，且自動遞增函數(shù)關系圖2. 程序代碼：#include<stdio.h>#include<stdlib.h>#include<string.h>#include<WinSock2.h>#include<mysql.h>#d

3、efine ADD 1#define DELETE 2#define BROWSE 3#define UPDATE 4#define CLOSE 5#define LENGTH 6MYSQL mysql, *sock;/聲明MySQL句柄/*函數(shù)聲明*/void Connector(char*,int);void mainMenu();void addMenu();void searchMenu();void update_bookinfo_menu();void search_by_bookName();void search_by_author();void add_bookinfo();

4、void delete_bookinfo();void update_bookName();void update_author();void update_publisher();void update_time();void update_price();/*程序入口*/void main()mainMenu();/主菜單/Connector(i_query);/*主菜單*/void mainMenu()int order;/用戶輸入指令printf("tt=nn");printf("tttt歡迎進入圖書管理系統(tǒng)nn");printf("t

5、tt 1.圖書錄入t");printf("t2.圖書查詢nn");printf("tttt3.退出圖書管理系統(tǒng)nn");printf("tt=n");printf("nn請輸入指令所對應的序號后按下回車：");scanf("%d",&order);switch (order)case 1 :addMenu();/進入圖書錄入子菜單break;case 2 :searchMenu();/進入圖書查詢子菜單break;case 3 :Connector("Close&qu

6、ot;,CLOSE);exit(1);break;default:printf("輸入指令有誤!n");system("pause");system("cls");mainMenu();break;/*圖書錄入子菜單*/void addMenu()int order;system("cls");printf("tt=nn");printf("tttt 0.返回主菜單nn");printf("ttt 1.錄入圖書信息t");printf("t2.刪

7、除圖書信息nn");printf("tttt 3.修改圖書信息nn");printf("tt=n");printf("請輸入指令序號:n");scanf("%d",&order);switch (order)case 0:system("cls");mainMenu();break;case 1:add_bookinfo();break;case 2:delete_bookinfo();break;case 3:system("cls");update_bo

8、okinfo_menu();default:printf("輸入指令有誤!n");system("pause");system("cls");addMenu();break;/*修改圖書信息子菜單*/void update_bookinfo_menu()int order;printf("tt=nn");printf("tttt 0.返回上級菜單nn");printf("tt 1.修改書名t 2.修改作者t3.修改出版社nn");printf("ttt 4.修改出版

9、時間t5.修改價格nn");printf("tt=nn");printf("請輸入指令序號:n");scanf("%d",&order);switch (order)case 0:system("cls");addMenu();break;case 1:update_bookName();break;case 2:update_author();break;case 3:update_publisher();break;case 4:update_time();break;case 5:updat

10、e_price();break;default:printf("輸入指令有誤!n");system("pause");system("cls");update_bookinfo_menu();break;/*修改書名*/void update_bookName()char i_query200 = "update book set bookName= ""char i_query_140 = "" where id = ""char ID11;char bookNa

11、me50;printf("請輸入圖書ID：n");scanf("%s",&ID);printf("請輸入圖書名稱：");scanf("%s",&bookName);Connector(strcat(i_query,strcat(bookName,strcat(i_query_1,strcat(ID,"""),UPDATE);/*修改作者*/void update_author()char i_query200 = "update book set author

12、= ""char i_query_140 = "" where id = ""char ID11;char author50 ;printf("請輸入圖書ID：n");scanf("%s",&ID);printf("請輸入作者名稱：");scanf("%s",&author);Connector(strcat(i_query,strcat(author,strcat(i_query_1,strcat(ID,"""

13、;),UPDATE);/*修改出版社*/void update_publisher()char i_query200 = "update book set publisher= ""char i_query_140 = "" where id = ""char ID11;char publisher50 ;printf("請輸入圖書ID：n");scanf("%s",&ID);printf("請輸入出版社：");scanf("%s",&a

14、mp;publisher);Connector(strcat(i_query,strcat(publisher,strcat(i_query_1,strcat(ID,"""),UPDATE);/*修改時間*/void update_time()char i_query200 = "update book set time= ""char i_query_140 = "" where id = ""char ID11;char time50 ;printf("請輸入圖書ID：n"

15、;);scanf("%s",&ID);printf("請輸入出版時間：");scanf("%s",&time);Connector(strcat(i_query,strcat(time,strcat(i_query_1,strcat(ID,"""),UPDATE);/*修改價格*/void update_price()char i_query200 = "update book set price= ""char i_query_140 = "&qu

16、ot; where id = ""char ID11;char price50 ;printf("請輸入圖書ID：n");scanf("%s",&ID);printf("請輸入圖書價格：");scanf("%s",&price);Connector(strcat(i_query,strcat(price,strcat(i_query_1,strcat(ID,"""),UPDATE);/*添加圖書信息*/void add_bookinfo()char

17、i_query300 = "insert into book(bookName,author,publisher,time,price) values(""char bookName200;char author100;char publisher100;char time40;char price10;printf("請輸入書名：n");scanf("%s",bookName);printf("請輸入作者：n");scanf("%s",author);printf("請輸入

18、出版社：n");scanf("%s",publisher);printf("請輸入出版時間：n");scanf("%s",time);printf("請輸入價格：n");scanf("%s",price);Connector(strcat(strcat(strcat(strcat(strcat(strcat(strcat(strcat(strcat(strcat(i_query,bookName),"",""),author),"&qu

19、ot;,""),publisher),"",""),time),"",""),price),"")"),ADD);/*刪除圖書信息*/void delete_bookinfo()char i_query100 = "delete from book where id = '"char input10;printf("請輸入要刪除圖書的ID:n");scanf("%s",&input);Con

20、nector(strcat(strcat(i_query,input),"'"),DELETE);/*圖書查詢子菜單*/void searchMenu()int order;/用戶輸入指令system("cls");printf("tt=nn");printf("tttt 0.返回主菜單nn");printf("ttt 1.按書名查詢t");printf("t2.按作者查詢nn");printf("tttt3.瀏覽多有圖書的信息nn");print

21、f("tt=n");printf("請輸入指令序號：");scanf("%d",&order);switch (order)case 0: system("cls");mainMenu();break;case 1:search_by_bookName();break;case 2:search_by_author();break;case 3: Connector("select * from book",BROWSE);break;default:printf("輸入指令有

22、誤!n");system("pause");system("cls");searchMenu();break;/*按書名查找*/void search_by_bookName()char i_query50 = "select * from book where bookName = ""char input20;char quotation = """printf("請輸入書名：");scanf("%s",&input);strcat(

23、i_query,input);strcat(i_query, quotation);Connector(i_query,BROWSE);/*按作者名查找*/void search_by_author()char i_qurey50 = "select * from book where author = ""char input20;char quotation = """printf("請輸入作者名：");scanf("%s",&input);strcat(i_qurey, input

24、);strcat(i_qurey, quotation);Connector(i_qurey, BROWSE);/*連接數(shù)據(jù)庫函數(shù)*/void Connector(char *i_query, int function)const char *host = "127.0.0.1"const char *user = "root"const char *password = "paw8zmre"const char *db = "bookinfos"unsigned int port = 3306;const cha

25、r *unix_socket = NULL;unsigned long client_flag = 0;MYSQL_RES *result;MYSQL_ROW row;mysql_init(&mysql);sock = mysql_real_connect(&mysql, host, user, password, db, port, unix_socket, client_flag);mysql_set_character_set(&mysql, "GBK");result = mysql_store_result(&mysql);switch (function)/*添加圖書信息*/case ADD:mysql_query(sock,i_qu