magazineinfosystempanel1.java~29~

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

        DefaultMutableTreeNode magazinetypeFather[];
        DefaultMutableTreeNode magazinetypeChilkl[];
        int size = 0;
        int j = 0;
        int i = 0;
        //连接数据库
        //  if (db.getconn()) {
        //获得结果集
        re = db.searchMagazinTree();

        try {
            while (re.next()) {
                size++;
            }
            magazinetypeFather = new DefaultMutableTreeNode[size];
            magazinetypeChilkl = new DefaultMutableTreeNode[size];
            boolean a = re.first();
            String TypeFather = "";
            String TypeChild = "";
            for (i = 0, j = 0; a; i++) {
                String TypeFather1 = re.getString(2).trim();
                String TypeChild1 = re.getString(3).trim();
                if (!TypeFather.trim().equals(TypeFather1)) {
                    TypeFather = TypeFather1;
                    magazinetypeFather[j] = new DefaultMutableTreeNode(
                            TypeFather);
                    qikan.add(magazinetypeFather[j]);
                    j++;
                }
                magazinetypeChilkl[i] = new DefaultMutableTreeNode(TypeChild1);
                magazinetypeFather[j - 1].add(magazinetypeChilkl[i]);
                a = re.next();
            }
            jTreeqikan.updateUI();
        } catch (SQLException ex) {
            System.out.println(ex.toString());
        }
        db.myClose(1);
    }

     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 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);
           jTeaRightTop.setModel(model);
           jTeaRightTop.updateUI();
           db.myClose(1);

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

   }



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

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

     public void jPanRight_ancestorResized(HierarchyEvent e) {
         jPanelRightTop.setSize((jPanRight.getWidth()) - 4,
                                (jPanRight.getHeight()) / 3 - 2);
         jScrollPane1.setSize((jPanelRightTop.getWidth()) - 1,
                              (jPanelRightTop.getHeight()));
         jPaneRightBottom.setBounds(jPanRight.getX() + 1,
                                    (jPanRight.getY() + jPanelRightTop.getHeight() +
                                     3), (jPanRight.getWidth()) - 5,
                                    (jPanRight.getHeight()) * 2 / 3 - 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) {
         if(e.getButton()==1)
             display();

     }



     public void jTeaRightTop_mouseClicked(MouseEvent e) {
         if(e.getButton()==e.BUTTON1)
         {
            String name="";
            String type="";
            String num="";
            String chubanshe="";
            String zuozhe="";
            String dingjia="";
            String yuyan="";
            String weizhi="";
            String shuliang="";
            //获取
          name=jTeaRightTop.getValueAt(jTeaRightTop.getSelectedRow(),0).toString();
          //  type=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();

            jtxBookName1.setText(name);
            jtxBookNum1.setText(num);
            jtxBookConcern1.setText(chubanshe);
            jtxBookAuthor.setText(zuozhe);
            jtxBookPurchaseMoney.setText(dingjia);
            jtxBookBorrowMoneyNum1.setText(shuliang);
            jtxBookStation.setText(weizhi);
            jtxBookLanguage.setText(yuyan);
            jtxBookType1.setText(fenlei);

         }

     }

    public void jTreeqikan_mouseClicked(MouseEvent e) {
        display();
    }


}


class MagazineInfoSystemPanel1_jTreeqikan_mouseAdapter extends MouseAdapter {
    private MagazineInfoSystemPanel1 adaptee;
    MagazineInfoSystemPanel1_jTreeqikan_mouseAdapter(MagazineInfoSystemPanel1
            adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {

        adaptee.jTreeqikan_mouseClicked(e);
    }
}


class MagazineInfoSystemPanel1_jTeaRightTop_mouseAdapter extends MouseAdapter {
    private MagazineInfoSystemPanel1 adaptee;
    MagazineInfoSystemPanel1_jTeaRightTop_mouseAdapter(MagazineInfoSystemPanel1
            adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {

        adaptee.jTeaRightTop_mouseClicked(e);
    }
}


class MagazineInfoSystemPanel1_jPaneRightBottom_componentAdapter extends
        ComponentAdapter {
    private MagazineInfoSystemPanel1 adaptee;
    MagazineInfoSystemPanel1_jPaneRightBottom_componentAdapter(
            MagazineInfoSystemPanel1 adaptee) {
        this.adaptee = adaptee;
    }

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


class MagazineInfoSystemPanel1_jPanRight_hierarchyBoundsAdapter extends
        HierarchyBoundsAdapter {
    private MagazineInfoSystemPanel1 adaptee;
    MagazineInfoSystemPanel1_jPanRight_hierarchyBoundsAdapter(
            MagazineInfoSystemPanel1 adaptee) {
        this.adaptee = adaptee;
    }

    public void ancestorResized(HierarchyEvent e) {

        adaptee.jPanRight_ancestorResized(e);
    }
}





class MagazineInfoSystemPanel1_jScright_hierarchyBoundsAdapter extends
        HierarchyBoundsAdapter {
    private MagazineInfoSystemPanel1 adaptee;
    MagazineInfoSystemPanel1_jScright_hierarchyBoundsAdapter(
            MagazineInfoSystemPanel1 adaptee) {
        this.adaptee = adaptee;
    }

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


class MagazineInfoSystemPanel1_jScright_componentAdapter extends
        ComponentAdapter {
    private MagazineInfoSystemPanel1 adaptee;
    MagazineInfoSystemPanel1_jScright_componentAdapter(MagazineInfoSystemPanel1
            adaptee) {
        this.adaptee = adaptee;
    }

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




class MagazineInfoSystemPanel1_this_hierarchyBoundsAdapter extends
        HierarchyBoundsAdapter {
    private MagazineInfoSystemPanel1 adaptee;
    MagazineInfoSystemPanel1_this_hierarchyBoundsAdapter(
            MagazineInfoSystemPanel1 adaptee) {
        this.adaptee = adaptee;
    }

    public void ancestorResized(HierarchyEvent e) {

        adaptee.this_ancestorResized(e);
    }
}