图书馆管理系统设计附带源代码

..-..word.zl-毕业设计_图 书 关于书的成语关于读书的排比句社区图书漂流公约怎么写关于读书的小报汉书pdf 管理系统一、数据库设计数据库设CREATEDATABASETSGLGOUSETSGLGO..-..word.zl-CREATETABLEBmanage(bIdvarchar(10)PRIMARYKEY,bNamevarchar(50),--添加图书--图书编号--书名..-..word.zl-bNumbervarchar(10),--书数目..-..word.zl-)GObSorevarchar(50)--分类..-..word.zl-CREATETABLEMadmin(mNamevarchar(10)PRIMARYKEY,mPwdvarchar(25),mAgevarchar(8),mSexvarchar(4),mNumbervarchar(15),mrolevarchar(8))GO--图书员管理--图书管理员XX--图书管理员密码--图书管理员年龄--图书管理员性别--图书管理员--图书管理员角色..-..word.zl-..-..word.zl-CREATETABLEReader(rSnovarchar(10)PRIMARYKEY,rNamevarchar(10),rPwdvarchar(25),rAgevarchar(8),rSexvarchar(4),rStatevarchar(8),rNumbervarchar(15),rEmailvarchar(25),--读者信息表reader--读者号--XX--密码--年龄--性别--状态----电子..-..word.zl-rAdressvarChar(50),--地址..-..word.zl-)GOrGradevarChar(15),rClassvarchar(15),rRolevarchar(8)--年级--班级--角色..-..word.zl-CREATETABLERrecord(rSnovarchar(10)PRIMARYKEY,rNamevarChar(10),bIdvarchar(10),bNamevarChar(50),bTimevarchar(10),bBackTimevarchar(10))GOCREATETABLESysSet(rRolevarchar(8)PRIMARYKEY,rStatevarchar(8),Finefloat(25),rDayvarchar(8)--读者编号学号--读者XX--图书编号--图书名称--借书时间--还书时间--读者角色--读者可借书数--过期罚款设置--可借书天数)..-..word.zl-二、界面截图及说明1)登录窗口〔实现管理员和馆长的登陆〕..-..word.zl-..-..word.zl-2)管理员窗口3)馆长窗口..-..word.zl-4)关于窗口5)新增图书窗口6)新增管理员、查找及修改窗口..-..word.zl-7)新增读者、查找及修改窗口8)图书的查找及修改窗口..-..word.zl-9)借阅窗口10)系统设置窗口..-..word.zl-三、主要代码主要代1)登录窗口〔实现管理员和馆长的登陆〕登陆检查：usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Data;usingprjTSGL.ClassLib.DBAccess;namespaceprjTSGL.ClassLib.Logic{classclsLoginCheck{publicstaticDataTableCheckLogin(stringUserId,stringPWD){{stringSQLstmt="selectmName,mPwd,mRolefromMadminwheremName='"+UserId+"'andmPwd='"+PWD+"'";DataTabledt=clsGlobalVar.GetDataTable(SQLstmt);returndt;}..-..word.zl-}}}登陆：usingSystem;usingSystem.Collections.Generic;usingSystem.ponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingprjTSGL.ClassLib.Logic;namespaceprjTSGL.TSGL_UI{publicpartialclassfrmLogin:Form{publicfrmLogin(){Initializeponent();}privatevoidbtnLogin_Click(objectsender,EventArgse){stringstrUserID=loginid.Text.Trim();stringstrPWD=loginpwd.Text.Trim();stringtype="";try{DataTabledt=clsLoginCheck.CheckLogin(strUserID,strPWD);if(dt.Rows.Count==0){MessageBox.Show("登陆失败，请重新输入!");loginpwd.Focus();return;}else{..-..word.zl-type=dt.Rows[0]["mRole"].ToString().Trim();if(cboLT.Text.Trim()=="馆长"){if(type=="馆长"){this.Hide();frmManagerobjManager=newfrmManager();objManager.Show();}else{MessageBox.Show("您没有权限！");loginpwd.Focus();return;}}else{if(type=="管理员"){this.Hide();frmAdminobjAdmin=newfrmAdmin();objAdmin.Show();}else{MessageBox.Show("您没有权限！");loginpwd.Focus();return;}}}}catch(Exceptionex){throwex;}..-..word.zl-}privatevoidbtnExit_Click(objectsender,EventArgse){this.Close();}}}2)管理员窗口usingSystem;usingSystem.Collections.Generic;usingSystem.ponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceprjTSGL.TSGL_UI{publicpartialclassfrmAdmin:Form{publicfrmAdmin(){Initializeponent();}privatevoidShowForm(FormfrmToShow){this.Cursor=Cursors.WaitCursor;foreach(FormfrmChildinthis.MdiChildren){if(frmChild.GetType()==frmToShow.GetType()){frmToShow.Dispose();frmChild.Activate();this.Cursor=Cursors.Default;return;}}frmToShow.MdiParent=this;..-..word.zl-frmToShow.Show();this.Cursor=Cursors.Default;}privatevoid读者信息修改ToolStripMenuItem_Click(objectsender,EventArgse){ShowForm(newfrmUpdateReader());}privatevoid新增图书ToolStripMenuItem_Click(objectsender,EventArgse){ShowForm(newfrmAddNewBook());}privatevoid图书的查找和修改ToolStripMenuItem_Click(objectsender,EventArgse){ShowForm(newfrmUpdateBook());}privatevoid流通管理ToolStripMenuItem_Click(objectsender,EventArgse){ShowForm(newfrmBorrow());}privatevoid帮助ToolStripMenuItem_Click(objectsender,EventArgse){ShowForm(newfrmAbout());}privatevoid退出ToolStripMenuItem_Click(objectsender,EventArgse){Application.Exit();}}}3)馆长窗口usingSystem;usingSystem.Collections.Generic;..-..word.zl-usingSystem.ponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceprjTSGL.TSGL_UI{publicpartialclassfrmManager:Form{publicfrmManager(){Initializeponent();}privatevoidShowForm(FormfrmToShow){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;}privatevoidfrmManager_FormClosed(objectsender,FormClosedEventArgse){Application.Exit();}privatevoid管理员信息管理ToolStripMenuItem_Click_1(objectsender,EventArgse){ShowForm(newfrmSelectAdmin());}..-..word.zl-privatevoid系统设置ToolStripMenuItem_Click_1(objectsender,EventArgse){ShowForm(newfrmSys());}privatevoid关于ToolStripMenuItem_Click(objectsender,EventArgse){ShowForm(newfrmAbout());}privatevoid退出ToolStripMenuItem_Click_1(objectsender,EventArgse){Application.Exit();}}}4)关于窗口usingSystem;usingSystem.Collections.Generic;usingSystem.ponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceprjTSGL.TSGL_UI{publicpartialclassfrmAbout:Form{publicfrmAbout(){Initializeponent();}privatevoidbutton1_Click(objectsender,EventArgse){this.Close();}}..-..word.zl-}5)新增图书窗口usingSystem;usingSystem.Collections.Generic;usingSystem.ponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingprjTSGL.ClassLib.DBAccess;namespaceprjTSGL.TSGL_UI{publicpartialclassfrmAddNewBook:Form{publicfrmAddNewBook(){Initializeponent();}privateboolValidatInput(){if(textBox1.Text==""){MessageBox.Show("请输入图书编号！","输入提示",MessageBoxButtons.OK,MessageBoxIcon.Information);textBox1.Focus();returnfalse;}if(textBox2.Text==""){MessageBox.Show("请输入图书名称！","输入提示",MessageBoxButtons.OK,MessageBoxIcon.Information);textBox2.Focus();returnfalse;}if(textBox3.Text==""){MessageBox.Show("请输入图书数目！","输入提示",MessageBoxButtons.OK,..-..word.zl-MessageBoxIcon.Information);textBox3.Focus();returnfalse;}if(boBox1.Text==""){MessageBox.Show("请选择图书类别！","输入提示",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=boBox1.Text;stringsql="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()+"','"+textBox3.Text.Trim()+"','"+boBox1.Text.Trim()+"')";try{boolresult=clsGlobalVar.ExecSQL(SQL);if(result){MessageBox.Show("添加成功！","操作提示",MessageBoxButtons.OK,MessageBoxIcon.Information);textBox1.Text="";textBox2.Text="";textBox3.Text="";boBox1.Text="";textBox1.Focus();..-..word.zl-}else{MessageBox.Show("添加失败！","操作提示",MessageBoxButtons.OK,MessageBoxIcon.Error);}}catch(Exceptionex){MessageBox.Show("操作数据库出错！","操作演示",MessageBoxButtons.OK,MessageBoxIcon.Error);Console.WriteLine(ex.Message);}}else{MessageBox.Show("图书编号已存在！","操作提示",MessageBoxButtons.OK,MessageBoxIcon.Information);textBox1.Focus();}}}privatevoidbtnCancel_Click(objectsender,EventArgse){this.Close();}}}6)新增管理员、查找及修改窗口usingSystem;usingSystem.Collections.Generic;usingSystem.ponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingprjTSGL.ClassLib.DBAccess;..-..word.zl-namespaceprjTSGL.TSGL_UI{publicpartialclassfrmSelectAdmin:Form{publicfrmSelectAdmin(){Initializeponent();}stringname="";stringSQL="";stringPWD="";stringAge="";stringSex="";stringTel="";stringRole="";privatevoidSelectAdmin(){stringstrfilter="";stringSQL="selectmNameAS用户名,mPwdAS密码,mAgeAS年龄,mSexAS性别,mNumberAS,mRoleAS角色fromMadmin";if(txtName.Text=="")strfilter="";elsestrfilter="wheremName='"+txtName.Text.Trim()+"'";try{DataTabledt=clsGlobalVar.GetDataTable(SQL+strfilter);intintIndex=0;if(dt.Rows.Count==0){MessageBox.Show("抱歉，没有您要找的用户！","结果提示",MessageBoxButtons.OK,MessageBoxIcon.Information);txtName.Text="";txtPWD.Text="";txtAge.Text="";cboSex.Text="";txtTel.Text="";cboRole.Text="";}else..-..word.zl-{{LV.Columns.Clear();LV.Items.Clear();LV.Columns.Add("序号",100,HorizontalAlignment.Center);for(intintJ=0;intJ