magazinelogoutpanel.java~19~

一个功能强大的图书管理系统,是个人版,适合学习swing的初学者阅读.

           } 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()-2),25);
      jPanelRightTop.setBounds(jPaneRightBottom.getX()+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(5,2,jPanelRightTopjPanel.getWidth()-10,20);
      jPaneRightBottom.setSize((jPanRight.getWidth())-5,(jPanRight.getHeight())*4/7-2);

  }



  public void jScright_componentResized(ComponentEvent e) {

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

  public void jPaneRightBottom_componentResized(ComponentEvent e) {
      jTpRightBottom.setSize(jPaneRightBottom.getWidth()-2,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);
            jTeaRightTop2.setModel(model);
            jTeaRightTop2.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()+"'+'%'";
          jlbM.setText(clickNode.toString().trim()+"类 期刊信息列表");
                   // jtxBookType1.setText(clickNode.toString().trim());
                    //  jtxBookType2.setText(clickNode.toString().trim());
          fenlei=clickNode.toString().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=jTeaRightTop2.getValueAt(jTeaRightTop2.getSelectedRow(),0).toString();
         num=jTeaRightTop2.getValueAt(jTeaRightTop2.getSelectedRow(),1).toString();
         chubanshe=jTeaRightTop2.getValueAt(jTeaRightTop2.getSelectedRow(),4).toString();
         zuozhe=jTeaRightTop2.getValueAt(jTeaRightTop2.getSelectedRow(),3).toString();
         dingjia=jTeaRightTop2.getValueAt(jTeaRightTop2.getSelectedRow(),6).toString();
         yuyan=jTeaRightTop2.getValueAt(jTeaRightTop2.getSelectedRow(),7).toString();
         weizhi=jTeaRightTop2.getValueAt(jTeaRightTop2.getSelectedRow(),8).toString();
         shuliang=jTeaRightTop2.getValueAt(jTeaRightTop2.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);

       }
   }

    public void jtxBookNum2_actionPerformed(ActionEvent e) {

    }

    public void jPanelRightTop_mouseClicked(MouseEvent e) {

    }




}


class MagazineLogOutPanel_jPaneRightBottom_componentAdapter extends
        ComponentAdapter {
    private MagazineLogOutPanel adaptee;
    MagazineLogOutPanel_jPaneRightBottom_componentAdapter(MagazineLogOutPanel
            adaptee) {
        this.adaptee = adaptee;
    }

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


class MagazineLogOutPanel_jScright_hierarchyBoundsAdapter extends
        HierarchyBoundsAdapter {
    private MagazineLogOutPanel adaptee;
    MagazineLogOutPanel_jScright_hierarchyBoundsAdapter(MagazineLogOutPanel
            adaptee) {
        this.adaptee = adaptee;
    }

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


class MagazineLogOutPanel_this_componentAdapter extends ComponentAdapter {
    private MagazineLogOutPanel adaptee;
    MagazineLogOutPanel_this_componentAdapter(MagazineLogOutPanel adaptee) {
        this.adaptee = adaptee;
    }

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


class MagazineLogOutPanel_this_hierarchyBoundsAdapter extends
        HierarchyBoundsAdapter {
    private MagazineLogOutPanel adaptee;
    MagazineLogOutPanel_this_hierarchyBoundsAdapter(MagazineLogOutPanel adaptee) {
        this.adaptee = adaptee;
    }

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


class MagazineLogOutPanel_jScright_componentAdapter extends ComponentAdapter {
    private MagazineLogOutPanel adaptee;
    MagazineLogOutPanel_jScright_componentAdapter(MagazineLogOutPanel adaptee) {
        this.adaptee = adaptee;
    }

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


class MagazineLogOutPanel_jPanRight_hierarchyBoundsAdapter extends
        HierarchyBoundsAdapter {
    private MagazineLogOutPanel adaptee;
    MagazineLogOutPanel_jPanRight_hierarchyBoundsAdapter(MagazineLogOutPanel
            adaptee) {
        this.adaptee = adaptee;
    }

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


class MagazineLogOutPanel_jPanelRightTop_mouseAdapter extends MouseAdapter {
    private MagazineLogOutPanel adaptee;
    MagazineLogOutPanel_jPanelRightTop_mouseAdapter(MagazineLogOutPanel adaptee) {
        this.adaptee = adaptee;
    }

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


class MagazineLogOutPanel_jTeaRightTop_mouseAdapter extends MouseAdapter {
    private MagazineLogOutPanel adaptee;
    MagazineLogOutPanel_jTeaRightTop_mouseAdapter(MagazineLogOutPanel adaptee) {
        this.adaptee = adaptee;
    }

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


class MagazineLogOutPanel_jTreBooks_mouseAdapter extends MouseAdapter {
    private MagazineLogOutPanel adaptee;
    MagazineLogOutPanel_jTreBooks_mouseAdapter(MagazineLogOutPanel adaptee) {
        this.adaptee = adaptee;
    }

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


class MagazineLogOutPanel_jtxBookNum2_mouseAdapter extends MouseAdapter {
    private MagazineLogOutPanel adaptee;
    MagazineLogOutPanel_jtxBookNum2_mouseAdapter(MagazineLogOutPanel adaptee) {
        this.adaptee = adaptee;
    }

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


class MagazineLogOutPanel_jtxBookNum2_actionAdapter implements ActionListener {
    private MagazineLogOutPanel adaptee;
    MagazineLogOutPanel_jtxBookNum2_actionAdapter(MagazineLogOutPanel adaptee) {
        this.adaptee = adaptee;
    }

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