大学图书馆系统设计与应用说明书

1、 / 177大学图书馆系统设计及应用说明书课程设计目的1通过实际的编程与学习，了解自己的学习情况和实际动手能力;2通过编程发现问题与解决问题，提高自己解决问题的能力；3通过编程熟悉java的编程过程和软件的使用技巧。:、设计内容数据库设计图书信息编号，图书编号，图书名称，作者，价格,入库时间，书籍剩余数目，书籍数目，是否被借，借书人编号，借书时间，还书时间读者信息编号，XX,级别，密码，读者类型，现借数量，限制数量Book表字段名个约束IDStringReader_idString主键readernaneStringreadertypeStringsexStringMax_numStringD

2、ays_numStringBorrow表字段名约束ID自动编pISBN_id文本主键reader_id文本borrow_date日期/时间shouldback_date日期/时间back_date日期/时间if_back文本fine货币is_count文本登陆表字段名约束IDintKindint主键StudentnuString主键PWDString软件结构设计结构图图书馆管理系统它的主要功能包括：新书入库，旧书删除，借书，还书，馆内图书详细信息，图书查询，读者管理，读者信息管理，数据库管理。图书管理：这是图书馆最重要的模块之一,它将对图书馆中的书籍进行管理操作,所有的原始数据输入都是在这里实

3、现的,有了这里的数据输入,才能开始以后的诸如借书、还书等操作。新书入库,旧书注销,图书查询,图书表列,图书信息修改。业务管理：图书借阅：该功能要求用户输入图书编号或者图书条码,并且检查输入合法性；再输入借书证号,并且检查输入合法性；系统记录借书的经手人,最后由借书按钮实现操作。图书归还：与图书借阅类似,自动生成用户还可借书数。人员管理：这是针对读者和图书馆工作人员而设计的一个管理模块,它将完整的录读者的信息,以及图书馆工作人员的信息。读者管理：记录读者的详细信息,并提供增加、撤除、查询等操作。图书馆工作人员管理：在读者管理子模块的基础上增加权限管理功能,保证数据安全。四、概要设计功能设计管理员

4、登陆可以进行用户管理和图书管理,用户管理包括添加用户,删除用户,修改密码,查找用户,查看用户列表；图书管理包括添加图书,删除图书,修改图书价格,按书名,作者,查询图书,图书列表,借书列表,借书,还书。普通用户登陆可以进行按书名,作者,查询图书,修改用户密码,查询借书信息,图书列表。设计思路：向JFrame添加容器,在面板中添加文本框,标签，表,面板设为默认布局,然后添加按纽,设置监听器,设置事件和响应。五、程序源代码详细设计登陆代码：packagebookmana;importDBConnection.DBConnection;importjava.awt.event.ActionEvent;

5、importjava.sql.*;importjava.util.logging.Level;importjava.util.logging.Logger;importjavax.swing.JDialog;importjavax.swing.JOptionPane;publicclassLoginextendsjavax.swing.JFrameprivatebooleanXsjiemian;publicstaticintKIND;/登录类型,全局变量publicstaticStringname;publicLogininitComponents;setLocationRelativeTo;

6、SuppressWarnings/privatevoidinitComponentsjPanel1=newjavax.swing.JPanel;jLabelyh=newjavax.swing.JLabel;jLabelmi=newjavax.swing.JLabel;namefield=newjavax.swing.JTextField;numfield=newjavax.swing.JPasswordField;Reset=newjavax.swing.utton;Ensure=newjavax.swing.utton;Kind=newjavax.swing.JComboBox;jLabel

7、2=newjavax.swing.JLabel;jLabel3=newjavax.swing.JLabel;utton1=newjavax.swing.utton;jLabel1=newjavax.swing.JLabel;jLabel5=newjavax.swing.JLabel;setDefaultCloseOperation;jLabelyh.setText;jLabelmi.setText;namefield.addActionListenernewjava.awt.event.ActionListenerpublicvoidactionPerformednamefieldAction

8、Performed;numfield.addActionListenernewjava.awt.event.ActionListenerpublicvoidactionPerformednumfieldActionPerformed;Reset.setText;Reset.addActionListenernewjava.awt.event.ActionListenerpublicvoidactionPerformedResetActionPerformed;Ensure.setText;Ensure.addActionListenernewjava.awt.event.ActionListe

9、nerpublicvoidactionPerformedEnsureActionPerformed;Kind.setModelnewjavax.swing.DefaultComboBoxModel;Kind.addActionListenernewjava.awt.event.ActionListenerpublicvoidactionPerformedKindActionPerformed;jLabel2.setText;jLabel3.setText;utton1.setText;utton1.addActionListenernewjava.awt.event.ActionListene

10、rpublicvoidactionPerformedutton1ActionPerformed;javax.swing.GroupLayoutjPanel1Layout=newjavax.swing.GroupLayout;jPanel1.setLayout;jPanel1Layout.setHorizontalGroupjPanel1Layout.createParallelGroup.addGroupjPanel1Layout.createSequentialGroup.addGap.addGroupjPanel1Layout.createParallelGroup.addGroupjPa

11、nel1Layout.createSequentialGroup.addComponent.addPreferredGap.addComponent.addGap.addGroupjPanel1Layout.createSequentialGroup.addGap.addGroupjPanel1Layout.createParallelGroup.addGroupjPanel1Layout.createParallelGroup.addComponent.addComponent.addComponent.addGap.addGroupjPanel1Layout.createParallelG

12、roup.addComponent.addComponent.addComponent.addPreferredGap.addGroupjPanel1Layout.createParallelGroup.addComponent.addGroupjPanel1Layout.createSequentialGroup.addComponent.addGap.addContainerGap;jPanel1Layout.setVerticalGroupjPanel1Layout.createParallelGroup.addGroupjPanel1Layout.createSequentialGro

13、up.addGap.addGroupjPanel1Layout.createParallelGroup.addComponent.addComponent.addPreferredGap.addGroupjPanel1Layout.createParallelGroup.addComponent.addComponent.addComponent.addGap.addGroupjPanel1Layout.createParallelGroup.addComponent.addComponent.addComponent.addPreferredGap.addGroupjPanel1Layout

14、.createParallelGroup.addComponent.addComponent.addGap;jLabel1.setFontnewjava.awt.Font;/NOI18NjLabel1.setText;jLabel5.setIconnewjavax.swing.ImageIcongetClass.getResource;NOI18Njavax.swing.GroupLayoutlayout=newjavax.swing.GroupLayoutgetContentPane;getContentPane.setLayout;layout.setHorizontalGrouplayo

15、ut.createParallelGroup.addGrouplayout.createSequentialGroup.addGap.addGrouplayout.createParallelGroup.addComponent.addComponent.addContainerGap.addGroupjavax.swing.GroupLayout.Alignment.TRAILING,layout.createSequentialGroup.addContainerGap.addComponent.addContainerGap;layout.setVerticalGrouplayout.c

16、reateParallelGroup.addGrouplayout.createSequentialGroup.addGap.addComponent.addPreferredGap.addComponent.addPreferredGap.addComponent.addContainerGap;pack;/privatevoidResetActionPerformednamefield.setText;numfield.setText;/TODOaddyourhandlingcodehere:privatevoidEnsureActionPerformedname=namefield.ge

17、tText;/获得登录用户名charc=numfield.getPassword;/获得登录密码Stringpwd=newString;/获得登录类型,普通用户用0等价,管理员用1等价ifKind.getSelectedItem.equalsKIND=0;elseKIND=1;StringqueryStr=select*fromEnsurewhereStudentnu=+name+andPWD=+pwd+andKind=+KIND;System.out.println;tryResultSetrs=DBConnection.executeQuery;/查询数据库ifrs.nextifXsjie

18、mianmainFrame=newXsjiemian;/this.dispose;/mainFrame.setVisible;elseManagermainFrame=newManager;/this.dispose;/mainFrame.setVisible;elseJOptionPane.showMessageDialognewJDialog,namefield.setText;/numfield.setText;catchpublicstaticvoidmainjava.awt.EventQueue.invokeLaternewRunnable跳转到主界面关闭登录界面跳转到主界面关闭登录

19、界面用户名或密码错误,请重新输入!;重置登录用户名publicvoidrunNewLogin.setVisible;privatevoidnamefieldActionPerformed/TODOaddyourhandlingcodehere:privatevoidnumfieldActionPerformed/TODOaddyourhandlingcodehere:privatevoidKindActionPerformed/TODOaddyourhandlingcodehere:privatevoidutton1ActionPerformedthis.dispose;newAdduser.

20、setVisible;/TODOaddyourhandlingcodehere:/Variablesdeclaration-donotmodifyprivatejavax.swing.uttonEnsure;privatejavax.swing.JComboBoxKind;privatejavax.swing.uttonReset;privatejavax.swing.uttonutton1;privatejavax.swing.JLabeljLabel1;privatejavax.swing.JLabeljLabel2;privatejavax.swing.JLabeljLabel3;pri

21、vatejavax.swing.JLabeljLabel5;privatejavax.swing.JLabeljLabelmi;privatejavax.swing.JLabeljLabelyh;privatejavax.swing.JPaneljPanel1;privatejavax.swing.JTextFieldnamefield;privatejavax.swing.JPasswordFieldnumfield;/Endofvariablesdeclaration管理员操作主界面：packagebookmana;importjava.awt.*;importjava.awt.event

22、.*;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.text.ParseException;importjava.text.SimpleDateFormat;importjavax.swing.*;importDBConnection.DBConnection;publicclassManagerextendsjavax.swing.JFramepublicvoidsetRightsifrights.equalsjMenu1.setEnabled;jMenu2.setEnabled;publicManagerin

23、itComponents;this.setVisible;setLocationRelativeTo;SuppressWarnings/privatevoidinitComponentsjLabel1=newjavax.swing.JLabel;jMenuBar1=newjavax.swing.JMenuBar;jMenu1=newjavax.swing.JMenu;jMenu5=newjavax.swing.JMenu;jMenuItem2=newjavax.swing.JMenuItem;jMenuItem3=newjavax.swing.JMenuItem;jMenuItem10=new

24、javax.swing.JMenuItem;jMenu6=newjavax.swing.JMenu;jMenuItem1=newjavax.swing.JMenuItem;jMenuItem11=newjavax.swing.JMenuItem;jMenuItem12=newjavax.swing.JMenuItem;jMenu2=newjavax.swing.JMenu;jMenuItem4=newjavax.swing.JMenuItem;jMenuItem5=newjavax.swing.JMenuItem;jMenuItem14=newjavax.swing.JMenuItem;jMe

25、nu3=newjavax.swing.JMenu;jMenuItem6=newjavax.swing.JMenuItem;jMenuItem7=newjavax.swing.JMenuItem;jMenu4=newjavax.swing.JMenu;jMenuItem8=newjavax.swing.JMenuItem;jMenuItem13=newjavax.swing.JMenuItem;jMenuItem9=newjavax.swing.JMenuItem;setDefaultCloseOperation;jLabel1.setIconnewjavax.swing.ImageIconge

26、tClass.getResource;/NOI18NjMenu1.setText;jMenu5.setText;jMenuItem2.setText;jMenuItem2.addActionListenernewjava.awt.event.ActionListenerpublicvoidactionPerformedjMenuItem2ActionPerformed;jMenu5.add;jMenuItem3.setText;jMenuItem3.addActionListenernewjava.awt.event.ActionListenerpublicvoidactionPerforme

27、djMenuItem3ActionPerformed;jMenu5.add;jMenuItem10.setText;jMenuItem10.addActionListenernewjava.awt.event.ActionListenerpublicvoidactionPerformedjMenuItem10ActionPerformed;jMenu5.add;jMenu1.add;jMenu6.setText;jMenuItem1.setText;jMenuItem1.addActionListenernewjava.awt.event.ActionListenerpublicvoidact

28、ionPerformedjMenuItem1ActionPerformed;jMenu6.add;jMenuItem11.setText;jMenuItem11.addActionListenernewjava.awt.event.ActionListenerpublicvoidactionPerformedjMenuItem11ActionPerformed;jMenu6.add;jMenuItem12.setText;jMenuItem12.addActionListenernewjava.awt.event.ActionListenerpublicvoidactionPerformedj

29、MenuItem12ActionPerformed;jMenu6.add;jMenu1.add;jMenuBar1.add;jMenu2.setText;jMenuItem4.setText;jMenuItem4.addActionListenernewjava.awt.event.ActionListenerpublicvoidactionPerformedjMenuItem4ActionPerformed;jMenu2.add;jMenuItem5.setText;jMenuItem5.addActionListenernewjava.awt.event.ActionListenerpub

30、licvoidactionPerformedjMenuItem5ActionPerformed;jMenu2.add;jMenuItem14.setText;jMenuItem14.addActionListenernewjava.awt.event.ActionListenerpublicvoidactionPerformedjMenuItem14ActionPerformed;jMenu2.add;jMenuBar1.add;jMenu3.setText;jMenuItem6.setText;jMenuItem6.addActionListenernewjava.awt.event.Act

31、ionListenerpublicvoidactionPerformedjMenuItem6ActionPerformed;jMenu3.add;jMenuItem7.setText;jMenuItem7.addActionListenernewjava.awt.event.ActionListenerpublicvoidactionPerformedjMenuItem7ActionPerformed;jMenu3.add;jMenuBar1.add;jMenu4.setText;jMenuItem8.setText;jMenuItem8.addActionListenernewjava.aw

32、t.event.ActionListenerpublicvoidactionPerformedjMenuItem8ActionPerformed;jMenu4.add;jMenuItem13.setText;jMenuItem13.addActionListenernewjava.awt.event.ActionListenerpublicvoidactionPerformedjMenuItem13ActionPerformed;jMenu4.add;jMenuItem9.setText;jMenuItem9.addActionListenernewjava.awt.event.ActionL

33、istenerpublicvoidactionPerformedjMenuItem9ActionPerformed;jMenu4.add;jMenuBar1.add;setJMenuBar;javax.swing.GroupLayoutlayout=newjavax.swing.GroupLayoutgetContentPane;getContentPane.setLayout;layout.setHorizontalGrouplayout.createParallelGroup.addGrouplayout.createSequentialGroup.addContainerGap.addC

34、omponent;layout.setVerticalGrouplayout.createParallelGroup.addComponent;pack;/privatevoidjMenuItem2ActionPerformed/TODOaddyourhandlingcodehere:newBookAdd.setVisible;privatevoidjMenuItem10ActionPerformed/TODOaddyourhandlingcodehere:newBookDelete.setVisible;privatevoidjMenuItem3ActionPerformed/TODOadd

35、yourhandlingcodehere:newBookUpdate.setVisible;privatevoidjMenuItem1ActionPerformed/TODOaddyourhandlingcodehere:newReaderAdd.setVisible;privatevoidjMenuItem11ActionPerformed/TODOaddyourhandlingcodehere:newReaderUpdate.setVisible;privatevoidjMenuItem12ActionPerformed/TODOaddyourhandlingcodehere:newRea

36、derDelete.setVisible;privatevoidjMenuItem9ActionPerformed/TODOaddyourhandlingcodehere:DBConnection.Close; /关闭数据库System.exit;privatevoidjMenuItem4ActionPerformed/TODOaddyourhandlingcodehere:newBorrowBook.setVisible;privatevoidjMenuItem5ActionPerformed/TODOaddyourhandlingcodehere:newBackBookk.setVisib

37、le;privatevoidjMenuItem8ActionPerformed/TODOaddyourhandlingcodehere:newMylib.setVisible;privatevoidjMenuItem7ActionPerformed/TODOaddyourhandlingcodehere:newReaderQuery.setVisible;privatevoidjMenuItem6ActionPerformed/TODOaddyourhandlingcodehere:newBookQuery.setVisible;privatevoidjMenuItem14ActionPerf

38、ormed/TODOaddyourhandlingcodehere:newBorrowQuery.setVisible;privatevoidjMenuItem13ActionPerformed/TODOaddyourhandlingcodehere:newMylib1.setVisible;/*paramargsthecommandlinearguments*/publicstaticvoidmain/*SettheNimbuslookandfeel*/editor-folddefaultstate=collapseddesc=Lookandfeelsettingcode/*IfNimbus

39、isnotavailable,staywiththedefaultlookandfeel.*Fordetailssee:/download.oracle/javase/tutorial/uiswing/lookandfeel/plaf.html*/tryforjavax.swing.UIManager.LookAndFeelInfoinfo:javax.swing.UIManager.getInstalledLookAndFeelsifNimbus.equalsinfo.getNamejavax.swing.UIManager.setLookAndFeelinfo.getClassName;b

40、reak;catchjava.util.logging.Logger.getLoggerManager.class.getName.log;catchjava.util.logging.Logger.getLoggerManager.class.getName.log;catchjava.util.logging.Logger.getLoggerManager.class.getName.log;catchjava.util.logging.Logger.getLoggerManager.class.getName.log;/*Createanddisplaytheform*/java.awt

41、.EventQueue.invokeLaternewRunnablepublicvoidrunnewManager.setVisible;/Variablesdeclaration-donotmodifyprivatejavax.swing.JLabeljLabel1;privatejavax.swing.JMenujMenu1;privatejavax.swing.JMenujMenu2;privatejavax.swing.JMenujMenu3;privatejavax.swing.JMenujMenu4;privatejavax.swing.JMenujMenu5;privatejav

42、ax.swing.JMenujMenu6;privatejavax.swing.JMenuBarjMenuBar1;privatejavax.swing.JMenuItemjMenuItem1;privatejavax.swing.JMenuItemjMenuItem10;privatejavax.swing.JMenuItemjMenuItem11;privatejavax.swing.JMenuItemjMenuItem12;privatejavax.swing.JMenuItemjMenuItem13;privatejavax.swing.JMenuItemjMenuItem14;pri

43、vatejavax.swing.JMenuItemjMenuItem2;privatejavax.swing.JMenuItemjMenuItem3;privatejavax.swing.JMenuItemjMenuItem4;privatejavax.swing.JMenuItemjMenuItem5;privatejavax.swing.JMenuItemjMenuItem6;privatejavax.swing.JMenuItemjMenuItem7;privatejavax.swing.JMenuItemjMenuItem8;privatejavax.swing.JMenuItemjM

44、enuItem9;/Endofvariablesdeclaration管理用户子界面：添加用户：packagebookmana;/*authorjhf*/8.importjava.awt.*;9.importjava.awt.event.*;10.importjava.sql.ResultSet;11.importjava.sql.SQLException;12.importjavax.swing.*;13.importpublicmodule.*;importDBConnection.DBConnection;publicclassReaderAddextendsjavax.swing.JF

45、rame/*CreatesnewformReaderAdd*/publicReaderAddinitComponents;setLocationRelativeTo;/*Thismethodiscalledfromwithintheconstructortoinitializetheform.*WARNING:DoNOTmodifythiscode.Thecontentofthismethodisalways*regeneratedbytheFormEditor.*/SuppressWarnings/privatevoidinitComponentsutton1=newjavax.swing.

46、utton;jTextField1=newjavax.swing.JTextField;utton2=newjavax.swing.utton;jLabel2=newjavax.swing.JLabel;utton3=newjavax.swing.utton;jComboBox1=newjavax.swing.JComboBox;jLabel1=newjavax.swing.JLabel;jLabel5=newjavax.swing.JLabel;jLabel6=newjavax.swing.JLabel;jTextField5=newjavax.swing.JTextField;jTextF

47、ield6=newjavax.swing.JTextField;jComboBox2=newjavax.swing.JComboBox;jLabel4=newjavax.swing.JLabel;jTextField2=newjavax.swing.JTextField;jLabel3=newjavax.swing.JLabel;setDefaultCloseOperation;utton1.setFontnewjava.awt.Font;/NOI18Nutton1.setText;utton1.addActionListenernewjava.awt.event.ActionListener

48、publicvoidactionPerformedutton1ActionPerformed;宋体 , 0, 14; / NOI18N宋体 , 0, 14; / NOI18NjTextField1.setFontnewjava.awt.Fontutton2.setFontnewjava.awt.Fontutton2.setText;utton2.addActionListenernewjava.awt.event.ActionListenerpublicvoidactionPerformedutton2ActionPerformed;jLabel2.setFontnewjava.awt.Fon

49、t;/NOI18NjLabel2.setText;utton3.setFontnewjava.awt.Font;/NOI18N74.utton3.setText;75.utton3.addActionListenernewjava.awt.event.ActionListenerpublicvoidactionPerformedutton3ActionPerformed;jComboBox1.setFontnewjava.awt.Font;/NOI18NjComboBox1.setModelnewjavax.swing.DefaultComboBoxModel;83.jLabel1.setFo

50、ntnewjava.awt.FontjLabel1.setText;宋体,0,14;/NOI18N86.87.jLabel5.setFontnewjava.awt.Font;/NOI18N88.jLabel5.setText;89.90.jLabel6.setFontnewjava.awt.Font;/NOI18NjLabel6.setText;jTextField5.setFontnewjava.awt.FontjTextField6.setFontnewjava.awt.FontjComboBox2.setFontnewjava.awt.Font;/NOI18N宋体,0,14;/NOI18

51、N宋体,0,14;/NOI18N98.jComboBox2.setModelnewjavax.swing.DefaultComboBoxModel;jLabel4.setFontnewjava.awt.FontjLabel4.setText;jTextField2.setFontnewjava.awt.FontjLabel3.setFontnewjava.awt.FontjLabel3.setText;宋体,0,14;/NOI18N宋体,0,14;/NOI18N宋体,0,14;/NOI18Njavax.swing.GroupLayoutlayout=newjavax.swing.GroupLa

52、youtgetContentPane;getContentPane.setLayout;layout.setHorizontalGrouplayout.createParallelGroup.addGrouplayout.createSequentialGroup.addGrouplayout.createParallelGroup114.addGrouplayout.createSequentialGroup.addGap.addGrouplayout.createParallelGroup.addComponent.addComponent.addComponent.addGrouplay

53、out.createParallelGroup.addGrouplayout.createSequentialGroup.addPreferredGap.addGrouplayout.createParallelGroup.addComponent.addComponent.addGrouplayout.createSequentialGroup.addGap.addComponent129.addGap130.addGrouplayout.createParallelGroup131.addComponent132.addComponent.addComponent.addPreferred

54、Gap135.addGrouplayout.createSequentialGroup.addGap.addComponent.addPreferredGap139.addComponent.addGap.addGrouplayout.createParallelGroup142.addComponent.addGrouplayout.createParallelGroup.addComponent.addComponent146.addComponent.addContainerGap;layout.setVerticalGrouplayout.createParallelGroup.add

55、Grouplayout.createSequentialGroup.addGap.addGrouplayout.createParallelGroup.addComponent.addComponent.addComponent.addComponent.addGap.addGrouplayout.createParallelGroup.addComponent.addComponent.addComponent.addComponent.addGap.addGrouplayout.createParallelGroup.addComponent.addComponent.addCompone

56、nt.addComponent.addGap.addGrouplayout.createParallelGroup.addComponent.addComponent.addComponent.addContainerGap;pack;/180.privatevoidutton1ActionPerformed/TODOaddyourhandlingcodehere:Stringreadid=jTextField1.getText;Stringname=jTextField2.getName;Stringtype=jComboBox1.getSelectedItem.toString;Strin

57、gsex=jComboBox2.getSelectedItem.toString;/如果读者编号为空,则终止保存记录操作ifreadid.equalsJOptionPane.showMessageDialog;return;/如果读者编号重复,则记录无效,需修改读者编号ifIfReaderIdExitJOptionPane.showMessageDialog;return;tryintmax_num=Integer.parseIntjTextField5.getText;intdays_num=Integer.parseIntjTextField6.getText;Stringsql=inse

58、rtintoreadervalues;inti=DBConnection.executeUpdate;ifJOptionPane.showMessageDialog;clearAllTextfield;/清空全部文本框catchJOptionPane.showMessageDialog;privatevoidutton2ActionPerformed/TODOaddyourhandlingcodehere:clearAllTextfield;privatevoidutton3ActionPerformed/TODOaddyourhandlingcodehere:dispose;privateb

59、ooleanIfReaderIdExitStringsql=select*fromreaderwherereader_id=+readid+;ResultSetrs=DBConnection.executeQuery;tryifrs.nextreturntrue;elsereturnfalse; TOC o 1-5 h z catchJOptionPane.showMessageDialog;returnfalse;privatevoidclearAllTextfieldjTextField1.setText;jTextField2.setText;jTextField5.setText;jT

60、extField6.setText;/*paramargsthecommandlinearguments*/publicstaticvoidmaincode look and feel.detailsinfo/*SettheNimbuslookandfeel*/*IfNimbusisnotavailable,staywiththedefault*Forsee:/download.oracle/javase/tutorial/uiswing/lookandfeel/plaf.html*/tryforjavax.swing.UIManager.LookAndFeelInfojavax.swing.