图书管理系统系统设计

1、高级程序设计语言图书管理系统设计报告学院：国+济源工程学院专业：测绘工程成员:*指导教师：黄云铠日期：2014年11月5日1系统设计1.1设计目标注册用户可以登录此系统；非注册用户注册后可以使用本系统；读者可以查询、借阅、归还图书等；管理员可以对读者、图书进行管理。数据库设计概述概念结构设计将从需求分析中得到的数据信息抽象为概念模型E-R模型。如图所示。XV,图书-_C出版社二一图1-1图书实体ER图(密码J)Q生名J)，经分析可得到数据库的版日匚J)Qjt阅日匚本系统是针对图书管理工作过程进行设计的，主要实现如下目标:图1-2实体读者ER图用户图1-3用户实体ER图项目规划图书管理系统是一个

2、典型的数据库应用程序，由应用程序和后台数据库两部分构成。(1)应用程序应用程序主要包括登录，注册，用户信息，读者信息，图书信息管理，借阅图书，综合查询，出版社信息等几个部分组成。(2)数据库数据库负责对图书信息，用户信息等数据的管理。2数据库设计说明书2.1数据库表结构图书表book列名知Nullr。ooldcharflO)BBookWritenvarchar(30)HBooltNamenvar匚har(2。)叨BookPublishnv3rclniar(!50)国BookPublishDatedatetimeBookPrieerricneyBBookSertnvarcharO1)H借阅信息表

3、borrow列名允许恒加charflO)解BooUDchar(10)BorrcwDdtedatetimeHReturnDatedatetimeIBOutTimeint7园TotalFinerrchar(10)BLo«tbitB用户信息表Reader列名娟NWchar(10)ElRejderNamtnvarchar(0)nRedderPa&swordnvarchr(20)RlReaderSexnvarchar5J口fteaderAgeint回ReaderDcptnvarrhar(5D)sReaderZhuartVenvarchar(50)nWaxNumberintsikLost

4、nvarchar(15)ElRedderEmallvarchar(20>回|B用户信息权限表right列wNullMI3ES393int周MajtTimeintmFiremoneyETimesint周用户账号表user列名音Null,?char(10UserPaswordnvarchar(20)JUs#rSortnvrchartSO)管理员账号表usererheper列宅允许hull悔jAdmlnlDchar(iO)BTypenvarcharfZOj而AdminPassnvarchar(20)0ResderlDchar(lO)ReaderPassnvarchar20画数据关系图图书管理系

5、统暂有数据（模拟运行）管理员学工号：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；usingWindowsFormsApplicationlpubl

6、icpartialclassLoginForm:Formpublicstringpassword;privateintErrorTimes;stringUser,Pwd;boolflagshow=false;privateboolyanzhengshuru()password=;if"")("请选择登录类型","登录提示",();returnfalse;elseif"")("请输入用户名","登录提示",;();returnfalse;elseif(password=&quo

7、t;")("请输入密码","登录提示",;();returnfalse;elsereturntrue;publicLoginForm()InitializeComponent();privatevoidcancelbtn_Click(objectsender,EventArgse)();privatevoidLoginForm_Load(objectsender,EventArgse)privatevoidLoginForm_Closing(objectsender,FormClosingEventArgse)();privatevoidlog

8、inbtn_Click(objectsender,EventArgse)if(yanzhengshuru()if="管理员")SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog=1管理数据库;IntegratedSecurity=True");();stringcmd="selectAdminID,AdminPassfromuserhelper"SqlCommandcom=newSqlCommand(cmd,conConn

9、ection);SqlDataReaderreader=();while()User=reader"AdminID".ToString();Pwd=reader"AdminPass".ToString();if()=&()=flagshow=true;();();if(flagshow=true)();adminf1=newadmin();();elseif="普通用户")SqlConnectionconConnectionl=newSqlConnection("DataSource=.sqlexpress;Init

10、ialCatalog学生管理数据库;IntegratedSecurity=True");();stringcnd="selectReaderID,ReaderPasswordfromreader"SqlCommandcnm=newSqlCommand(cnd,conConnection1);SqlDataReaderreader1=();while()User=reader1"ReaderID".ToString();Pwd=reader1"ReaderPassword".ToString();if()=&()=fl

11、agshow=true;();();if(flagshow=true)()；读者查阅fl=new读者查阅();()；else("用户名不存在或密码错误！”,”提示)ErrorTimes+;if(ErrorTimes>=3)("登录次数过多，程序将关闭”)；sqlexpress;Initial Catalog学生管理数据库;Integrated Security=True");()；stringcmd="selectReaderlDfromreader"SqlCommandcom=newSqlCommand(cmd,conConnectio

12、n);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;="邮箱

13、格式不正确，请重新输入"else=true;="邮箱格式正确"if(UserFlag=true)("用户已经存在，请重新输入！");return;if(UserFlag=false)SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog考生管理数据库;IntegratedSecurity=True");();stringcmd="insertintoreader(ReaderID,ReaderPasswor

14、d,ReaderEmall)values('"+"',"+"'"+"',"+"'"+"')"SqlCommandcom=newSqlCommand(cmd,conConnection);();();("注册成功！点击确定，返回登录界面。","提示");();LoginFormf2=newLoginForm();管理员操作界面usingSystem;using；using；using；using；us

15、ing；usingWindowsFormsApplicationlpublicpartialclassadmin:Formpublicadmin()InitializeComponent();privatevoid查看用户信息ToolStripMenuItem_Click(objectsender,EventArgse)权限设置f8=new权限设置();();privatevoid查看用户信息ToolStripMenuItem1_Click(objectsender,EventArgse)用户信息fi=new用户信息()；();privatevoid新增用户ToolStripMenuItem1

16、_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删除书

17、籍();();privatevoid还书处理ToolStripMenuItem_Click(objectsender,EventArgse)还书处理f9=new还书处理();();privatevoidadmin_Load(objectsender,EventArgse)privatevoid借阅处理ToolStripMenuItem_Click(objectsender,EventArgse)借阅处理f10=new借阅处理()；();管理用户管理用户下共有三个子菜单|苜望月户圉书告理新塞用户制般用勺查看用户信息新增用户界面主要代码如下:usingSystem;using；using；usin

18、g；using；using；usingWindowsFormsApplicationlpublicpartialclass新增用户：Formpublic新增用户()InitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog#生管理数据库;IntegratedSecurity=True");();stringcmd="in

19、sertintoreader(ReaderID,ReaderName,ReaderPassword,ReaderSex,ReaderAge,ReaderDept,ReaderZhuanYe,MaxNumber,ReaderEmall)values('+"')"SqlCommandcom=newSqlCommand(cmd,conConnection);()；()；("添加成功！点击确定，返回登录界面。"，”提示)()；删除用户界面输入学号即可查询用户信息，如图，点击删除即删除该用户主要代码如下：usingSystem;using；usin

20、g；using；using；using；usingWindowsFormsApplicationlpublicpartialclass用户信息：FormboolUserFlag;public用户信息()InitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse)if(UserFlag=false)("不存在该用户，请核对后再输入","警告");return;if(UserFlag=true)SqlConnectionconConnection=newSqlConnectio

21、n("DataSource=.sqlexpress;InitialCatalog写生管理数据库;IntegratedSecurity=True");();stringcmd="select*fromreader"SqlCommandcom=newSqlCommand(cmd,conConnection);="select*fromreader"SqlDataReaderdr=();while()=true;=dr"ReaderName".ToString().Trim();=dr"ReaderPasswo

22、rd".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();();priva

23、tevoidtextBox1_TextChanged(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog斗生管理数据库;IntegratedSecurity=True");();stringcmd="selectReaderIDfromreader"SqlCommandcom=newSqlCommand(cmd,conConnection);SqlDataReaderreaderUser=();

24、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写生管理数据库;Integr

25、atedSecurity=True");();stringcmd="deletefromreaderwhereReaderID='"+""',""")+""'SqlCommandcom=newSqlCommand(cmd,conConnection);();();("是否确认删除"，"提示)查看用户信息界面该界面与删除用户界面代码基本相似，主要是将查询按钮隐藏，故代码不再列出图书管理图书查询下共有2个子菜单录入书籍页面吗书筹信息_厂一国书号，

26、出版日期，作有价检王由书却出版社；录入主要代码如下：usingSystem;using；using；using；using；using；usingWindowsFormsApplicationlpublicpartialclass书籍信息：Formpublic书籍信息()InitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog写生管理数据

27、库;IntegratedSecurity=True");();stringcmd="insertintobook(BookID,BookWrite,BookName,BookPublish,BookPublishDate,BookPrice,BookSort)values('"+ "'." + "'" + "'." + "'" + "'." + "'" +"'."

28、 + "'" + "'." + "'" + "'." + "'" +"')"SqlCommandcom=newSqlCommand(cmd,conConnection);();();("录入成功","提示");删除书籍删除书籍之前如需确认是否是所需删除的书籍，以防删除错误，可以先将所需删除的书籍的书名输入，点击检索后会出现该书的详细信息，若确认无误后点击删除即可删除该书主要代码如下:usi

29、ngSystem;using；using；using；using；using；usingWindowsFormsApplicationlpublicpartialclass删除书籍：FormboolUserFlag;public删除书籍()InitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse)if(UserFlag=false)(“不存在此书，请核对后再输入“，”警告)return;if(UserFlag=true)SqlConnectionconConnection=newSqlConnection(&q

30、uot;DataSource=.sqlexpress;InitialCatalog浮生管理数据库;IntegratedSecurity=True");();stringcmd="select*frombook"SqlCommandcom=newSqlCommand(cmd,conConnection);="select*frombook"SqlDataReaderdr=();while()=dr"BookID".ToString().Trim();=dr"BookWrite".ToString().Tri

31、m();=dr"BookPublish".ToString().Trim();=dr"BookPublishDate".ToString().Trim();=dr"BookPrice".ToString().Trim();=dr"BookSort".ToString().Trim();();privatevoidtextBox3_TextChanged(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection("DataSour

32、ce=.sqlexpress;InitialCatalog#生管理数据库;IntegratedSecurity=True");();stringcmd="selectBookNamefrombook"SqlCommandcom=newSqlCommand(cmd,conConnection);SqlDataReaderreaderUser=();while()if=readerUser"BookName".ToString().Trim()UserFlag=true;return;elseif!=readerUser"BookName

33、".ToString().Trim()UserFlag=false;privatevoidbutton2_Click(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog斗生管理数据库;IntegratedSecurity=True");();stringcmd="deletefrombookwhereBookName='"+"'","

34、9;'")+"'"SqlCommandcom=newSqlCommand(cmd,conConnection);();();("是否确认删除”,”提示)权限设置该界面可以设置普通用户的最大借书数量、最长借阅时间、超期罚款(元/天)、遗失赔率等，主要代码如下：usingSystem;using；using；using；using；using；usingWindowsFormsApplicationlpublicpartialclass权限设置：Formpublic权限设置()InitializeComponent()；privatevoid

35、button1_Click(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress；InitialCatalog写生管理数据库;IntegratedSecurity=True")；()；stringcmd="insertintoRight(MaxNum,MaxTime,Fine,Times)values('"+"',"+""'+"',"+

36、，"”+"',"+，”+"')"；SqlCommandcom=newSqlCommand(cmd,conConnection)；();();(“修改成功"，”提示");();还书处理输入书籍号后即可查询借阅人超期信息及图书信息，无误后点击归还确认。操作后界面如下：主要代码如下：usingSystem;using;using;using;using;using;usingWindowsFormsApplicationlpublicpartialclass还书处理：FormboolUserFlag;public还

37、书处理()InitializeComponent();privatevoidbutton2_Click(objectsender,EventArgse)if(UserFlag=false)("不存在此书，请核对后再输入","警告");return;if(UserFlag=true)SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog浮生管理数据库;IntegratedSecurity=True");();stringcmd=

38、"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().

39、Trim();=dr"BookPrice".ToString().Trim();=dr"BookSort".ToString().Trim();();SqlConnectionconConnectionl=newSqlConnection("DataSource=.sqlexpress;InitialCatalog学生管理数据库;IntegratedSecurity=True");();stringcmd1="selects.*,g.*fromborrows,readergwhere="SqlCommandcom1

40、=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&quo

41、t;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)Sq

42、lConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog写生管理数据库;IntegratedSecurity=True");();stringcmd="selectBookIDfrombook"SqlCommandcom=newSqlCommand(cmd,conConnection);SqlDataReaderreaderUser=();while()if=readerUser"BookID".ToString().Trim()U

43、serFlag=true;return;elseif!=readerUser"BookID".ToString().Trim()UserFlag=false;privatevoidbutton1_Click(objectsender,EventArgse)SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog斗生管理数据库;IntegratedSecurity=True");()；stringcmd="deletefromborroww

44、hereBookID=('"+"')"SqlCommandcom=newSqlCommand(cmd,conConnection);();();("添加成功！点击确定，返回登录界面。"，"提示")；();借阅处理输入用户名及书籍编号，点击借阅即借书成功，操作后界面如下:主要代码如下:usingSystem;using;using;using;using;using;usingWindowsFormsApplication1publicpartialclass借阅处理:Formpublic借阅处理()Initi

45、alizeComponent();privatevoidbutton1_Click(objectsender,EventArgse)if"")("请输入用户名","提示");return;if="")("请输入书籍编号","提示");return;stringtime=DateTimedt=stringreturntime=();=time;=returntime;SqlConnectionconConnection=newSqlConnection("DataSo

46、urce=.sqlexpress;InitialCatalog#生管理数据库;IntegratedSecurity=True");();stringconn="DataSource=.sqlexpress;InitialCatalog考生管理数据库integratedSecurity=True"stringtt="selectBookNamefrombookwhereBookID='"+"'"SqlDataAdapterda=newSqlDataAdapter(tt,conn);DataSetds=newDa

47、taSet();(ds);=ds.Tables0.Rows00.ToString();stringcmd="insertintoborrow(ReaderID,BookID,BorrowDate,ReturnDate)values('"+"',"+"'"+"',"+"'"+"',"+"'"+"')"SqlCommandcom=newSqlCommand(cmd,conCon

48、nection);();();("借阅成功","提示");读者查询读者查询界面主要代码如下:usingSystem;using；using；using；using；using；usingWindowsFormsApplicationlpublicpartialclass读者查阅：Formpublic读者查阅()InitializeComponent();privatevoid读者彳言息ToolStripMenuItem_Click(objectsender,EventArgse)借阅信息f2=new借阅信息();();privatevoid图书查询Too

49、lStripMenuItem_Click(objectsender,EventArgse)图书查询f1=new图书查询();();privatevoid图书续借ToolStripMenuItem_Click(objectsender,EventArgse)图书续借f3=new图书续借();();privatevoid图书挂失ToolStripMenuItem_Click(objectsender,EventArgse)图书挂失f4=new图书挂失();()；图书查询该页面支持模糊查询，输入关键字即可查询相关书籍，操作界面如下:usingSystem;using;using;using;usin

50、g;using;using;namespaceWindowsFormsApplication1publicpartialclass图书查询：Formpublic图书查询()InitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse)FillGrid();privatevoidFillGrid()if=("请输入你要使用的检索条件！","提示！");return;stringsql=;sql+="selectBookIDasI若,BookWriteas作者,Book

51、Nameas书名，BookPublishas出版社,BookPublishDateas出版日期,BookPriceas价格,BookSortas书类frombook"if!="")sql+="whereBookNamelike'%"+"%'"SqlConnectionconConnection=newSqlConnection("DataSource=.sqlexpress;InitialCatalog斗生管理数据库;IntegratedSecurity=True");();stringc

52、md=sql;DataSetdataset=newDataSet();SqlDataAdaptermyDataAdapter=newSqlDataAdapter(cmd,conConnection);(dataset);=0;借阅信息输入学号后点击查询，即可查到已有借阅信息，查询后界面如下主要代码如下：usingSystem;using；using；using；using；using；using；namespaceWindowsFormsApplicationlpublicpartialclass借阅彳言息：Formpublic借阅信息()InitializeComponent();priva

53、tevoidbutton1_Click(objectsender,EventArgse)FillGrid();privatevoidFillGrid()if（"请输入你要使用的学号！”,“提示！”）；return;stringsql=;sql+="selectasI若,as作者，as书名，as出版社，as出版日期，as价格，as借阅日期frombooks,borrowg"if!="")sql+="where="SqlConnectionconConnection=newSqlConnection("DataSour

54、ce=.sqlexpress;InitialCatalog斗生管理数据库;IntegratedSecurity=True");()；stringcmd=sql;DataSetdataset=newDataSet();SqlDataAdaptermyDataAdapter=newSqlDataAdapter(cmd,conConnection);(dataset);=0;图书续借输入书籍编号，点击续借即可主要代码如下：usingSystem;using;using;using;using;using;usingWindowsFormsApplication1publicpartialclass图书续借:Formpublic图书续借()InitializeComponent();privatevoidbutton1_C