magazineinfosystempanel1.java

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

        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 = "";
                       if (j == 8)
                           s = (new Float(rs.getFloat(j + 2))).toString().trim() +
                               "元";
                       else
                           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();
           }
           db.myClose(1);
       }


     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())/2 - 2);

         jScrollPane1.setSize((jPanelRightTop.getWidth()) - 1,
                              (jPanelRightTop.getHeight()));

         jPaneRightBottom.setBounds(jPanRight.getX() + 1,
                                    (jPanRight.getY() + jPanelRightTop.getHeight() +
                                     3), (jPanRight.getWidth()) - 5,
                                    (jPanRight.getHeight())/2 - 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);
    }
}