magazinelogoutpanel.java~23~

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

  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 = db.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++)
                    {
                        String s = rs.getString(j+2);
                        if(s==null)
                            s="null";
                        data[i][j] = s.trim();
                    }
                    rs.next();
                }
                DefaultTableModel model = new DefaultTableModel(data,title);
            jTeaRightTop2.setModel(model);
            jTeaRightTop2.updateUI();
            db.myClose(1);

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

   }
   public void display()
  {
      DefaultMutableTreeNode clickNode = (DefaultMutableTreeNode) jTreeQikan.getLastSelectedPathComponent();
      String sql="";
      String sql2= "";
      String bti="";
      //数据库表没有见
      if (clickNode != null ) {

          //查询条件许转换
          if(clickNode.toString().trim().equals("所有期刊"))
          {
              bti="%";
          }
          else
          {
              sql = "select TypeID from typechaxun where magazinTypeName='"+clickNode.toString().trim() + "'";
              sql2 =  "select TypeID1 from typechaxun where typeName='"+clickNode.toString().trim() + "'";

              db.search(sql);
              try {
                  if (db.rs.next())
                      bti = db.rs.getString(1).trim();
                  else
                  {
                      db.myClose(1);
                      db.search(sql2);
                      if (db.rs.next())
                          bti = db.rs.getString(1).trim();
                  }
              } catch (SQLException ex) {
                  System.out.println(ex.toString());
              }
              db.myClose(1);
          }
          sql = "select * from magazineInfo where typenumbers like'"+bti.trim()+"'+'%'";

          jlbM.setText(clickNode.toString().trim()+"类 期刊信息列表");
          jtxBookType2.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);
    }
}