圖書(shū)管理系統(tǒng)系統(tǒng)設(shè)計(jì)

1、高級(jí)程序設(shè)計(jì)語(yǔ)言圖書(shū)管理系統(tǒng)設(shè)計(jì)報(bào)告學(xué)院：國(guó)+濟(jì)源工程學(xué)院專業(yè)：測(cè)繪工程成員:*指導(dǎo)教師：黃云鎧日期：2014年11月5日1系統(tǒng)設(shè)計(jì)1.1設(shè)計(jì)目標(biāo)注冊(cè)用戶可以登錄此系統(tǒng)；非注冊(cè)用戶注冊(cè)后可以使用本系統(tǒng)；讀者可以查詢、借閱、歸還圖書(shū)等；管理員可以對(duì)讀者、圖書(shū)進(jìn)行管理。數(shù)據(jù)庫(kù)設(shè)計(jì)概述概念結(jié)構(gòu)設(shè)計(jì)將從需求分析中得到的數(shù)據(jù)信息抽象為概念模型E-R模型。如圖所示。XV,圖書(shū)-_C出版社二一圖1-1圖書(shū)實(shí)體ER圖(密碼J)Q生名J)，經(jīng)分析可得到數(shù)據(jù)庫(kù)的版日匚J)Qjt閱日匚本系統(tǒng)是針對(duì)圖書(shū)管理工作過(guò)程進(jìn)行設(shè)計(jì)的，主要實(shí)現(xiàn)如下目標(biāo):圖1-2實(shí)體讀者ER圖用戶圖1-3用戶實(shí)體ER圖項(xiàng)目規(guī)劃圖書(shū)管理系統(tǒng)是一個(gè)

2、典型的數(shù)據(jù)庫(kù)應(yīng)用程序，由應(yīng)用程序和后臺(tái)數(shù)據(jù)庫(kù)兩部分構(gòu)成。(1)應(yīng)用程序應(yīng)用程序主要包括登錄，注冊(cè)，用戶信息，讀者信息，圖書(shū)信息管理，借閱圖書(shū)，綜合查詢，出版社信息等幾個(gè)部分組成。(2)數(shù)據(jù)庫(kù)數(shù)據(jù)庫(kù)負(fù)責(zé)對(duì)圖書(shū)信息，用戶信息等數(shù)據(jù)的管理。2數(shù)據(jù)庫(kù)設(shè)計(jì)說(shuō)明書(shū)2.1數(shù)據(jù)庫(kù)表結(jié)構(gòu)圖書(shū)表book列名知Nullr。ooldcharflO)BBookWritenvarchar(30)HBooltNamenvar匚har(2。)叨BookPublishnv3rclniar(!50)國(guó)BookPublishDatedatetimeBookPrieerricneyBBookSertnvarcharO1)H借閱信息表

3、borrow列名允許恒加charflO)解BooUDchar(10)BorrcwDdtedatetimeHReturnDatedatetimeIBOutTimeint7園TotalFinerrchar(10)BLo«tbitB用戶信息表Reader列名娟NWchar(10)ElRejderNamtnvarchar(0)nRedderPa&swordnvarchr(20)RlReaderSexnvarchar5J口fteaderAgeint回ReaderDcptnvarrhar(5D)sReaderZhuartVenvarchar(50)nWaxNumberintsikLost

4、nvarchar(15)ElRedderEmallvarchar(20>回|B用戶信息權(quán)限表right列wNullMI3ES393int周MajtTimeintmFiremoneyETimesint周用戶賬號(hào)表user列名音Null,?char(10UserPaswordnvarchar(20)JUs#rSortnvrchartSO)管理員賬號(hào)表usererheper列宅允許hull悔jAdmlnlDchar(iO)BTypenvarcharfZOj而AdminPassnvarchar(20)0ResderlDchar(lO)ReaderPassnvarchar20畫數(shù)據(jù)關(guān)系圖圖書(shū)管理系

5、統(tǒng)暫有數(shù)據(jù)（模擬運(yùn)行）管理員學(xué)工號(hào)：20姓名：邢吉昌密碼：111普通用戶學(xué)工號(hào)：21姓名：豬八戒密碼：333學(xué)工號(hào)：22姓名：孫悟空密碼：444圖書(shū)信息出版日期價(jià)格 書(shū)類編號(hào)作者書(shū)名出版社H1MARKC京門經(jīng)典清華大學(xué)出版社2011/4/5計(jì)算機(jī)H2哪吒和猴子的那些事大庭文印2010/1/2情感H3二郎神我也可以鬧天宮大庭文印2009/8/1技術(shù)3程序功能的實(shí)現(xiàn)登陸界面已注冊(cè)用戶登錄時(shí)，用戶類別選擇普通用戶或管理員，不選擇會(huì)出現(xiàn)提示主要代碼如下：usingSystem;using；using；using；using；using；usingWindowsFormsApplicationlpubl

6、icpartialclassLoginForm:Formpublicstringpassword;privateintErrorTimes;stringUser,Pwd;boolflagshow=false;privateboolyanzhengshuru()password=;if"")("請(qǐng)選擇登錄類型","登錄提示",();returnfalse;elseif"")("請(qǐng)輸入用戶名","登錄提示",;();returnfalse;elseif(password=&quo

7、t;")("請(qǐng)輸入密碼","登錄提示",;();returnfalse;elsereturntrue;publicLoginForm()InitializeComponent();privatevoidcancelbtn_Click(objectsender,EventArgse)();privatevoidLoginForm_Load(objectsender,EventArgse)privatevoidLoginForm_Closing(objectsender,FormClosingEventArgse)();privatevoidlog

8、inbtn_Click(objectsender,EventArgse)if(yanzhengshuru()if="管理員")SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog=1管理數(shù)據(jù)庫(kù);IntegratedSecurity=True");();stringcmd="selectAdminID,AdminPassfromuserhelper"SqlCommandcom=newSqlCommand(cmd,conConn

9、ection);SqlDataReaderreader=();while()User=reader"AdminID".ToString();Pwd=reader"AdminPass".ToString();if()=&()=flagshow=true;();();if(flagshow=true)();adminf1=newadmin();();elseif="普通用戶")SqlConnectionconConnectionl=newSqlConnection("DataSource=.sqlexpress;Init

10、ialCatalog學(xué)生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True");();stringcnd="selectReaderID,ReaderPasswordfromreader"SqlCommandcnm=newSqlCommand(cnd,conConnection1);SqlDataReaderreader1=();while()User=reader1"ReaderID".ToString();Pwd=reader1"ReaderPassword".ToString();if()=&()=fl

11、agshow=true;();();if(flagshow=true)()；讀者查閱fl=new讀者查閱();()；else("用戶名不存在或密碼錯(cuò)誤！”,”提示)ErrorTimes+;if(ErrorTimes>=3)("登錄次數(shù)過(guò)多，程序?qū)㈥P(guān)閉”)；sqlexpress;Initial Catalog學(xué)生管理數(shù)據(jù)庫(kù);Integrated Security=True");()；stringcmd="selectReaderlDfromreader"SqlCommandcom=newSqlCommand(cmd,conConnectio

12、n);SqlDataReaderreaderUser=();while()if=readerUser"ReaderID".ToString().Trim()=true;UserFlag=true;return;elseif!=readerUser"ReaderID".ToString().Trim()=false;=true;UserFlag=false;privatevoidbutton1_Click(objectsender,EventArgse)intindex="");if(index<1)=true;="郵箱

13、格式不正確，請(qǐng)重新輸入"else=true;="郵箱格式正確"if(UserFlag=true)("用戶已經(jīng)存在，請(qǐng)重新輸入！");return;if(UserFlag=false)SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog考生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True");();stringcmd="insertintoreader(ReaderID,ReaderPasswor

14、d,ReaderEmall)values('"+"',"+"'"+"',"+"'"+"')"SqlCommandcom=newSqlCommand(cmd,conConnection);();();("注冊(cè)成功！點(diǎn)擊確定，返回登錄界面。","提示");();LoginFormf2=newLoginForm();管理員操作界面usingSystem;using；using；using；using；us

15、ing；usingWindowsFormsApplicationlpublicpartialclassadmin:Formpublicadmin()InitializeComponent();privatevoid查看用戶信息ToolStripMenuItem_Click(objectsender,EventArgse)權(quán)限設(shè)置f8=new權(quán)限設(shè)置();();privatevoid查看用戶信息ToolStripMenuItem1_Click(objectsender,EventArgse)用戶信息fi=new用戶信息()；();privatevoid新增用戶ToolStripMenuItem1

16、_Click(objectsender,EventArgse)新增用戶f2=new新增用戶();();privatevoid刪除用戶ToolStripMenuItem1_Click(objectsender,EventArgse)用戶信息f3=new用戶信息();=true;();privatevoid錄入書(shū)籍ToolStripMenuItem_Click(objectsender,EventArgse)書(shū)籍信息f5=new書(shū)籍信息();();privatevoid刪除書(shū)籍ToolStripMenuItem_Click(objectsender,EventArgse)刪除書(shū)籍f6=new刪除書(shū)

17、籍();();privatevoid還書(shū)處理ToolStripMenuItem_Click(objectsender,EventArgse)還書(shū)處理f9=new還書(shū)處理();();privatevoidadmin_Load(objectsender,EventArgse)privatevoid借閱處理ToolStripMenuItem_Click(objectsender,EventArgse)借閱處理f10=new借閱處理()；();管理用戶管理用戶下共有三個(gè)子菜單|苜望月戶圉書(shū)告理新塞用戶制般用勺查看用戶信息新增用戶界面主要代碼如下:usingSystem;using；using；usin

18、g；using；using；usingWindowsFormsApplicationlpublicpartialclass新增用戶：Formpublic新增用戶()InitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog#生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True");();stringcmd="in

19、sertintoreader(ReaderID,ReaderName,ReaderPassword,ReaderSex,ReaderAge,ReaderDept,ReaderZhuanYe,MaxNumber,ReaderEmall)values('+"')"SqlCommandcom=newSqlCommand(cmd,conConnection);()；()；("添加成功！點(diǎn)擊確定，返回登錄界面。"，”提示)()；刪除用戶界面輸入學(xué)號(hào)即可查詢用戶信息，如圖，點(diǎn)擊刪除即刪除該用戶主要代碼如下：usingSystem;using；usin

20、g；using；using；using；usingWindowsFormsApplicationlpublicpartialclass用戶信息：FormboolUserFlag;public用戶信息()InitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse)if(UserFlag=false)("不存在該用戶，請(qǐng)核對(duì)后再輸入","警告");return;if(UserFlag=true)SqlConnectionconConnection=newSqlConnectio

21、n("DataSource=.sqlexpress;InitialCatalog寫生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True");();stringcmd="select*fromreader"SqlCommandcom=newSqlCommand(cmd,conConnection);="select*fromreader"SqlDataReaderdr=();while()=true;=dr"ReaderName".ToString().Trim();=dr"ReaderPasswo

22、rd".ToString().Trim();=dr"ReaderSex".ToString().Trim();=dr"ReaderAge".ToString().Trim();=dr"ReaderDept".ToString().Trim();=dr"ReaderZhuanYe".ToString().Trim();=dr"MaxNumber".ToString().Trim();=dr"ReaderEmall".ToString().Trim();();priva

23、tevoidtextBox1_TextChanged(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog斗生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True");();stringcmd="selectReaderIDfromreader"SqlCommandcom=newSqlCommand(cmd,conConnection);SqlDataReaderreaderUser=();

24、while()if=readerUser"ReaderID".ToString().Trim()UserFlag=true;return;elseif!=readerUser"ReaderID".ToString().Trim()UserFlag=false;privatevoidbutton2_Click(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog寫生管理數(shù)據(jù)庫(kù);Integr

25、atedSecurity=True");();stringcmd="deletefromreaderwhereReaderID='"+""',""")+""'SqlCommandcom=newSqlCommand(cmd,conConnection);();();("是否確認(rèn)刪除"，"提示)查看用戶信息界面該界面與刪除用戶界面代碼基本相似，主要是將查詢按鈕隱藏，故代碼不再列出圖書(shū)管理圖書(shū)查詢下共有2個(gè)子菜單錄入書(shū)籍頁(yè)面嗎書(shū)籌信息_廠一國(guó)書(shū)號(hào)，

26、出版日期，作有價(jià)檢王由書(shū)卻出版社；錄入主要代碼如下：usingSystem;using；using；using；using；using；usingWindowsFormsApplicationlpublicpartialclass書(shū)籍信息：Formpublic書(shū)籍信息()InitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog寫生管理數(shù)據(jù)

27、庫(kù);IntegratedSecurity=True");();stringcmd="insertintobook(BookID,BookWrite,BookName,BookPublish,BookPublishDate,BookPrice,BookSort)values('"+ "'." + "'" + "'." + "'" + "'." + "'" +"'."

28、 + "'" + "'." + "'" + "'." + "'" +"')"SqlCommandcom=newSqlCommand(cmd,conConnection);();();("錄入成功","提示");刪除書(shū)籍刪除書(shū)籍之前如需確認(rèn)是否是所需刪除的書(shū)籍，以防刪除錯(cuò)誤，可以先將所需刪除的書(shū)籍的書(shū)名輸入，點(diǎn)擊檢索后會(huì)出現(xiàn)該書(shū)的詳細(xì)信息，若確認(rèn)無(wú)誤后點(diǎn)擊刪除即可刪除該書(shū)主要代碼如下:usi

29、ngSystem;using；using；using；using；using；usingWindowsFormsApplicationlpublicpartialclass刪除書(shū)籍：FormboolUserFlag;public刪除書(shū)籍()InitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse)if(UserFlag=false)(“不存在此書(shū)，請(qǐng)核對(duì)后再輸入“，”警告)return;if(UserFlag=true)SqlConnectionconConnection=newSqlConnection(&q

30、uot;DataSource=.sqlexpress;InitialCatalog浮生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True");();stringcmd="select*frombook"SqlCommandcom=newSqlCommand(cmd,conConnection);="select*frombook"SqlDataReaderdr=();while()=dr"BookID".ToString().Trim();=dr"BookWrite".ToString().Tri

31、m();=dr"BookPublish".ToString().Trim();=dr"BookPublishDate".ToString().Trim();=dr"BookPrice".ToString().Trim();=dr"BookSort".ToString().Trim();();privatevoidtextBox3_TextChanged(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection("DataSour

32、ce=.sqlexpress;InitialCatalog#生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True");();stringcmd="selectBookNamefrombook"SqlCommandcom=newSqlCommand(cmd,conConnection);SqlDataReaderreaderUser=();while()if=readerUser"BookName".ToString().Trim()UserFlag=true;return;elseif!=readerUser"BookName

33、".ToString().Trim()UserFlag=false;privatevoidbutton2_Click(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog斗生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True");();stringcmd="deletefrombookwhereBookName='"+"'","

34、9;'")+"'"SqlCommandcom=newSqlCommand(cmd,conConnection);();();("是否確認(rèn)刪除”,”提示)權(quán)限設(shè)置該界面可以設(shè)置普通用戶的最大借書(shū)數(shù)量、最長(zhǎng)借閱時(shí)間、超期罰款(元/天)、遺失賠率等，主要代碼如下：usingSystem;using；using；using；using；using；usingWindowsFormsApplicationlpublicpartialclass權(quán)限設(shè)置：Formpublic權(quán)限設(shè)置()InitializeComponent()；privatevoid

35、button1_Click(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress；InitialCatalog寫生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True")；()；stringcmd="insertintoRight(MaxNum,MaxTime,Fine,Times)values('"+"',"+""'+"',"+

36、，"”+"',"+，”+"')"；SqlCommandcom=newSqlCommand(cmd,conConnection)；();();(“修改成功"，”提示");();還書(shū)處理輸入書(shū)籍號(hào)后即可查詢借閱人超期信息及圖書(shū)信息，無(wú)誤后點(diǎn)擊歸還確認(rèn)。操作后界面如下：主要代碼如下：usingSystem;using;using;using;using;using;usingWindowsFormsApplicationlpublicpartialclass還書(shū)處理：FormboolUserFlag;public還

37、書(shū)處理()InitializeComponent();privatevoidbutton2_Click(objectsender,EventArgse)if(UserFlag=false)("不存在此書(shū)，請(qǐng)核對(duì)后再輸入","警告");return;if(UserFlag=true)SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog浮生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True");();stringcmd=

38、"select*frombook"SqlCommandcom=newSqlCommand(cmd,conConnection);="select*frombook"SqlDataReaderdr=();while()=dr"BookWrite".ToString().Trim();=dr"BookName".ToString().Trim();=dr"BookPublish".ToString().Trim();=dr"BookPublishDate".ToString().

39、Trim();=dr"BookPrice".ToString().Trim();=dr"BookSort".ToString().Trim();();SqlConnectionconConnectionl=newSqlConnection("DataSource=.sqlexpress;InitialCatalog學(xué)生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True");();stringcmd1="selects.*,g.*fromborrows,readergwhere="SqlCommandcom1

40、=newSqlCommand(cmd1,conConnection1);="selects.*,g.*fromborrows,readergwhere="SqlDataReaderdr1=();while()=dr1"BorrowDate".ToString().Trim();=dr1"ReturnDate".ToString().Trim();=dr1"ReaderID".ToString().Trim();=dr1"ReaderName".ToString().Trim();=dr1&quo

41、t;ReaderSex".ToString().Trim();=dr1"ReaderDept".ToString().Trim();=dr1"ReaderZhuanYe".ToString().Trim();DateTimet1=;DateTimet2=(DateTime)dr1"ReturnDate"TimeSpants=t1-t2;intd=;=(d);if(d<=0)=(0);else(d*;();privatevoidtextBox1_TextChanged(objectsender,EventArgse)Sq

42、lConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog寫生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True");();stringcmd="selectBookIDfrombook"SqlCommandcom=newSqlCommand(cmd,conConnection);SqlDataReaderreaderUser=();while()if=readerUser"BookID".ToString().Trim()U

43、serFlag=true;return;elseif!=readerUser"BookID".ToString().Trim()UserFlag=false;privatevoidbutton1_Click(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog斗生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True");()；stringcmd="deletefromborroww

44、hereBookID=('"+"')"SqlCommandcom=newSqlCommand(cmd,conConnection);();();("添加成功！點(diǎn)擊確定，返回登錄界面。"，"提示")；();借閱處理輸入用戶名及書(shū)籍編號(hào)，點(diǎn)擊借閱即借書(shū)成功，操作后界面如下:主要代碼如下:usingSystem;using;using;using;using;using;usingWindowsFormsApplication1publicpartialclass借閱處理:Formpublic借閱處理()Initi

45、alizeComponent();privatevoidbutton1_Click(objectsender,EventArgse)if"")("請(qǐng)輸入用戶名","提示");return;if="")("請(qǐng)輸入書(shū)籍編號(hào)","提示");return;stringtime=DateTimedt=stringreturntime=();=time;=returntime;SqlConnectionconConnection=newSqlConnection("DataSo

46、urce=.sqlexpress;InitialCatalog#生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True");();stringconn="DataSource=.sqlexpress;InitialCatalog考生管理數(shù)據(jù)庫(kù)integratedSecurity=True"stringtt="selectBookNamefrombookwhereBookID='"+"'"SqlDataAdapterda=newSqlDataAdapter(tt,conn);DataSetds=newDa

47、taSet();(ds);=ds.Tables0.Rows00.ToString();stringcmd="insertintoborrow(ReaderID,BookID,BorrowDate,ReturnDate)values('"+"',"+"'"+"',"+"'"+"',"+"'"+"')"SqlCommandcom=newSqlCommand(cmd,conCon

48、nection);();();("借閱成功","提示");讀者查詢讀者查詢界面主要代碼如下:usingSystem;using；using；using；using；using；usingWindowsFormsApplicationlpublicpartialclass讀者查閱：Formpublic讀者查閱()InitializeComponent();privatevoid讀者彳言息ToolStripMenuItem_Click(objectsender,EventArgse)借閱信息f2=new借閱信息();();privatevoid圖書(shū)查詢Too

49、lStripMenuItem_Click(objectsender,EventArgse)圖書(shū)查詢f1=new圖書(shū)查詢();();privatevoid圖書(shū)續(xù)借ToolStripMenuItem_Click(objectsender,EventArgse)圖書(shū)續(xù)借f3=new圖書(shū)續(xù)借();();privatevoid圖書(shū)掛失ToolStripMenuItem_Click(objectsender,EventArgse)圖書(shū)掛失f4=new圖書(shū)掛失();()；圖書(shū)查詢?cè)擁?yè)面支持模糊查詢，輸入關(guān)鍵字即可查詢相關(guān)書(shū)籍，操作界面如下:usingSystem;using;using;using;usin

50、g;using;using;namespaceWindowsFormsApplication1publicpartialclass圖書(shū)查詢：Formpublic圖書(shū)查詢()InitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse)FillGrid();privatevoidFillGrid()if=("請(qǐng)輸入你要使用的檢索條件！","提示！");return;stringsql=;sql+="selectBookIDasI若,BookWriteas作者,Book

51、Nameas書(shū)名，BookPublishas出版社,BookPublishDateas出版日期,BookPriceas價(jià)格,BookSortas書(shū)類frombook"if!="")sql+="whereBookNamelike'%"+"%'"SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog斗生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True");();stringc

52、md=sql;DataSetdataset=newDataSet();SqlDataAdaptermyDataAdapter=newSqlDataAdapter(cmd,conConnection);(dataset);=0;借閱信息輸入學(xué)號(hào)后點(diǎn)擊查詢，即可查到已有借閱信息，查詢后界面如下主要代碼如下：usingSystem;using；using；using；using；using；using；namespaceWindowsFormsApplicationlpublicpartialclass借閱彳言息：Formpublic借閱信息()InitializeComponent();priva

53、tevoidbutton1_Click(objectsender,EventArgse)FillGrid();privatevoidFillGrid()if（"請(qǐng)輸入你要使用的學(xué)號(hào)！”,“提示！”）；return;stringsql=;sql+="selectasI若,as作者，as書(shū)名，as出版社，as出版日期，as價(jià)格，as借閱日期frombooks,borrowg"if!="")sql+="where="SqlConnectionconConnection=newSqlConnection("DataSour

54、ce=.sqlexpress;InitialCatalog斗生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True");()；stringcmd=sql;DataSetdataset=newDataSet();SqlDataAdaptermyDataAdapter=newSqlDataAdapter(cmd,conConnection);(dataset);=0;圖書(shū)續(xù)借輸入書(shū)籍編號(hào)，點(diǎn)擊續(xù)借即可主要代碼如下：usingSystem;using;using;using;using;using;usingWindowsFormsApplication1publicpartialclass圖書(shū)續(xù)借:Formpublic圖書(shū)續(xù)借()InitializeComponent();privatevoidbutton1_C