图书馆书库管理系统_图书管理系统的附录

5.6流通系统界面

图5.4 借书界面图                                图5.5 还书界面图                   

                           图5.6 领书界面图

5.7查询系统界面

     图5.7 查询书籍界面                          图5.8 查房记录界面

5.8编目系统界面

                              图5.9 新书编目界面图

           图5.10更新书籍界面图                     图5.11会员注册界面图

第六章 模块设计

6.1文档介绍

6.1.1文档目的

     模块化设计是把一个整体划分为几个局部，而这些局部又可能可以再划分为更小的局部，这些局部就是模块，当我们开发具有独立功能而且和其他模块之间没有过多的相互作用的模块，就可以做到模块独立。换句话说，希望这样设计软件结构，使得每个模块完成一个相对独立的特定子功能，并且和其他模块之间的关系很简单。

6.1.2文档范围

     模块化设计是一种结构化的设计，是程序内部的具体功能设计。

6.1.3读者对象

     对象是设计代码的工作者。

6.2模块命名规则

     模块的命名规则是根据模块的功能和类的来命名的。如借书模块，显然这个模块是实现学生或老师向图书馆借书的功能。

6.3模块总汇

6.3.1模块总汇表 

表6.1 子系统表

表6.2 子系统表

6.3.2模块关系图

图6.1 模块关系图

6.4模块设计

6.4.1采购管理系统的模块设计

订购模块：

取消订购模块：

6.4.2流通管理系统的模块设计

借书模块：

还书模块

领取书籍模块：

6.4.3查询系统的模块设计

查询书籍模块：

查找记录模块：

6.4.4编目系统的模块设计

新书编目模块：

更新书籍模块：

会员模块：

第七章 软件测试

7.1软件测试的目标

   （1）制定程序测试方案

(2)利用测试方案找到程序的错误

(3)发现到今尚未发现的错误

7．2软件测试准则

  (1)所有测试都应该能追溯到用户需求

  (2)应该远在测试开始之前就制定出测试计划

  (3)应该从“小规模”测试开始，并逐步进行“大规模”测试。

  (4)为了达到最佳的测试效果，应该由独立的第三方从事测试工作。

7．3测试方法

   测试任何产品都有两种方法：黑盒测试和白盒测试。

7．4测试步骤

   (1)模块测试

   (2)子系统测试

   (3)系统测试

   (4)验收测试

   (5)平行运行

7.5接口测试用

第八章 结论

图书馆书库管理系统是一个以计算机为工具，对图书馆管理信息进行处理的人——机系统，它能准确、及时地反映图书馆当前书籍信息状态，能利用过去的数据统计分析，能从全局出发辅助图书馆管理人员管理图书馆书籍。可见，工商管理系统首先必须具有强大的电子数据处理功能，能大大提高学校管理人员的工作效率，减轻劳动强度，同时，该系统应当采用管理模型，将仿真、优化等现代决策手段结合起来，为学校管理层的决策提供有效信息。通过这次设计我除了在程序设计水平和数据库应用能力上有了很大程度的提高，也更加深入了理解了JAVA SWING 和SQL SERVER 2000设计中常见问题和的其设计的意义。

由于设计此类系统经验不足，时间有限，尤其是对图书馆管理流程的认识不足，虽然目前顺利完成了系统的调研、分析、设计和调试的工作，但是仍然有许多不足之处，我们会在将来的软件设计过程中引以为戒。

致谢

首先，我要衷心感谢我的所有教学老师。在我攻读学士学位的四年期间，他们在学习上对我严格要求，在生活上对我关怀备至。其中特别要感谢老师，他在毕业论文上给予我精心而有效的指导，使我顺利的结束了大学里的最后一堂课，所有一切将永远留在我的记忆中。

感谢我的导师对我的指导和关怀。一直以来，刘老师不遗余力地为我创造了许多学习和实践的机会。他的悉心指导不仅使我的专业技能水平得到了提高而且使我的抽象思维能力和表达能力大大提高。刘老师不但具有渊博的知识和很高的治学水平，他崇高的道德情操更是我们学习的榜样。

同时也为我以后的学习和工作生涯打下了坚实的基础。

其次，我要感谢和我同课题的同学及其他帮助过我的人，他们给予我所需要的资料，必要时给予我鼓励。我所取得的成绩与他们的帮助是分不开的。我也十分感谢我周围的同学。他们在学术上给予我有益的帮助和启发，使我获益非浅。

最后，我要感谢我的父母、亲友，是他们一直在支持我、鼓励我，使我能够顺利地完成学业。

参考文献

[1] 张海藩. 软件工程导论(第四版). 北京：清华大学出版社，2003.

[2] 耿祥义，张跃平. Java2实用教程(修订). 北京：清华大学出版社，2001

[3]萨师煊，王珊. 数据库系统概论(第三版). 北京：高等教育出版社，2004

[4]Rob Hawthorne. SQL SERVER 2000从零开始(第一版). 北京：人民邮电出版社，2001

附录Ａ　安装说明

１.安装j2sdk1.4.2_04

把本软件安装电脑Ｃ盘上，安装成功后点击我的电脑，进行环境变量的设置，新建环境变量，变量名输入：path。变量值输入：你安装的JDK的路径

再打开DOS，在Ｃ盘符上输入set path=你安装的JDK的路径。回车即可

打入javac就会出一大堆帮助，那就表示安装成功。

２.安装SQL Server 2000

把本软件安装在电脑Ｃ盘上，在安装过程中关键是设置管理账号。安装好之后要导入数据,数据库里就会有图书馆系统的数据。

3.安装JDBC数据源

　　到控制面版点击JDBC数据源，新建数据库源，再进行配置，最后测试能否连上数据库。

附录B

原代码：主界面代码：

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

public class JLibrary extends JFrame implements ActionListener

{

 private JMenuBar menubar = new JMenuBar();

 private JMenu fileMenu,newbookMenu,searchMenu,getbooksMenu,buyMenu,addmembersMenu;

 private JMenuItem borrowbook,returnbook,print,exit,addbook,searchbook,updata,

         getbook,searchrecord,list1,list2,addmember;

 private borrowB borrow;

 private returnB returnb;

 private takeB takeb;

 private Addbs Addbss;

 private bbk bbks;

 private searchB searchb;

 private updataB updatab;

 private CancleList Canclelist;

 private SearchRecord Searchrecord;

 private membersID members;

 /*private borrowbooks borrowBook;

 private returnbooks returnBook;

 private addbooks addBook;

 private searchbooks searchBook;

 private getbooks getbook;

 private lists List1,List2;*/

 public JDesktopPane desktop = new JDesktopPane();

 public JLibrary()

 {

    super("LibrarySystem");

    

     setJMenuBar(menubar= new JMenuBar());

     menubar.add(fileMenu=new JMenu("文件"));

     menubar.add(newbookMenu=new JMenu("新书登记"));

     menubar.add(searchMenu=new JMenu("查询"));

     menubar.add(getbooksMenu=new JMenu("领书"));

     menubar.add(buyMenu=new JMenu("采购"));

     menubar.add(addmembersMenu=new JMenu("增加会员"));

     fileMenu.add(borrowbook=new JMenuItem("借书"));

     fileMenu.add(returnbook=new JMenuItem("还书"));

     fileMenu.add(print=new JMenuItem("打印"));

     fileMenu.add(exit=new JMenuItem("退出"));

     

       borrowbook.addActionListener(this);

       returnbook.addActionListener(this);

       print.addActionListener(this);

       exit.addActionListener(this);

       

     newbookMenu.add(addbook=new JMenuItem("新书编号"));

     newbookMenu.add(updata=new JMenuItem("更新书籍"));

       addbook.addActionListener(this);

       updata.addActionListener(this);

       

     searchMenu.add(searchbook=new JMenuItem("查找书籍"));

     searchMenu.add(searchrecord=new JMenuItem("查找记录"));

       searchbook.addActionListener(this);

       searchrecord.addActionListener(this);

       

     getbooksMenu.add(getbook=new JMenuItem("领取书籍"));

       getbook.addActionListener(this);

       

     buyMenu.add(list1=new JMenuItem("订购书籍"));

     buyMenu.add(list2=new JMenuItem("取消订购"));

       list1.addActionListener(this);

       list2.addActionListener(this);

       

     addmembersMenu.add(addmember=new JMenuItem("注册"));

       addmember.addActionListener(this);

       

     Container con=getContentPane();

    con.add(desktop);

     desktop.setDragMode(JDesktopPane.OUTLINE_DRAG_MODE);

     addWindowListener(

                             new WindowAdapter() {

                                public void windowClosing(WindowEvent e) {

                                   System.exit(0);

                                }

                             });

     Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();

         int width = 750, height = 550;

         if(screenSize.width >800)

            width = 950;

         if (screenSize.height >600)

            height = 650;

         setSize(width, height);

         setLocation((screenSize.width - width)/2,(screenSize.height-height) / 2);

         setVisible(true);

  }

  public void actionPerformed(ActionEvent ae) {

          if(ae.getSource() ==borrowbook) {

            Thread runner =

               new Thread() {

                  public void run() {

                     borrow=new borrowB();

                     desktop.add(borrow);

                     try {

                        borrow.setSelected(true);

                     }

                        catch(java.beans.PropertyVetoException e) {

                        }

                  }

               };

            runner.start();

         }

        if(ae.getSource() == returnbook) {

            Thread runner =

               new Thread() {

                  public void run() {

                     returnb=new returnB();

                     desktop.add(returnb);

                     try {

                        returnb.setSelected(true);

                     }

                        catch(java.beans.PropertyVetoException e) {

                        }

                  }

               };

            runner.start();

         }

           if(ae.getSource() == addbook) {

            Thread runner =

               new Thread() {

                  public void run() {

                     Addbss=new Addbs();

                     desktop.add(Addbss);

                     try {

                        Addbss.setSelected(true);

                     }

                        catch(java.beans.PropertyVetoException e) {

                        }

                  }

               };

            runner.start();

         }

          if(ae.getSource() ==updata) {

            Thread runner =

               new Thread() {

                  public void run() {

                     updatab=new updataB();

                     desktop.add(updatab);

                     try {

                        updatab.setSelected(true);

                     }

                        catch(java.beans.PropertyVetoException e) {

                        }

                  }

               };

            runner.start();

         }

        if(ae.getSource() ==searchbook) {

            Thread runner =

               new Thread() {

                  public void run() {

                     searchb =new searchB();

                     desktop.add(searchb);

                     try {

                        searchb.setSelected(true);

                     }

                        catch(java.beans.PropertyVetoException e) {

                        }

                  }

               };

            runner.start();

         }

         if(ae.getSource()==getbook) {

            Thread runner =

               new Thread() {

                  public void run() {

                     takeb=new takeB();

                     desktop.add(takeb);

                     try {

                        takeb.setSelected(true);

                     }

                        catch(java.beans.PropertyVetoException e) {

                        }

                  }

               };

            runner.start();

         }

        if(ae.getSource() ==list1) {

            Thread runner =

               new Thread() {

                  public void run() {

                     bbks =new bbk();

                     desktop.add(bbks);

                     try {

                        bbks.setSelected(true);

                     }

                        catch(java.beans.PropertyVetoException e) {

                        }

                  }

               };

            runner.start();

         }

     

         

          /*  if(ae.getSource() == exit) {

            dispose();

            System.exit(0);

         }*/

         if(ae.getSource() ==list2) {

            Thread runner =

               new Thread() {

                  public void run() {

                     Canclelist=new CancleList();

                     desktop.add(Canclelist);

                     try {

                        Canclelist.setSelected(true);

                     }

                        catch(java.beans.PropertyVetoException e) {

                        }

                  }

               };

            runner.start();

         }

         if(ae.getSource() ==searchrecord) {

            Thread runner =

               new Thread() {

                  public void run() {

                     Searchrecord=new SearchRecord();

                     desktop.add(Searchrecord);

                     try {

                        Searchrecord.setSelected(true);

                     }

                        catch(java.beans.PropertyVetoException e) {

                        }

                  }

               };

            runner.start();

         }

         if(ae.getSource() ==addmember) {

            Thread runner =

               new Thread() {

                  public void run() {

                     members=new membersID();

                     desktop.add(members);

                     try {

                        members.setSelected(true);

                     }

                        catch(java.beans.PropertyVetoException e) {

                        }

                  }

               };

            runner.start();

         }

      }

      public static void main(String arg[])

      {JLibrary win=new JLibrary();

       /*new Thread().start();*/

      }

 }

订购代码：

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

public class bbk extends JInternalFrame implements ActionListener

{ JTextField text1,text2,text3,text4,text5,text6;JButton button1,button2;

  bbk()

  {super("booklist",true,true,true,true);

  Container con=getContentPane();

  setVisible(true);

  try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}

     catch(ClassNotFoundException e){}

     try{Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

     Statement Stmt=Con.createStatement();}

     catch(SQLException ee){}

  

  text1=new JTextField(10);text2=new JTextField(10);

  text3=new JTextField(10);text4=new JTextField(10);

  text5=new JTextField(10);text6=new JTextField(10);

  button1=new JButton("提交");button2=new JButton("取消");

  button1.addActionListener(this);button2.addActionListener(this);

  JPanel p1=new JPanel();JPanel p2=new JPanel();

  p1.setLayout(new GridLayout(6,2));

  p1.add(new Label("会员号"));p1.add(text1);

  p1.add(new Label("书名"));p1.add(text2);

  p1.add(new Label("出版社"));p1.add(text3);

  p1.add(new Label("作者"));p1.add(text4);

  p1.add(new Label("数量"));p1.add(text5);

  p1.add(new Label("订书时间"));p1.add(text6);text6.setText(new java.util.Date().toString());

  text6.setEditable(false);

  p2.add(button1);p2.add(button2);

  con.add(p1,BorderLayout.NORTH);con.add(p2,BorderLayout.SOUTH);

  pack();

 }

   public void actionPerformed(ActionEvent e)

   { if(e.getSource()==button1)

       {try{bbk1();}

       catch(SQLException ee){}

       }

    if(e.getSource()==button2)

        {setVisible(false);}

   }

   public void bbk1() throws SQLException

   { String s1="'"+text1.getText().trim()+"'",

            s2="'"+text2.getText().trim()+"'",

            s3="'"+text3.getText().trim()+"'",

            s4="'"+text4.getText().trim()+"'",

            s5="'"+text5.getText().trim()+"'",

            s6="'"+text6.getText().trim()+"'";

   

    Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

    Statement Stmt=Con.createStatement();

    String temp="INSERT INTO List(MembersID,BookName,Edition,Author,Quantity,Bookdate) VALUES("+s1+","+s2+","+s3+","+s4+","+s5+","+s6+")";

              

    Stmt.executeUpdate(temp);

    JOptionPane.showMessageDialog(null,"成功订货","success",JOptionPane.INFORMATION_MESSAGE);

    text1.setText(null);text2.setText(null);text3.setText(null);

    text4.setText(null);text5.setText(null);

    Con.close();

    }

   public static void main(String args[])

     {bbk win=new bbk();}

  }

  

取消订购代码：

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

public class CancleList extends JInternalFrame implements ActionListener

{ JTextField text,text1,text2,text3,text4;JButton button1,button2,button3;

  int www=0;

  public CancleList()

  { super("cancla",true,true,true,true);

    setVisible(true);

       try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}

       catch(ClassNotFoundException e){}

       try{Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

       Statement sql=Con.createStatement();}

       catch(SQLException ee){}

    Container con=getContentPane();

    text=new JTextField(10);

    button1=new JButton("查找");

    JPanel p1=new JPanel();

    p1.add(new Label("订单号"));p1.add(text);p1.add(button1);

    button1.addActionListener(this);

         text1=new JTextField(10);text2=new JTextField(10);

         text3=new JTextField(10);text4=new JTextField(10);

         button2=new JButton("更改订单");button3=new JButton("取消订单");

         JPanel p2=new JPanel(),p3=new JPanel();

         p2.setLayout(new GridLayout(4,2));

         p2.add(new Label("书名"));p2.add(text1);

         p2.add(new Label("作者"));p2.add(text2);

         p2.add(new Label("出版社"));p2.add(text3);

         p2.add(new Label("订购数量"));p2.add(text4);

         p3.add(button2);p3.add(button3);

         button2.addActionListener(this);button3.addActionListener(this);

    con.add(p1,BorderLayout.NORTH);con.add(p2,BorderLayout.CENTER);

    con.add(p3,BorderLayout.SOUTH);

    pack();

  }

    public void actionPerformed(ActionEvent e)

    { if(e.getSource()==button1)

        {www=0;

          try{search1();}

          catch(SQLException ee){}

         }

      

      if(e.getSource()==button2)

        {try{update1();}

         catch(SQLException ee){}

        }

        

      if(e.getSource()==button3)

        {try{cancle();}

        catch(SQLException ee){}

        }

     }

     public void search1() throws SQLException

     { String listnumber,bookname,author,edition,quantity;

              Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

              Statement sql=Con.createStatement();

              ResultSet rs=sql.executeQuery("SELECT * FROM List");

              while(rs.next())

              {listnumber=rs.getString("ListNumber");

               bookname=rs.getString("BookName");

               author=rs.getString("Author");

               edition=rs.getString("Edition");

               quantity=rs.getString("Quantity");

                    if(listnumber.trim().equals(text.getText().trim()))

                      {text1.setText(bookname);text2.setText(author);text3.setText(edition);

                       text4.setText(quantity);www=1;break;

                      }

               }

               if(www==0)

               {text.setText("没有此订单");}

      }

      public void update1() throws SQLException

      { String s1="'"+text1.getText().trim()+"'",

               s2="'"+text2.getText().trim()+"'",         

               s3="'"+text3.getText().trim()+"'",

               s4="'"+text4.getText().trim()+"'",

               s="'"+text.getText().trim()+"'";

        String temp="UPDATE List SET BookName="+s1+",Author="+s2+",Edition="+s3+",Quantity="+s4+" WHERE ListNumber="+s+"";

                 Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

                 Statement sql=Con.createStatement();

                 sql.executeUpdate(temp);

                 JOptionPane.showMessageDialog(null,"更改成功","success",JOptionPane.INFORMATION_MESSAGE);

                 text.setText(null);text1.setText(null);text2.setText(null);

                 text3.setText(null);text4.setText(null);

                 Con.close();

       }          

       public void cancle()throws SQLException

       { String s="'"+text.getText().trim()+"'";

         String temp="DELETE FROM List WHERE ListNumber="+s+"";

                 Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

                 Statement sql=Con.createStatement();

                 sql.executeUpdate(temp);

                 JOptionPane.showMessageDialog(null,"取消订货","success",JOptionPane.INFORMATION_MESSAGE);   

                 text.setText(null);text1.setText(null);text2.setText(null);

                 text3.setText(null);text4.setText(null);

                 Con.close();

       }

         

         

                     

        public static void main(String args[])

     {CancleList win=new CancleList();}

}

      

     

借书：

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

public class borrowB extends JInternalFrame implements ActionListener

{ JTextField text,text1,text2,text3,text4,text5;JButton button1,button2,button3;JSplitPane split;

  private searchB searchb;

  private membersID memberID;

  int www=0;

  

  borrowB()

  {super("borrow",true,true,true,true);

   Container con=getContentPane();

   setVisible(true);setSize(100,100);

     try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}

     catch(ClassNotFoundException e){}

     try{Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

     Statement Stmt=Con.createStatement();}

     catch(SQLException ee){}

     text=new JTextField(10);

   text1=new JTextField(10);text2=new JTextField(10);

   text3=new JTextField(10);text4=new JTextField(10);

   text5=new JTextField(10);

   text1.setEditable(false);text2.setEditable(false);

   text3.setEditable(false);text4.setEditable(false);

   text5.setEditable(false);

   

   button1=new JButton("借书");button2=new JButton("取消");

   button3=new JButton("登陆");

   JPanel p1=new JPanel();JPanel p2=new JPanel();JPanel p3=new JPanel();

   p1.add(new Label("输入会员号"));p1.add(text);

   p1.add(button3);

   p2.setLayout(new GridLayout(6,2));

   

    p2.add(new Label("书的作者"));p2.add(text1);

    p2.add(new Label("书的号码"));p2.add(text2);

    p2.add(new Label("书的名字"));p2.add(text3);

    p2.add(new Label("书的出版社"));p2.add(text4);

    p2.add(new Label("借书日期"));p2.add(text5);text5.setText(new java.util.Date().toString());

    p2.add(new Label("登陆后请填写以上信息"));

    p3.add(button1);p3.add(button2);

  

   button1.addActionListener(this);

   button2.addActionListener(this);

   button3.addActionListener(this);

   con.add(p1,BorderLayout.NORTH);con.add(p2,BorderLayout.CENTER);

   con.add(p3,BorderLayout.SOUTH);

   pack();

   

    }

   public void actionPerformed(ActionEvent e)

   {if(e.getSource()==button3)

      {www=0;

       try{search1();}

      catch(SQLException ee){}

      }

      

     if(e.getSource()==button1)

     {try{borrow1();}

      catch(SQLException ee){}

     }

     

     if(e.getSource()==button2)

      {setVisible(false);}

    }

 public void search1() throws SQLException

 {String IDnumber;

         Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

         Statement Stmt=Con.createStatement();

         ResultSet rs=Stmt.executeQuery("SELECT * FROM Member");

         while(rs.next())

          {IDnumber=rs.getString("MembersID");

           if(IDnumber.equals(text.getText().trim()))

            {text1.setEditable(true);text2.setEditable(true);

            text3.setEditable(true);text4.setEditable(true);

           www=1;break;

             }

           }

           Con.close();

           

            if(www==0)

                   {text.setText("没有此ID");

                   text1.setEditable(false);text2.setEditable(false);

                   text3.setEditable(false);text4.setEditable(false);}

           

 }

 public void borrow1() throws SQLException

 {String s1="'"+text1.getText().trim()+"'",

         s2="'"+text2.getText().trim()+"'",

         s3="'"+text3.getText().trim()+"'",

         s4="'"+text4.getText().trim()+"'",

         s5="'"+text5.getText().trim()+"'",

         s6="'"+text.getText().trim()+"'";

   

   Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

   Statement Stmt=Con.createStatement();

   String temp="INSERT INTO BorrowRecord(Author,BooksID,BookName,Edition,Borrowdate,MembersID) VALUES ("+s1+","+s2+","+s3+","+s4+","+s5+","+s6+")";

              

  Stmt.executeUpdate(temp);

  JOptionPane.showMessageDialog(null,"成功借出","success",JOptionPane.INFORMATION_MESSAGE);

  text1.setText(null);text2.setText(null);text3.setText(null);

  text4.setText(null);

  Con.close();

  }

 public static void main(String args[])

   {borrowB win=new borrowB();

   }

 }

还书：

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

public class returnB extends JInternalFrame implements ActionListener

{JTextField text1,text2,text3,text4,text5;JButton button1,button2,button3;

  public returnB()

  {super("return",true,true,true,true);

   setVisible(true);setBounds(300,200,200,150);

          try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}

             catch(ClassNotFoundException e){}

          try{Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

             Statement sql=Con.createStatement();}

             catch(SQLException ee){}

   Container con=getContentPane();

   text1=new JTextField(10);text2=new JTextField(10);

   text3=new JTextField(10);text4=new JTextField(10);

   text5=new JTextField(10);

   button1=new JButton("查询");button2=new JButton("还书");button3=new JButton("取消");

   JPanel p1=new JPanel();JPanel p2=new JPanel(),p3=new JPanel();

      p1.add(new Label("书号"));p1.add(text1);p1.add(button1);

      p2.setLayout(new GridLayout(4,2));

      p2.add(new Label("会员号"));p2.add(text2);

      p2.add(new Label("书名"));p2.add(text3);

      p2.add(new Label("借书日期"));p2.add(text4);

      p2.add(new Label("借书记录号"));p2.add(text5);

      p3.add(button2);p3.add(button3);

   button1.addActionListener(this);

   button2.addActionListener(this);

   button3.addActionListener(this);

   con.add(p1,BorderLayout.NORTH);

   con.add(p2,BorderLayout.CENTER);

   con.add(p3,BorderLayout.SOUTH);

   pack();

  }

 public void actionPerformed(ActionEvent e)

  {if(e.getSource()==button1)

      {try{return1();}

       catch(SQLException ee){}

      }

   if(e.getSource()==button2)

      {try{del();}

      catch(SQLException ee){}

      }

   if(e.getSource()==button3)

   { setVisible(false);}

  }

  public void return1() throws SQLException

  {String bookID,memberID,bookname,borrowdate,recordnumber;

          Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

          Statement sql=Con.createStatement();

          ResultSet rs=sql.executeQuery("SELECT * FROM BorrowRecord");

          

          while(rs.next())

          { recordnumber=rs.getString("RecordNumber");

            bookID=rs.getString("BooksID");

            memberID=rs.getString("MembersID");

            borrowdate=rs.getString("Borrowdate");

            bookname=rs.getString("BookName");

            

               if(bookID.trim().equals(text1.getText().trim()))

               {text2.setText(memberID);

                text4.setText(borrowdate);

                text3.setText(bookname);

                text5.setText(recordnumber);

                

               }

            }

            Con.close();

            

            

    }

     public void del() throws SQLException

     {  String s="'"+text5.getText().trim()+"'";

      String temp="DELETE FROM BorrowRecord WHERE RecordNumber="+s+"";

     

      Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

        Statement sql=Con.createStatement();

        

        sql.executeUpdate(temp);

        JOptionPane.showMessageDialog(null,"成功还书","success",JOptionPane.INFORMATION_MESSAGE);

        Con.close();

     }

        

       

          

          

public static void main(String args[])

   {returnB win=new returnB();}

 }

   

   

   

领取书籍：

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

public class takeB extends JInternalFrame implements ActionListener

{JTextField text1,text2,text3,text4,text5,text6;

 JButton button1,button2,button3;int www=0;

 public takeB()

   {super("getbook",true,true,true,true);

    Container con=getContentPane();

    setVisible(true);

    try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}

       catch(ClassNotFoundException e){}

       try{Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

       Statement sql=Con.createStatement();}

       catch(SQLException ee){}

    text1=new JTextField(10);text2=new JTextField(10);

    text3=new JTextField(10);text4=new JTextField(10);

    text5=new JTextField(10);text6=new JTextField(10);

    button1=new JButton("领书");button2=new JButton("取消");

    button3=new JButton("查找订单");

    button1.addActionListener(this);

    button2.addActionListener(this);

    button3.addActionListener(this);

    JPanel p1=new JPanel();JPanel p2=new JPanel(),p3=new JPanel();

    p3.add(new Label("输入订单号"));p3.add(text6);p3.add(button3);

    p1.setLayout(new GridLayout(5,2));

    p1.add(new Label("订货会员号"));p1.add(text1);

    p1.add(new Label("书的名字"));p1.add(text2);

    p1.add(new Label("出版社"));p1.add(text3);

    p1.add(new Label("作者"));p1.add(text4);

    p1.add(new Label("数量"));p1.add(text5);

    p2.add(button1);p2.add(button2);

    con.add(p3,BorderLayout.NORTH);con.add(p1,BorderLayout.CENTER);

    con.add(p2,BorderLayout.SOUTH);

    pack();

   

   }

    public void actionPerformed(ActionEvent e)

    {if(e.getSource()==button3)

      {www=0;

       try{takeb1();}

       catch(SQLException ee){}

      }

      

       

      

     if(e.getSource()==button2)

        {setVisible(false);}

     }

   public void takeb1() throws SQLException

   {String listnumber,memberID,bookname,edition,author,quantity;

           Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

           Statement sql=Con.createStatement();

           ResultSet rs=sql.executeQuery("SELECT * FROM List");

           

           while(rs.next())

           {  listnumber=rs.getString("ListNumber");

              bookname=rs.getString("BookName");

              author=rs.getString("Author");

              edition=rs.getString("Edition");

              quantity=rs.getString("Quantity");

              memberID=rs.getString("MembersID");

            if(listnumber.trim().equals(text6.getText().trim()))

              {text1.setText(memberID);text2.setText(bookname);

               text3.setText(edition);text4.setText(author);

               text5.setText(quantity);www=1;break;

               }

           

             }

        Con.close();

            if(www==0)

             {text6.setText("没有此订单");

              text1.setText(null);text2.setText(null);

              text3.setText(null);text4.setText(null);

              text5.setText(null);

             }

    }

               

           

           

    public static void main(String args[])

    {takeB win=new takeB();}

   }

查询书籍：

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

public class searchB extends JInternalFrame implements ActionListener

{ JTextField text1;JTextArea text;

  JButton button1,button2;

  int www=0;

 public searchB()

  { super("search",true,true,true,true);

    Container con=getContentPane();

    setVisible(true);setSize(150,300);

    text1=new JTextField(10);

    

    text=new JTextArea(10,10);text.setBackground(Color.pink);text.setEditable(false);

    button1=new JButton("查找");button2=new JButton("取消");

    JPanel p1=new JPanel();JPanel p2=new JPanel();JPanel p3=new JPanel();

    p1.setLayout(new GridLayout(1,1));

    p1.add(new Label("书的名字"));p1.add(text1);

    p2.add(button1);p2.add(button2);

    p3.add(text);

    button1.addActionListener(this);

    button2.addActionListener(this);

    con.add(p1,BorderLayout.NORTH);con.add(p2,BorderLayout.SOUTH);

    con.add(p3,BorderLayout.CENTER);

    pack();

   }

 public void actionPerformed(ActionEvent e)

 {if(e.getSource()==button1)

  {www=0;

    text.setText("查询结果"+"\n");

    try{search1();}

    catch(SQLException ee){}

  }

 

 

  if(e.getSource()==button2)

    {setVisible(false);}

  }

  public void search1() throws SQLException

  {String name,author,edition,booksID;

    try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}

    catch(ClassNotFoundException e){}

    Connection con=DriverManager.getConnection("jdbc:odbc:Library");

    Statement sql=con.createStatement();

    ResultSet rs=sql.executeQuery("SELECT * FROM Library");

    while(rs.next())

    {  booksID=rs.getString(3);name=rs.getString(4);

       author=rs.getString(5);

       edition=rs.getString(6);

       if(name.trim().equals(text1.getText().trim()))

        {text.append("书号:"+booksID+"\n"+"书名:"+name+"\n"+"作者"+author+"\n"+"出版社"+edition+"\n");

          www=1;break;}

      }

        con.close();

        if(www==0)

          {text.setText("没有此书");}

   }

  public static void main(String args[])

  {searchB win=new searchB();}

 }

查询记录：

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

public class SearchRecord extends JInternalFrame implements ActionListener

{ JTextField text,text1,text2,text3;JButton button1,button2;

  

  public SearchRecord()

  { super("searchrecord",true,true,true,true);

    setVisible(true);

        try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}

        catch(ClassNotFoundException e){}

        try{Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

        Statement Stmt=Con.createStatement();}

        catch(SQLException ee){}

    Container con=getContentPane();

    text=new JTextField(10);

    button1=new JButton("查找");

    JPanel p1=new JPanel();

    p1.add(new Label("书名"));p1.add(text);p1.add(button1);

    button1.addActionListener(this);

         text1=new JTextField(10);text2=new JTextField(10);

         text3=new JTextField(10);

         button2=new JButton("关闭");

         JPanel p2=new JPanel(),p3=new JPanel();

         p2.setLayout(new GridLayout(3,2));

         p2.add(new Label("借书人会员号"));p2.add(text1);

         p2.add(new Label("借书日期"));p2.add(text2);

         p2.add(new Label("书号"));p2.add(text3);

         p3.add(button2);

         button2.addActionListener(this);

    con.add(p1,BorderLayout.NORTH);con.add(p2,BorderLayout.CENTER);

    con.add(p3,BorderLayout.SOUTH);

    pack();

  }

    public void actionPerformed(ActionEvent e)

    { if(e.getSource()==button1)

        {try{searchR();}

         catch(SQLException ee){}

        

        }

      

      if(e.getSource()==button2)

        {setVisible(false);}

      

     }

    public void searchR() throws SQLException

     {String bookid,memberid,borrowtime,name;

         Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

         Statement Stmt=Con.createStatement();

         ResultSet rs=Stmt.executeQuery("SELECT * FROM BorrowRecord");

             

         while(rs.next())

           {bookid=rs.getString("BooksID");memberid=rs.getString("MembersID");borrowtime=rs.getString("Borrowdate");

             name=rs.getString("BookName");

           

            if(name.trim().equals(text.getText().trim()))

              {

             text1.setText(memberid);text2.setText(borrowtime);text3.setText(bookid);

             }

           }

      

      }

     public static void main(String args[])

       {SearchRecord win=new SearchRecord();}

}           

新书编目：

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

class Addbs extends JInternalFrame implements ActionListener

{JTextField text1,text2,text3,text4,text5,text6;JButton button1,button2;

 Addbs()

 {super("addbook",true,true,true,true);

  Container con=getContentPane();

  setVisible(true);setBounds(300,200,200,250);

     try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}

     catch(ClassNotFoundException e){}

     try{Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

     Statement Stmt=Con.createStatement();}

     catch(SQLException ee){}

  text1=new JTextField(10);text2=new JTextField(10);

  text3=new JTextField(10);text4=new JTextField(10);

  text5=new JTextField(10);text6=new JTextField(10);

  button1=new JButton("添书");button2=new JButton("取消");

  button1.addActionListener(this);button2.addActionListener(this);

  JPanel p1=new JPanel();JPanel p2=new JPanel();

  p1.setLayout(new GridLayout(3,2));

  p1.add(new Label("科目"));p1.add(text1);

  p1.add(new Label("数量"));p1.add(text2);

  p1.add(new Label("书名"));p1.add(text3);

  p1.add(new Label("作者"));p1.add(text4);

  p1.add(new Label("出版社"));p1.add(text5);

  p1.add(new Label("入库时间"));p1.add(text6);

  p2.add(button1);p2.add(button2);

  con.add(p1,BorderLayout.NORTH);

  con.add(p2,BorderLayout.SOUTH);pack();

  }

    public void actionPerformed(ActionEvent e)

    {if(e.getSource()==button1)

       {try{Addbs1();}

        catch(SQLException ee){}

       }

     if(e.getSource()==button2)

        {setVisible(false);}

    }

    public void Addbs1() throws SQLException

    {String s1="'"+text1.getText().trim()+"'",

            s2="'"+text2.getText().trim()+"'",

            s3="'"+text3.getText().trim()+"'",

            s4="'"+text4.getText().trim()+"'",

            s5="'"+text5.getText().trim()+"'",

            s6="'"+text6.getText().trim()+"'";

          Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

          Statement Stmt=Con.createStatement();

          String temp="INSERT INTO Library(Category,Quantity,BookName,Author,Edition,Storetime) VALUES ("+s1+","+s2+","+s3+","+s4+","+s5+","+s6+")";              

          Stmt.executeUpdate(temp);

          JOptionPane.showMessageDialog(null,"The book is ok","success",JOptionPane.INFORMATION_MESSAGE);

          text1.setText(null);text2.setText(null);text3.setText(null);

          text4.setText(null);text5.setText(null);text6.setText(null);

          Con.close();

          

     }

  

 public static void main(String args[])

  {Addbs win=new Addbs();}

}

更新书籍：

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

public class updataB extends JInternalFrame implements ActionListener

{ JTextField text,text1,text2,text3,text4,text5;JButton button1,button2,button3;

  int www=0;

  public updataB()

  { super("update",true,true,true,true);

    setVisible(true);

       try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}

       catch(ClassNotFoundException e){}

       try{Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

       Statement sql=Con.createStatement();}

       catch(SQLException ee){}

    Container con=getContentPane();

    text=new JTextField(10);

    button1=new JButton("查找");

    JPanel p1=new JPanel();

    p1.add(new Label("书号"));p1.add(text);p1.add(button1);

    button1.addActionListener(this);

         text1=new JTextField(10);text2=new JTextField(10);

         text3=new JTextField(10);text4=new JTextField(10);

         text5=new JTextField(10);

         button2=new JButton("更改");button3=new JButton("取消");

         JPanel p2=new JPanel(),p3=new JPanel();

         p2.setLayout(new GridLayout(5,2));

         p2.add(new Label("科目"));p2.add(text1);

         p2.add(new Label("数量"));p2.add(text2);

         p2.add(new Label("书名"));p2.add(text3);

         p2.add(new Label("作者"));p2.add(text4);

         p2.add(new Label("出版社"));p2.add(text5);

         p3.add(button2);p3.add(button3);

         button2.addActionListener(this);button3.addActionListener(this);

    con.add(p1,BorderLayout.NORTH);con.add(p2,BorderLayout.CENTER);

    con.add(p3,BorderLayout.SOUTH);

    pack();

  }

    public void actionPerformed(ActionEvent e)

    { if(e.getSource()==button1)

        {www=0;

          try{search2();}

           catch(SQLException ee){}

        }

      

      if(e.getSource()==button2)

        {try{updataB1();}

          catch(SQLException ee){}

         }

      if(e.getSource()==button3)

        {setVisible(false);}

     }

    public void search2() throws SQLException

    {  String booksID,category,quantity,name,author,edition;

        Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

        Statement sql=Con.createStatement();

         ResultSet rs=sql.executeQuery("SELECT * FROM Library");

         while(rs.next())

         {   category=rs.getString(1);

             quantity=rs.getString(2);

             booksID=rs.getString(3);

             name=rs.getString(4);

             author=rs.getString(5);

             edition=rs.getString(6);

            if(booksID.trim().equals(text.getText().trim()))

            {text1.setText(category);text2.setText(quantity);

             text3.setText(name);text4.setText(author);

             text5.setText(edition);www=1;break;

             }

           }

           Con.close();

               if(www==0)

               {text.setText("没有此书");

               text1.setText(null);text2.setText(null);

               text3.setText(null);text4.setText(null);

               text5.setText(null);}

          

     }

     public void updataB1() throws SQLException

     {String s1="'"+text1.getText().trim()+"'",

             s2="'"+text2.getText().trim()+"'",

             s3="'"+text3.getText().trim()+"'",

             s4="'"+text4.getText().trim()+"'",

             s5="'"+text5.getText().trim()+"'",

             s="'"+text.getText().trim()+"'";

      String temp="UPDATE Library SET Category="+s1+",Quantity="+s2+",BookName="+s3+",Author="+s4+",Edition="+s5+" WHERE BooksID="+s+"";

                   

             Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

             Statement sql=Con.createStatement();

             sql.executeUpdate(temp);

             Con.close();

      }

     

        public static void main(String args[])

     {updataB wind=new updataB();}

}

      

     

增加会员：

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

public class membersID extends JInternalFrame implements ActionListener

{ JTextField text1,text2,text3,text4;;JButton button1,button2;

   membersID()

  {super("welcome",true,true,true,true);

   Container con=getContentPane();

   setVisible(true);

     try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}

     catch(ClassNotFoundException e){}

     try{Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

     Statement Stmt=Con.createStatement();}

     catch(SQLException ee){}

   text1=new JTextField(10);text2=new JTextField(10);

   text3=new JTextField(10);text4=new JTextField(10);

   button1=new JButton("注册");button2=new JButton("取消");

   JPanel p1=new JPanel();JPanel p2=new JPanel();

   p1.setLayout(new GridLayout(4,2));

   p1.add(new Label("新的会员号(只能数字)："));p1.add(text1);

   p1.add(new Label("你的名字："));p1.add(text2);

   p1.add(new Label("班级："));p1.add(text3);

   p1.add(new Label("学号(只能数字)："));p1.add(text4);

   p2.add(button1);p2.add(button2);

   con.add(p1,BorderLayout.NORTH);

   con.add(p2,BorderLayout.SOUTH);  

   button1.addActionListener(this);button2.addActionListener(this);

   pack();

   

  }

  public void actionPerformed(ActionEvent e)

  {if(e.getSource()==button1)

     {try{newmembers();}

      catch(SQLException ee){}

     }

     

     if(e.getSource()==button2)

     {setVisible(false);}

   }

   public void newmembers() throws SQLException

   {String s1="'"+text1.getText().trim()+"'",

           s2="'"+text2.getText().trim()+"'",

           s3="'"+text3.getText().trim()+"'",

           s4="'"+text4.getText().trim()+"'";

           Connection Con=DriverManager.getConnection("jdbc:odbc:Library","","");

           Statement Stmt=Con.createStatement();

           String temp="INSERT INTO Member(MembersID,StudentName,Class,StudentNumber) VALUES("+s1+","+s2+","+s3+","+s4+")";

           Stmt.executeUpdate(temp);

           JOptionPane.showMessageDialog(null,"注册成功","success",JOptionPane.INFORMATION_MESSAGE);

           text1.setText(null);text2.setText(null);

           text3.setText(null);text4.setText(null);

   }

   public static void main(String args[])

   {membersID win=new membersID();}

 }