bookslogoutpanel1.java

图书管理系统源代码,05年某人写的,还算不错

                    if(i!=arry[j])
                    {
                        bookstype[arry[j-1]].add(bookstype[i]);
                    }
                   else
                    {
                        j++;
                        books.add(bookstype[i]);
                    }
                }
            } catch (SQLException ex) {
                System.out.println(ex.toString());
            }
        jTreBooks.updateUI();
            dd.myClose();
      //  }
      //  else
        //    JOptionPane.showMessageDialog(this,"连接数据库失败","连接错误",JOptionPane.WARNING_MESSAGE);
    }

   public void this_ancestorResized(HierarchyEvent e) {
       jSpSystemPanel.setSize( this.getWidth()-5,this.getHeight());
        jSpSystemPanel.setDividerLocation(0.21);
    }

   public void jScright_ancestorResized(HierarchyEvent e) {
       jPanRight.setSize((jScright.getWidth()-1),(jScright.getHeight()-1));
   }

   public void jPanRight_ancestorResized(HierarchyEvent e) {
       jPanelRightTopjPanel.setSize((jPanelRightTop.getWidth()),25);
       jPanelRightTop.setBounds(1,(jPaneRightBottom.getY()+jPaneRightBottom.getHeight()-1),(jPanRight.getWidth())-5,jPanRight.getHeight()*3/7-1);
       jScrollPane1.setBounds(1,25,(jPanelRightTop.getWidth())-1,jPanelRightTop.getHeight()-25);
       jlbM.setBounds((jPanelRightTop.getWidth()-57)/2,1,57,20);
       jPaneRightBottom.setSize((jPanRight.getWidth())-5,(jPanRight.getHeight())*4/7-2);
   }



   public void jScright_componentResized(ComponentEvent e) {

       jPanRight.setSize((jScright.getWidth()-1),(jScright.getHeight()-1));
   }

   public void jPaneRightBottom_componentResized(ComponentEvent e) {
       jTpRightBottom.setSize(jPaneRightBottom.getWidth()-1,jPaneRightBottom.getHeight()-1);
   }

    public void jTreBooks_mouseClicked(MouseEvent e) {
        display();

    }
    public void tableDisp(String sql)
    {
        String[][] data;
         ResultSet rs;

          try
          {
                  rs = dd.booksInfosearch(sql);

                  int count=0;
                  while(rs.next())
                      count++;
                  rs.first();
                  data = new String[count][title.length];
                  for(int i=0;i<count;i++)
                  {
                      for(int j=0;j<title.length;j++)
                      {
                          data[i][j] = rs.getString(j+2).trim();
                      }
                      rs.next();
                  }
                  DefaultTableModel model = new DefaultTableModel(data,title);
                  jTeaRightTop.setModel(model);
                   jTeaRightTop.updateUI();
                  dd.myClose(1);

          }
          catch(SQLException sex)
          {
              System.out.println(sex.toString());
             // sex.printStackTrace();
          }

    }
    public void display()
   {
       DefaultMutableTreeNode clickNode = (DefaultMutableTreeNode) jTreBooks.getLastSelectedPathComponent();
       String sql;
       String bti="";
       //数据库表没有见
       if (clickNode != null ) {
           //查询条件许转换
           if(clickNode.toString().trim().equals("所有图书"))
           {
               bti="%";
           }
           else
           {
               type1=clickNode.toString().trim();
               sql = "select TypeID from BooksType where typeName='" +
                     clickNode.toString().trim() + "'";
               dd.search(sql);
               try {
                   if (dd.rs.next())
                       bti = dd.rs.getString(1).trim();
               } catch (SQLException ex) {
                   System.out.println(ex.toString());
               }
               dd.myClose(1);
           }
           sql = "select * from booksInfo where bookTypeID like'"+bti.trim()+"'+'%'";

           tableDisp(sql);
        }


   }

    public void jtxBookNum2_mouseClicked(MouseEvent e) {
        inputBooksNum(jtxBookNum2);
    }
    public void inputBooksNum(JTextField a)
    {
        String bianhao="";
        try {
              bianhao= JOptionPane.showInputDialog(null,"请输入需要增加图书的编号    例如 ","W00020070800000001").trim();
        } catch (Exception ex) {
           // JOptionPane.showMessageDialog(null, "你没有输入读者信息");
        }

       if(!bianhao.equals("")){
           if ((int)bianhao.charAt(0)>='A' && (int)bianhao.charAt(0) <= 'Z' ) {
               a.setText(bianhao);
               //查询此编号的图书

           }
       }
    }




    public void qingchu()
    {
    }
    public void btnReset_actionPerformed(ActionEvent e) {
        qingchu();

    }

    public void this_componentResized(ComponentEvent e) {
        jSpSystemPanel.setSize( this.getWidth(),this.getHeight());
        jSpSystemPanel.setDividerLocation(0.21);
    }

    public void jSpSystemPanel_componentResized(ComponentEvent e) {
        jPanRight.setSize(jScright.getWidth()-1,jScright.getHeight()-1);
        jSpSystemPanel.setDividerLocation(0.21);
    }

    public void jPanRight_componentResized(ComponentEvent e) {
        jPanelRightTopjPanel.setSize(jPanelRightTop.getWidth()-1,25);
      jPanelRightTop.setBounds(1,(jPaneRightBottom.getY()+jPaneRightBottom.getHeight()-1),(jPanRight.getWidth())-5,jPanRight.getHeight()*3/7-1);
      jScrollPane1.setBounds(1,25,(jPanelRightTop.getWidth())-1,jPanelRightTop.getHeight()-25);
      jlbM.setBounds((jPanelRightTop.getWidth()-57)/2,1,57,20);
      jPaneRightBottom.setSize((jPanRight.getWidth())-5,(jPanRight.getHeight())*4/7-2);

    }

    public void jTeaRightTop_mouseClicked(MouseEvent e) {
        if (e.getButton() == e.BUTTON1) {
            //表的行从0开始编号
            //JOptionPane.showMessageDialog(null,""+jTabRightTop.getSelectedRow());
            //获取书名
        /*
            String name = jTeaRightTop.getValueAt(jTeaRightTop.getSelectedRow(), 0).toString();
            String number = jTeaRightTop.getValueAt(jTeaRightTop.getSelectedRow(), 1).toString();
            String type = jTeaRightTop.getValueAt(jTeaRightTop.getSelectedRow(), 2).toString();
            String zuozhe = jTeaRightTop.getValueAt(jTeaRightTop.getSelectedRow(), 3).toString();
            String chubanshe = jTeaRightTop.getValueAt(jTeaRightTop.getSelectedRow(), 4).toString();
            String shuliang = jTeaRightTop.getValueAt(jTeaRightTop.getSelectedRow(), 5).toString();
            String dingjia = jTeaRightTop.getValueAt(jTeaRightTop.getSelectedRow(), 6).toString();
            String yuzhong = jTeaRightTop.getValueAt(jTeaRightTop.getSelectedRow(), 7).toString();
            if(e.getButton()==e.BUTTON1)
                 {
          */
          String name="";
          String num="";
          String chubanshe="";
          String zuozhe="";
          String dingjia="";
          String yuyan="";
          String weizhi="";
          String shuliang="";
          //获取
          name=jTeaRightTop.getValueAt(jTeaRightTop.getSelectedRow(),0).toString();
          num=jTeaRightTop.getValueAt(jTeaRightTop.getSelectedRow(),1).toString();
          chubanshe=jTeaRightTop.getValueAt(jTeaRightTop.getSelectedRow(),4).toString();
          zuozhe=jTeaRightTop.getValueAt(jTeaRightTop.getSelectedRow(),3).toString();
          dingjia=jTeaRightTop.getValueAt(jTeaRightTop.getSelectedRow(),6).toString();
          yuyan=jTeaRightTop.getValueAt(jTeaRightTop.getSelectedRow(),7).toString();
          weizhi=jTeaRightTop.getValueAt(jTeaRightTop.getSelectedRow(),8).toString();
          shuliang=jTeaRightTop.getValueAt(jTeaRightTop.getSelectedRow(),5).toString();
          jtxBookName2.setText(name);
          jtxBookNum2.setText(num);
          jtxBookConcern2.setText(chubanshe);
          jtxBookAuthor2.setText(zuozhe);
          jtxBookPurchaseMoney2.setText(dingjia);
          jtxBookBorrowMoneyNum2.setText(shuliang);
          jtxBookStation2.setText(weizhi);
          jtxBookLanguage2.setText(yuyan);
          jtxBookType2.setText(type1);

        }
    }


}


class BooksLogOutPanel1_jTeaRightTop_mouseAdapter extends MouseAdapter {
    private BooksLogOutPanel1 adaptee;
    BooksLogOutPanel1_jTeaRightTop_mouseAdapter(BooksLogOutPanel1 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jTeaRightTop_mouseClicked(e);
    }
}


class BooksLogOutPanel1_jSpSystemPanel_componentAdapter extends
        ComponentAdapter {
    private BooksLogOutPanel1 adaptee;
    BooksLogOutPanel1_jSpSystemPanel_componentAdapter(BooksLogOutPanel1 adaptee) {
        this.adaptee = adaptee;
    }

    public void componentResized(ComponentEvent e) {
        adaptee.jSpSystemPanel_componentResized(e);
    }
}


class BooksLogOutPanel1_this_componentAdapter extends ComponentAdapter {
    private BooksLogOutPanel1 adaptee;
    BooksLogOutPanel1_this_componentAdapter(BooksLogOutPanel1 adaptee) {
        this.adaptee = adaptee;
    }

    public void componentResized(ComponentEvent e) {
        adaptee.this_componentResized(e);
    }
}


class BooksLogOutPanel1_jPaneRightBottom_componentAdapter extends
        ComponentAdapter {
    private BooksLogOutPanel1 adaptee;
    BooksLogOutPanel1_jPaneRightBottom_componentAdapter(BooksLogOutPanel1
            adaptee) {
        this.adaptee = adaptee;
    }

    public void componentResized(ComponentEvent e) {
        adaptee.jPaneRightBottom_componentResized(e);
    }
}


class BooksLogOutPanel1_jTreBooks_mouseAdapter extends MouseAdapter {
    private BooksLogOutPanel1 adaptee;
    BooksLogOutPanel1_jTreBooks_mouseAdapter(BooksLogOutPanel1 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jTreBooks_mouseClicked(e);
    }
}


class BooksLogOutPanel1_jPanRight_hierarchyBoundsAdapter extends
        HierarchyBoundsAdapter {
    private BooksLogOutPanel1 adaptee;
    BooksLogOutPanel1_jPanRight_hierarchyBoundsAdapter(BooksLogOutPanel1
            adaptee) {
        this.adaptee = adaptee;
    }

    public void ancestorResized(HierarchyEvent e) {
        adaptee.jPanRight_ancestorResized(e);
    }
}


class BooksLogOutPanel1_jPanRight_componentAdapter extends ComponentAdapter {
    private BooksLogOutPanel1 adaptee;
    BooksLogOutPanel1_jPanRight_componentAdapter(BooksLogOutPanel1 adaptee) {
        this.adaptee = adaptee;
    }

    public void componentResized(ComponentEvent e) {

        adaptee.jPanRight_componentResized(e);
    }
}


class BooksLogOutPanel1_jScright_componentAdapter extends ComponentAdapter {
    private BooksLogOutPanel1 adaptee;
    BooksLogOutPanel1_jScright_componentAdapter(BooksLogOutPanel1 adaptee) {
        this.adaptee = adaptee;
    }

    public void componentResized(ComponentEvent e) {
        adaptee.jScright_componentResized(e);
    }
}


class BooksLogOutPanel1_jScright_hierarchyBoundsAdapter extends
        HierarchyBoundsAdapter {
    private BooksLogOutPanel1 adaptee;
    BooksLogOutPanel1_jScright_hierarchyBoundsAdapter(BooksLogOutPanel1 adaptee) {
        this.adaptee = adaptee;
    }

    public void ancestorResized(HierarchyEvent e) {
        adaptee.jScright_ancestorResized(e);
    }
}