Java图书馆管理系统附全代码-课程设计报告报告

./《数据库系统概论》课程报告课题名称：小型图书管理系统课题负责人名〔学号：best同组成员名单〔角色：指导教师：评阅成绩：评阅意见：提交报告时间：2015年12月15日小型图书管理系统计算机科学与技术专业学生指导老师[摘要]随着计算机技术的飞速发展,利用计算机来获得和处理信息是当今信息管理的一大特点。伴随计算机硬件的快速发展,有关信息管理的软件——数据库系统软件也在迅猛发展着。图书馆是高等院校的重要组成部门,是教师和学生获取知识的重要场所。由于图书馆主要从事大量的图书资料的储存和流通。所以一直以来,计算机在图书馆的图书管理中得到了广泛的应用。本系统实现图书信息管理的系统化,规范化和自动化,以最大程度提高操作人员的办公效率。关键词：JAVA、JDBC、SQLServer、数据库、图书馆管理一、实验题目：小型图书管理系统二、实验的目的和要求:完成一个小型图书管理系统,功能要求如下：能够通过书籍基本信息〔包括：书号、书名、出版社、出版日期、作者、内容摘要单个或以AND方式组合多个条件查询书籍信息；对于每一种书籍,除可查看其基本信息之外还可查看其总数以及目前在馆数量可增添新的书籍可删除已有书籍〔如有读者借了该书籍尚未归还,则不允许删除可修改书籍的基本信息能够通过读者基本信息〔包括：证号、姓名、性别、系名、年级单个或以AND方式组合多个条件查询读者信息对于每位读者除可查看其基本信息之外,还可查看其已借的书籍列表、数量、借还日期可增添新的读者可删除已有读者〔如该读者有尚未归还的借书,则不允许删除可修改读者的基本信息可完成借还书籍的手续还书时如超期,应该显示超期天数借书时如果有超期的书没有还,则不允许借书可查询有哪些读者有超期的书没有还,列出这些读者的基本信息三、实验的环境：1、硬件环境：CPU:Intel<R>Corei5-32302.60GHzRAM:8GB2、软件环境：操作系统：Windows7UltimateSP1编译软件：EclipseLunaMicrosoftSQLServer2014四、系统ER图五、表结构定义〔使用表格说明六、系统功能模块能够通过书籍基本信息单个或组合多个条件查询书籍信息；对于每一种书籍,除可查看其基本信息之外还可查看其总数以及目前在馆数量可增添新的书籍可删除已有书籍〔如有读者借了该书籍尚未归还,则不允许删除可修改书籍的基本信息能够通过读者基本信息单个或组合多个条件查询读者信息对于每位读者除可查看其基本信息之外,还可查看其已借的书籍列表、数量、借还日期可增添新的读者可删除已有读者〔如该读者有尚未归还的借书,则不允许删除可修改读者的基本信息可完成借还书籍的手续还书时如超期,应该显示超期天数借书时如果有超期的书没有还,则不允许借书可查询有哪些读者有超期的书没有还,列出这些读者的基本信息七、程序框架流程图九、程序运行结果八、核心代码AddBook.javaimportjava.awt.BorderLayout;importjava.awt.Container;importjava.awt.GridLayout;importjava.awt.event.*;importjava.util.ArrayList;importjavax.swing.*;publicclassAddBookextendsJFrameimplementsActionListener{ SQLOperationop=newSQLOperation<>; Containerc=getContentPane<>; JPanelp1=newJPanel<>; JLabelbookNumber=newJLabel<"BookNumber:">; JLabelbookName=newJLabel<"BookName:">; JLabelbookAuthor=newJLabel<"BookAuthor:">; JLabelpress=newJLabel<"Press:">; JLabelpressTime=newJLabel<"Presstime:">; JLabelbookAbstract=newJLabel<"Abstract:">; JLabelstorage=newJLabel<"Storage:">; JLabelremain=newJLabel<"Remain">; JLabelremain1=newJLabel<"UpdatewithStorage">;JTextFieldnumberField=newJTextField<>;JTextFieldnameField=newJTextField<>;JTextFieldauthorField=newJTextField<>;JTextFieldpressField=newJTextField<>;JTextFieldpressTimeField=newJTextField<>;JTextFieldabstractField=newJTextField<>;JTextFieldstorageField=newJTextField<>; JButtoncancel=newJButton<"Cancel">; JButtonconfirm=newJButton<"Confirm!!">;publicAddBook<>{c.add<p1,BorderLayout.NORTH>;p1.setLayout<newGridLayout<9,2,20,10>>;p1.add<bookNumber>;p1.add<numberField>;p1.add<bookName>;p1.add<nameField>;p1.add<bookAuthor>;p1.add<authorField>;p1.add<press>;p1.add<pressField>;p1.add<pressTime>;p1.add<pressTimeField>;p1.add<bookAbstract>;p1.add<abstractField>;p1.add<storage>;p1.add<storageField>;p1.add<remain>;p1.add<remain1>;p1.add<cancel>;p1.add<confirm>;cancel.addActionListener<this>;confirm.addActionListener<this>; }publicvoidactionPerformed<ActionEvente>{//TODOAuto-generatedmethodstubif<e.getSource<>==cancel>{this.dispose<>; }if<e.getSource<>==confirm>{this.dispose<>; BookInfobook=newBookInfo<numberField.getText<>,nameField.getText<>,authorField.getText<>,pressField.getText<>,pressTimeField.getText<>,abstractField.getText<>,Integer.parseInt<storageField .getText<>>, Integer.parseInt<storageField.getText<>>>; ArrayList<String>strArray=newArrayList<String><>;strArray=op.addBookJudgement<>;intn=0;intreplicate=0;while<n<Integer.parseInt<strArray.get<0>>>{n++;if<numberField.getText<>.equals<strArray.get<n>>>{replicate++; } }if<replicate==0>{op.saveBook<book>; JOptionPane.showMessageDialog<null,"Addabooksuccessfully！","Information",JOptionPane.INFORMATION_MESSAGE>; }else{ JOptionPane.showMessageDialog<null,"Thisbook<number>hasalreadyexisted!","Warning", JOptionPane.INFORMATION_MESSAGE>; } } }}AddReader.javaimportjava.awt.BorderLayout;importjava.awt.Container;importjava.awt.GridLayout;importjava.awt.event.*;importjava.util.ArrayList;importjavax.swing.*;publicclassAddReaderextendsJFrameimplementsActionListener{ SQLOperationop=newSQLOperation<>; Containerc=getContentPane<>; JPanelp1=newJPanel<>; JLabelreaderNumber=newJLabel<"ReaderNumber:">; JLabelreaderName=newJLabel<"ReaderName:">; JLabelsex=newJLabel<"Sex:">; JLabeldpt=newJLabel<"Department:">; JLabelgrade=newJLabel<"Grade:">; JTextFieldnumberField=newJTextField<>; JTextFieldnameField=newJTextField<>; JTextFieldsexField=newJTextField<>; JTextFielddptField=newJTextField<>; JTextFieldgradeField=newJTextField<>; JButtoncancel=newJButton<"Cancel">; JButtonconfirm=newJButton<"Confirm!!">;publicAddReader<>{c.add<p1,BorderLayout.NORTH>;p1.setLayout<newGridLayout<6,2,20,10>>;p1.add<readerNumber>;p1.add<numberField>;p1.add<readerName>;p1.add<nameField>;p1.add<sex>;p1.add<sexField>;p1.add<dpt>;p1.add<dptField>;p1.add<grade>;p1.add<gradeField>;p1.add<cancel>;p1.add<confirm>;cancel.addActionListener<this>;confirm.addActionListener<this>; }publicvoidactionPerformed<ActionEvente>{//TODOAuto-generatedmethodstubif<e.getSource<>==cancel>{this.dispose<>; }if<e.getSource<>==confirm>{this.dispose<>; ReaderInforeader=newReaderInfo<numberField.getText<>,nameField.getText<>,sexField.getText<>,dptField.getText<>,Integer.parseInt<gradeField.getText<>>>; ArrayList<String>strArray=newArrayList<String><>;strArray=op.addReaderJudgement<>;intn=0;intreplicate=0;while<n<Integer.parseInt<strArray.get<0>>>{n++;if<numberField.getText<>.equals<strArray.get<n>>>{replicate++; } }if<replicate==0>{if<!sexField.getText<>.equals<"boy"> &&!sexField.getText<>.equals<"girl">>{ JOptionPane .showMessageDialog<null,"IntheSexfield,youcanonlyinput'boy'or'girl'！","Warning",JOptionPane.INFORMATION_MESSAGE>; }else{op.saveReader<reader>; JOptionPane.showMessageDialog<null,"Addareadersuccessfully！","Information", JOptionPane.INFORMATION_MESSAGE>; } }else{ JOptionPane.showMessageDialog<null,"Thisreader<number>hasalreadyexisted!","Warning", JOptionPane.INFORMATION_MESSAGE>; } } }}BookDetails.javaimportjava.awt.BorderLayout;importjava.awt.Container;importjava.awt.Dimension;importjava.awt.GridLayout;importjava.awt.event.*;importjava.util.ArrayList;importjavax.swing.*;importjavax.swing.table.DefaultTableModel;publicclassBookDetailsextendsJFrameimplementsActionListener{ SQLOperationop=newSQLOperation<>; Containerc=getContentPane<>; JPanelp1=newJPanel<>; JPanelp2=newJPanel<>; JPanelp3=newJPanel<>; JLabelbookNumber=newJLabel<"BookNumber:">; JLabelbookName=newJLabel<"BookName:">; JLabelauthor=newJLabel<"Author:">; JLabelpress=newJLabel<"Press:">; JLabelpressTime=newJLabel<"Presstime:">; JLabelbookAbstract=newJLabel<"Abstract:">; JLabelstorage=newJLabel<"Storage:">; JLabelremain=newJLabel<"Remain:">; JLabelnumberField=newJLabel<>; JLabelnameField=newJLabel<>; JLabelauthorField=newJLabel<>; JLabelpressField=newJLabel<>; JLabelpressTimeField=newJLabel<>; JLabelabstractField=newJLabel<>; JLabelstorageField=newJLabel<>; JLabelremainField=newJLabel<>; JButtoncancel=newJButton<"Cancel">; JLabeldetails=newJLabel<"Borrowandreaturndetails">; Object[]s={"Readernumber","Borrowtime","Deadline","Overtime"}; Object[][]ob1=newObject[7][4]; JTabletable=newJTable<ob1,s>; JScrollPanescrollPane=newJScrollPane<table>;publicBookDetails<Stringnumber>{ BookInfobook=newBookInfo<number>;ob1=op.borrowListForBook<number>;for<inti=0;i<5;i++>{ DefaultTableModelbooks=newDefaultTableModel<ob1,s>;for<intn=0;n<7;n++>{for<intm=0;m<4;m++>{ob1[n][m]=this.ob1[n][m]; }table.setModel<books>;table.invalidate<>; } } ArrayList<String>strArray=newArrayList<String><>;strArray=op.outputBook<book>;numberField.setText<number>;nameField.setText<strArray.get<1>>;authorField.setText<strArray.get<2>>;pressField.setText<strArray.get<3>>;pressTimeField.setText<strArray.get<4>>;abstractField.setText<strArray.get<5>>;storageField.setText<strArray.get<6>>;remainField.setText<strArray.get<7>>;c.add<p1,BorderLayout.NORTH>;c.add<p2,BorderLayout.CENTER>;c.add<p3,BorderLayout.SOUTH>;p1.setLayout<newGridLayout<9,2,20,10>>;p1.add<bookNumber>;p1.add<numberField>;p1.add<bookName>;p1.add<nameField>;p1.add<author>;p1.add<authorField>;p1.add<press>;p1.add<pressField>;p1.add<pressTime>;p1.add<pressTimeField>;p1.add<bookAbstract>;p1.add<abstractField>;p1.add<storage>;p1.add<storageField>;p1.add<remain>;p1.add<remainField>;p1.add<details>;scrollPane.setBounds<0,0,800,300>;p2.add<scrollPane>;p3.add<cancel>;table.setPreferredScrollableViewportSize<newDimension<400,100>>;cancel.addActionListener<this>; }publicvoidactionPerformed<ActionEvente>{//TODOAuto-generatedmethodstubif<e.getSource<>==cancel>{this.dispose<>; } }}BookInfo.javapublicclassBookInfo{privateStringnumber,name,author,press,pressTime,bookAbstract;privateinttotal,remain;//defaultconstructorpublicBookInfo<>{ }publicBookInfo<Stringnumber>{this.number=number; }publicBookInfo<Stringnumber,Stringname>{this.number=number;=name; }publicBookInfo<Stringnumber,Stringname,Stringauthor,Stringpress, StringpressTime,StringbookAbstract,inttotal,intremain>{this.number=number;=name;this.author=author;this.press=press;this.pressTime=pressTime;this.bookAbstract=bookAbstract;this.total=total;this.remain=remain; }publicvoidsetRemain<inti>{this.remain=i; }publicStringgetNumber<>{returnnumber; }publicStringgetName<>{returnname; }publicStringgetAuthor<>{returnauthor; }publicStringgetPress<>{returnpress; }publicStringgetPressTime<>{returnpressTime; }publicStringgetBookAbstract<>{returnbookAbstract; }publicintgetTotal<>{returntotal; }publicintgetRemain<>{returnremain; }}BookRetrieval.javaimportjava.awt.BorderLayout;importjava.awt.Container;importjava.awt.Dimension;importjava.awt.Font;importjava.awt.GridLayout;importjava.awt.event.*;importjava.util.ArrayList;importjavax.swing.*;importjavax.swing.table.DefaultTableModel;classBookRetrievalextendsJFrameimplementsActionListener{ SQLOperationop=newSQLOperation<>; Containerc=getContentPane<>; JPanelp1=newJPanel<>; JPanelp4=newJPanel<>; JPanelp5=newJPanel<>; JLabelbookNumber=newJLabel<"BookNumber:">; JLabelbookName=newJLabel<"BookName:">; JTextFieldnumber=newJTextField<>; JTextFieldname=newJTextField<>; JButtonback=newJButton<"Back<Fresh>">; JButtonaddBook=newJButton<"Addabook">; JButtondeleteBook=newJButton<"Deleteabook">; JButtoneditBook=newJButton<"Editabook">; JButtonsearch=newJButton<"Searchfordetails!">; JButtonborrowBook=newJButton<"Borrowabook">; JButtonreturnBook=newJButton<"Returnabook">; Fontfont1=newFont<"00",Font.BOLD,20>; Object[]s={"Number","Name","Author","Press","PressTime","Abstract","Storage","Remain"}; Object[][]ob=newObject[40][8]; JTabletable=newJTable<ob,s>; JScrollPanescrollPane=newJScrollPane<table>;publicBookRetrieval<>{ BookInfobook=newBookInfo<>;ob=op.allBook<book>;for<inti=0;i<5;i++>{ DefaultTableModelbooks=newDefaultTableModel<ob,s>;for<intn=0;n<20;n++>{for<intm=0;m<8;m++>{ob[n][m]=this.ob[n][m]; }table.setModel<books>;table.invalidate<>; } }c.add<p4,BorderLayout.NORTH>;c.add<p1,BorderLayout.CENTER>;c.add<p5,BorderLayout.SOUTH>;search.setFont<font1>;p4.setLayout<newGridLayout<2,4,20,10>>;p4.add<back>;p4.add<addBook>;p4.add<editBook>;p4.add<deleteBook>;p4.add<borrowBook>;p4.add<returnBook>;p1.setLayout<null>;scrollPane.setBounds<0,0,800,300>;p1.add<scrollPane>;p5.setLayout<newGridLayout<5,1,0,0>>;p5.add<bookNumber>;p5.add<number>;p5.add<bookName>;p5.add<name>;p5.add<search>;table.setPreferredScrollableViewportSize<newDimension<400,300>>;addBook.addActionListener<this>;search.addActionListener<this>;back.addActionListener<this>;deleteBook.addActionListener<this>;editBook.addActionListener<this>;borrowBook.addActionListener<this>;returnBook.addActionListener<this>; }publicvoidactionPerformed<ActionEvente>{if<e.getSource<>==search>{ ArrayList<String>strArray=newArrayList<String><>;strArray=op.addBookJudgement<>; Strings1=number.getText<>; Strings2=name.getText<>;intn=0;intreplicate=0;while<n<Integer.parseInt<strArray.get<0>>>{n++;if<s1.equals<strArray.get<n>>>{replicate++; } } ArrayList<String>strArray1=newArrayList<String><>;strArray1=op.addBookJudgement1<>;intn1=0;intreplicate1=0;while<n1<Integer.parseInt<strArray1.get<0>>>{n1++;if<s2.equals<strArray1.get<n1>>>{replicate1++; } }if<replicate==0&&replicate1==0>{ JOptionPane.showMessageDialog<null,"Pleaseinputacorrectbooknumberorname!","Warning",JOptionPane.INFORMATION_MESSAGE>; }elseif<replicate!=0||replicate1!=0>{if<replicate==0&&replicate1!=0>{ BookInfobook=newBookInfo<s1,s2>; Strings=op.searchBookByName<book>; BookDetailsf=newBookDetails<s>;//f.setDefaultCloseOperation<JFrame.EXIT_ON_CLOSE>;f.setTitle<"BookDetails">;f.setLocation<300,200>;f.setSize<480,470>;f.setVisible<true>; }elseif<replicate!=0>{ BookDetailsf=newBookDetails<s1>;//f.setDefaultCloseOperation<JFrame.EXIT_ON_CLOSE>;f.setTitle<"BookDetails">;f.setLocation<300,200>;f.setSize<480,470>;f.setVisible<true>; } } }if<e.getSource<>==back>{this.dispose<>; MyFramef=newMyFrame<>;//f.setDefaultCloseOperation<JFrame.EXIT_ON_CLOSE>;f.setTitle<"LibraryManagementSystem">;f.setLocation<300,200>;f.setSize<580,300>;f.setVisible<true>; }if<e.getSource<>==addBook>{ AddBookf=newAddBook<>;//f.setDefaultCloseOperation<JFrame.EXIT_ON_CLOSE>;f.setTitle<"Addabook">;f.setLocation<300,200>;f.setSize<300,400>;f.setVisible<true>; }if<e.getSource<>==deleteBook>{ DeleteBookf=newDeleteBook<>;//f.setDefaultCloseOperation<JFrame.EXIT_ON_CLOSE>;f.setTitle<"Deleteabook">;f.setLocation<300,200>;f.setSize<300,200>;f.setVisible<true>; }if<e.getSource<>==borrowBook>{ BorrowBookf=newBorrowBook<>;//f.setDefaultCloseOperation<JFrame.EXIT_ON_CLOSE>;f.setTitle<"Borrowabook">;f.setLocation<300,200>;f.setSize<300,200>;f.setVisible<true>; }if<e.getSource<>==returnBook>{ ReturnBookf=newReturnBook<>;//f.setDefaultCloseOperation<JFrame.EXIT_ON_CLOSE>;f.setTitle<"Returnabook">;f.setLocation<300,200>;f.setSize<300,200>;f.setVisible<true>; }if<e.getSource<>==editBook>{ SelectEditf=newSelectEdit<>;//f.setDefaultCloseOperation<JFrame.EXIT_ON_CLOSE>;f.setTitle<"Editabook">;f.setLocation<300,200>;f.setSize<300,200>;f.setVisible<true>; } }}BorrowBook.javaimportjava.awt.BorderLayout;importjava.awt.Container;importjava.awt.GridLayout;importjava.awt.event.*;importjava.util.ArrayList;importjavax.swing.*;publicclassBorrowBookextendsJFrameimplementsActionListener{ SQLOperationop=newSQLOperation<>; Containerc=getContentPane<>; JPanelp1=newJPanel<>; JLabelbookNumber=newJLabel<"BookNumber:">; JTextFieldnumberField=newJTextField<>; JLabelreaderNumber=newJLabel<"ReaderNumber:">; JTextFieldreaderNumberField=newJTextField<>; JButtoncancel=newJButton<"Cancel">; JButtonborrow=newJButton<"Borrow!!">;publicBorrowBook<>{c.add<p1,BorderLayout.NORTH>;p1.setLayout<newGridLayout<3,2,20,10>>;p1.add<bookNumber>;p1.add<numberField>;p1.add<readerNumber>;p1.add<readerNumberField>;p1.add<cancel>;p1.add<borrow>;cancel.addActionListener<this>;borrow.addActionListener<this>; }publicvoidactionPerformed<ActionEvente>{//TODOAuto-generatedmethodstubif<e.getSource<>==cancel>{this.dispose<>; }if<e.getSource<>==borrow>{ StringbookNumber=numberField.getText<>; ArrayList<String>strArray=newArrayList<String><>;strArray=op.addBookJudgement<>;intn=0;intreplicate=0;while<n<Integer.parseInt<strArray.get<0>>>{n++;if<bookNumber.equals<strArray.get<n>>>{replicate++; } } StringreaderNumber=readerNumberField.getText<>; ArrayList<String>strArray1=newArrayList<String><>;strArray1=op.addReaderJudgement<>;intn1=0;intreplicate1=0;while<n1<Integer.parseInt<strArray1.get<0>>>{n1++;if<readerNumber.equals<strArray1.get<n1>>>{replicate1++; } }if<replicate==0||replicate1==0>{ JOptionPane .showMessageDialog<null,"Pleaseinputacorrectbooknumberandareadernumber!","Warning",JOptionPane.INFORMATION_MESSAGE>; }else{ BookInfobook=newBookInfo<bookNumber>; ArrayList<String>s=newArrayList<String><>;s=op.outputBook<book>;if<Integer.parseInt<s.get<7>>>0>{ints1=op.reBorrowCheck<numberField.getText<>,readerNumberField.getText<>>;if<s1==1>{ JOptionPane .showMessageDialog<null,"Youhaveborrowedthisbook,cannotreborrowit!","Unsuccessful", JOptionPane.INFORMATION_MESSAGE>; }else{longcurrentTime=System.currentTimeMillis<>;if<op.deadLineCheck<readerNumberField.getText<>,currentTime>!=0>{ JOptionPane .showMessageDialog<null,"Youhaveexceededthedeadline,pleasereturnthesebooksfirst!","Unsuccessful", JOptionPane.INFORMATION_MESSAGE>; }else{ BookInfobook1=newBookInfo<s.get<0>,s.get<1>,s.get<2>,s.get<3>,s.get<4>,s.get<5>, Integer.parseInt<s.get<6>>, Integer.parseInt<s.get<7>>-1>;op.inputBook<book1>; StringborrowTime=Long.toString<System .currentTimeMillis<>>; Stringdeadline=Long.toString<System .currentTimeMillis<>+2592000000l>; System.out.println<borrowTime>; System.out.println<deadline>;op.insertBorrow<numberField.getText<>,readerNumberField.getText<>,borrowTime,deadline>; JOptionPane .showMessageDialog<null,"Borrowedthisbooksuccessfully,youhave30daystoenjoythisbook!","Successful", JOptionPane.INFORMATION_MESSAGE>; } } }else{ JOptionPane.showMessageDialog<null,"Thisbookhasbeenborrowed!","Unsuccessful", JOptionPane.INFORMATION_MESSAGE>; } }this.dispose<>; } }}BorrowList.Javaimportjava.awt.BorderLayout;importjava.awt.Container;importjava.awt.Dimension;import;import;importjava.awt.event.*;import;importjavax.swing.*;importjavax.swing.table.DefaultTableModel;publicclassBorrowListextendsJFrameimplementsActionListener{ SQLOperationop=newSQLOperation<>; Containerc=getContentPane<>; JPanelp1=newJPanel<>; JPanelp2=newJPanel<>; JButtonback=newJButton<"Back">; Object[]s={"Booknumber","Readernumber","Borrowtime","Deadline","OverTime"}; Object[][]ob=newObject[100][5]; JTabletable=newJTable<ob,s>; JScrollPanescrollPane=newJScrollPane<table>;publicBorrowList<>{//TODOAuto-generatedconstructorstub Object[][]ob1=op.borrowList<>;for<inti=0;i<5;i++>{ DefaultTableModellist=newDefaultTableModel<ob,s>;for<intn=0;n<100;n++>{for<intm=0;m<5;m++>{ob[n][m]=ob1[n][m]; }table.setModel<list>;table.invalidate<>; } }c.add<p1,BorderLayout.CENTER>;c.add<p2,BorderLayout.SOUTH>;scrollPane.setBounds<0,0,800,300>;p1.add<scrollPane>;p2.add<back>;table.setPreferredScrollableViewportSize<newDimension<400,400>>;back.addActionListener<this>; }publicvoidactionPerformed<ActionEvente>{if<e.getSource<>==back>{this.dispose<>; MyFramef=newMyFrame<>;f.setDefaultCloseOperation<JFrame.EXIT_ON_CLOSE>;f.setTitle<"LibraryManagementSystem">;f.setLocation<300,200>;f.setSize<580,300>;f.setVisible<true>; }//TODOAuto-generatedmethodstub }}Date.javaimportjava.text.DateFormat;importjava.text.SimpleDateFormat;publicclassDate{publicDate<>{ }staticStringborrowTimeInterface<longtime>{ SimpleDateFormatdf=<SimpleDateFormat>DateFormat.getInstance<>;df.applyPattern<"yyyy-MM-dd">; Strings=df.format<time>;returns; }}DeleteBook.javaimportjava.awt.BorderLayout;importjava.awt.Container;importjava.awt.GridLayout;importjava.awt.event.*;importjavax.swing.*;publicclassDeleteBookextendsJFrameimplementsActionListener{ SQLOperationop=newSQLOperation<>; Containerc=getContentPane<>; JPanelp1=newJPanel<>; JLabelbookNumber=newJLabel<"BookNumber:">; JTextFieldnumberField=newJTextField<>; JButtoncancel=newJButton<"Cancel">; JButtondelete=newJButton<"Delete!!">;publicDeleteBook<>{c.add<p1,BorderLayout.NORTH>;p1.setLayout<newGridLayout<2,2,20,10>>;p1.add<bookNumber>;p1.add<numberField>;p1.add<cancel>;p1.add<delete>;cancel.addActionListener<this>;delete.addActionListener<this>; }publicvoidactionPerformed<ActionEvente>{//TODOAuto-generatedmethodstubif<e.getSource<>==cancel>{this.dispose<>; }if<e.getSource<>==delete>{ BookInfobook=newBookInfo<numberField.getText<>>;this.dispose<>;if<op.deleteBookCheck<numberField.getText<>>!=0>{ JOptionPane .showMessageDialog<null,"Deletethebookunsuccessfully.Thebookbasbeenborrowed!","Warning",JOptionPane.INFORMATION_MESSAGE>; }else{if<op.deleteBook<book>==1>{ JOptionPane.showMessageDialog<null,"Deletethebooksuccessfully！","Information", JOptionPane.INFORMATION_MESSAGE>; }else{ JOptionPane .showMessageDialog<null,"Deletethebookunsuccessfully.Thebookdoesnotexist!","Warning",JOptionPane.INFORMATION_MESSAGE>; } } } }}DeleteReader.javaimportjava.awt.BorderLayout;importjava.awt.Container;importjava.awt.GridLayout;importjava.awt.event.*;importjavax.swing.*;publicclassDeleteReaderextendsJFrameimplementsActionListener{ SQLOperationop=newSQLOperation<>; Containerc=getContentPane<>; JPanelp1=newJPanel<>; JLabelreaderNumber=newJLabel<"ReaderNumber:">; JTextFieldnumberField=newJTextField<>; JButtoncancel=newJButton<"Cancel">; JButtondelete=newJButton<"Delete!!">;publicDeleteReader<>{c.add<p1,BorderLayout.NORTH>;p1.setLayout<newGridLayout<2,2,20,10>>;p1.add<readerNumber>;p1.add<numberField>;p1.add<cancel>;p1.add<delete>;cancel.addActionListener<this>;delete.addActionListener<this>; }publicvoidactionPerformed<ActionEvente>{//TODOAuto-generatedmethodstubif<e.getSource<>==cancel>{this.dispose<>; }if<e.getSource<>==delete>{ ReaderInforeader=newReaderInfo<numberField.getText<>>;this.dispose<>;if<op.deleteReaderCheck<numberField.getText<>>!=0>{ JOptionPane .showMessageDialog<null,"Deletethereaderunsuccessfully.Pleasereturnbooksfirst!","Warning",JOptionPane.INFORMATION_MESSAGE>; }else{if<op.deleteReader<reader>==1>{ JOptionPane.showMessageDialog<null,"Deletethereadersuccessfully！","Information", JOptionPane.INFORMATION_MESSAGE>; }else{ JOptionPane .showMessageDialog<null,"Deletethereaderunsuccessfully.Thereaderdoesnotexist!","Warning",JOptionPane.INFORMATION_MESSAGE>; } } } }}EditBook.javaimportjava.awt.BorderLayout;importjava.awt.Container;importjava.awt.GridLayout;importjava.awt.event.*;importjava.util.ArrayList;importjavax.swing.*;publicclassEditBookextendsJFrameimplementsActionListener{ SQLOperationop=newSQLOperation<>; Containerc=getContentPane<>; JPanelp1=newJPanel<>; JLabelbookNumber=newJLabel<"BookNumber:">; JLabelbookName=newJLabel<"BookName:">; JLabelauthor=newJLabel<"BookAuthor:">; JLabelpress=newJLabel<"Press:">; JLabelpressTime=newJLabel<"Presstime:">; JLabelbookAbstract=newJLabel<"Abstract:">; JLabelstorage=newJLabel<"Storage:">; JLabelremain=newJLabel<"Remain:">; JLabelremain1=newJLabel<"Updatewithstorage">; JLabelnumberField=newJLabel<>; JTextFieldnameField=newJTextField<>; JTextFieldauthorField=newJTextField<>; JTextFieldpressField=newJTextField<>; JTextFieldpressTimeField=newJTextField<>; JTextFieldabstractField=newJTextField<>; JTextFieldstorageField=newJTextField<>; JTextFieldtemp1=newJTextField<>; JTextFieldtemp2=newJTextField<>; JButtoncancel=newJButton<"Cancel">; JButtonsave=newJButton<"Save!!">;publicEditBook<Stringnumber>{ BookInfobook=newBookInfo<number>; ArrayList<String>strArray=newArrayList<String><>;strArray=op.outputBook<book>;numberField.setText<number>;nameField.setText<strArray.get<1>>;authorField.setText<strArray.get<2>>;pressField.setText<strArray.get<3>>;pressTimeField.setText<strArray.get<4>>;abstractField.setText<strArray.get<5>>;storageField.setText<strArray.get<6>>;temp1.setText<strArray.get<6>>;temp2.setText<strArray.get<7>>;c.add<p1,BorderLayout.NORTH>;p1.setLayout<newGridLayout<9,2,20,10>>;p1.add<bookNumber>;p1.add<numberField>;p1.add<bookName>;p1.add<nameField>;p1.add<author>;p1.add<authorField>;p1.add<press>;p1.add<pressField>;p1.add<pressTime>;p1.add<pressTimeField>;p1.add<bookAbstract>;p1.add<abstractField>;p1.add<storage>;p1.add<storageField>;p1.add<remain>;p1.add<remain1>;p1.add<cancel>;p1.add<save>;cancel.addActionListener<this>;save.addActionListener<this>; }publicvoidactionPerformed<ActionEvente>{//TODOAuto-generatedmethodstubif<e.getSource<>==cancel>{this.dispose<>; }if<e.getSource<>==save>{inti=Integer.parseInt<storageField.getText<>> -Integer.parseInt<temp1.getText<>> +Integer.parseInt<temp2.getText<>>; BookInfobook=newBookInfo<numberField.getText<>,nameField.getText<>,authorField.getText<>,pressField.getText<>,pressTimeField.getText<>,abstractField.getText<>,Integer.parseInt<storageField .getText<>>,i>;op.inputBook<book>; JOptionPane.showMessageDialog<null,"Editthebooksuccessfully！","Information",JOptionPane.INFORMATION_MESSAGE>;this.dispose<>; } }}EditReader.javaimportjava.awt.BorderLayout;importjava.awt.Container;importjava.awt.GridLayout;importjava.awt.event.*;importjava.util.ArrayList;importjavax.swing.*;publicclassEditReaderextendsJFrameimplementsActionListener{ SQLOperationop=newSQLOperation<>; Containerc=getContentPane<>; JPanelp1=newJPanel<>; JLabelreaderNumber=newJLabel<"ReaderNumber:">; JLabelreaderName=newJLabel<"ReaderName:">; JLabelsex=newJLabel<"Sex:">; JLabeldpt=newJLabel<"Department:">; JLabelgrade=newJLabel<"Grade:">; JLabelnumberField=newJLabel<>; JTextFieldnameField=newJTextField<>; JTextFieldsexField=newJTextField<>; JTextFielddptField=newJTextField<>; JTextFieldgradeField=newJTextField<>; JButtoncancel=newJButton<"Cancel">; JButtonsave=newJButton<"Save!!">;publicEditReader<Stringnumber>{numberField.setText<number>; ReaderInforeader=newReaderInfo<number>; ArrayList<String>strArray=newArrayList<String><>;strArray=op.outputReader<reader>; System.out.println<strArray>;numberField.setText<number>;nameField.setText<strArray.get<1>>;sexField.setText<strArray.get<2>>;dptField.setText<strArray.get<3>>;gradeField.setText<strArray.get<4>>