magazinelogoutpanel.java

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

package booksboeeowreadsystem;

import java.awt.*;

import javax.swing.*;
import java.awt.*;
import com.borland.internetbeans.IxTable;
import java.awt.event.HierarchyEvent;
import java.awt.event.HierarchyBoundsAdapter;
import java.awt.event.ComponentEvent;
import java.awt.event.ComponentAdapter;
import javax.swing.tree.DefaultMutableTreeNode;
import java.sql.ResultSet;
import java.sql.*;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import javax.swing.table.DefaultTableModel;
import com.borland.jbcl.layout.XYLayout;
import javax.swing.border.TitledBorder;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
/**
 * <p>Title: 图书借阅系统</p>
 *
 * <p>Description: 科学的管理系统</p>
 *
 * <p>Copyright: 吴明卫小组</p>
 *
 * <p>Company: </p>
 *
 * @author 吴明卫
 * @version 1.0
 */
public class MagazineLogOutPanel extends JPanel {
    Dbcom db = new Dbcom();
    String fenlei = "";
    DefaultMutableTreeNode qikan = new DefaultMutableTreeNode("所有期刊");
    String[] title = {"期刊编号", "期刊名称", "期刊类别编号", "出版社", "订阅代码", "可借数量", "入库时间",
                     "语言种类", "定价", "是否可用", "书架位置"};

    String type1 = "";
    IxTable ixTable1 = new IxTable();
    JTable jTeaRightTop2 = new JTable();
    JScrollPane jScright = new JScrollPane();
    JScrollPane jScleft = new JScrollPane();
    JTree jTreeQikan = new JTree(qikan, true);
    JSplitPane jSpSystemPanel = new JSplitPane();
    JPanel jPanRight = new JPanel();
    JTabbedPane jTpRightBottom = new JTabbedPane();
    JPanel jPaneRightBottom = new JPanel();
    JPanel jPanelRightTop = new JPanel();
    JScrollPane jScrollPane1 = new JScrollPane();
    JLabel jLabel12 = new JLabel();
    JLabel jLabel13 = new JLabel();
    JTextField jtxBookName2 = new JTextField();
    JTextField jtxBookBeginHandlers2 = new JTextField();
    JTextField jtxBookStation2 = new JTextField();
    JLabel jLabel14 = new JLabel();
    JLabel jLabel15 = new JLabel();
    JLabel jLabel16 = new JLabel();
    JTextField jtxBookPurchaseMoney2 = new JTextField();
    JTextField jtxBookConcern2 = new JTextField();
    JTextField jtxBookType2 = new JTextField();
    JLabel jLabel17 = new JLabel();
    JTextField jtxBookLanguage2 = new JTextField();
    JLabel jLabel18 = new JLabel();
    JTextField jtxBookAuthor2 = new JTextField();
    JTextField jtxBookNum2 = new JTextField();
    JTextField jtxBookBorrowMoneyNum2 = new JTextField();
    JLabel jLabel19 = new JLabel();
    JPanel jTpRightBottomPanel2 = new JPanel();
    JLabel jLabel20 = new JLabel();
    JLabel jLabel21 = new JLabel();
    TitledBorder titledBorder1 = new TitledBorder("");
    TitledBorder titledBorder2 = new TitledBorder("");
    JPanel jPanelRightTopjPanel = new JPanel();
    JLabel jlbM = new JLabel();
    String beizhu = "";
    //类型编号
    String bh = "";
    JButton btnQueRen2 = new JButton();
    JButton btnReset2 = new JButton();
    JTextArea jtxLogOut = new JTextArea();
    JLabel jLabel2 = new JLabel();
    JScrollPane jScrollPane2 = new JScrollPane();
    TitledBorder titledBorder3 = new TitledBorder("");

    public MagazineLogOutPanel() {
        try {

            jbInit();
            loginTree();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {

        this.setLayout(null);
        this.setBounds(new Rectangle(3, 60, 790, 535));
        this.addComponentListener(new MagazineLogOutPanel_this_componentAdapter(this));
        this.addHierarchyBoundsListener(new
                                        MagazineLogOutPanel_this_hierarchyBoundsAdapter(this));

        jTeaRightTop2.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jTeaRightTop2.setForeground(Color.blue);

        jSpSystemPanel.setBounds(new Rectangle(1, 1, 863, 505));

        jPanRight.setLayout(null);
        jTpRightBottom.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTpRightBottom.setForeground(Color.blue);
        jTpRightBottom.setBounds(new Rectangle( -2, 1, 704, 311));

        jPanelRightTop.setBounds(new Rectangle(3, 318, 693, 185));
        jPanelRightTop.addMouseListener(new
                                        MagazineLogOutPanel_jPanelRightTop_mouseAdapter(this));
        jPaneRightBottom.setBounds(new Rectangle(4, 2, 702, 316));
        jPaneRightBottom.addComponentListener(new
                                              MagazineLogOutPanel_jPaneRightBottom_componentAdapter(this));

        jPaneRightBottom.setLayout(null);
        jPanelRightTop.setBorder(BorderFactory.createEtchedBorder());
        jPanelRightTop.setLayout(null);
        jTreeQikan.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jTreeQikan.setForeground(Color.blue);
        jTreeQikan.addMouseListener(new
                                    MagazineLogOutPanel_jTreBooks_mouseAdapter(this));

        jLabel12.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel12.setForeground(Color.blue);
        jLabel12.setText("期刊作者");
        jLabel12.setBounds(new Rectangle(25, 63, 61, 14));
        jLabel13.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel13.setForeground(Color.blue);
        jLabel13.setText("期刊语种");
        jLabel13.setBounds(new Rectangle(25, 89, 61, 14));
        jtxBookName2.setEnabled(false);
        jtxBookName2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookName2.setForeground(Color.blue);
        jtxBookName2.setEditable(true);
        jtxBookName2.setBounds(new Rectangle(95, 7, 187, 21));
        jtxBookBeginHandlers2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookBeginHandlers2.setForeground(Color.blue);
        jtxBookBeginHandlers2.setEditable(false);
        jtxBookBeginHandlers2.setText("当前系统操作员");
        jtxBookBeginHandlers2.setBounds(new Rectangle(448, 110, 187, 21));
        jtxBookStation2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookStation2.setForeground(Color.blue);
        jtxBookStation2.setBounds(new Rectangle(448, 85, 187, 21));
        jLabel14.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel14.setForeground(Color.blue);
        jLabel14.setText("操作人员");
        jLabel14.setBounds(new Rectangle(371, 114, 61, 14));
        jLabel15.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel15.setForeground(Color.blue);
        jLabel15.setText("书架位置");
        jLabel15.setBounds(new Rectangle(371, 89, 61, 14));
        jLabel16.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel16.setForeground(Color.blue);
        jLabel16.setText("期刊编号");
        jLabel16.setBounds(new Rectangle(25, 37, 61, 14));
        jtxBookPurchaseMoney2.setEnabled(false);
        jtxBookPurchaseMoney2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookPurchaseMoney2.setForeground(Color.blue);
        jtxBookPurchaseMoney2.setBounds(new Rectangle(448, 59, 187, 21));
        jtxBookConcern2.setEnabled(false);
        jtxBookConcern2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookConcern2.setForeground(Color.blue);
        jtxBookConcern2.setEditable(true);
        jtxBookConcern2.setBounds(new Rectangle(448, 33, 187, 21));
        jtxBookType2.setEnabled(false);
        jtxBookType2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookType2.setForeground(Color.blue);
        jtxBookType2.setEditable(true);
        jtxBookType2.setBounds(new Rectangle(448, 7, 187, 21));
        jLabel17.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel17.setForeground(Color.blue);
        jLabel17.setText("当前数量");
        jLabel17.setBounds(new Rectangle(25, 114, 61, 14));
        jtxBookLanguage2.setEnabled(false);
        jtxBookLanguage2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookLanguage2.setForeground(Color.blue);
        jtxBookLanguage2.setEditable(true);
        jtxBookLanguage2.setBounds(new Rectangle(95, 85, 187, 21));
        jLabel18.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel18.setForeground(Color.blue);
        jLabel18.setText("期刊名称");
        jLabel18.setBounds(new Rectangle(26, 11, 61, 14));
        jtxBookAuthor2.setEnabled(false);
        jtxBookAuthor2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookAuthor2.setForeground(Color.blue);
        jtxBookAuthor2.setEditable(true);
        jtxBookAuthor2.setBounds(new Rectangle(95, 59, 187, 21));
        jtxBookNum2.setEnabled(false);
        jtxBookNum2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookNum2.setForeground(Color.blue);
        jtxBookNum2.setEditable(true);
        jtxBookNum2.setText("点击输入期刊编号");
        jtxBookNum2.setBounds(new Rectangle(95, 33, 187, 21));
        jtxBookNum2.addMouseListener(new
                                     MagazineLogOutPanel_jtxBookNum2_mouseAdapter(this));
        jtxBookNum2.addActionListener(new
                                      MagazineLogOutPanel_jtxBookNum2_actionAdapter(this));
        jtxBookBorrowMoneyNum2.setEnabled(false);

        jtxBookBorrowMoneyNum2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookBorrowMoneyNum2.setForeground(Color.red);
        jtxBookBorrowMoneyNum2.setEditable(true);
        jtxBookBorrowMoneyNum2.setText("");
        jtxBookBorrowMoneyNum2.setBounds(new Rectangle(95, 110, 187, 21));
        jLabel19.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel19.setForeground(Color.blue);
        jLabel19.setText("期刊定价");
        jLabel19.setBounds(new Rectangle(371, 63, 61, 14));
        jLabel20.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel20.setForeground(Color.blue);
        jLabel20.setText("出 版 社");
        jLabel20.setBounds(new Rectangle(371, 37, 61, 14));
        jLabel21.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel21.setForeground(Color.blue);
        jLabel21.setText("期刊分类");
        jLabel21.setBounds(new Rectangle(371, 11, 61, 14));
        jTpRightBottomPanel2.setLayout(null);
        jTeaRightTop2.getTableHeader().setFont(new java.awt.Font("宋体",
                Font.PLAIN, 14));
        jTeaRightTop2.getTableHeader().setForeground(Color.blue);
        jTeaRightTop2.setGridColor(Color.black);
        jTeaRightTop2.setRowHeight(20);
        jTeaRightTop2.addMouseListener(new
                                       MagazineLogOutPanel_jTeaRightTop_mouseAdapter(this));
        jPanelRightTopjPanel.setBorder(BorderFactory.createEtchedBorder());
        jPanelRightTopjPanel.setBounds(new Rectangle(1, 0, 607, 26));
        jPanelRightTopjPanel.setLayout(null);
        jScrollPane1.setBorder(null);
        jScrollPane1.setBounds(new Rectangle(1, 29, 562, 240));
        jlbM.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jlbM.setForeground(Color.magenta);
        jlbM.setHorizontalAlignment(SwingConstants.CENTER);
        jlbM.setHorizontalTextPosition(SwingConstants.CENTER);
        jlbM.setText("期刊信息列表");
        jlbM.setBounds(new Rectangle(7, 6, 598, 20));

        btnQueRen2.setBounds(new Rectangle(74, 206, 123, 30));
        btnQueRen2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        btnQueRen2.setForeground(Color.red);
        btnQueRen2.setText("确认注销");
        btnReset2.setBounds(new Rectangle(419, 206, 123, 30));
        btnReset2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        btnReset2.setForeground(Color.blue);
        btnReset2.setText("数据重置");

        jScrollPane2.setBorder(BorderFactory.createLineBorder(Color.black));
        jScrollPane2.setBounds(new Rectangle(97, 144, 537, 54));
        jtxLogOut.setBounds(2, 2, jScrollPane2.getWidth() - 10,
                            jScrollPane2.getHeight() - 10);
        jtxLogOut.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        jtxLogOut.setForeground(Color.red);
        jtxLogOut.setBorder(BorderFactory.createEtchedBorder());
        jtxLogOut.setToolTipText("");
        jtxLogOut.setMargin(new Insets(10, 10, 10, 10));
        jtxLogOut.setText("必添");
        jtxLogOut.setLineWrap(true);
        jLabel2.setFont(new java.awt.Font("宋体", Font.BOLD, 16));
        jLabel2.setForeground(Color.red);
        jLabel2.setText("注销原因");
        jLabel2.setBounds(new Rectangle(24, 150, 71, 27));
        jScright.addComponentListener(new
                                      MagazineLogOutPanel_jScright_componentAdapter(this));
        jScright.addHierarchyBoundsListener(new
                                            MagazineLogOutPanel_jScright_hierarchyBoundsAdapter(this));
        jPanRight.addHierarchyBoundsListener(new
                                             MagazineLogOutPanel_jPanRight_hierarchyBoundsAdapter(this));

        jSpSystemPanel.add(jScleft, JSplitPane.LEFT);
        jScleft.getViewport().add(jTreeQikan);
        jSpSystemPanel.add(jScright, JSplitPane.RIGHT);
        jScright.getViewport().add(jPanRight);
        jPanRight.add(jPaneRightBottom);
        jPaneRightBottom.add(jTpRightBottom);
        jPanRight.add(jPanelRightTop);
        jTpRightBottom.add(jTpRightBottomPanel2, "期刊注销业务   ");
        jPanelRightTop.add(jPanelRightTopjPanel);
        jPanelRightTopjPanel.add(jlbM);
        jPanelRightTop.add(jScrollPane1);
        jScrollPane1.getViewport().add(jTeaRightTop2);
        jTpRightBottomPanel2.add(jLabel18);
        jTpRightBottomPanel2.add(jtxBookName2);
        jTpRightBottomPanel2.add(jLabel16);
        jTpRightBottomPanel2.add(jtxBookNum2);
        jTpRightBottomPanel2.add(jLabel12);
        jTpRightBottomPanel2.add(jtxBookAuthor2);
        jTpRightBottomPanel2.add(jLabel13);
        jTpRightBottomPanel2.add(jtxBookLanguage2);
        jTpRightBottomPanel2.add(jLabel17);
        jTpRightBottomPanel2.add(jtxBookBorrowMoneyNum2);
        jTpRightBottomPanel2.add(jLabel2);
        jTpRightBottomPanel2.add(btnReset2);
        jTpRightBottomPanel2.add(btnQueRen2);
        jTpRightBottomPanel2.add(jScrollPane2);
        jTpRightBottomPanel2.add(jtxBookStation2);
        jTpRightBottomPanel2.add(jtxBookType2);
        jTpRightBottomPanel2.add(jLabel21);
        jTpRightBottomPanel2.add(jLabel20);
        jTpRightBottomPanel2.add(jtxBookConcern2);
        jTpRightBottomPanel2.add(jtxBookPurchaseMoney2);
        jTpRightBottomPanel2.add(jLabel19);
        jTpRightBottomPanel2.add(jLabel15);
        jTpRightBottomPanel2.add(jLabel14);
        jTpRightBottomPanel2.add(jtxBookBeginHandlers2);
        jScrollPane2.getViewport().add(jtxLogOut);
        this.add(jSpSystemPanel);
        // jPanelRightTopjPanel
    }

    public void loginTree() {
        ResultSet re = null;
        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 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,