图书管理系统系统设计(含代码)

《高级程序设计语言》图书管理系统设计 报告 软件系统测试报告下载sgs报告如何下载关于路面塌陷情况报告535n,sgs报告怎么下载竣工报告下载 　　　学　　院：　　国土资源工程学院　　专　　业：　测绘工程　　成　　员：********************************指导教师：　　　　　　　黄云铠　　　　　　日　　期：　　　2014年11月5日　　　　1系统设计1.1设计目标本系统是针对图书管理工作过程进行设计的，主要实现如下目标：注册用户可以登录此系统；非注册用户注册后可以使用本系统；读者可以查询、借阅、归还图书等；管理员可以对读者、图书进行管理。数据库设计概述概念结构设计将从需求分析中得到的数据信息抽象为概念模型,经分析可得到数据库的E-R模型。如图所示。图1-1图书实体ER图图1-2实体读者ER图图1-3用户实体ER图项目规划图书管理系统是一个典型的数据库应用程序，由应用程序和后台数据库两部分构成。（1）应用程序应用程序主要包括登录，注册，用户信息，读者信息，图书信息管理，借阅图书，综合查询，出版社信息等几个部分组成。（2）数据库数据库负责对图书信息，用户信息等数据的管理。2数据库设计说明书2．1数据库表结构图书表book借阅信息表borrow用户信息表Reader用户信息权限表right用户账号表user管理员账号表usererheper数据关系图图书管理系统暂有数据（模拟运行）管理员学工号：20姓名：邢吉昌密码：111普通用户学工号：21姓名：猪八戒密码：333学工号：22姓名：孙悟空密码：444图书信息编号作者书名出版社出版日期价格书类H1MARKC#入门经典清华大学出版社2011/4/5计算机H2哪吒和猴子的那些事天庭文印2010/1/2情感H3二郎神我也可以闹天宫天庭文印2009/8/1技术3程序功能的实现登陆界面已注册用户登录时，用户类别选择普通用户或管理员，不选择会出现提示主要代码如下：usingSystem;using;using;using;using;using;usingWindowsFormsApplication1{publicpartialclassLoginForm:Form{publicstringpassword;privateintErrorTimes;stringUser,Pwd;boolflagshow=false;privateboolyanzhengshuru(){password=;if""){("请选择登录类型","登录提示",,;();returnfalse;}elseif""){("请输入用户名","登录提示",,;();returnfalse;}elseif(password==""){("请输入密码","登录提示",,;();returnfalse;}else{returntrue;}}publicLoginForm(){InitializeComponent();}privatevoidcancelbtn_Click(objectsender,EventArgse){();}privatevoidLoginForm_Load(objectsender,EventArgse){}privatevoidLoginForm_Closing(objectsender,FormClosingEventArgse){();}privatevoidloginbtn_Click(objectsender,EventArgse){if(yanzhengshuru()){if=="管理员"){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd="selectAdminID,AdminPassfromuserhelper";SqlCommandcom=newSqlCommand(cmd,conConnection);SqlDataReaderreader=();while()){User=reader["AdminID"].ToString();Pwd=reader["AdminPass"].ToString();if()==&()=={flagshow=true;}}();();if(flagshow==true){();adminf1=newadmin();();}}else{if=="普通用户"){SqlConnectionconConnection1=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcnd="selectReaderID,ReaderPasswordfromreader";SqlCommandcnm=newSqlCommand(cnd,conConnection1);SqlDataReaderreader1=();while()){User=reader1["ReaderID"].ToString();Pwd=reader1["ReaderPassword"].ToString();if()==&()=={flagshow=true;}}();();if(flagshow==true){();读者查阅f1=new读者查阅();();}else{("用户名不存在或密码错误！","提示");ErrorTimes++;if(ErrorTimes>=3){("登录次数过多，程序将关闭");sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd="selectReaderIDfromreader";SqlCommandcom=newSqlCommand(cmd,conConnection);SqlDataReaderreaderUser=();while()){if==readerUser["ReaderID"].ToString().Trim()){=true;UserFlag=true;return;}elseif!=readerUser["ReaderID"].ToString().Trim()){=false;=true;UserFlag=false;}}}privatevoidbutton1_Click(objectsender,EventArgse){intindex="@");if(index<1){=true;="邮箱格式不正确，请重新输入";}else{=true;="邮箱格式正确";}if(UserFlag==true){("用户已经存在，请重新输入！");return;}if(UserFlag==false){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd="insertintoreader(ReaderID,ReaderPassword,ReaderEmall)values('"++"',"+"'"++"',"+"'"++"')";SqlCommandcom=newSqlCommand(cmd,conConnection);();();("注册成功！点击确定，返回登录界面。","提示");();LoginFormf2=newLoginForm();}}}}管理员操作界面usingSystem;using;using;using;using;using;usingWindowsFormsApplication1{publicpartialclassadmin:Form{publicadmin(){InitializeComponent();}privatevoid查看用户信息ToolStripMenuItem_Click(objectsender,EventArgse){权限设置f8=new权限设置();();}privatevoid查看用户信息ToolStripMenuItem1_Click(objectsender,EventArgse){用户信息fi=new用户信息();();}privatevoid新增用户ToolStripMenuItem1_Click(objectsender,EventArgse){新增用户f2=new新增用户();();}privatevoid删除用户ToolStripMenuItem1_Click(objectsender,EventArgse){用户信息f3=new用户信息();=true;();}privatevoid录入书籍ToolStripMenuItem_Click(objectsender,EventArgse){书籍信息f5=new书籍信息();();}privatevoid删除书籍ToolStripMenuItem_Click(objectsender,EventArgse){删除书籍f6=new删除书籍();();}privatevoid还书处理ToolStripMenuItem_Click(objectsender,EventArgse){还书处理f9=new还书处理();();}privatevoidadmin_Load(objectsender,EventArgse){}privatevoid借阅处理ToolStripMenuItem_Click(objectsender,EventArgse){借阅处理f10=new借阅处理();();}}}管理用户管理用户下共有三个子菜单新增用户界面主要代码如下：usingSystem;using;using;using;using;using;usingWindowsFormsApplication1{publicpartialclass新增用户:Form{public新增用户(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd="insertintoreader(ReaderID,ReaderName,ReaderPassword,ReaderSex,ReaderAge,ReaderDept,ReaderZhuanYe,MaxNumber,ReaderEmall)values('"++"',"+"'"++"',"+"'"++"',"+"'"++"',"+"'"++"',"+"'"++"',"+"'"++"',"+"'"++"',"+"'"++"')";SqlCommandcom=newSqlCommand(cmd,conConnection);();();("添加成功！点击确定，返回登录界面。","提示");();}}}删除用户界面输入学号即可查询用户信息，如图，点击删除即删除该用户主要代码如下：usingSystem;using;using;using;using;using;usingWindowsFormsApplication1{publicpartialclass用户信息:Form{boolUserFlag;public用户信息(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){if(UserFlag==false){("不存在该用户，请核对后再输入","警告");return;}if(UserFlag==true){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd="select*fromreader";SqlCommandcom=newSqlCommand(cmd,conConnection);="select*fromreader";SqlDataReaderdr=();while()){=true;=dr["ReaderName"].ToString().Trim();=dr["ReaderPassword"].ToString().Trim();=dr["ReaderSex"].ToString().Trim();=dr["ReaderAge"].ToString().Trim();=dr["ReaderDept"].ToString().Trim();=dr["ReaderZhuanYe"].ToString().Trim();=dr["MaxNumber"].ToString().Trim();=dr["ReaderEmall"].ToString().Trim();}();}}privatevoidtextBox1_TextChanged(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd="selectReaderIDfromreader";SqlCommandcom=newSqlCommand(cmd,conConnection);SqlDataReaderreaderUser=();while()){if==readerUser["ReaderID"].ToString().Trim()){UserFlag=true;return;}elseif!=readerUser["ReaderID"].ToString().Trim()){UserFlag=false;}}}privatevoidbutton2_Click(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd="deletefromreaderwhereReaderID='"+"'","''")+"'";SqlCommandcom=newSqlCommand(cmd,conConnection);();();("是否确认删除","提示");}}}查看用户信息界面该界面与删除用户界面代码基本相似，主要是将查询按钮隐藏，故代码不再列出图书管理图书查询下共有2个子菜单录入书籍页面主要代码如下：usingSystem;using;using;using;using;using;usingWindowsFormsApplication1{publicpartialclass书籍信息:Form{public书籍信息(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd="insertintobook(BookID,BookWrite,BookName,BookPublish,BookPublishDate,BookPrice,BookSort)values('"++"',"+"'"++"',"+"'"++"',"+"'"++"',"+"'"++"',"+"'"++"',"+"'"++"')";SqlCommandcom=newSqlCommand(cmd,conConnection);();();("录入成功","提示");="";="";="";="";="";="";="";}}}删除书籍删除书籍之前如需确认是否是所需删除的书籍，以防删除错误，可以先将所需删除的书籍的书名输入，点击检索后会出现该书的详细信息，若确认无误后点击删除即可删除该书主要代码如下：usingSystem;using;using;using;using;using;usingWindowsFormsApplication1{publicpartialclass删除书籍:Form{boolUserFlag;public删除书籍(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){if(UserFlag==false){("不存在此书，请核对后再输入","警告");return;}if(UserFlag==true){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd="select*frombook";SqlCommandcom=newSqlCommand(cmd,conConnection);="select*frombook";SqlDataReaderdr=();while()){=dr["BookID"].ToString().Trim();=dr["BookWrite"].ToString().Trim();=dr["BookPublish"].ToString().Trim();=dr["BookPublishDate"].ToString().Trim();=dr["BookPrice"].ToString().Trim();=dr["BookSort"].ToString().Trim();}();}}privatevoidtextBox3_TextChanged(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd="selectBookNamefrombook";SqlCommandcom=newSqlCommand(cmd,conConnection);SqlDataReaderreaderUser=();while()){if==readerUser["BookName"].ToString().Trim()){UserFlag=true;return;}elseif!=readerUser["BookName"].ToString().Trim()){UserFlag=false;}}}privatevoidbutton2_Click(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd="deletefrombookwhereBookName='"+"'","''")+"'";SqlCommandcom=newSqlCommand(cmd,conConnection);();();("是否确认删除","提示");}}}权限设置该界面可以设置普通用户的最大借书数量、最长借阅时间、超期罚款（元/天）、遗失赔率等，主要代码如下：usingSystem;using;using;using;using;using;usingWindowsFormsApplication1{publicpartialclass权限设置:Form{public权限设置(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd="insertintoRight(MaxNum,MaxTime,Fine,Times)values('"++"',"+"'"++"',"+"'"++"',"+"'"++"')";SqlCommandcom=newSqlCommand(cmd,conConnection);();();("修改成功","提示");();}}}还书处理输入书籍号后即可查询借阅人超期信息及图书信息，无误后点击归还确认。操作后界面如下：主要代码如下：usingSystem;using;using;using;using;using;usingWindowsFormsApplication1{publicpartialclass还书处理:Form{boolUserFlag;public还书处理(){InitializeComponent();}privatevoidbutton2_Click(objectsender,EventArgse){if(UserFlag==false){("不存在此书，请核对后再输入","警告");return;}if(UserFlag==true){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd="select*frombook";SqlCommandcom=newSqlCommand(cmd,conConnection);="select*frombook";SqlDataReaderdr=();while()){=dr["BookWrite"].ToString().Trim();=dr["BookName"].ToString().Trim();=dr["BookPublish"].ToString().Trim();=dr["BookPublishDate"].ToString().Trim();=dr["BookPrice"].ToString().Trim();=dr["BookSort"].ToString().Trim();}();SqlConnectionconConnection1=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd1="selects.*,g.*fromborrows,readergwhere=";SqlCommandcom1=newSqlCommand(cmd1,conConnection1);="selects.*,g.*fromborrows,readergwhere=";SqlDataReaderdr1=();while()){=dr1["BorrowDate"].ToString().Trim();=dr1["ReturnDate"].ToString().Trim();=dr1["ReaderID"].ToString().Trim();=dr1["ReaderName"].ToString().Trim();=dr1["ReaderSex"].ToString().Trim();=dr1["ReaderDept"].ToString().Trim();=dr1["ReaderZhuanYe"].ToString().Trim();DateTimet1=;DateTimet2=(DateTime)dr1["ReturnDate"];TimeSpants=t1-t2;intd=;=(d);if(d<=0){=(0);}else{=(d*;}}();}}privatevoidtextBox1_TextChanged(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd="selectBookIDfrombook";SqlCommandcom=newSqlCommand(cmd,conConnection);SqlDataReaderreaderUser=();while()){if==readerUser["BookID"].ToString().Trim()){UserFlag=true;return;}elseif!=readerUser["BookID"].ToString().Trim()){UserFlag=false;}}}privatevoidbutton1_Click(objectsender,EventArgse){SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd="deletefromborrowwhereBookID=('"++"')";SqlCommandcom=newSqlCommand(cmd,conConnection);();();("添加成功！点击确定，返回登录界面。","提示");();}}}借阅处理输入用户名及书籍编号，点击借阅即借书成功，操作后界面如下：主要代码如下：usingSystem;using;using;using;using;using;usingWindowsFormsApplication1{publicpartialclass借阅处理:Form{public借阅处理(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){if""){("请输入用户名","提示");return;}if==""){("请输入书籍编号","提示");return;}stringtime=DateTimedt=stringreturntime=();=time;=returntime;SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringconn=@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True";stringtt="selectBookNamefrombookwhereBookID='"++"'";SqlDataAdapterda=newSqlDataAdapter(tt,conn);DataSetds=newDataSet();(ds);=ds.Tables[0].Rows[0][0].ToString();stringcmd="insertintoborrow(ReaderID,BookID,BorrowDate,ReturnDate)values('"++"',"+"'"++"',"+"'"++"',"+"'"++"')";SqlCommandcom=newSqlCommand(cmd,conConnection);();();("借阅成功","提示");}}}读者查询读者查询界面主要代码如下：usingSystem;using;using;using;using;using;usingWindowsFormsApplication1{publicpartialclass读者查阅:Form{public读者查阅(){InitializeComponent();}privatevoid读者信息ToolStripMenuItem_Click(objectsender,EventArgse){借阅信息f2=new借阅信息();();}privatevoid图书查询ToolStripMenuItem_Click(objectsender,EventArgse){图书查询f1=new图书查询();();}privatevoid图书续借ToolStripMenuItem_Click(objectsender,EventArgse){图书续借f3=new图书续借();();}privatevoid图书挂失ToolStripMenuItem_Click(objectsender,EventArgse){图书挂失f4=new图书挂失();();}}}图书查询该页面支持模糊查询，输入关键字即可查询相关书籍，操作界面如下：usingSystem;using;using;using;using;using;using;namespaceWindowsFormsApplication1{publicpartialclass图书查询:Form{public图书查询(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){FillGrid();}privatevoidFillGrid(){if=={("请输入你要使用的检索条件！","提示！");return;}stringsql=;sql+="selectBookIDasID号,BookWriteas作者,BookNameas书名,BookPublishas出版社,BookPublishDateas出版日期,BookPriceas价格,BookSortas书类frombook";if!=""){sql+="whereBookNamelike'%"++"%'";}SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd=sql;DataSetdataset=newDataSet();SqlDataAdaptermyDataAdapter=newSqlDataAdapter(cmd,conConnection);(dataset);=[0];}}}借阅信息输入学号后点击查询，即可查到已有借阅信息，查询后界面如下主要代码如下：usingSystem;using;using;using;using;using;using;namespaceWindowsFormsApplication1{publicpartialclass借阅信息:Form{public借阅信息(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){FillGrid();}privatevoidFillGrid(){if=={("请输入你要使用的学号！","提示！");return;}stringsql=;sql+="selectasID号,as作者,as书名,as出版社,as出版日期,as价格,as借阅日期frombooks,borrowg";if!=""){sql+="where=";}SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd=sql;DataSetdataset=newDataSet();SqlDataAdaptermyDataAdapter=newSqlDataAdapter(cmd,conConnection);(dataset);=[0];}}}图书续借输入书籍编号，点击续借即可。主要代码如下：usingSystem;using;using;using;using;using;usingWindowsFormsApplication1{publicpartialclass图书续借:Form{public图书续借(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){if==""){("请输入书籍编号","提示");return;}else{SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringconn=@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True";stringtt="selectBookNamefrombookwhereBookID='"++"'";SqlDataAdapterda=newSqlDataAdapter(tt,conn);DataSetds=newDataSet();(ds);=[0].Rows[0][0].ToString();stringcmd="updateborrowsetReturnDate=whereBookID='"++"'";SqlCommandcom=newSqlCommand(cmd,conConnection);();();("续借成功","提示");="";="";}}}}图书挂失输入图书编号即可挂失，操作后界面如下主要代码如下：usingSystem;using;using;using;using;using;usingWindowsFormsApplication1{publicpartialclass图书挂失:Form{public图书挂失(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){if==""){("请输入书籍编号","提示");return;}stringconn=@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True";stringtt="selectBookNamefrombookwhereBookID='"++"'";SqlDataAdapterda=newSqlDataAdapter(tt,conn);DataSetds=newDataSet();(ds);=[0].Rows[0][0].ToString();SqlConnectionconConnection=newSqlConnection(@"DataSource=.\sqlexpress;InitialCatalog=学生管理数据库;IntegratedSecurity=True");();stringcmd="updateborrowsetLost=1whereBookID='"++"'";//stringcmd="insertintoborrow(ReaderID,BookID,BorrowDate,ReturnDate)values('"++"',"+"'"++"',"+"'"++"',"+"'"++"',)";SqlCommandcom=newSqlCommand(cmd,conConnection);();();("挂失成功","提示");="";="";}}}附录：软件基本信息1、软件系统的名称：图书管理系统2、开发者：小组全体成员姓名学号邢吉昌20魏广宇16吴阳18袁清冽23张建柱243、该软件系统同其他系统或其他机构的基本的相互来往关系：该系统可以联网运营，简单方便图书名称作者编号出版日期价格种类出版社密码读者姓名编号专业借阅时间借书量年龄性别用户密码类型编号