magazineinfosystempanel1.java

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

package booksboeeowreadsystem;

import java.awt.*;

import javax.swing.*;
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 java.awt.event.ContainerEvent;
import java.awt.event.ContainerAdapter;
import javax.swing.tree.DefaultMutableTreeNode;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import javax.swing.table.DefaultTableModel;

/**
 * <p>Title: 图书借阅系统</p>
 *
 * <p>Description: 科学的管理系统</p>
 *
 * <p>Copyright: 吴明卫小组</p>
 *
 * <p>Company: </p>
 *
 * @author 吴明卫
 * @version 1.0
 */
public class MagazineInfoSystemPanel1 extends JPanel {
    Dbcom db;
    String fenlei = "";
    DefaultMutableTreeNode qikan = new DefaultMutableTreeNode("所有期刊");
    String[] title = {"期刊编号", "期刊名称", "期刊类别编号", "出版社", "订阅代码", "可借数量", "入库时间",
                     "语言种类", "定价", "是否可用", "书架位置"};
    IxTable ixTable1 = new IxTable();
     JTable jTeaRightTop = new JTable();
     JScrollPane jScright = new JScrollPane();
     JScrollPane jScleft = new JScrollPane();
     JPanel jPanelSystemTop = new JPanel();
     JButton jBtyqqk = new JButton();
     JButton jBttsdacx = new JButton();
     JTree jTreeqikan = new JTree(qikan, true);
     JSplitPane jSpSystemPanel = new JSplitPane();
     FlowLayout flowLayout1 = new FlowLayout();
     JPanel jPanRight = new JPanel();
     JPanel jTpRightBottom = new JPanel();
     JPanel jPaneRightBottom = new JPanel();
     JPanel jTpRightBottomjPanel4 = new JPanel();
     JPanel jPanelRightTop = new JPanel();
     JScrollPane jScrollPane1 = new JScrollPane();
     JButton jBttsrkcx = new JButton();
     JButton jBttszxcx = new JButton();
     JLabel jLabel1 = new JLabel();
     JLabel jLabel2 = new JLabel();
     JLabel jLabel3 = new JLabel();
     JLabel jLabel4 = new JLabel();
     JLabel jLabel5 = new JLabel();
     JLabel jLabel6 = new JLabel();
     JLabel jLabel7 = new JLabel();
     JLabel jLabel8 = new JLabel();
     JLabel jLabel9 = new JLabel();
     JLabel jLabel10 = new JLabel();
     JTextField jtxBookConcern1 = new JTextField();
     JTextField jtxBookPurchaseMoney = new JTextField();
     JTextField jtxRuKuCaozuo = new JTextField();
     JTextField jtxBookBeginHandlers1 = new JTextField();
     JTextField jtxBookType1 = new JTextField();
     JTextField jtxBookAuthor = new JTextField();
     JTextField jtxBookNum1 = new JTextField();
     JTextField jtxRuKuTime = new JTextField();
     JTextField jtxBookName1 = new JTextField();
     JTextField jtxLogOutTime = new JTextField();
     javax.swing.JTextField jtxBookLanguage = new JTextField();
     javax.swing.JLabel jLabel11 = new JLabel();
     javax.swing.JLabel jLabel22 = new JLabel();
     javax.swing.JTextField jtxBookStation = new JTextField();
     javax.swing.JLabel jLabel23 = new JLabel();
     javax.swing.JLabel jLabel24 = new JLabel();
     javax.swing.JTextField jtxBookBorrowMoneyNum1 = new JTextField();
     javax.swing.JTextField jTextField4 = new JTextField();
     public MagazineInfoSystemPanel1(Dbcom db) {
         try {
             this.db=db;
             jbInit();
             loginTree();
         } catch (Exception exception) {
             exception.printStackTrace();
         }
     }


     private void jbInit() throws Exception {
         this.setLayout(null);
         this.setBounds(new Rectangle(3, 60, 790, 535));
         this.addHierarchyBoundsListener(new
                 MagazineInfoSystemPanel1_this_hierarchyBoundsAdapter(this));
         jTeaRightTop.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
         jTeaRightTop.setForeground(Color.blue);
         jPanelSystemTop.setBounds(new Rectangle(3, 0, 860, 30));
         jPanelSystemTop.setLayout(flowLayout1);
        jBtyqqk.setEnabled(false);
        jBtyqqk.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jBtyqqk.setForeground(Color.blue);
         jBtyqqk.setText("期刊借阅查询");
         jBttsdacx.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jBttsdacx.setForeground(Color.blue);
         jBttsdacx.setText("期刊档案查询");
         jSpSystemPanel.setBounds(new Rectangle(2, 30, 863, 505));
         flowLayout1.setAlignment(FlowLayout.LEFT);
         flowLayout1.setHgap(0);
         flowLayout1.setVgap(0);
         jPanRight.setLayout(null);
         jTpRightBottom.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jTpRightBottom.setForeground(Color.blue);
         jTpRightBottom.setBorder(BorderFactory.createEtchedBorder());
         jTpRightBottom.setBounds(new Rectangle(2, 2, 704, 311));
         jTpRightBottom.setLayout(null);
         jPaneRightBottom.setBounds(new Rectangle( -1, 187, 705, 316));
         jPaneRightBottom.addComponentListener(new
                 MagazineInfoSystemPanel1_jPaneRightBottom_componentAdapter(this));
         jPaneRightBottom.setLayout(null);
         jTpRightBottomjPanel4.setLayout(null);
         jPanelRightTop.setBorder(BorderFactory.createEtchedBorder());
         jPanelRightTop.setBounds(new Rectangle(1, 2, 693, 185));

         jPanelRightTop.setLayout(null);
         jPanelRightTop.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jPanelRightTop.setForeground(Color.blue);
         //jPanelRightTop
         jTreeqikan.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jTreeqikan.setForeground(Color.blue);
        jTreeqikan.addMouseListener(new
                MagazineInfoSystemPanel1_jTreeqikan_mouseAdapter(this));
        jBttsrkcx.setEnabled(false);
        jBttsrkcx.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jBttsrkcx.setForeground(Color.blue);
         jBttsrkcx.setText("期刊入库查询");
        jBttszxcx.setEnabled(false);
        jBttszxcx.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jBttszxcx.setForeground(Color.blue);
         jBttszxcx.setText("期刊注销查询");
         jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel1.setForeground(Color.blue);
         jLabel1.setText("注销操作员");
         jLabel1.setBounds(new Rectangle(339, 193, 70, 20));
         jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel2.setForeground(Color.blue);
         jLabel2.setText("注销时间");
         jLabel2.setBounds(new Rectangle(25, 192, 58, 20));
         jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel3.setForeground(Color.blue);
         jLabel3.setText("损坏数量");
         jLabel3.setBounds(new Rectangle(339, 134, 58, 20));
         jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel4.setForeground(Color.blue);
         jLabel4.setText("入库时间");
         jLabel4.setBounds(new Rectangle(25, 166, 58, 20));
         jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel5.setForeground(Color.blue);
         jLabel5.setText("期刊分类");
         jLabel5.setBounds(new Rectangle(339, 16, 58, 20));
         jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel6.setForeground(Color.blue);
         jLabel6.setText("期刊名称");
         jLabel6.setBounds(new Rectangle(25, 43, 58, 20));
         jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel7.setForeground(Color.blue);
         jLabel7.setText("期刊编号");
         jLabel7.setBounds(new Rectangle(25, 14, 58, 20));
         jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel8.setForeground(Color.blue);
         jLabel8.setText("订阅代码");
         jLabel8.setBounds(new Rectangle(339, 42, 58, 20));
         jLabel9.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel9.setForeground(Color.blue);
         jLabel9.setText("期刊定价");
         jLabel9.setBounds(new Rectangle(339, 75, 58, 20));
         jLabel10.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel10.setForeground(Color.blue);
         jLabel10.setText("出 版 社");
         jLabel10.setBounds(new Rectangle(25, 74, 58, 20));
         jtxBookConcern1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jtxBookConcern1.setForeground(Color.blue);
         jtxBookConcern1.setBounds(new Rectangle(423, 39, 165, 23));
         jtxBookPurchaseMoney.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jtxBookPurchaseMoney.setForeground(Color.blue);
         jtxBookPurchaseMoney.setText("");
         jtxBookPurchaseMoney.setBounds(new Rectangle(107, 160, 165, 23));
         jtxRuKuCaozuo.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jtxRuKuCaozuo.setForeground(Color.blue);
         jtxRuKuCaozuo.setText("");
         jtxRuKuCaozuo.setBounds(new Rectangle(423, 162, 165, 23));
         jtxBookBeginHandlers1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jtxBookBeginHandlers1.setForeground(Color.blue);
         jtxBookBeginHandlers1.setText("");
         jtxBookBeginHandlers1.setBounds(new Rectangle(424, 190, 165, 23));
         jtxBookType1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jtxBookType1.setForeground(Color.blue);
         jtxBookType1.setText("");
         jtxBookType1.setBounds(new Rectangle(423, 10, 165, 23));
         jtxBookAuthor.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jtxBookAuthor.setForeground(Color.blue);
         jtxBookAuthor.setText("");
         jtxBookAuthor.setBounds(new Rectangle(107, 73, 165, 23));
         jtxBookNum1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jtxBookNum1.setForeground(Color.blue);
         jtxBookNum1.setText("");
         jtxBookNum1.setBounds(new Rectangle(107, 42, 165, 23));
         jtxRuKuTime.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jtxRuKuTime.setForeground(Color.blue);
         jtxRuKuTime.setText("");
         jtxRuKuTime.setBounds(new Rectangle(423, 98, 165, 23));
         jtxBookName1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jtxBookName1.setForeground(Color.blue);
         jtxBookName1.setText("");
         jtxBookName1.setBounds(new Rectangle(107, 13, 165, 23));
         jtxLogOutTime.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jtxLogOutTime.setForeground(Color.blue);
         jtxLogOutTime.setText("");
         jtxLogOutTime.setBounds(new Rectangle(107, 191, 165, 23));
         jScright.addHierarchyBoundsListener(new
                 MagazineInfoSystemPanel1_jScright_hierarchyBoundsAdapter(this));
         jScright.addComponentListener(new
                 MagazineInfoSystemPanel1_jScright_componentAdapter(this));
         jPanRight.addHierarchyBoundsListener(new
                 MagazineInfoSystemPanel1_jPanRight_hierarchyBoundsAdapter(this));
         jtxBookLanguage.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jtxBookLanguage.setForeground(Color.blue);
         jtxBookLanguage.setBounds(new Rectangle(107, 102, 165, 23));
         jLabel11.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel11.setForeground(Color.blue);
         jLabel11.setText("期刊语种");
         jLabel11.setBounds(new Rectangle(25, 106, 58, 20));
         jLabel22.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel22.setForeground(Color.blue);
         jLabel22.setText("数    量");
         jLabel22.setBounds(new Rectangle(25, 133, 58, 20));
         jtxBookStation.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jtxBookStation.setForeground(Color.blue);
         jtxBookStation.setBounds(new Rectangle(423, 70, 165, 23));
         jLabel23.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel23.setForeground(Color.blue);
         jLabel23.setText("入库操作员");
         jLabel23.setBounds(new Rectangle(339, 165, 70, 20));
         jLabel24.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel24.setForeground(Color.blue);
         jLabel24.setText("书架位置");
         jLabel24.setBounds(new Rectangle(339, 106, 58, 20));
         jtxBookBorrowMoneyNum1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jtxBookBorrowMoneyNum1.setForeground(Color.blue);
         jtxBookBorrowMoneyNum1.setBounds(new Rectangle(107, 132, 165, 23));
         jTextField4.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jTextField4.setForeground(Color.blue);
         jTextField4.setBounds(new Rectangle(423, 131, 165, 23));
         jTeaRightTop.getTableHeader().setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jTeaRightTop.getTableHeader().setForeground(Color.blue);
         jTeaRightTop.setGridColor(Color.cyan);
         jTeaRightTop.setRowHeight(20);
        jTeaRightTop.addMouseListener(new
                MagazineInfoSystemPanel1_jTeaRightTop_mouseAdapter(this));
        jTpRightBottomjPanel4.setBounds(new Rectangle(1,1, jTpRightBottom.getWidth()-2,jTpRightBottom.getHeight()-2 ));

         this.add(jPanelSystemTop);
         jPanelSystemTop.add(jBttsdacx);
         jPanelSystemTop.add(jBtyqqk);
         jPanelSystemTop.add(jBttsrkcx);
         jPanelSystemTop.add(jBttszxcx);
         this.add(jSpSystemPanel);
         jScright.getViewport().add(jPanRight);
         jPanRight.add(jPaneRightBottom);
         jPanRight.add(jPanelRightTop);
         jPanelRightTop.add(jScrollPane1);
         jScrollPane1.getViewport().add(jTeaRightTop);
         jPaneRightBottom.add(jTpRightBottom);
        jTpRightBottomjPanel4.add(jLabel5);
        jTpRightBottomjPanel4.add(jLabel8);
        jTpRightBottomjPanel4.add(jLabel9);
        jTpRightBottomjPanel4.add(jLabel24);
        jTpRightBottomjPanel4.add(jLabel3);
        jTpRightBottomjPanel4.add(jLabel23);
        jTpRightBottomjPanel4.add(jLabel1);
        jTpRightBottomjPanel4.add(jtxBookLanguage);
        jTpRightBottomjPanel4.add(jLabel7);
        jTpRightBottomjPanel4.add(jLabel6);
        jTpRightBottomjPanel4.add(jLabel10);
        jTpRightBottomjPanel4.add(jLabel11);
        jTpRightBottomjPanel4.add(jLabel22);
        jTpRightBottomjPanel4.add(jLabel4);
        jTpRightBottomjPanel4.add(jLabel2);
        jTpRightBottomjPanel4.add(jtxBookName1);
        jTpRightBottomjPanel4.add(jtxBookNum1);
        jTpRightBottomjPanel4.add(jtxBookAuthor);
        jTpRightBottomjPanel4.add(jtxBookBorrowMoneyNum1);
        jTpRightBottomjPanel4.add(jtxLogOutTime);
        jTpRightBottomjPanel4.add(jtxBookPurchaseMoney);
        jTpRightBottomjPanel4.add(jtxRuKuCaozuo);
        jTpRightBottomjPanel4.add(jtxBookType1);
        jTpRightBottomjPanel4.add(jtxBookConcern1);
        jTpRightBottomjPanel4.add(jtxBookStation);
        jTpRightBottomjPanel4.add(jtxRuKuTime);
        jTpRightBottomjPanel4.add(jTextField4);
        jTpRightBottomjPanel4.add(jtxBookBeginHandlers1);
        jTpRightBottom.add(jTpRightBottomjPanel4);
         jSpSystemPanel.add(jScright, JSplitPane.BOTTOM);
         jSpSystemPanel.add(jScleft, JSplitPane.TOP);
         jScleft.getViewport().add(jTreeqikan);
     }

     public void loginTree() {
        ResultSet re = null;
        DefaultMutableTreeNode magazinetypeFather[];