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

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

2、部分構(gòu)成。（1）應(yīng)用程序應(yīng)用程序主要包括登錄，注冊(cè)，用戶信息，讀者信息，圖書信息管理，借閱圖書，綜合查詢，出版社信息等幾個(gè)部分組成。（2）數(shù)據(jù)庫(kù)數(shù)據(jù)庫(kù)負(fù)責(zé)對(duì)圖書信息，用戶信息等數(shù)據(jù)的管理。2數(shù)據(jù)庫(kù)設(shè)計(jì)說(shuō)明書1數(shù)據(jù)庫(kù)表結(jié)構(gòu)2.1.1圖書表book列名允許MullooklcharflOEBookWritenvarchar(30)KIBookNamerwrch占r(20)BookPublishnvrclniar(!50)gBookPublishDatedatetimeISBoolePricerricneyBBookSertnvarcharO1)7HB2.1.2借閱信息表borrow列名允許Nulln

3、“匕_I啓翳瑁char(10HBooUDchar(10SBorrcwDdtedatetimeHReturnDatedatetimeIBOutTimeint7囲TotalFinenchar(10)BLotbitBn2.1.2用戶信息表Reader列容允許NullcharflO)RejderNamtnvarchar(20)0Read&rPasswQrdnvrthjrfiO)Envsrthrfj)mRedderAgeintaReaderDeptnvarchar(SO)團(tuán)ReaderZhuarrVenyarchar(50)aMaxNumb-erintaIsLostnvrchar(15)aReaderE

4、mallvarchar(20)2.1.4用戶信息權(quán)限表right列名允許NullintMajcTime；ntEFinemoney0Timesint匣2.1.5用戶賬號(hào)表user列名允許Nullchar(10UserPacswordnyarchar(20)gUserSortnvrcharfSO)1=12.1.6管理員賬號(hào)表usererheper1列名數(shù)摒類型允許hullAdmlnlDchart10)BTypenvarchar(20)AdminPassnvarchar(20)ReaderlDchar10)00團(tuán)ReaderPassnvr匚hNr(20)團(tuán)n2.2數(shù)據(jù)關(guān)系圖2.3圖書管理系統(tǒng)暫有數(shù)據(jù)

5、（模擬運(yùn)行）2.3.1管理員學(xué)工號(hào)：2014701020姓名：邢吉昌密碼：1112.3.2普通用戶學(xué)工號(hào)：2014701021姓名：豬八戒密碼：333學(xué)工號(hào)：2014701022姓名：孫悟空密碼：4442.3.3圖書信息編號(hào)作者書名出版社出版日期價(jià)格書類H319584781MARKC入門經(jīng)典清華大學(xué)出版社2011/4/521.56計(jì)算機(jī)H319584782哪吒和猴子的那些事天庭文印2010/1/2216.5情感H319584783二郎神我也可以鬧天宮天庭文印2009/8/129.32技術(shù)3程序功能的實(shí)現(xiàn)3.1登陸界面已注冊(cè)用戶登錄時(shí)，用戶類別選擇普通用戶或管理員，不選擇會(huì)出現(xiàn)提示主要代碼如下：

6、usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWindowsFormsApplication1publicpartialclassLoginForm:Formpublicstringpassword;privateintErrorTime

7、s;stringUser,Pwd;boolflagshow=false;privateboolyanzhengshuru()password=textBox3.Text;if(Typename.Text.Trim()=“)MessageBoxShow(“請(qǐng)選擇登錄類型“,登錄提示,MessageBoxButtons.OK,MessageBoxIcon.Information);Typename.Focus();returnfalse;elseif(loginid.Text.Trim()=“)MessageBoxShow(“請(qǐng)輸入用戶名“，登錄提示“，MessageBoxButtons.OK,M

8、essageBoxIcon.Information);loginid.Focus();returnfalse;elseif(password=“)MessageBoxShow(“請(qǐng)輸入密碼“,登錄提示“,MessageBoxButtons.OK,MessageBoxIcon.Information);textBox3.Focus();returnfalse;elsereturntrue;publicLoginForm()lnitializeComponent();privatevoidcancelbtn_Click(objectsender,EventArgse)Application.Exi

9、t();privatevoidLoginForm_Load(objectsender,EventArgse)privatevoidLoginForm_Closing(objectsender,FormClosingEventArgse)Application.Exit();privatevoidloginbtn_Click(objectsender,EventArgse)if(yanzhengshuru()if(Typename.Text.Trim()=管理員“)SqlConnectionconConnection=newSqlConnection(DataSource=.sqlexpress

10、;lnitialCatalog=學(xué)生管理數(shù)據(jù)庫(kù)IntegratedSecurity=True);conConnection.Open();stringcmd=selectAdminlD,AdminPassfromuserhelper;SqlCommancbom=newSqlComman(tmd,conConnection);SqlDataReaderreader=com.ExecuteReader();while(reader.Read()User=readerAdminlD.ToString();Pwd=readerAdminPass.ToString();if(User.Trim()=lo

11、ginid.Text&Pwd.Trim()=textBox3.Text)flagshow=true;reader.Close();conConnection.Close();if(flagshow=true)this.Hide();adminfl=newadmin();f1.ShowDialog();elseif(Typename.Text.Trim()=普通用戶“)SqlConnectionconConnectionl=newSqlConnection(DataSource=.sqlexpress;lnitialCatalog=學(xué)生管理數(shù)據(jù)庫(kù)IntegratedSecurity=True);

12、conConnection1.Open();stringcnd=selectReaderID,ReaderPasswordfromreader;SqlCommanctnm=newSqlComman(tnd,conConnectionl);SqlDataReaderreaderl=cnm.ExecuteReader();while(reader1.Read()User=reader1Pwd=reader1ReaderlD.ToString();ReaderPassword.ToString();if(User.Trim()=loginid.Text&Pwd.Trim()=textBox3.Tex

13、t)flagshow=true;reader1.Close();conConnection1.Close();if(flagshow=true)this.Hide();讀者查閱f1=new讀者查閱（）;f1.ShowDialog();elseMessageBoxShow（用戶名不存在或密碼錯(cuò)誤！,提示）;ErrorTimes+;if(ErrorTimes=3)MessageBoxShow（”登錄次數(shù)過(guò)多，程序?qū)㈥P(guān)閉）;/Application.Exit();return;privatevoidlabel1_Click(objectsender,EventArgse)privatevoidlab

14、el2_Click(objectsender,EventArgse)privatevoidlabel3_Click(objectsender,EventArgse)privatevoidbutton1_Click(objectsender,EventArgse)this.Hide();注冊(cè)fl=new注冊(cè)();f1.ShowDialog();privatevoidusercomboBox_SelectedIndexChanged(objectsender,EventArgse)privatevoiduseracctxt_TextChanged(objectsender,EventArgse)p

15、rivatevoidtextBox3_TextChanged(objectsender,EventArgse)3.2登陸界面如果學(xué)號(hào)已經(jīng)存在，則會(huì)出現(xiàn)“*用戶名已經(jīng)存在，請(qǐng)重新輸入”的提示，當(dāng)重新輸入密碼時(shí)，如果兩次密碼不相同，則會(huì)出現(xiàn)“*請(qǐng)注意，兩次密碼不一樣”的提示主要代碼如下：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Wind

16、ows.Forms;usingSystem.Data.SqlClient;namespaceWindowsFormsApplication1publicpartialclass注冊(cè):Formpublic注冊(cè)()lnitializeComponent();publicboolUserFlag;privatevoidtextBox3_TextChanged(objectsender,EventArgse)if(textBox2.Text.Trim()!=textBox3.Text.Trim()label6.Visible=true;elselabel8.Visible=true;label6.Vi

17、sible=false;privatevoid注冊(cè)_Load(objectsender,EventArgse)privatevoidtextBox1_TextChanged(objectsender,EventArgse)學(xué)生管理SqlConnectionconConnection=newSqlConnection(DataSource=.sqlexpress;lnitialCatalog=數(shù)據(jù)庫(kù);IntegratedSecurity=True);conConnection.Open();stringcmd=selectReaderIDfromreader;SqlCommanobom=newS

18、qlComman(tmd,conConnection);SqlDataReaderreaderUser=com.ExecuteReader();while(readerUser.Read()if(textBox1.Text=readerUserReaderID.ToString().Trim()label7.Visible=true;UserFlag=true;return;elseif(textBox1.Text!=readerUserReaderID.ToString().Trim()label7.Visible=false;label9.Visible=true;UserFlag=fal

19、se;privatevoidbutton1_Click(objectsender,EventArgse)intindex=textBox4.TextndexOf(if(index1)）；labellO.Visible=labellO.Text=elselabellO.Visible=labellO.Text=true;郵箱格式不正確，請(qǐng)重新輸入true;郵箱格式正確;if(UserFlag=true)MessageBoxShow(“用戶已經(jīng)存在，請(qǐng)重新輸入！“)；return;if(UserFlag=false)SqlConnectionconConnection=newSqlConnecti

20、on(DataSource=.sqlexpress;lnitialCatalog=學(xué)生管理數(shù)據(jù)庫(kù)IntegratedSecurity=True);conConnection.Open();stringcmd=insertintoreader(ReaderlD,ReaderPassword,ReaderEmall)values(+textBox1.Text+,+”+textBox2.Text+,+textBox4.Text+);SqlCommanobom=newSqlComman(tmd,conConnection);com.ExecuteNonQuery();conConnection.Clo

21、se();MessageBoxShow(“注冊(cè)成功！點(diǎn)擊確定，返回登錄界面。,提示);this.Close();LoginFormf2=newLoginForm();3.3管理員操作界面usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsFormsApplication1public

22、partialclassadmin:Formpublicadmin()InitializeComponent();privatevoid查看用戶信息ToolStripMenultem_Click(objectsender,EventArgse)權(quán)限設(shè)置f8=new權(quán)限設(shè)置();f8.ShowDialog();privatevoid查看用戶信息ToolStripMenultem1_Click(objectsender,EventArgse)用戶信息fi=new用戶信息();fi.ShowDialog();privatevoid新增用戶ToolStripMenultem1_Click(object

23、sender,EventArgse)新增用戶f2=new新增用戶();f2.ShowDialog();privatevoid刪除用戶ToolStripMenultem1_Click(objectsender,EventArgse)用戶信息f3=new用戶信息();f3.button2.Visible=true;f3.ShowDialog();privatevoid錄入書籍ToolStripMenultem_Click(objectsender,書籍信息f5=new書籍信息();f5.ShowDialog();privatevoid刪除書籍ToolStripMenultem_Click(obje

24、ctsender,刪除書籍f6=new刪除書籍();f6.ShowDialog();privatevoid還書處理ToolStripMenultem_Click(objectsender,還書處理f9=new還書處理();f9.ShowDialog();privatevoidadmin_Load(objectsender,EventArgse)privatevoid借閱處理ToolStripMenultem_Click(objectsender,借閱處理f10=new借閱處理();EventArgse)EventArgse)EventArgse)EventArgse)f10.ShowDialo

25、g();3.3.1管理用戶管理用戶下共有三個(gè)子菜單詭可戶|圏韋套毘新竜用戶刪除用戶新增用戶界面主要代碼如下:usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWindowsFormsApplication1publicpartialclass

26、新增用戶:Formpublic新增用戶()lnitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection(DataSource=.sqlexpress;InitialCatalog=學(xué)生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True);conConnection.Open();stringcmd=insertintoreader(ReaderlD,ReaderName,ReaderPassword,ReaderSex,

27、ReaderAge,ReaderDept,ReaderZhuanYe,MaxNumber,ReaderEmall)values(+textBox1.Text+,+textBox2.Text+,+textBox3.Text+,+textBox4.Text+,+m+textBox5.Text+,+吶+textBox6.Text+,+吶+textBox7.Text+,+吶+textBox8.Text+,+”+textBox9.Text+);SqlCommandtom=newSqlComman(Cmd,conConnection);com.ExecuteNonQuery();conConnection

28、.Close();MessageBoxShow(“添加成功！點(diǎn)擊確定，返回登錄界面。，“提示“);this.Close();331.2刪除用戶界面輸入學(xué)號(hào)即可查詢用戶信息，如圖，點(diǎn)擊刪除即刪除該用戶主要代碼如下：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient

29、;namespaceWindowsFormsApplication1publicpartialclass用戶信息:FormboolUserFlag;public用戶信息()InitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse)if(UserFlag=false)MessageBoxShow(不存在該用戶，請(qǐng)核對(duì)后再輸入,警告);return;if(UserFlag=true)SqlConnectionconConnection=newSqlConnection(DataSource=.sqlexpress;

30、InitialCatalog=學(xué)生管理數(shù)據(jù)庫(kù)IntegratedSecurity=True);conConnection.Open();stringcmd=select*fromreader;SqlCommanobom=newSqlCommanc(cmd,conConnection);com.CommandText=select*fromreader;SqlDataReaderdr=com.ExecuteReader();while(dr.Read()labelll.Visible=true;textBox2.Text=drReaderName.ToString().Trim();textBo

31、x3.Text=drReaderPassword.ToString().Trim();textBox4.Text=drReaderSex.ToString().Trim();textBox5.Text=drReaderAge.ToString().Trim();textBox6.Text=drReaderDept.ToString().Trim();textBox7.Text=drReaderZhuanYe.ToString().Trim();textBox8.Text=drMaxNumber.ToString().Trim();textBox9.Text=drReaderEmall.ToSt

32、ring().Trim();conConnection.Close();privatevoidtextBox1_TextChanged(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection(DataSource=.sqlexpress;lnitialCatalog=數(shù)據(jù)庫(kù)IntegratedSecurity=True);conConnection.Open();stringcmd=selectReaderlDfromreader;SqlCommanobom=newSqlComman(tmd,conConnecti

33、on);SqlDataReaderreaderUser=com.ExecuteReader();while(readerUser.Read()if(textBoxl.Text=readerUserReaderlD.ToString().Trim()UserFlag=true;return;elseif(textBoxl.Text!=readerUserReaderlD.ToString().Trim()UserFlag=false;privatevoidbutton2_Click(objectsender,EventArgse)SqlConnectionconConnection=newSql

34、Connection(DataSource=.sqlexpress;lnitialCatalog=數(shù)據(jù)庫(kù);lntegratedSecurity=True);conConnection.Open();stringcmd=deletefromreaderwhereReaderlD=+textBox1.Text.Replace(,)+SqlCommanotom=newSqlComman(fcmd,conConnection);com.ExecuteNonQuery();conConnection.Close();MessageBoxShow(是否確認(rèn)刪除，提示)；學(xué)生管理學(xué)生管理查看用戶信息界面該界

35、面與刪除用戶界面代碼基本相似，主要是將查詢按鈕隱藏，故代碼不再列出332圖書管理圖書查詢下共有2個(gè)子菜單錄入書籍頁(yè)面主要代碼如下:usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWindowsFormsApplicationlpublicp

36、artialclass書籍信息:Formpublic書籍信息()lnitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection(DataSource=.sqlexpress;InitialCatalog=學(xué)生管理數(shù)據(jù)庫(kù)IntegratedSecurity=True);conConnection.Open();stringcmd=insertintobookTOC o 1-5 h z(BooklD,BookWrite,BookNam

37、e,BookPublish,BookPublishDate,BookPrice,BookSort)values(+textBoxl.Text+,+textBox2.Text+,+吶+textBox3.Text+,+吶+textBox4.Text+,+“+textBox5.Text+,+吶+textBox6.Text+,+吶+textBox7.Text+);SqlCommanobom=newSqlComman(tmd,conConnection);com.ExecuteNonQuery();conConnection.Close();MessageBoxShow(“錄入成功“,提示“)；TOC

38、o 1-5 h ztextBoxl.Text=;textBox2.Text=;textBox3.Text=;textBox4.Text=;textBox5.Text=;textBox6.Text=;textBox7.Text=;3.322刪除書籍刪除書籍之前如需確認(rèn)是否是所需刪除的書籍，以防刪除錯(cuò)誤，可以先將所需刪除的書籍的書名輸入，點(diǎn)擊檢索后會(huì)出現(xiàn)該書的詳細(xì)信息，若確認(rèn)無(wú)誤后點(diǎn)擊刪除即可刪除該書主要代碼如下：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;using

39、System.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWindowsFormsApplication1publicpartialclass刪除書籍:FormboolUserFlag;public刪除書籍()lnitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse)if(UserFlag=false)MessageBoxShow(“不存在此書，請(qǐng)核

40、對(duì)后再輸入，“警告);return;if(UserFlag=true)SqlConnectionconConnection=newSqlConnection(DataSource=.sqlexpress;lnitialCatalog=管理數(shù)據(jù)庫(kù)IntegratedSecurity=True);學(xué)生conConnection.Open();stringcmd=select*frombook;SqlCommanotom=newSqlComman(tmd,conConnection);com.CommandText=select*frombook;SqlDataReaderdr=com.Execut

41、eReader();while(dr.Read()textBoxl.Text=drtextBox2.Text=drtextBox4.Text=drtextBox5.Text=drtextBox6.Text=drtextBox7.Text=drconConnection.Close();BookID.ToString().Trim();BookWrite.ToString().Trim();BookPublish.ToString().Trim();BookPublishDate.ToString().Trim();BookPrice.ToString().Trim();BookSort.ToS

42、tring().Trim();privatevoidtextBox3_TextChanged(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection(DataSource=.sqlexpress;lnitialCatalog=學(xué)生管理數(shù)據(jù)庫(kù)IntegratedSecurity=True);conConnection.Open();stringcmd=selectBookNamefrombook;SqlCommanotom=newSqlComman(fcmd,conConnection);SqlDataReaderr

43、eaderUser=com.ExecuteReader();while(readerUser.Read()if(textBoxl.Text=readerUserBookName.ToString().Trim()UserFlag=true;return;elseif(textBox1.Text!=readerUserBookName.ToString().Trim()UserFlag=false;privatevoidbutton2_Click(objectsender,EventArgse)學(xué)生管理SqlConnectionconConnection=newSqlConnection(Dat

44、aSource=.sqlexpress;lnitialCatalog=數(shù)據(jù)庫(kù);IntegratedSecurity=True);conConnection.Open();stringcmd=deletefrombookwhereBookName=+textBox3.Text.Replace(,”)+SqlCommanotom=newSqlComman(tmd,conConnection);com.ExecuteNonQuery();conConnection.Close();MessageBoxShow(“是否確認(rèn)刪除，“提示);3.3.3權(quán)限設(shè)置/天）、該界面可以設(shè)置普通用戶的最大借書數(shù)量、

45、最長(zhǎng)借閱時(shí)間、超期罰款（元遺失賠率等，主要代碼如下：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWindowsFormsApplication1publicpartialclass權(quán)限設(shè)置:Formpublic權(quán)限設(shè)置()lnitial

46、izeComponent();privatevoidbutton1_Click(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection(DataSource=.sqlexpress;InitialCatalog=學(xué)生管理數(shù)據(jù)庫(kù)IntegratedSecurity=True);conConnection.Open();stringcmd=insertintoRight(MaxNum,MaxTime,Fine,Times)values(+textBoxl.Text+,+textBox2.Text+,+吶+textBox

47、3.Text+,+“+textBox4.Text+);SqlCommanobom=newSqlComman(tmd,conConnection);com.ExecuteNonQuery();conConnection.Close();MessageBoxShow(“修改成功“,提示“)；this.Close();3.3.4還書處理操作輸入書籍號(hào)后即可查詢借閱人超期信息及圖書信息，無(wú)誤后點(diǎn)擊歸還確認(rèn)后界面如下：主要代碼如下：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data

48、;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.OleDb;usingSystem.Data.SqlClient;namespaceWindowsFormsApplication1publicpartialclass還書處理:FormboolUserFlag;public還書處理()lnitializeComponent();privatevoidbutton2_Click(objectsender,EventArgse)if(UserFlag=f

49、alse)MessageBoxShow(“不存在此書，請(qǐng)核對(duì)后再輸入，“警告);return;if(UserFlag=true)學(xué)生SqlConnectionconConnection=newSqlConnection(DataSource=.sqlexpress;InitialCatalog=管理數(shù)據(jù)庫(kù)IntegratedSecurity=True);conConnection.Open();conConnection.Open();stringcmd=select*frombook;SqlCommanotom=newSqlComman(bmd,conConnection);com.Comm

50、andText=select*frombookSqlDataReaderdr=com.ExecuteReader();while(dr.Read()textBoxll.Text=drtextBox12.Text=drtextBox13.Text=drtextBox14.Text=drtextBox15.Text=drtextBox16.Text=drconConnection.Close();BookWrite.ToString().Trim();BookName.ToString().Trim();BookPublish.ToString().Trim();BookPublishDate.T

51、oString().Trim();BookPrice.ToString().Trim();BookSort.ToString().Trim();SqlConnectionconConnectionl=newSqlConnection(DataSource=.sqlexpress;lnitialCatalog=學(xué)生管理數(shù)據(jù)庫(kù)IntegratedSecurity=True);conConnection1.Open();stringcmdl=selects.*,g*fromborrows,readergwheres.ReaderID=g.ReaderIDSqlCommanoboml=newSqlCo

52、mman(tmd1,conConnectionl);coml.CommandText=selects.*,g*fromborrows,readergwheres.ReaderID=g.ReaderIDSqlDataReaderdr1=com1.ExecuteReader();while(dr1.Read()textBox2.Text=dr1textBox3.Text=dr1textBox4.Text=dr1textBox5.Text=dr1textBox6.Text=dr1textBox7.Text=dr1textBox8.Text=dr1DateTimet1=DateTimet2=(Borr

53、owDate.ToString().Trim();ReturnDate.ToString().Trim();ReaderID.ToString().Trim();ReaderName.ToString().Trim();ReaderSex.ToString().Trim();ReaderDept.ToString().Trim();ReaderZhuanYe.ToString().Trim()ReturnDate;DateTime.Now;DateTime)dr1TimeSpants=t1-t2;intd=ts.Days;Convert.ToString(0);textBox9.Text=if

54、(d=0)textBoxIO.Text=elseConvert.ToString(d);textBoxIO.Text=Convert.ToString(d*0.1);conConnection1.Close();conConnection1.Close();privatevoidtextBox1_TextChanged(objectsender,EventArgse)學(xué)生管理數(shù)SqlConnectionconConnection=newSqlConnection(DataSource=.sqlexpress;lnitialCatalog=據(jù)庫(kù)IntegratedSecurity=True);c

55、onConnection.Open();stringcmd=selectBookIDfrombook;SqlCommanobom=newSqlComman(tmd,conConnection);SqlDataReaderreaderUser=com.ExecuteReader();while(readerUser.Read()if(textBoxl.Text=readerUserBookID.ToString().Trim()UserFlag=true;return;elseif(textBoxl.Text!=readerUserBookID.ToString().Trim()UserFlag

56、=false;privatevoidbutton1_Click(objectsender,EventArgse)學(xué)生管理SqlConnectionconConnection=newSqlConnection(DataSource=.sqlexpress;InitialCatalog=數(shù)據(jù)庫(kù)IntegratedSecurity=True);conConnection.Open();stringcmd=deletefromborrowwhereBookID=(+textBox1.Text+);SqlCommanobom=newSqlComman(tmd,conConnection);com.Exe

57、cuteNonQuery();conConnection.Close();MessageBoxShow(“添加成功！點(diǎn)擊確定，返回登錄界面。，“提示“)；this.Close();335借閱處理輸入用戶名及書籍編號(hào)，點(diǎn)擊借閱即借書成功，操作后界面如下:主要代碼如下：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms

58、;usingSystem.Data.SqlClient;namespaceWindowsFormsApplication1publicpartialclass借閱處理:Formpublic借閱處理（）lnitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse)if(textBox1.Text.Trim()=“)MessageBoxShow(“請(qǐng)輸入用戶名“,提示“)；return;if(textBox2.Text.Trim()=)MessageBoxShow(“請(qǐng)輸入書籍編號(hào)“,提示);return;string

59、time=DateTime.Now.ToString();DateTimedt=DateTime.Now.Date.AddDays(30);stringreturntime=dt.ToString();textBox4.Text=time;textBox5.Text=returntime;SqlConnectionconConnection=newSqlConnection(DataSource=.sqlexpress;lnitialCatalog=學(xué)生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True);conConnection.Open();stringconn=DataSour

60、ce=.sqlexpress;InitialCatalog=學(xué)生管理數(shù)據(jù)庫(kù);IntegratedSecurity=True;stringtt=selectBookNamefrombookwhereBookID=+textBox2.Text+;SqlDataAdapterda=newSqlDataAdapter(tt,conn);DataSetds=newDataSet();da.Fill(ds);textBox3.Text=ds.Tables0.Rows00.ToString();stringcmd=insertintoborrow(ReaderlD,BooklD,BorrowDate,Ret