圖書館管理系統(tǒng)設(shè)計(附帶源代碼)

1、畢業(yè)設(shè)計_圖書管理系統(tǒng)一、數(shù)據(jù)庫設(shè)計數(shù)據(jù)庫設(shè)CREATEDATABASETSGLGOUSETSGLGOCREATETABLEBmanage(bIdvarchar(10)PRIMARYKEY,bNamevarchar(50),bNumbervarchar(10),bSorevarchar(50)GOCREATETABLEMadmin(mNamevarchar(10)PRIMARYKEY,mPwdvarchar(25),mAgevarchar(8),mSexvarchar(4),mNumbervarchar(15),mrolevarchar(8)-添加圖書-圖書編號-書名-書數(shù)目-分類-圖書員管理

2、-圖書管理員姓名- -圖書管理員密碼- -圖書管理員年齡- -圖書管理員性別- -圖書管理員電話- -圖書管理員角色CREATETABLEReader-讀者信息表reader(rSnovarchar(10)PRIMARYKEY,二士口.-讀者號rNamevarchar(10),-姓名rPwdvarchar(25),-密碼rAgevarchar(8),-年齡rSexvarchar(4),-性別rStatevarchar(8),-狀態(tài)rNumbervarchar(15),-電話號碼rEmailvarchar(25),-電子郵件rAdressvarChar(50),-地址rGradevarChar(

3、15),-年級rClassvarchar(15),-班級rRolevarchar(8)-角色)GOCREATETABLERrecord(rSnovarchar(10)PRIMARYKEY,-讀者編號學號rNamevarChar(10),-讀者姓名bIdvarchar(10),-圖書編號bNamevarChar(50),-圖書名稱bTimevarchar(10),-借書時間bBackTimevarchar(10)-還書時間)GO- 讀者角色- 讀者可借書數(shù)- 過期罰款設(shè)置- 可借書天數(shù))CREATETABLESysSet(rRolevarchar(8)PRIMARYKEY,rStatevarch

4、ar(8),Finefloat(25),rDayvarchar(8)二、界面截圖及說明1) 登錄窗口(實現(xiàn)管理員和館長的登陸)可編輯2）管理員窗口3）館長窗口S1rHeinuStripl上恒長智運管理員信急笆理系統(tǒng)設(shè)置關(guān)于退出4）關(guān)于窗口軟汴看春：陽書善理京段!版本：VUO亦布：Jason日期二2011/08/130K新增圖書窗口6）新增管理員、查找及修改窗口用戶名百攫由戔年跛角色天由電話7）新增讀者、查找及修改窗口讀苕姓名用尸者5TK件劑借書狀態(tài)潴加地地電話卓。席期用色售班翻除工國8）圖書的查找及修改窗口羯彳塌與類弱因書名稱觸目9）借閱窗口10）系統(tǒng)設(shè)置窗口角色設(shè)置查詢修改如消三、主要代碼主

5、要代1)登錄窗口(實現(xiàn)管理員和館長的登陸)登陸檢查：usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Data;usingprjTSGL.ClassLib.DBAccess;namespaceprjTSGL.ClassLib.LogicclassclsLoginCheckpublicstaticDataTableCheckLogin(stringUserId,stringPWD)stringSQLstmt="selectmName,mPwd,mRolefr

6、omMadminwheremName='"+UserId+"'andmPwd='"+PWD+"”'DataTabledt=clsGlobalVar.GetDataTable(SQLstmt);returndt;登陸：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Wi

7、ndows.Forms;usingprjTSGL.ClassLib.Logic;namespaceprjTSGL.TSGL_UIpublicpartialclassfrmLogin:FormpublicfrmLogin()InitializeComponent();privatevoidbtnLogin_Click(objectsender,EventArgse)stringstrUserID=loginid.Text.Trim();stringstrPWD=loginpwd.Text.Trim();stringtype=""tryDataTabledt=clsLoginC

8、heck.CheckLogin(strUserID,strPWD);if(dt.Rows.Count=0)MessageBox.Show("登陸失敗，請重新輸入!");loginpwd.Focus();return;elsetype=dt.Rows0"mRole".ToString().Trim();if(cboLT.Text.Trim()="館長")if(type="館長")this.Hide();frmManagerobjManager=newfrmManager();objManager.Show();els

9、eMessageBox.Show("您沒有權(quán)限！");loginpwd.Focus();return;elseif(type="管理員")this.Hide();frmAdminobjAdmin=newfrmAdmin();objAdmin.Show();elseMessageBox.Show("您沒有權(quán)限！");loginpwd.Focus();return;catch(Exceptionex)throwex;privatevoidbtnExit_Click(objectsender,EventArgse)this.Close();

10、2) 管理員窗口usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceprjTSGL.TSGL_UIpublicpartialclassfrmAdmin:FormpublicfrmAdmin()InitializeComponent();privatevoidShowForm(FormfrmToSh

11、ow)this.Cursor=Cursors.WaitCursor;foreach(FormfrmChildinthis.MdiChildren)if(frmChild.GetType()=frmToShow.GetType()frmToShow.Dispose();frmChild.Activate();this.Cursor=Cursors.Default;return;frmToShow.MdiParent=this;frmToShow.Show();this.Cursor=Cursors.Default;privatevoid讀者信息修改ToolStripMenuItem_Click(

12、objectsender,EventArgse)ShowForm(newfrmUpdateReader();privatevoid新增圖書ToolStripMenuItem_Click(objectsender,EventArgse)ShowForm(newfrmAddNewBook();privatevoid圖書的查找和修改ToolStripMenuItem_Click(objectsender,EventArgse)ShowForm(newfrmUpdateBook();privatevoid流通管理ToolStripMenuItem_Click(objectsender,EventArg

13、se)ShowForm(newfrmBorrow();privatevoid幫助ToolStripMenuItem_Click(objectsender,EventArgse)ShowForm(newfrmAbout();privatevoid退出ToolStripMenuItem_Click(objectsender,EventArgse)Application.Exit();3) 館長窗口usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Dr

14、awing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceprjTSGL.TSGL_UIpublicpartialclassfrmManager:FormpublicfrmManager()InitializeComponent();privatevoidShowForm(FormfrmToShow)this.Cursor=Cursors.WaitCursor;foreach(FormfrmChildinthis.MdiChildren)if(frmChild.GetType()=frmToShow.G

15、etType()frmToShow.Dispose();frmChild.Activate();this.Cursor=Cursors.Default;return;frmToShow.MdiParent=this;frmToShow.Show();this.Cursor=Cursors.Default;privatevoidfrmManager_FormClosed(objectsender,FormClosedEventArgse)Application.Exit();privatevoid管理員信息管理ToolStripMenuItem_Click_1(objectsender,Even

16、tArgse)ShowForm(newfrmSelectAdmin();privatevoid系統(tǒng)設(shè)置ToolStripMenuItem_Click_1(objectsender,EventArgse)ShowForm(newfrmSys();privatevoid關(guān)于ToolStripMenuItem_Click(objectsender,EventArgse)ShowForm(newfrmAbout();object sender, EventArgs e)privatevoid退出ToolStripMenuItem_Click_1(Application.Exit();4) 關(guān)于窗口us

17、ingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceprjTSGL.TSGL_UIpublicpartialclassfrmAbout:FormpublicfrmAbout()InitializeComponent();privatevoidbutton1_Click(objectsender,Eve

18、ntArgse)this.Close();5)新增圖書窗口usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingprjTSGL.ClassLib.DBAccess;namespaceprjTSGL.TSGL_UIpublicpartialclassfrmAddNewBook:FormpublicfrmAdd

19、NewBook()InitializeComponent();privateboolValidatInput()if(textBox1.Text="").OK,MessageBox.Show("請輸入圖書編號！","輸入提示",MessageBoxButtonsMessageBoxIcon.Information);textBox1.Focus();returnfalse;if(textBox2.Text="")MessageBox.Show("請輸入圖書名稱！","輸入提示"

20、;,MessageBoxButtons.OK,MessageBoxIcon.Information);textBox2.Focus();returnfalse;if(textBox3.Text="")MessageBox.Show("請輸入圖書數(shù)目！","輸入提示",MessageBoxButtons.OK,MessageBoxIcon.Information);textBox3.Focus();returnfalse;if(comboBox1.Text="")MessageBox.Show("請選擇圖書

21、類別！","輸入提示",MessageBoxButtons.OK,MessageBoxIcon.Information);textBox3.Focus();returnfalse;returntrue;privatevoidbtnOK_Click_1(objectsender,EventArgse)if(ValidatInput()/stringid=textBox1.Text;/stringname=textBox2.Text;/stringNumber=textBox3.Text;/stringsore=comboBox1.Text;stringsql=&qu

22、ot;SELECT*FROMBmanageWHEREbId='"+textBox1.Text.Trim()+"'"DataTabledt=clsGlobalVar.GetDataTable(sql);if(dt.Rows.Count=0)stringSQL="insertintoBmanage(bId,bName,bNumber,bSore)values('"+textBox1.Text.Trim()+"','"+textBox2.Text.Trim()+"',

23、9;"+textBox3.Text.Trim()+"','"+comboBox1.Text.Trim()+"')"tryboolresult=clsGlobalVar.ExecSQL(SQL);if(result)MessageBox.Show("添加成功！","操作提示",MessageBoxButtons.OK,MessageBoxIcon.Information);textBox1.Text=""textBox2.Text=""text

24、Box3.Text=""comboBox1.Text=textBox1.Focus();elseMessageBox.Show("添加失??！","操作提示",MessageBoxButtons.OK,MessageBoxIcon.Error);catch(Exceptionex)MessageBox.Show("操作數(shù)據(jù)庫出錯！","操作演示",MessageBoxButtons.OK,MessageBoxIcon.Error);Console.WriteLine(ex.Message);els

25、eMessageBox.Show("圖書編號已存在！","操作提示",MessageBoxButtons.OK,MessageBoxIcon.Information);textBox1.Focus();privatevoidbtnCancel_Click(objectsender,EventArgse)this.Close();6) 新增管理員、查找及修改窗口usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem

26、.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingprjTSGL.ClassLib.DBAccess;namespaceprjTSGL.TSGL_UIpublicpartialclassfrmSelectAdmin:FormpublicfrmSelectAdmin()InitializeComponent();stringname=""stringSQL=""stringPWD=""stringAge=""string

27、Sex=""stringTel=""stringRole=""private void SelectAdmin()string strfilter ="" ;string SQL = "select mName ASAS 電話 ,mRole AS 角色 from Madmin "if (txtName.Text ="" )strfilter ="" ;elsestrfilter = "where mName='"用戶名 ,mPw

28、d AS 密碼 ,mAge AS 年齡 ,mSex AS+ txtName.Text.Trim() +"'" ;性別 ,mNumbertry DataTable dt = clsGlobalVar .GetDataTable(SQL + strfilter);int intIndex = 0;if (dt.Rows.Count = 0) MessageBox .Show( "抱歉，沒有您要找的用戶！ ", "結(jié)果提示 ", MessageBoxButtons .OK, MessageBoxIcon .Information);

29、txtName.Text =txtPWD.Text =txtAge.Text =cboSex.Text =txtTel.Text =cboRole.Text =elseLV.Columns.Clear();LV.Items.Clear();LV.Columns.Add("序號",100,HorizontalAlignment.Center);for(intintJ=0;intJ<dt.Columns.Count;intJ+)LV.Columns.Add(dt.ColumnsintJ.ColumnName,200,HorizontalAlignment.Center);

30、for(intintI=0;intI<dt.Rows.Count;intI+)intIndex=intI+1;LV.Items.Add(intIndex.ToString();LV.ItemsintI.SubItems.Add(dt.RowsintI"用戶名".ToString().Trim();LV.ItemsintI.SubItems.Add(dt.RowsintI"密碼".ToString().Trim();LV.ItemsintI.SubItems.Add(dt.RowsintI"年齡".ToString().Trim(

31、);LV.ItemsintI.SubItems.Add(dt.RowsintI"性別".ToString().Trim();LV.ItemsintI.SubItems.Add(dt.RowsintI"電話".ToString().Trim();LV.ItemsintI.SubItems.Add(dt.RowsintI"角色".ToString().Trim();/連接數(shù)據(jù)庫，將數(shù)據(jù)讀取出放入MadminDatacatch(Exceptionex)MessageBox.Show("查詢數(shù)據(jù)庫出錯！","提示

32、",MessageBoxButtons.OK,MessageBoxIcon.Error);Console.WriteLine(ex.Message);privatevoidbtnSearch_Click(objectsender,EventArgse)SelectAdmin();/調(diào)用函數(shù)/實現(xiàn)修改功能privatevoidbtnUpdata_Click(objectsender,EventArgse)if(txtName.Text=""|cboRole.Text="")MessageBox.Show("請選擇要修改的用戶!"

33、;);elseSQL = "UPDATE Madmin SET txtPWD.Text.Trim() +"',mAge='"+ txtAge.Text.Trim() +"',mNumber='" + txtTel.Text.Trim() +"',mRole='"mName='" + txtName.Text.Trim() +"',mPwd='"+"',mSex='" + cboSex.Te

34、xt.Trim() + cboRole.Text.Trim() +"' where mName='" + name+"'ANDmPwd='"+PWD+"'ANDmAge='"+Age+"'ANDmSex='"+Sex+"'ANDmNumber='"+Tel+"'ANDmRole='"+Role+"'"tryboolresult=clsGlobalVar.

35、ExecSQL(SQL);if(result)/txtName.Text=""txtPWD.Text=txtAge.Text=cboSex.Text=txtTel.Text=cboRole.Text=""MessageBox.Show("修改已成功");SelectAdmin();elseMessageBox.Show("更新失敗！","操作提示",MessageBoxButtons.OK,MessageBoxIcon.Error);.OK,catch(Exceptionex)MessageBo

36、x.Show("操作數(shù)據(jù)庫出錯！","操作演示",MessageBoxButtonsMessageBoxIcon.Error);Console.WriteLine(ex.Message);privatevoidbtnExit_Click(objectsender,EventArgse)this.Close();privatevoidLV_SelectedIndexChanged_1(objectsender,EventArgse)txtName.Text=LV.FocusedItem.SubItems1.Text.Trim();txtPWD.Text=L

37、V.FocusedItem.SubItems2.Text.Trim();txtAge.Text=LV.FocusedItem.SubItems3.Text.Trim();cboSex.Text=LV.FocusedItem.SubItems4.Text.Trim();txtTel.Text=LV.FocusedItem.SubItems5.Text.Trim();cboRole.Text=LV.FocusedItem.SubItems6.Text.Trim();name=LV.FocusedItem.SubItems1.Text.Trim();PWD=LV.FocusedItem.SubIte

38、ms2.Text.Trim();Age=LV.FocusedItem.SubItems3.Text.Trim();Sex=LV.FocusedItem.SubItems4.Text.Trim();Tel=LV.FocusedItem.SubItems5.Text.Trim();Role=LV.FocusedItem.SubItems6.Text.Trim();privatevoidfrmSelectAdmin_Load(objectsender,EventArgse)this.btnSearch_Click(sender,e);privatevoidbtnAdd_Click(objectsen

39、der,EventArgse)if(txtName.Text=""|txtPWD.Text=""|txtAge.Text=""|cboSex.Text=""|txtTel.Text=""|cboRole.Text="")MessageBox.Show（"請至少輸入用戶名，密碼和角色!"）;elseSQL="SELECTmName,mPwd,mAge,mSex,mNumber,mRolefromMadminWHEREmName='"

40、;txtName.Text.Trim()+"'"DataTabledt=clsGlobalVar.GetDataTable(SQL);if(dt.Rows.Count = 0)txtPWD.Text.Trim() +txtTel.Text.Trim() +/txtName.Text =nn.SQL="INSERTINTOMadminVALUES('"+txtName.Text.Trim()+"','"+"','"+txtAge.Text.Trim()+"&#

41、39;,'"+cboSex.Text.Trim()+"','"+"','"+cboRole.Text.Trim()+"')"if(clsGlobalVar.ExecSQL(SQL)=true)txtPWD.Text=txtAge.Text=cboSex.Text=txtTel.Text=cboRole.Text=""MessageBox.Show("成功添加新管理員!");SelectAdmin();elseExceptionex=new

42、Exception();MessageBox.Show(ex.Message.ToString();elseMessageBox.Show("用戶名已存在，請選擇其他用戶名！","結(jié)果提示",MessageBoxButtons.OK,MessageBoxIcon.Information);txtName.Text=""privatevoidbtnDelete_Click(objectsender,EventArgse)if (txtName.Text = "" | cboRole.Text =""

43、;MessageBox.Show("請選擇要刪除的管理員用戶!");elseDialogResultdr=MessageBox.Show("此操作不可撤銷，確定要刪除此用戶信息嗎？"提示",MessageBoxButtons.YesNo,MessageBoxIcon.Question);if(dr=DialogResult.Yes)SQL="DELETEFROMMadminWHEREmName='"+name+"'ANDmPwd='"+PWD+"'ANDmAge=

44、'"+Age+"'ANDmSex='"+Sex+"'ANDmNumber='"+Tel+"'ANDmRole='"+Role+if(clsGlobalVar.ExecSQL(SQL)=true)MessageBox.Show("成功刪除此管理信息!");SelectAdmin();elseExceptionex=newException();MessageBox.Show(ex.Message.ToString();privatevoidbtnRes

45、et_Click(objectsender,EventArgse)txtName.Text=txtPWD.Text=txtAge.Text=cboSex.Text=txtTel.Text=cboRole.Text=7) 新增讀者、查找及修改窗口usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingprjTS

46、GL.ClassLib.DBAccess;namespaceprjTSGL.TSGL_UIpublicpartialclassfrmUpdateReader:FormpublicfrmUpdateReader()InitializeComponent();stringSno=""stringPwd=""stringAge=""stringname=""stringSex=""stringState=""stringAdress=""stringNumber

47、=""stringEmail=""stringGrade=""stringClass=""stringRole=""/查找學生讀者privatevoidSelectStudent()stringstrfilter=密碼 ,rAge AS 年郵箱 ,rGrade AS 年stringSQL="selectrSnoAS讀者編號,rNameAS讀者姓名,rPwdAS齡,rSexAS性別,rStateAS借書狀態(tài),rAdressAS地址,rNumberAS電話,rEmailAS級,rClass

48、AS班級,rRoleAS角色fromReader""" )if(txtReaderName.Text=strfilter=""elsestrfilter="whererName='"+txtReaderName.Text.Trim()+tryDataTabledt=clsGlobalVar.GetDataTable(SQL+strfilter);intintIndex=0;if(dt.Rows.Count=0)MessageBox.Show("抱歉，沒有您要找的讀者信息！","結(jié)果提示&

49、quot;,MessageBoxButtons.OK,MessageBoxIcon.Information);elseLV.Columns.Clear();LV.Items.Clear();LV.Columns.Add("序號",100,HorizontalAlignment.Center);for(intintJ=0;intJ<dt.Columns.Count;intJ+)LV.Columns.Add(dt.ColumnsintJ.ColumnName,200,HorizontalAlignment.Center);for(intintI=0;intI<dt.

50、Rows.Count;intI+)intIndex=intI+1;LV.Items.Add(intIndex.ToString();for(intj=1;j<dt.Columns.Count;j+)LV.ItemsintI.SubItems.Add(dt.RowsintIj.ToString();讀者編號 ".ToString();讀者姓名 ".ToString();密碼 ".ToString();年齡 ".ToString();性別 ".ToString();借書狀態(tài) ".ToString();地址 ".ToStri

51、ng();電話 ".ToString();郵箱 ".ToString();年級 ".ToString();班級 ".ToString();角色 ".ToString();/LV.ItemsintI.SubItems.Add(dt.RowsintI"/LV.ItemsintI.SubItems.Add(dt.RowsintI"/LV.ItemsintI.SubItems.Add(dt.RowsintI"/LV.ItemsintI.SubItems.Add(dt.RowsintI"/LV.ItemsintI.

52、SubItems.Add(dt.RowsintI"/LV.ItemsintI.SubItems.Add(dt.RowsintI"/LV.ItemsintI.SubItems.Add(dt.RowsintI"/LV.ItemsintI.SubItems.Add(dt.RowsintI"/LV.ItemsintI.SubItems.Add(dt.RowsintI"/LV.ItemsintI.SubItems.Add(dt.RowsintI"/LV.ItemsintI.SubItems.Add(dt.RowsintI"/LV.It

53、emsintI.SubItems.Add(dt.RowsintI"catch(Exceptionex)MessageBox.Show("查詢數(shù)據(jù)庫出錯！","提示",MessageBoxButtons.OK,MessageBoxIcon.Error);Console.WriteLine(ex.Message);/實現(xiàn)查找功能privatevoidbtnSearch_Click(objectsender,EventArgse)SelectStudent();/實現(xiàn)修改功能privatevoidbtnUpdata_Click(objectsende

54、r,EventArgse)if(textBox2.Text="")MessageBox.Show("請選擇要修改的用戶!");else/stringsql="SELECT*fromReaderWHERErSno='"+textBox2.Text.Trim()+"'"/DataTabledt=clsGlobalVar.GetDataTable(sql);/if(dt.Rows.Count=0)/stringSQL="UPDATEReaderSETrSno='"+textBo

55、x2.Text.Trim()+"',rPwd='"+textBox3.Text.Trim()+"',rAge='"+textBox1.Text.Trim()+"',rName='"+txtReaderName.Text.Trim()+"',rSex='"+cboSex.Text.Trim()+"',rState='"+textBox4.Text.Trim()+"',rAdress='&quo

56、t;+textBox5.Text.Trim()+"',rNumber='"+textBox6.Text.Trim()+"',rEmail='"+textBox7.Text.Trim()+"',rGrade='"+textBox8.Text.Trim()+"',rClass='"+textBox9.Text.Trim()+"',rRole='"+cboRole.Text.Trim()+"'"

57、stringstrfilter="whererSno='"+Sno+"'"tryboolresult=clsGlobalVar.ExecSQL(SQL+strfilter);if(result)textBox2.Text=textBox3.Text=""textBox1.Text=""cboSex.Text=textBox4.Text=textBox5.Text=textBox6.Text=textBox7.Text=textBox8.Text=textBox9.Text=cboRole.Text=

58、MessageBox.Show("修改已成功");SelectStudent();.OK,elseMessageBox.Show("讀者信息不存在！","操作提示",MessageBoxButtonsMessageBoxIcon.Error);catch(Exceptionex)MessageBox.Show("操作數(shù)據(jù)庫出錯！","操作演示",MessageBoxButtons.OK,MessageBoxIcon.Error);Console.WriteLine(ex.Message);/el

59、se/MessageBox.Show("用戶名已存在，請選擇其他用戶名！","結(jié)果提示",MessageBoxButtons.OK,MessageBoxIcon.Information);/textBox2.Text=""/privatevoidbtnExit_Click(objectsender,EventArgse)this.Close();privatevoidLV_SelectedIndexChanged(objectsender,EventArgse)textBox2.Text=LV.FocusedItem.SubItems1.Text.Trim();txtReaderName.Text=LV.FocusedItem.SubItems2.Text.Trim();textBox3.Text=LV.FocusedItem.SubItems3.Text.Trim();textBox1.Text=LV.FocusedItem.SubItems4.Text.Trim();cboSex.Text=LV.FocusedItem.SubItems5.Text.