精选文档图书管理系统系统设计(含代码)

《高级程序设计语言》图书管理系统设计报告 学院：国土资源工程学院专业：测绘工程成员：********************************指导教师：黄云铠日期：2014年11月5日

1系统设计设计目标本系统是针对图书管理工作过程进行设计的，主要实现如下目标：注册用户可以登录此系统；非注册用户注册后可以使用本系统；读者可以查询、借阅、归还图书等；管理员可以对读者、图书进行管理。1.2数据库设计概述1.2.1概念结构设计将从需求分析中得到的数据信息抽象为概念模型,经分析可得到数据库的E-R模型。如图所示。图书名称作者编号出版日期价格种类出版社图1-1图书实体ER图密码密码读者姓名编号专业借阅时间借书量年龄性别图1-2实体读者ER图用户用户密码类型编号图1-3用户实体ER图1.2项目规划图书管理系统是一个典型的数据库应用程序，由应用程序和后台数据库两部分构成。（1）应用程序应用程序主要包括登录，注册，用户信息，读者信息，图书信息管理，借阅图书，综合查询，出版社信息等几个部分组成。（2）数据库数据库负责对图书信息，用户信息等数据的管理。2数据库设计说明书2．1数据库表结构2.1.1图书表book2.1.2借阅信息表borrow2.1.2用户信息表Reader2.1.4用户信息权限表right2.1.5用户账号表user2.1.6管理员账号表usererheper2.2数据关系图2.3图书管理系统暂有数据（模拟运行）2.3.1管理员学工号：2014701020姓名：邢吉昌密码：1112.3.2普通用户学工号：2014701021姓名：猪八戒密码：333学工号：2014701022姓名：孙悟空密码：4442.3.3图书信息编号作者书名出版社出版日期价格书类H319584781MARKC#入门经典清华大学出版社2011/4/521.56计算机H319584782哪吒和猴子的那些事天庭文印2010/1/2216.5情感H319584783二郎神我也可以闹天宫天庭文印2009/8/129.32技术3程序功能的实现3.1登陆界面已注册用户登录时，用户类别选择普通用户或管理员，不选择会出现提示主要代码如下：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWindowsFormsApplication1{publicpartialclassLoginForm:Form{publicstringpassword;privateintErrorTimes;stringUser,Pwd;boolflagshow=false;privateboolyanzhengshuru(){password=textBox3.Text;if(Typename.Text.Trim()==""){MessageBox.Show("请选择登录类型","登录提示",MessageBoxButtons.OK,MessageBoxIcon.Information);Typename.Focus();returnfalse;}elseif(loginid.Text.Trim()==""){MessageBox.Show("请输入用户名","登录提示",MessageBoxButtons.OK,MessageBoxIcon.Information);loginid.Focus();returnfalse;}elseif(password==""){MessageBox.Show("请输入密码","登录提示",MessageBoxButtons.OK,MessageBoxIcon.Information);textBox3.Focus();returnfalse;}else{returntrue;}}publicLoginForm(){InitializeComponent();}privatevoidcancelbtn_Click(objectsender,EventArgse){Application.Exit();}privatevoidLoginForm_Load(objectsender,EventArgse){}privatevoidLoginForm_Closing(objectsender,FormClosingEventArgse){Application.Exit();}privatevoidloginbtn_Click(objectsender,EventArgse){if(yanzhengshuru()){if(Typename.Text.Trim()=="管理员"){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");conConnection.Open();stringcmd="selectAdminID,AdminPassfromuserhelper";SqlCommandcom=newSqlCommand(cmd,conConnection);SqlDataReaderreader=com.ExecuteReader();while(reader.Read()){User=reader["AdminID"].ToString();Pwd=reader["AdminPass"].ToString();if(User.Trim()==loginid.Text&Pwd.Trim()==textBox3.Text){flagshow=true;}}reader.Close();conConnection.Close();if(flagshow==true){this.Hide();adminf1=newadmin();f1.ShowDialog();}}else{if(Typename.Text.Trim()=="普通用户"){SqlConnectionconConnection1=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");conConnection1.Open();stringcnd="selectReaderID,ReaderPasswordfromreader";SqlCommandcnm=newSqlCommand(cnd,conConnection1);SqlDataReaderreader1=cnm.ExecuteReader();while(reader1.Read()){User=reader1["ReaderID"].ToString();Pwd=reader1["ReaderPassword"].ToString();if(User.Trim()==loginid.Text&Pwd.Trim()==textBox3.Text){flagshow=true;}}reader1.Close();conConnection1.Close();if(flagshow==true){this.Hide();读者查阅f1=new读者查阅();f1.ShowDialog();}else{MessageBox.Show("用户名不存在或密码错误！","提示");ErrorTimes++;if(ErrorTimes>=3){MessageBox.Show("登录次数过多，程序将关闭");//Application.Exit();return;}}}}}}privatevoidlabel1_Click(objectsender,EventArgse){}privatevoidlabel2_Click(objectsender,EventArgse){}privatevoidlabel3_Click(objectsender,EventArgse){}privatevoidbutton1_Click(objectsender,EventArgse){this.Hide();注册f1=new注册();f1.ShowDialog();}privatevoidusercomboBox_SelectedIndexChanged(objectsender,EventArgse){}privatevoiduseracctxt_TextChanged(objectsender,EventArgse){}privatevoidtextBox3_TextChanged(objectsender,EventArgse){}}}3.2登陆界面如果学号已经存在，则会出现“*用户名已经存在，请重新输入”的提示，当重新输入密码时，如果两次密码不相同，则会出现“*请注意，两次密码不一样”的提示主要代码如下：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWindowsFormsApplication1{publicpartialclass注册:Form{public注册(){InitializeComponent();}publicboolUserFlag;privatevoidtextBox3_TextChanged(objectsender,EventArgse){if(textBox2.Text.Trim()!=textBox3.Text.Trim()){label6.Visible=true;}else{label8.Visible=true;label6.Visible=false;}}privatevoid注册_Load(objectsender,EventArgse){}privatevoidtextBox1_TextChanged(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");conConnection.Open();stringcmd="selectReaderIDfromreader";SqlCommandcom=newSqlCommand(cmd,conConnection);SqlDataReaderreaderUser=com.ExecuteReader();while(readerUser.Read()){if(textBox1.Text==readerUser["ReaderID"].ToString().Trim()){label7.Visible=true;UserFlag=true;return;}elseif(textBox1.Text!=readerUser["ReaderID"].ToString().Trim()){label7.Visible=false;label9.Visible=true;UserFlag=false;}}}privatevoidbutton1_Click(objectsender,EventArgse){intindex=textBox4.Text.IndexOf("@");if(index<1){label10.Visible=true;label10.Text="邮箱格式不正确，请重新输入";}else{label10.Visible=true;label10.Text="邮箱格式正确";}if(UserFlag==true){MessageBox.Show("用户已经存在，请重新输入！");return;}if(UserFlag==false){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");conConnection.Open();stringcmd="insertintoreader(ReaderID,ReaderPassword,ReaderEmall)values('"+textBox1.Text+"',"+"'"+textBox2.Text+"',"+"'"+textBox4.Text+"')";SqlCommandcom=newSqlCommand(cmd,conConnection);com.ExecuteNonQuery();conConnection.Close();MessageBox.Show("注册成功！点击确定，返回登录界面。","提示");this.Close();LoginFormf2=newLoginForm();}}}}3.3管理员操作界面usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsFormsApplication1{publicpartialclassadmin:Form{publicadmin(){InitializeComponent();}privatevoid查看用户信息ToolStripMenuItem_Click(objectsender,EventArgse){权限设置f8=new权限设置();f8.ShowDialog();}privatevoid查看用户信息ToolStripMenuItem1_Click(objectsender,EventArgse){用户信息fi=new用户信息();fi.ShowDialog();}privatevoid新增用户ToolStripMenuItem1_Click(objectsender,EventArgse){新增用户f2=new新增用户();f2.ShowDialog();}privatevoid删除用户ToolStripMenuItem1_Click(objectsender,EventArgse){用户信息f3=new用户信息();f3.button2.Visible=true;f3.ShowDialog();}privatevoid录入书籍ToolStripMenuItem_Click(objectsender,EventArgse){书籍信息f5=new书籍信息();f5.ShowDialog();}privatevoid删除书籍ToolStripMenuItem_Click(objectsender,EventArgse){删除书籍f6=new删除书籍();f6.ShowDialog();}privatevoid还书处理ToolStripMenuItem_Click(objectsender,EventArgse){还书处理f9=new还书处理();f9.ShowDialog();}privatevoidadmin_Load(objectsender,EventArgse){}privatevoid借阅处理ToolStripMenuItem_Click(objectsender,EventArgse){借阅处理f10=new借阅处理();f10.ShowDialog();}}}3.3.1管理用户管理用户下共有三个子菜单新增用户界面主要代码如下：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWindowsFormsApplication1{publicpartialclass新增用户:Form{public新增用户(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");conConnection.Open();stringcmd="insertintoreader(ReaderID,ReaderName,ReaderPassword,ReaderSex,ReaderAge,ReaderDept,ReaderZhuanYe,MaxNumber,ReaderEmall)values('"+textBox1.Text+"',"+"'"+textBox2.Text+"',"+"'"+textBox3.Text+"',"+"'"+textBox4.Text+"',"+"'"+textBox5.Text+"',"+"'"+textBox6.Text+"',"+"'"+textBox7.Text+"',"+"'"+textBox8.Text+"',"+"'"+textBox9.Text+"')";SqlCommandcom=newSqlCommand(cmd,conConnection);com.ExecuteNonQuery();conConnection.Close();MessageBox.Show("添加成功！点击确定，返回登录界面。","提示");this.Close();}}}删除用户界面输入学号即可查询用户信息，如图，点击删除即删除该用户主要代码如下：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWindowsFormsApplication1{publicpartialclass用户信息:Form{boolUserFlag;public用户信息(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){if(UserFlag==false){MessageBox.Show("不存在该用户，请核对后再输入","警告");return;}if(UserFlag==true){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");conConnection.Open();stringcmd="select*fromreader";SqlCommandcom=newSqlCommand(cmd,conConnection);com.CommandText="select*fromreader";SqlDataReaderdr=com.ExecuteReader();while(dr.Read()){label11.Visible=true;textBox2.Text=dr["ReaderName"].ToString().Trim();textBox3.Text=dr["ReaderPassword"].ToString().Trim();textBox4.Text=dr["ReaderSex"].ToString().Trim();textBox5.Text=dr["ReaderAge"].ToString().Trim();textBox6.Text=dr["ReaderDept"].ToString().Trim();textBox7.Text=dr["ReaderZhuanYe"].ToString().Trim();textBox8.Text=dr["MaxNumber"].ToString().Trim();textBox9.Text=dr["ReaderEmall"].ToString().Trim();}conConnection.Close();}}privatevoidtextBox1_TextChanged(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");conConnection.Open();stringcmd="selectReaderIDfromreader";SqlCommandcom=newSqlCommand(cmd,conConnection);SqlDataReaderreaderUser=com.ExecuteReader();while(readerUser.Read()){if(textBox1.Text==readerUser["ReaderID"].ToString().Trim()){UserFlag=true;return;}elseif(textBox1.Text!=readerUser["ReaderID"].ToString().Trim()){UserFlag=false;}}}privatevoidbutton2_Click(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");conConnection.Open();stringcmd="deletefromreaderwhereReaderID='"+textBox1.Text.Replace("'","''")+"'";SqlCommandcom=newSqlCommand(cmd,conConnection);com.ExecuteNonQuery();conConnection.Close();MessageBox.Show("是否确认删除","提示");}}}查看用户信息界面该界面与删除用户界面代码基本相似，主要是将查询按钮隐藏，故代码不再列出3.3.2图书管理图书查询下共有2个子菜单录入书籍页面主要代码如下：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWindowsFormsApplication1{publicpartialclass书籍信息:Form{public书籍信息(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");conConnection.Open();stringcmd="insertintobook(BookID,BookWrite,BookName,BookPublish,BookPublishDate,BookPrice,BookSort)values('"+textBox1.Text+"',"+"'"+textBox2.Text+"',"+"'"+textBox3.Text+"',"+"'"+textBox4.Text+"',"+"'"+textBox5.Text+"',"+"'"+textBox6.Text+"',"+"'"+textBox7.Text+"')";SqlCommandcom=newSqlCommand(cmd,conConnection);com.ExecuteNonQuery();conConnection.Close();MessageBox.Show("录入成功","提示");textBox1.Text="";textBox2.Text="";textBox3.Text="";textBox4.Text="";textBox5.Text="";textBox6.Text="";textBox7.Text="";}}}删除书籍删除书籍之前如需确认是否是所需删除的书籍，以防删除错误，可以先将所需删除的书籍的书名输入，点击检索后会出现该书的详细信息，若确认无误后点击删除即可删除该书主要代码如下：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWindowsFormsApplication1{publicpartialclass删除书籍:Form{boolUserFlag;public删除书籍(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){if(UserFlag==false){MessageBox.Show("不存在此书，请核对后再输入","警告");return;}if(UserFlag==true){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");conConnection.Open();stringcmd="select*frombook";SqlCommandcom=newSqlCommand(cmd,conConnection);com.CommandText="select*frombook";SqlDataReaderdr=com.ExecuteReader();while(dr.Read()){textBox1.Text=dr["BookID"].ToString().Trim();textBox2.Text=dr["BookWrite"].ToString().Trim();textBox4.Text=dr["BookPublish"].ToString().Trim();textBox5.Text=dr["BookPublishDate"].ToString().Trim();textBox6.Text=dr["BookPrice"].ToString().Trim();textBox7.Text=dr["BookSort"].ToString().Trim();}conConnection.Close();}}privatevoidtextBox3_TextChanged(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");conConnection.Open();stringcmd="selectBookNamefrombook";SqlCommandcom=newSqlCommand(cmd,conConnection);SqlDataReaderreaderUser=com.ExecuteReader();while(readerUser.Read()){if(textBox1.Text==readerUser["BookName"].ToString().Trim()){UserFlag=true;return;}elseif(textBox1.Text!=readerUser["BookName"].ToString().Trim()){UserFlag=false;}}}privatevoidbutton2_Click(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");conConnection.Open();stringcmd="deletefrombookwhereBookName='"+textBox3.Text.Replace("'","''")+"'";SqlCommandcom=newSqlCommand(cmd,conConnection);com.ExecuteNonQuery();conConnection.Close();MessageBox.Show("是否确认删除","提示");}}}3.3.3权限设置该界面可以设置普通用户的最大借书数量、最长借阅时间、超期罚款（元/天）、遗失赔率等，主要代码如下：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWindowsFormsApplication1{publicpartialclass权限设置:Form{public权限设置(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");conConnection.Open();stringcmd="insertintoRight(MaxNum,MaxTime,Fine,Times)values('"+textBox1.Text+"',"+"'"+textBox2.Text+"',"+"'"+textBox3.Text+"',"+"'"+textBox4.Text+"')";SqlCommandcom=newSqlCommand(cmd,conConnection);com.ExecuteNonQuery();conConnection.Close();MessageBox.Show("修改成功","提示");this.Close();}}}3.3.4还书处理输入书籍号后即可查询借阅人超期信息及图书信息，无误后点击归还确认。操作后界面如下：主要代码如下：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.OleDb;usingSystem.Data.SqlClient;namespaceWindowsFormsApplication1{publicpartialclass还书处理:Form{boolUserFlag;public还书处理(){InitializeComponent();}privatevoidbutton2_Click(objectsender,EventArgse){if(UserFlag==false){MessageBox.Show("不存在此书，请核对后再输入","警告");return;}if(UserFlag==true){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");conConnection.Open();stringcmd="select*frombook";SqlCommandcom=newSqlCommand(cmd,conConnection);com.CommandText="select*frombook";SqlDataReaderdr=com.ExecuteReader();while(dr.Read()){textBox11.Text=dr["BookWrite"].ToString().Trim();textBox12.Text=dr["BookName"].ToString().Trim();textBox13.Text=dr["BookPublish"].ToString().Trim();textBox14.Text=dr["BookPublishDate"].ToString().Trim();textBox15.Text=dr["BookPrice"].ToString().Trim();textBox16.Text=dr["BookSort"].ToString().Trim();}conConnection.Close();SqlConnectionconConnection1=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");conConnection1.Open();stringcmd1="selects.*,g.*fromborrows,readergwheres.ReaderID=g.ReaderID";SqlCommandcom1=newSqlCommand(cmd1,conConnection1);com1.CommandText="selects.*,g.*fromborrows,readergwheres.ReaderID=g.ReaderID";SqlDataReaderdr1=com1.ExecuteReader();while(dr1.Read()){textBox2.Text=dr1["BorrowDate"].ToString().Trim();textBox3.Text=dr1["ReturnDate"].ToString().Trim();textBox4.Text=dr1["ReaderID"].ToString().Trim();textBox5.Text=dr1["ReaderName"].ToString().Trim();textBox6.Text=dr1["ReaderSex"].ToString().Trim();textBox7.Text=dr1["ReaderDept"].ToString().Trim();textBox8.Text=dr1["ReaderZhuanYe"].ToString().Trim();DateTimet1=DateTime.Now;DateTimet2=(DateTime)dr1["ReturnDate"];TimeSpants=t1-t2;intd=ts.Days;textBox9.Text=Convert.ToString(d);if(d<=0){textBox10.Text=Convert.ToString(0);}else{textBox10.Text=Convert.ToString(d*0.1);}}conConnection1.Close();}}privatevoidtextBox1_TextChanged(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");conConnection.Open();stringcmd="selectBookIDfrombook";SqlCommandcom=newSqlCommand(cmd,conConnection);SqlDataReaderreaderUser=com.ExecuteReader();while(readerUser.Read()){if(textBox1.Text==readerUser["BookID"].ToString().Trim()){UserFlag=true;return;}elseif(textBox1.Text!=readerUser["BookID"].ToString().Trim()){UserFlag=false;}}}privatevoidbutton1_Click(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");conConnection.Open();stringcmd="deletefromborrowwhereBookID=('"+textBox1.Text+"')";SqlCommandcom=newSqlCommand(cmd,conConnection);com.ExecuteNonQuery();conConnection.Close();MessageBox.Show("添加成功！点击确定，返回登录界面。","提示");this.Close();}}}3.3.5借阅处理输入用户名及书籍编号，点击借阅即借书成功，操作后界面如下：主要代码如下：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWindowsFormsApplication1{publicpartialclass借阅处理:Form{public借阅处理(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){if(textBox1.Text.Trim()==""){MessageBox.Show("请输入用户名","提示");return;}if(textBox2.Text.Trim()==""){MessageBox.Show("请输入书籍编号","提示");return;}stringtime=DateTime.Now.ToString();DateTimedt=DateTime.Now.Date.AddDays(30);stringreturntime=dt.ToString();textBox4.Text=time;textBox5.Text=returntime;SqlConnectionconConnection=newSqlConne