magazinelogoutpanel.java

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

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

           }

           catch (SQLException sex) {
               System.out.println(sex.toString());
               // sex.printStackTrace();
           }
           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 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);
    }
}