1、图书馆管理系统设计附带源代码毕业设计_图书管理系统 一、数据库设计数据库设CREATE DATABASE TSGL GO USE TSGL GO CREATE TABLE Bmanage( bId varchar(10) PRIMARY KEY,bName varchar(50),-添加图书-图书编号-书名bNumbervarchar(10),-书数目) GO bSore varchar(50)-分类CREATE TABLE Madmin( mName varchar(10)PRIMARY KEY,mPwd varchar(25),mAge varchar(8),mSex varchar(4)
2、,mNumber varchar(15),mrole varchar(8) GO -图书员管理-图书管理员姓名-图书管理员密码-图书管理员年龄-图书管理员性别-图书管理员-图书管理员角色CREATE TABLE Reader( rSno varchar(10) PRIMARY KEY,rName varchar(10),rPwd varchar(25),rAge varchar(8),rSex varchar(4),rState varchar(8),rNumber varchar(15),rEmail varchar(25),-读者信息表reader -读者号-姓名-密码-年龄-性别-状态-
3、电子rAdressvarChar(50),-地址) GO rGrade varChar(15),rClass varchar(15),rRole varchar(8)-年级-班级-角色CREATE TABLE Rrecord( rSno varchar(10) PRIMARY KEY,rName varChar(10),bId varchar(10),bName varChar(50),bTime varchar(10),bBackTime varchar(10) GO CREATE TABLE SysSet( rRole varchar(8)PRIMARY KEY,rState varcha
4、r(8),Fine float(25),rDay varchar(8)-读者编号学号-读者姓名-图书编号-图书名称-借书时间-还书时间-读者角色-读者可借书数-过期罚款设置-可借书天数)二、界面截图及说明1) 登录窗口(实现管理员和馆长的登陆) 2) 管理员窗口 3) 馆长窗口 4) 关于窗口 5) 新增图书窗口 6) 新增管理员、查找及修改窗口 7) 新增读者、查找及修改窗口 8) 图书的查找及修改窗口 9) 借阅窗口 10)系统设置窗口 三、主要代码主要代1) 登录窗口(实现管理员和馆长的登陆) 登陆检查: using System; using System.Collections.Ge
5、neric; using System.Linq; using System.Text; using System.Data; using prjTSGL.ClassLib.DBAccess; namespace prjTSGL.ClassLib.Logic class clsLoginCheck public static DataTable CheckLogin(string UserId, string PWD) string SQLstmt = select mName,mPwd,mRole from Madmin where mName= + UserId + and mPwd= +
6、 PWD + ; DataTable dt = clsGlobalVar.GetDataTable(SQLstmt); return dt; 登陆: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using prjTSGL.ClassLib.Logic; namespace p
7、rjTSGL.TSGL_UI public partial class frmLogin : Form public frmLogin() InitializeComponent(); private void btnLogin_Click(object sender, EventArgs e) string strUserID = loginid.Text.Trim(); string strPWD = loginpwd.Text.Trim(); string type = ; try DataTable dt = clsLoginCheck.CheckLogin(strUserID, st
8、rPWD); if (dt.Rows.Count = 0) MessageBox.Show(登陆失败,请重新输入!); loginpwd.Focus(); return; else type = dt.Rows0mRole.ToString().Trim(); if (cboLT.Text.Trim()=馆长 ) if (type = 馆长) this.Hide(); frmManager objManager = new frmManager(); objManager.Show(); else MessageBox.Show(您没有权限!); loginpwd.Focus(); retur
9、n; else if (type =管理员) this.Hide(); frmAdmin objAdmin = new frmAdmin(); objAdmin.Show(); else MessageBox.Show(您没有权限!); loginpwd.Focus(); return; catch (Exception ex) throw ex; private void btnExit_Click(object sender, EventArgs e) this.Close(); 2) 管理员窗口 using System; using System.Collections.Generic
10、; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace prjTSGL.TSGL_UI public partial class frmAdmin : Form public frmAdmin() InitializeComponent(); private void ShowForm(Form frmToShow) this.Cursor = Cursor
11、s.WaitCursor; foreach (Form frmChild in this.MdiChildren) if (frmChild.GetType() = frmToShow.GetType() frmToShow.Dispose(); frmChild.Activate(); this.Cursor = Cursors.Default; return; frmToShow.MdiParent = this; frmToShow.Show(); this.Cursor = Cursors.Default; private void 读者信息修改ToolStripMenuItem_Cl
12、ick(object sender, EventArgs e) ShowForm(new frmUpdateReader(); private void 新增图书ToolStripMenuItem_Click(object sender, EventArgs e) ShowForm(new frmAddNewBook(); private void 图书的查找和修改ToolStripMenuItem_Click(object sender, EventArgs e) ShowForm(new frmUpdateBook(); private void 流通管理ToolStripMenuItem
13、_Click(object sender, EventArgs e) ShowForm(new frmBorrow(); private void 帮助ToolStripMenuItem_Click(object sender, EventArgs e) ShowForm(new frmAbout(); private void 退出ToolStripMenuItem_Click(object sender, EventArgs e) Application.Exit(); 3) 馆长窗口 using System; using System.Collections.Generic; usin
14、g System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace prjTSGL.TSGL_UI public partial class frmManager : Form public frmManager() InitializeComponent(); private void ShowForm(Form frmToShow) this.Cursor = Cursors.
15、WaitCursor; foreach (Form frmChild in this.MdiChildren) if (frmChild.GetType() = frmToShow.GetType() frmToShow.Dispose(); frmChild.Activate(); this.Cursor = Cursors.Default; return; frmToShow.MdiParent = this; frmToShow.Show(); this.Cursor = Cursors.Default; private void frmManager_FormClosed(object
16、 sender, FormClosedEventArgs e) Application.Exit(); private void 管理员信息管理ToolStripMenuItem_Click_1(object sender, EventArgs e) ShowForm(new frmSelectAdmin(); private void 系统设置ToolStripMenuItem_Click_1(object sender, EventArgs e) ShowForm(new frmSys(); private void 关于ToolStripMenuItem_Click(object sen
17、der, EventArgs e) ShowForm(new frmAbout(); private void 退出ToolStripMenuItem_Click_1(object sender, EventArgs e) Application.Exit(); 4) 关于窗口 using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; usin
18、g System.Windows.Forms; namespace prjTSGL.TSGL_UI public partial class frmAbout : Form public frmAbout() InitializeComponent(); private void button1_Click(object sender, EventArgs e) this.Close(); 5) 新增图书窗口 using System; using System.Collections.Generic; using System.ComponentModel; using System.Dat
19、a; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using prjTSGL.ClassLib.DBAccess; namespace prjTSGL.TSGL_UI public partial class frmAddNewBook : Form public frmAddNewBook() InitializeComponent(); private bool ValidatInput() if (textBox1.Text = ) MessageBox.S
20、how(请输入图书编号!, 输入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); textBox1.Focus(); return false; if (textBox2.Text = ) MessageBox.Show(请输入图书名称!, 输入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); textBox2.Focus(); return false; if (textBox3.Text = ) MessageBox.Show(请输入图书数目!, 输入提示, Messag
21、eBoxButtons.OK, MessageBoxIcon.Information); textBox3.Focus(); return false; if (comboBox1.Text = ) MessageBox.Show(请选择图书类别!, 输入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); textBox3.Focus(); return false; return true; private void btnOK_Click_1(object sender, EventArgs e) if (ValidatInput(
22、) /string id = textBox1.Text; /string name = textBox2.Text; /string Number = textBox3.Text; /string sore = comboBox1.Text; string sql = SELECT *FROM Bmanage WHERE bId= + textBox1.Text.Trim() + ; DataTable dt = clsGlobalVar.GetDataTable(sql); if (dt.Rows.Count = 0) string SQL = insert into Bmanage(bI
23、d,bName,bNumber,bSore)values( + textBox1.Text.Trim() + , + textBox2.Text.Trim() + , + textBox3.Text.Trim() + ,+ comboBox1.Text.Trim() + ); try bool result = clsGlobalVar.ExecSQL(SQL); if (result) MessageBox.Show(添加成功!, 操作提示, MessageBoxButtons.OK, MessageBoxIcon.Information); textBox1.Text = ; textBo
24、x2.Text = ; textBox3.Text = ; comboBox1.Text = ; textBox1.Focus(); else MessageBox.Show(添加失败!, 操作提示, MessageBoxButtons.OK, MessageBoxIcon.Error); catch (Exception ex) MessageBox.Show(操作数据库出错!, 操作演示, MessageBoxButtons.OK, MessageBoxIcon.Error); Console.WriteLine(ex.Message); else MessageBox.Show(图书编号
25、已存在!, 操作提示, MessageBoxButtons.OK, MessageBoxIcon.Information); textBox1.Focus(); private void btnCancel_Click(object sender, EventArgs e) this.Close(); 6) 新增管理员、查找及修改窗口 using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.
26、Linq; using System.Text; using System.Windows.Forms; using prjTSGL.ClassLib.DBAccess; namespace prjTSGL.TSGL_UI public partial class frmSelectAdmin : Form public frmSelectAdmin() InitializeComponent(); string name = ; string SQL = ; string PWD = ; string Age = ; string Sex = ; string Tel = ; string
27、Role = ; private void SelectAdmin() string strfilter = ; string SQL = select mName AS 用户名,mPwd AS 密码,mAge AS 年龄 ,mSex AS 性别,mNumber AS ,mRole AS 角色 from Madmin ; if (txtName.Text = ) strfilter = ; else strfilter = where mName= + txtName.Text.Trim() + ; try DataTable dt = clsGlobalVar.GetDataTable(SQL + strfilter); int i
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1