圖書館信息管理系統(tǒng)學(xué)位論文

借閱者數(shù)量名稱作者數(shù)量名稱作者出版社類別出版日期備注價(jià)格編號(hào)姓名借書證號(hào)罰款密碼身份證性別電話身份編號(hào)借還借閱者圖書工作人員管理人員借還維護(hù)圖3-2全局ER模式圖3.3系統(tǒng)數(shù)據(jù)流分析3.3.1系統(tǒng)數(shù)據(jù)庫操作數(shù)據(jù)庫的應(yīng)用無處不在，C#語言具有強(qiáng)大的數(shù)據(jù)庫操作功能，數(shù)據(jù)庫連接對(duì)“圖書館信息管理系統(tǒng)”來說是非常重要的部分，建立與數(shù)據(jù)庫連接，執(zhí)行查詢，提取數(shù)據(jù)，，刪除和修改數(shù)據(jù)等操作。應(yīng)用程序應(yīng)用程序取得與數(shù)據(jù)的連接Connection生成SQL執(zhí)行對(duì)象執(zhí)行SQL語句數(shù)據(jù)庫圖3-3數(shù)據(jù)庫操作圖3.4可行性分析3.4.1開發(fā)語言可行性分析本圖書館信息管理系統(tǒng)主要目的是利用C#編制一個(gè)圖書館信息管理系統(tǒng)，用以實(shí)現(xiàn)圖書館對(duì)管理員信息、讀者信息、借還書等信息的集中管理，對(duì)整個(gè)系統(tǒng)的分析、設(shè)計(jì)過程給出一個(gè)完整論證，圖書館信息管理系統(tǒng)是一種基于C/S的數(shù)據(jù)庫數(shù)據(jù)操作模式。本系統(tǒng)的建成無疑會(huì)提高圖書館的管理效率，以及實(shí)現(xiàn)辦公自動(dòng)化帶來非常重要的作用。3.4.2系統(tǒng)可行性分析本系統(tǒng)對(duì)電腦的要求配置比較低，是基本電腦都能達(dá)到的。作為操作平臺(tái)的WindowsXP以上版本的操作系統(tǒng)功能逐漸的強(qiáng)大完善，故而軟件的運(yùn)行環(huán)境是可以滿足的。3.4.3經(jīng)濟(jì)可行性分析一、開發(fā)經(jīng)濟(jì)成本本畢業(yè)設(shè)計(jì)采用C#設(shè)計(jì)，運(yùn)行SQLSERVER2005數(shù)據(jù)庫，運(yùn)行系統(tǒng)要求為Windows。SQLServer2005、VisualStudio2005都是Windows里很常見的開發(fā)工具，而Windows系統(tǒng)本身也被廣泛使用。因此，開發(fā)此系統(tǒng)，所需經(jīng)費(fèi)不高,并且此系統(tǒng)操作簡(jiǎn)單、便捷、效率高。二、使用經(jīng)濟(jì)價(jià)值隨著社會(huì)的發(fā)展，傳統(tǒng)手工的圖書館管理模式已經(jīng)不能滿足現(xiàn)代圖書館快速發(fā)展的需要，信息化的不斷發(fā)展，信息技術(shù)的成熟及成本下降也是圖書館信息管理化水平提高的積極因素之一。許多高校把實(shí)現(xiàn)圖書館信息管理自動(dòng)化建設(shè)制定為中長期發(fā)展規(guī)劃,圖書館信息管理自動(dòng)化建設(shè)作為今后幾年要抓好的重點(diǎn)任務(wù)。與此圖書館信息管理系統(tǒng)作為圖書館管理重要的組成部分，也必將在未來的高校發(fā)展中發(fā)揮更大的作用。

4.圖書館信息管理系統(tǒng)設(shè)計(jì)和實(shí)現(xiàn)4.1數(shù)據(jù)庫設(shè)計(jì)4.1.1建立數(shù)據(jù)庫數(shù)據(jù)庫名稱為library,數(shù)據(jù)庫中包括：1.圖書信息表（book）；2.借出圖書信息表（bookOut）；3.借閱者信息表（person）；4.身份信息表（identity）；5.圖書類別信息表（type）；6.管理員信息表（manager）；其中數(shù)據(jù)庫的表分別如圖所示：一、圖4-1圖書信息表（book）二、圖4-2借出圖書信息表（bookOut）三、圖4-3借閱者信息表（person）四、圖4-4身份信息表（identity）五、圖4-5圖書類別信息表（type）六、圖4-6管理員信息表（manager）4.2功能模實(shí)現(xiàn)和關(guān)鍵代碼4.2.1用戶登陸界面設(shè)計(jì)圖4-7登陸模塊登陸模塊關(guān)鍵代碼：privatevoidbtAdd_Click(objectsender,System.EventArgse) { if(name.Text.Trim()==""||password.Text.Trim()=="") MessageBox.Show("請(qǐng)輸入用戶名和密碼","提示"); else { sqlConnection1.Open();SqlCommandcmd=newSqlCommand("",sqlConnection1); if(radioManage.Checked==true)//管理員角色登錄 { stringsql="select*frommanagerwhereMName='"+name.Text.Trim()+"'andMCode='"+password.Text.Trim()+"'"; cmd.CommandText=sql; if(null!=cmd.ExecuteScalar()) { //隱藏登錄窗口 this.Visible=false; //創(chuàng)建并打開主界面 mainmain=newmain(); main.Tag=this.FindForm();SqlDataReaderdr; cmd.CommandText=sql; dr=cmd.ExecuteReader(); dr.Read();main.menuItem1.Visible=(bool)(dr.GetValue(2).ToString().Trim()=="1"?true:false);//數(shù)據(jù)庫中表dbo.manager的第二列控制菜單欄的menuItem1menuItem2menuItem3main.menuItem2.Visible=(bool)(dr.GetValue(2).ToString().Trim()=="1"?true:false);main.menuItem3.Visible=(bool)(dr.GetValue(2).ToString().Trim()=="1"?true:false);main.menuItem4.Visible=(bool)(dr.GetValue(3).ToString().Trim()=="1"?true:false);//數(shù)據(jù)庫中表dbo.manager的第三列控制菜單欄的menuItem4main.menuItem5.Visible=(bool)(dr.GetValue(4).ToString().Trim()=="1"?true:false);//數(shù)據(jù)庫中表dbo.manager的第三列控制菜單欄的menuItem5 main.statusBarPanel2.Text=name.Text.Trim(); main.statusBarPanel6.Text="管理員"; main.ShowDialog(); } else MessageBox.Show("用戶名或密碼錯(cuò)誤","警告"); } elseif(radioPerson.Checked==true)//讀者登錄 { stringsql="select*frompersonwherePID='"+name.Text.Trim()+"'andPCode='"+password.Text.Trim()+"'"; cmd.CommandText=sql; if(null!=cmd.ExecuteScalar()) { //隱藏登錄窗口 this.Visible=false; //創(chuàng)建并打開主界面 mainmain=newmain(); main.Tag=this.FindForm();SqlDataReaderdr; cmd.CommandText=sql; dr=cmd.ExecuteReader(); dr.Read();main.menuItem1.Visible=main.menuItem2.Visible=main.menuItem3.Visible=main.menuItem4.Visible=false;//讀者沒有menuItem1menuItem2menuItem3menuItem4的功能 main.statusBarPanel2.Text=name.Text.Trim(); main.statusBarPanel6.Text="讀者"; main.ShowDialog(); } else MessageBox.Show("用戶名或密碼錯(cuò)誤","警告"); } else MessageBox.Show("沒有選擇角色","提示"); sqlConnection1.Close(); } }privatevoidpassword_KeyDown(objectsender,KeyEventArgse){if(e.KeyCode.ToString()=="Return")btAdd_Click(null,null);} privatevoidbtClose_Click(objectsender,System.EventArgse) { this.Close(); }4.2.2主界面設(shè)計(jì)圖4-8主界面4.2.3系統(tǒng)管理設(shè)計(jì)圖4-9添加用戶添加用戶關(guān)鍵代碼：privatevoidbtAdd_Click(objectsender,System.EventArgse) { if(textName.Text.Trim()==""||textPassword.Text.Trim()==""||textPWDNew.Text.Trim()==""||radioManage.Checked==false&&radioWork.Checked==false) { MessageBox.Show("請(qǐng)輸入完整信息！","警告"); } else { if(textPassword.Text.Trim()!=textPWDNew.Text.Trim()) { MessageBox.Show("兩次密碼輸入不一致！","警告"); } else { sqlConnection1.Open();SqlCommandcmd=newSqlCommand("",sqlConnection1); stringsql="select*frommanagerwhereMName='"+textName.Text.Trim()+"'"; cmd.CommandText=sql; if(null==cmd.ExecuteScalar()) { if(radioManage.Checked==true) sql="insertintomanager"+ "values('"+textName.Text.Trim()+"','"+textPWDNew.Text.Trim()+"',1,0,0)"; else sql="insertintomanager"+ "values('"+textName.Text.Trim()+"','"+textPWDNew.Text.Trim()+"',0,1,0)"; cmd.CommandText=sql; cmd.ExecuteNonQuery(); MessageBox.Show("添加用戶成功！","提示"); this.Close(); } else { MessageBox.Show("用戶名"+textName.Text.Trim()+"已經(jīng)存在！","提示"); textPWDNew.Text=""; textPassword.Text=""; } sqlConnection1.Close(); } } } privatevoidbtClose_Click(objectsender,System.EventArgse) { this.Close();}4.2.5圖書管理設(shè)計(jì)圖4-10圖書書目圖書書目關(guān)鍵代碼：AddBookaddBook; privatevoidbtAdd_Click(objectsender,System.EventArgse) { addBook=newAddBook(); addBook.ShowDialog(); } ModifyBookmodifyBook; privatevoidbtModify_Click(objectsender,System.EventArgse) { if(dataGrid1.DataSource!=null||dataGrid1[dataGrid1.CurrentCell]!=null)//數(shù)據(jù)源不為空，被選中的單元格不為空 { modifyBook=newModifyBook(); modifyBook.textID.Text=ds.Tables["book"].Rows[dataGrid1.CurrentCell.RowNumber][0].ToString().Trim(); modifyBook.textName.Text=ds.Tables["book"].Rows[dataGrid1.CurrentCell.RowNumber][1].ToString().Trim(); modifyBook.textWriter.Text=ds.Tables["book"].Rows[dataGrid1.CurrentCell.RowNumber][2].ToString().Trim(); modifyBook.textPublish.Text=ds.Tables["book"].Rows[dataGrid1.CurrentCell.RowNumber][3].ToString().Trim(); modifyBook.date1.Text=ds.Tables["book"].Rows[dataGrid1.CurrentCell.RowNumber][4].ToString().Trim(); modifyBook.textPrice.Text=ds.Tables["book"].Rows[dataGrid1.CurrentCell.RowNumber][5].ToString().Trim(); modifyBook.textNum.Text=ds.Tables["book"].Rows[dataGrid1.CurrentCell.RowNumber][6].ToString().Trim(); modifyBook.textType.Text=ds.Tables["book"].Rows[dataGrid1.CurrentCell.RowNumber][7].ToString().Trim(); modifyBook.textRemark.Text=ds.Tables["book"].Rows[dataGrid1.CurrentCell.RowNumber][8].ToString().Trim(); modifyBook.Show(); } else MessageBox.Show("沒有指定圖書信息！","提示"); } privatevoidbtDel_Click(objectsender,System.EventArgse) { if(dataGrid1.CurrentRowIndex>=0&&dataGrid1.DataSource!=null&&dataGrid1[dataGrid1.CurrentCell]!=null) { sqlConnection1.Open(); stringsql="select*frombookOutwhereBID='"+ds.Tables["book"].Rows[dataGrid1.CurrentCell.RowNumber][0].ToString().Trim()+"'";SqlCommandcmd=newSqlCommand(sql,sqlConnection1);SqlDataReaderdr; dr=cmd.ExecuteReader(); if(dr.Read()) { MessageBox.Show("刪除圖書'"+ds.Tables["book"].Rows[dataGrid1.CurrentCell.RowNumber][1].ToString().Trim()+"'失敗，該圖書正在流通中！","提示"); dr.Close(); } else { dr.Close(); sql="deletefrombookwhereBIDnotin(selectdistinctBIDfrombookOut)andBID"+ "='"+ds.Tables["book"].Rows[dataGrid1.CurrentCell.RowNumber][0].ToString().Trim()+"'"; cmd.CommandText=sql; cmd.ExecuteNonQuery(); MessageBox.Show("刪除圖書'"+ds.Tables[0].Rows[dataGrid1.CurrentCell.RowNumber][1].ToString().Trim()+"'成功","提示"); } sqlConnection1.Close(); } else return; } privatevoidbtClose_Click(objectsender,System.EventArgse) { this.Close();}4.2.5讀者管理設(shè)計(jì)圖4-11借閱者信息借閱者信息關(guān)鍵代碼：AddPersonaddPerson; privatevoidbtAdd_Click(objectsender,System.EventArgse) { addPerson=newAddPerson(); addPerson.ShowDialog(); } ModifyPersonmodifyPerson; privatevoidbtModify_Click(objectsender,System.EventArgse) { if(dataGrid1.DataSource!=null||dataGrid1[dataGrid1.CurrentCell]!=null) { modifyPerson=newModifyPerson(); modifyPerson.textID.Text=ds.Tables["person"].Rows[dataGrid1.CurrentCell.RowNumber][0].ToString().Trim(); modifyPerson.textName.Text=ds.Tables["person"].Rows[dataGrid1.CurrentCell.RowNumber][1].ToString().Trim(); modifyPboSex.Text=ds.Tables["person"].Rows[dataGrid1.CurrentCell.RowNumber][2].ToString().Trim(); modifyPerson.textPhone.Text=ds.Tables["person"].Rows[dataGrid1.CurrentCell.RowNumber][3].ToString().Trim(); modifyPerson.textPN.Text=ds.Tables["person"].Rows[dataGrid1.CurrentCell.RowNumber][4].ToString().Trim(); modifyPerson.textCode.Text=ds.Tables["person"].Rows[dataGrid1.CurrentCell.RowNumber][5].ToString().Trim(); modifyPerson.textMoney.Text=ds.Tables["person"].Rows[dataGrid1.CurrentCell.RowNumber][6].ToString().Trim(); modifyPerson.textiden.Text=ds.Tables["person"].Rows[dataGrid1.CurrentCell.RowNumber][7].ToString().Trim(); modifyPerson.textRemark.Text=ds.Tables["person"].Rows[dataGrid1.CurrentCell.RowNumber][8].ToString().Trim(); modifyPerson.Show(); } else MessageBox.Show("沒有指定信息！","提示"); } privatevoidbtDel_Click(objectsender,System.EventArgse) { if(dataGrid1.CurrentRowIndex>=0&&dataGrid1.DataSource!=null&&dataGrid1[dataGrid1.CurrentCell]!=null) { sqlConnection1.Open(); stringsql="deletefrompersonwherePID='"+ds.Tables[0].Rows[dataGrid1.CurrentCell.RowNumber][0].ToString().Trim()+"'"; SqlCommandcmd=newSqlCommand(sql,sqlConnection1); cmd.ExecuteNonQuery(); MessageBox.Show("刪除借閱者'"+ds.Tables[0].Rows[dataGrid1.CurrentCell.RowNumber][1].ToString().Trim()+"'成功","提示"); } else return; } privatevoidbtClose_Click(objectsender,System.EventArgse) { this.Close();}4.2.6借還管理設(shè)計(jì)圖4-12借書借書關(guān)鍵代碼：privatevoidtextPID_KeyDown(objectsender,KeyEventArgse){if(e.KeyData.ToString()=="Return"){sqlConnection1.Open();stringsql1="selectPNameas姓名,PSexas性別,PNas身份證,PMoneyas罰款,[identity]as身份frompersonwherePID='"+textPID.Text.Trim()+"'";stringsql3="selectBIDfrombookOutwherePID='"+textPID.Text.Trim()+"'";SqlDataAdapteradp=newSqlDataAdapter(sql1,sqlConnection1);SqlDataAdapteradp3=newSqlDataAdapter(sql3,sqlConnection1);ds=newDataSet();ds.Clear();adp.Fill(ds,"person");adp3.Fill(ds,"bookid");dataGrid2.DataSource=ds.Tables["person"].DefaultView;dataGrid4.DataSource=ds.Tables["bookid"].DefaultView;if(ds.Tables[0].Rows.Count!=0){textPName.Text=ds.Tables["person"].Rows[dataGrid2.CurrentCell.RowNumber][0].ToString().Trim();textPSex.Text=ds.Tables["person"].Rows[dataGrid2.CurrentCell.RowNumber][1].ToString().Trim();textPN.Text=ds.Tables["person"].Rows[dataGrid2.CurrentCell.RowNumber][2].ToString().Trim();textMoney.Text=ds.Tables["person"].Rows[dataGrid2.CurrentCell.RowNumber][3].ToString().Trim();textIden.Text=ds.Tables["person"].Rows[dataGrid2.CurrentCell.RowNumber][4].ToString().Trim();dataGrid2.CaptionText="共有"+ds.Tables["person"].Rows.Count+"條記錄";}elseMessageBox.Show("沒有該借書證號(hào)","提示");for(intx=0;x<ds.Tables["bookid"].Rows.Count;x++){stringsql2="selectbook.BIDas圖書編號(hào),BNameas圖書名,BWriteras作者,BPublishas出版社,BDateas出版日期,BPriceas價(jià)格,"+"typeas類型,ODateas借書日期,(selectlongTimefromidentityinfowhere[identity]=(select[identity]frompersonwherePID='"+textPID.Text.Trim()+"'))"+"as最長借書時(shí)間,dateAdd(month,(selectlongTimefromidentityinfowhere[identity]=(select[identity]frompersonwherePID='1')),ODate)as應(yīng)還日期frombook,bookOutwherebook.BID=bookOut.BIDandbook.BID='"+ds.Tables["bookid"].Rows[x][0]+"'"+"andPID='"+textPID.Text.Trim()+"'";SqlDataAdapteradp2=newSqlDataAdapter(sql2,sqlConnection1);adp2.Fill(ds,"bookout");dataGrid1.DataSource=ds.Tables["bookout"].DefaultView;dataGrid1.CaptionText="已借圖書"+ds.Tables["bookout"].Rows.Count+"本";}sqlConnection1.Close();}} privatevoidtextBID_KeyDown(objectsender,KeyEventArgse) { if(e.KeyData.ToString()=="Return") { sqlConnection1.Open(); stringsql="selectBNameas圖書名,BWriteras作者,BPublishas出版社,BDateas出版日期,BPriceas價(jià)格,"+ "typeas類型frombookwhereBID='"+textBID.Text.Trim()+"'";SqlDataAdapteradp=newSqlDataAdapter(sql,sqlConnection1); ds=newDataSet(); ds.Clear(); adp.Fill(ds,"book"); dataGrid3.DataSource=ds.Tables["book"].DefaultView; if(ds.Tables[0].Rows.Count!=0) { textBName.Text=ds.Tables[0].Rows[dataGrid3.CurrentCell.RowNumber][0].ToString().Trim(); textWriter.Text=ds.Tables[0].Rows[dataGrid3.CurrentCell.RowNumber][1].ToString().Trim(); textPublish.Text=ds.Tables[0].Rows[dataGrid3.CurrentCell.RowNumber][2].ToString().Trim(); textBDate.Text=ds.Tables[0].Rows[dataGrid3.CurrentCell.RowNumber][3].ToString().Trim(); textPrice.Text=ds.Tables[0].Rows[dataGrid3.CurrentCell.RowNumber][4].ToString().Trim(); textType.Text=ds.Tables[0].Rows[dataGrid3.CurrentCell.RowNumber][5].ToString().Trim(); dataGrid3.CaptionText="共有"+ds.Tables["book"].Rows.Count+"條記錄"; } else MessageBox.Show("沒有該圖書編號(hào)","提示"); sqlConnection1.Close(); } } privatevoidbtOut_Click(objectsender,System.EventArgse) { if(textPID.Text.Trim()==""||textBID.Text.Trim()=="") MessageBox.Show("請(qǐng)輸入完整信息","提示"); else { sqlConnection1.Open(); stringsql="select*frombookOutwhereBID='"+textBID.Text.Trim()+"'andPID='"+textPID.Text.Trim()+"'";SqlCommandcmd=newSqlCommand(sql,sqlConnection1); if(null!=cmd.ExecuteScalar()) MessageBox.Show("你已經(jīng)借了一本該書","提示"); else {sql="insertintobookOut(BID,PID,ODate)values('"+textBID.Text.Trim()+"','"+textPID.Text.Trim()+"','"+date1.Value.ToString()+"')"; cmd.CommandText=sql; cmd.ExecuteNonQuery(); MessageBox.Show("借出成功","提示"); }sqlConnection1.Close(); } }圖4-13還書還書關(guān)鍵代碼：privatevoidbtIn_Click(objectsender,System.EventArgse) { if(textBID.Text.Trim()==null) MessageBox.Show("請(qǐng)?zhí)顚憟D書編號(hào)","提示"); else { sqlConnection1.Open(); stringsql="deletefrombookOutwhereBID='"+textBID.Text.Trim()+"'andPID='"+textPID.Text.Trim()+"'";SqlCommandcmd=newSqlCommand(sql,sqlConnection1); cmd.ExecuteNonQuery(); MessageBox.Show("還書成功","提示"); } } privatevoidbtClose_Click(objectsender,System.EventArgse) { this.Close();}4.2.7查詢管理設(shè)計(jì)圖4-14圖書查詢圖書查詢關(guān)鍵代碼：privatevoidbtQuery_Click(objectsender,System.EventArgse) {stringsql1="(BNum-(selectcount(*)frombookOutwhere";//由于數(shù)據(jù)庫語句較長，所以用字符串分段實(shí)現(xiàn) stringsql="selectBIDas圖書編號(hào),BNameas圖書名,BWriteras作者,BPublishas出版社,BDateas出版日期,BPriceas價(jià)格,"+ "BNumas數(shù)量,typeas類型,BRemarkas備注,"; if(textID.Text.Trim()!="") { sql1=sql1+"BID="+"'"+textID.Text.Trim()+"'))as庫存數(shù)量"; sql=sql+sql1+"frombookwhereBID="+"'"+textID.Text.Trim()+"'"; } elseif(textName.Text.Trim()!="") { sql1=sql1+"BID=(selectBIDfrombookwhereBName='"+textName.Text+"')))as庫存數(shù)量"; sql=sql+sql1+"frombookwhereBName="+"'"+textName.Text+"'"; } elseif(textWriter.Text.Trim()!="") { sql1=sql1+"BID=(selectBIDfrombookwhereBWriter='"+textWriter.Text+"')))as庫存數(shù)量"; sql=sql+sql1+"frombookwhereBWriter="+"'"+textWriter.Text+"'"; } else { MessageBox.Show("請(qǐng)輸入查詢條件","提示"); return; } sqlConnection1.Open(); SqlDataAdapteradp=newSqlDataAdapter(sql,sqlConnection1); DataSetds=newDataSet(); ds.Clear(); adp.Fill(ds,"book"); dataGrid1.DataSource=ds.Tables[0].DefaultView; dataGrid1.CaptionText="共有"+ds.Tables[0].Rows.Count+"條查詢記"; sqlConnection1.Close(); } privatevoidbtClear_Click(objectsender,System.EventArgse) { textID.Text=""; textName.Text=""; textWriter.Text=""; } privatevoidbtClose_Click(objectsender,System.EventArgse) { this.Close(); }4.2.8用戶管理設(shè)計(jì)圖4-15修改密碼修改密碼關(guān)鍵代碼：privatevoidbtSave_Click(objectsender,System.EventArgse) { if(textName.Text.Trim()==""||textPWD.Text.Trim()==""||textPWDNew.Text.Trim()==""||textPWDNew2.Text.Trim()=="") MessageBox.Show("請(qǐng)?zhí)顚懲暾畔ⅲ?,"提示"); else { sqlConnection1.Open();SqlCommandcmd=newSqlCommand("",sqlConnection1); stringsql1="select*frompersonwherePID='"+textName.Text.Trim()+"'andPCode='"+textPWD.Text.Trim()+"'"; stringsql2="select*frommanagerwh