frmbook.java~138~

这是我在北大青鸟的第一学期的一个毕业设计

            else if(name.equals("证号修改"))
            {
                page = 0;
                pnlLendNumber_Modify lnm = new pnlLendNumber_Modify(this);
                spnV.setTopComponent(lnm);
                clsLendNumber_condb.initSearch();
                clsLendNumber_condb.initInfo(tblData, clsLendNumber_condb.rsLN);
                String tab = "lendnumberinfo";
                this.DataPane(clsLendNumber_condb.rsLN, tab);
                this.StateContent("借书证管理", "借书证修改");
            }

            else if(name.equals("证号查找"))
            {
                page = 0;
                pnlLendNumber_Search lns = new pnlLendNumber_Search(this);
                spnV.setTopComponent(lns);
                clsLendNumber_condb.initSearch();
                clsLendNumber_condb.initInfo(tblData, clsLendNumber_condb.rsLN);
                String tab = "lendnumberinfo";
                this.DataPane(clsLendNumber_condb.rsLN, tab);
                this.StateContent("借书证管理", "借书证查找");
            }
            else if(name.equals("登陆"))
            {
                Frmtrans ft = new Frmtrans();
                ft.setVisible(true);
            }
            else if(name.equals("添加用户"))
            {
                FrmUser_Add ua = new FrmUser_Add();
                ua.setLocation(100, 100);
                ua.setSize(450, 300);
                ua.setVisible(true);
            }
            else if(name.equals("删除用户"))
            {
                FrmUser_Delete ud = new FrmUser_Delete();
                ud.setLocation(100, 100);
                ud.setSize(400, 300);
                ud.setVisible(true);
            }
            else if(name.equals("按书名精确查询"))
            {
                page = 0;
                pnlSearch_JName sjn = new pnlSearch_JName(this);
                spnV.setTopComponent(sjn);
                JPanel p = new JPanel();
                spnV.setBottomComponent(p);
                baconne.initSearch();
                baconne.initInfo(tblData, baconne.rs);
                ResultSet rsto = bookadd_condb.rsBook();
                String tab = "bookinfo";
                this.DataPane(rsto, tab);
                this.StateContent("图书查询", "精确查询");
            }
            else if(name.equals("按书名模糊查询"))
            {
                page = 0;
                pnlSearch_MName smn = new pnlSearch_MName(this);
                spnV.setTopComponent(smn);
                JPanel p = new JPanel();
                spnV.setBottomComponent(p);
                baconne.initSearch();
                baconne.initInfo(tblData, baconne.rs);
                ResultSet rsto = bookadd_condb.rsBook();
                String tab = "bookinfo";
                this.DataPane(rsto, tab);
                this.StateContent("图书查询", "模糊查询");
            }
            else if(name.equals("按作者查询"))
            {
                page = 0;
                pnlSearch_Author sa = new pnlSearch_Author(this);
                spnV.setTopComponent(sa);
                JPanel p = new JPanel();
                spnV.setBottomComponent(p);
                baconne.initSearch();
                baconne.initInfo(tblData, baconne.rs);
                ResultSet rsto = bookadd_condb.rsBook();
                String tab = "bookinfo";
                this.DataPane(rsto, tab);
                this.StateContent("图书查询", "按作者查询");
            }
            else if(name.equals("按出版社查询"))
            {
                page = 0;
                pnlSearch_Publish sp = new pnlSearch_Publish(this);
                spnV.setTopComponent(sp);
                JPanel p = new JPanel();
                spnV.setBottomComponent(p);
                baconne.initSearch();
                baconne.initInfo(tblData, baconne.rs);
                ResultSet rsto = bookadd_condb.rsBook();
                String tab = "bookinfo";
                this.DataPane(rsto, tab);
                this.StateContent("图书查询", "按出版社查询");
            }
            else if(name.equals("组合查询"))
            {
                page = 0;
                pnlSearch_Group sg = new pnlSearch_Group(this);
                spnV.setTopComponent(sg);
                JPanel p = new JPanel();
                spnV.setBottomComponent(p);
                baconne.initSearch();
                baconne.initInfo(tblData, baconne.rs);
                ResultSet rsto = bookadd_condb.rsBook();
                String tab = "bookinfo";
                this.DataPane(rsto, tab);
                this.StateContent("图书查询", "组合查询");
            }
        }catch(Exception ex)
        {

        }
    }


    public void scrollTitle(final FrmBook ft)
        {
            final String str[]={"欢","迎","使","用","图","书","管","理","系","统","!","!"};

            ActionListener a1=new ActionListener()
            {
                String title="";
                int i=0;
                public void actionPerformed(ActionEvent e)
                {
                  if(i<str.length)
                  {
                      title+=str[i];
                      ft.setTitle(title);
                      i++;
                  }
                  else
                  {
                      title="";
                      ft.setTitle("");
                      i=0;
                  }
                }

            };
            Timer t=new Timer(200,a1);
            t.start();
        }

    public void this_windowClosing(WindowEvent e) {
        int i=1;
            this.setTitle("谢谢使用，再见!");
            for(i=this.getHeight();i>0;i-=10)
            {
                this.setSize(this.getWidth(),i);
            }
            for(int j=this.getWidth();j>0;j-=10)
            {
                this.setSize(j,i);
            }

    }


    public void btnFirst_actionPerformed(ActionEvent e) {
        page=0;
        ResultSet rspage=bookadd_condb.splitPage(page,table);
       bookadd_condb.initInfo(this.tblData,rspage);
    }

    public void btnNextPage_actionPerformed(ActionEvent e) {

        if(page==totalpage)
        {
            page=totalpage;
            JOptionPane.showMessageDialog(this,"已经到了最后一页","提示信息",JOptionPane.INFORMATION_MESSAGE);
        }
        else
        {
            page++;
        }
       ResultSet rspage=bookadd_condb.splitPage(page,table);
       bookadd_condb.initInfo(this.tblData,rspage);
    }

    public void btnPrePage_actionPerformed(ActionEvent e) {
        if(page==0)
        {
            page=0;
            JOptionPane.showMessageDialog(this,"已经到了最前一页","提示信息",JOptionPane.INFORMATION_MESSAGE);
        }
        else
        {
            page--;
        }
        ResultSet rspage=bookadd_condb.splitPage(page,table);
        bookadd_condb.initInfo(this.tblData,rspage);
    }

    public void btnLast_actionPerformed(ActionEvent e) {
        page=totalpage;
        ResultSet rspage=bookadd_condb.splitPage(totalpage,table);
        bookadd_condb.initInfo(this.tblData,rspage);
    }

    public void btnGoto_actionPerformed(ActionEvent e)
    {
        page=Integer.parseInt(txtPage.getText())-1;
        if(page<0 || page>totalpage)
        {
            JOptionPane.showMessageDialog(this,"此页不存在","提示信息",JOptionPane.INFORMATION_MESSAGE);
            if(page<0)
            {
                page=0;
            }
            if(page>totalpage)
            {
                page=totalpage;
            }
        }
        else
        {
            ResultSet rspage = bookadd_condb.splitPage(page,table);
            bookadd_condb.initInfo(this.tblData, rspage);
        }
    }

    public void btnLogin_mouseEntered(MouseEvent e) {
        //btnLogin.setSize(50,50);
        btnLogin.setIcon(new ImageIcon("pic\\sysinfo.gif"));
       this.setCursor(new Cursor(Cursor.HAND_CURSOR));
    }

    public void btnLogin_mouseExited(MouseEvent e) {
         //btnLogin.setSize(32,32);
        btnLogin.setIcon(new ImageIcon("pic\\sysinfo_s.gif"));
        this.setCursor(new Cursor(Cursor.DEFAULT_CURSOR));
    }

    public void btnSearch_mouseEntered(MouseEvent e) {
        //btnSearch.setSize(50,50);
        btnSearch.setIcon(new ImageIcon("pic\\Find.gif"));
    }

    public void btnSearch_mouseExited(MouseEvent e) {
        //btnSearch.setSize(32,32);
        btnSearch.setIcon(new ImageIcon("pic\\Find_s.gif"));
    }

    public void btnReturnBook_mouseEntered(MouseEvent e) {
        //btnReturnBook.setSize(50,50);
        btnReturnBook.setIcon(new ImageIcon("pic\\book.gif"));
    }

    public void btnReturnBook_mouseExited(MouseEvent e) {
        //btnReturnBook.setSize(32,32);
        btnReturnBook.setIcon(new ImageIcon("pic\\book_s.gif"));
    }

    public void btnLendBook_mouseEntered(MouseEvent e) {
        //btnLendBook.setSize(50,50);
        btnLendBook.setIcon(new ImageIcon("pic\\time.gif"));
    }

    public void btnLendBook_mouseExited(MouseEvent e) {
        //btnLendBook.setSize(32,32);
        btnLendBook.setIcon(new ImageIcon("pic\\time_s.gif"));
    }

    public void btnAbout_mouseEntered(MouseEvent e) {
        //btnAbout.setSize(50,50);
        btnAbout.setIcon(new ImageIcon("pic\\Help.gif"));
    }

    public void btnAbout_mouseExited(MouseEvent e) {
        //btnAbout.setSize(32,32);
        btnAbout.setIcon(new ImageIcon("pic\\Help_s.gif"));
    }

    public void btnQuit_mouseEntered(MouseEvent e) {
        //btnQuit.setSize(50,50);
         btnQuit.setIcon(new ImageIcon("pic\\Documents.gif"));
    }

    public void btnQuit_mouseExited(MouseEvent e) {
       // btnQuit.setSize(32,32);
         btnQuit.setIcon(new ImageIcon("pic\\Documents_s.gif"));
    }

    public void btnLogin_actionPerformed(ActionEvent e) {
        Frmtrans ft=new Frmtrans();
        ft.setVisible(true);
         this.StateContent("用户管理","登陆");

    }

    public void btnSearch_actionPerformed(ActionEvent e) {
        page=0;
       pnlSearch_Group sg=new pnlSearch_Group(this);
       spnV.setTopComponent(sg);
       JPanel p=new JPanel();
       spnV.setBottomComponent(p);
       baconne.initSearch();
       baconne.initInfo(tblData,baconne.rs);
       ResultSet rsto=bookadd_condb.rsBook();
       String tab="bookinfo";
      this.DataPane(rsto,tab);
      this.StateContent("图书查询","组合查询");

    }

    public void btnReturnBook_actionPerformed(ActionEvent e) {
        pnlLendBook_Return lbr=new pnlLendBook_Return(this);
        spnV.setTopComponent(lbr);
        clsLendBook_condb.initSearch_return();
        clsLendBook_condb.initInfo(this.tblData,clsLendBook_condb.rsLbr);
        String tab="returnbook";
        this.DataPane(clsLendBook_condb.rsReturn(),tab);
        this.StateContent("借阅管理","还书");



    }

    public void btnLendBook_actionPerformed(ActionEvent e) {
        pnlLendBook_Lend lbl=new pnlLendBook_Lend(this);
        spnV.setTopComponent(lbl);
        clsLendBook_condb.initSearch();
        clsLendBook_condb.initInfo(this.tblData,clsLendBook_condb.rsLbl);
        String tab="lendbook";
        this.DataPane(clsLendBook_condb.rsLend(),tab);
        this.StateContent("借阅管理","借书");

    }

    public void btnAbout_actionPerformed(ActionEvent e) {
        About.getAbout();
        this.StateContent("关于","关于");
    }

    public void btnQuit_actionPerformed(ActionEvent e) {
        this.dispose();
    }

}




class FrmBook_mnuUAdd_actionAdapter implements ActionListener {
    private FrmBook adaptee;
    FrmBook_mnuUAdd_actionAdapter(FrmBook adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.mnuUAdd_actionPerformed(e);
    }
}


class FrmBook_mnuUDelete_actionAdapter implements ActionListener {
    private FrmBook adaptee;
    FrmBook_mnuUDelete_actionAdapter(FrmBook adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.mnuUDelete_actionPerformed(e);
    }
}


class FrmBook_mnuExit_actionAdapter implements ActionListener {
    private FrmBook adaptee;
    FrmBook_mnuExit_actionAdapter(FrmBook adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.mnuExit_actionPerformed(e);
    }
}


class FrmBook_mnuLogin_actionAdapter implements ActionListener {
    private FrmBook adaptee;
    FrmBook_mnuLogin_actionAdapter(FrmBook adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.mnuLogin_actionPerformed(e);
    }
}


class FrmBook_mnuAbout_actionAdapter implements ActionListener {
    private FrmBook adaptee;
    FrmBook_mnuAbout_actionAdapter(FrmBook adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.mnuAbout_actionPerformed(e);
    }
}


class FrmBook_mnuHelpDoc_actionAdapter implements ActionListener {
    private FrmBook adaptee;
    FrmBook_mnuHelpDoc_actionAdapter(FrmBook adaptee) {
        this.adaptee = adaptee;
    }