magazineinfosystempanel.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 java.awt.event.MouseEvent;
import java.sql.ResultSet;
import javax.swing.table.DefaultTableModel;
import javax.swing.border.TitledBorder;
import java.awt.event.ActionEvent;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import javax.swing.tree.DefaultMutableTreeNode;
import java.awt.event.ActionListener;
import java.awt.event.MouseAdapter;

/**
 * <p>Title: 图书借阅系统</p>
 *
 * <p>Description: 科学的管理系统</p>
 *
 * <p>Copyright: 吴明卫小组</p>
 *
 * <p>Company: </p>
 *
 * @author 吴明卫
 * @version 1.0
 */
public class MagazineInfoSystemPanel extends JPanel {
    Dbcom db;
    String fenlei="";
   public MagazineInfoSystemPanel(Dbcom db) {
       this.db=db;
       try {
           jbInit();
           loginTree();
       } catch (Exception exception) {
           exception.printStackTrace();
       }
   }
   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 jBttszxgl = new JButton();
  JButton jBttsbmrk = new JButton();
  JTree jTreeQikan = new JTree(qikan,true);
  JSplitPane jSpSystemPanel = new JSplitPane();
  FlowLayout flowLayout1 = new FlowLayout();
  JPanel jPanRight = new JPanel();
  JTabbedPane jTpRightBottom = new JTabbedPane();
  JPanel jPaneRightBottom = new JPanel();
   JPanel jTpRightBottomjPanel4 = new JPanel();
   JPanel jPanelRightTop = new JPanel();
  JScrollPane jScrollPane1 = new JScrollPane();
   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 jtxBookStation = new JTextField();
   JTextField jtxBookBeginHandlers1 = new JTextField();
   JTextField jtxBookType1=new JTextField() ;
   JTextField jtxBookAuthor = new JTextField();
   JTextField jtxBookNum1 = new JTextField();
   JTextField jtxBookLanguage = new JTextField();
   JTextField jtxBookName1 = new JTextField();
   JTextField jtxBookBorrowMoneyNum1 = new JTextField();
   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();
   JButton btnReset = new JButton();
   JButton btnQueRen = new JButton();
   JButton btnAddInfo = new JButton();
   String beizhu="";
   //类型编号
   String bh="";
   JButton btnQueRen2 = new JButton();
   JButton btnReset2 = new JButton();
   JButton btnAddInfo2 = new JButton();
   MagazineLogOutPanel magaizeLogOutPanel1 = new MagazineLogOutPanel();

   private void jbInit() throws Exception {
      this.setLayout(null);
      this.setBounds(new Rectangle(3, 60, 790, 535));
      this.addHierarchyBoundsListener(new MagazineInfoSystemPanel_this_hierarchyBoundsAdapter(this));

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

      jPanelSystemTop.setBounds(new Rectangle(3, 0, 860, 30));
      jSpSystemPanel.setBounds(new Rectangle(2, 30, 863, 505));

      magaizeLogOutPanel1.setBounds(new Rectangle(1, 30, 863, 505));

      jPanelSystemTop.setLayout(flowLayout1);
      jBttszxgl.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
      jBttszxgl.setForeground(Color.blue);
      jBttszxgl.setSelectedIcon(null);
      jBttszxgl.setText("期刊注销管理");
      jBttszxgl.addActionListener(new
                MagazineInfoSystemPanel_jBttszxgl_actionAdapter(this));

        jBttsbmrk.setBackground(SystemColor.menu);
       jBttsbmrk.setEnabled(true);
       jBttsbmrk.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jBttsbmrk.setForeground(Color.blue);
       jBttsbmrk.setText("期刊编目入库");
        jBttsbmrk.addActionListener(new
                MagazineInfoSystemPanel_jBttsbmrk_actionAdapter(this));

        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.setBounds(new Rectangle(2, 2, 704, 311));

      jPanelRightTop.setBounds(new Rectangle(1, 318, 693, 185));
        jPaneRightBottom.setBounds(new Rectangle( 1, 2, 705, 316));
        jPaneRightBottom.addComponentListener(new
                MagazineInfoSystemPanel_jPaneRightBottom_componentAdapter(this));

        jPaneRightBottom.setLayout(null);
       jTpRightBottomjPanel4.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
                MagazineInfoSystemPanel_jTreBooks_mouseAdapter(this));

        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel1.setForeground(Color.blue);
       jLabel1.setText("操作人员");
       jLabel1.setBounds(new Rectangle(381, 142, 58, 20));
       jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel2.setForeground(Color.blue);
       jLabel2.setText("数    量");
       jLabel2.setBounds(new Rectangle(22, 142, 58, 20));
       jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel3.setForeground(Color.blue);
       jLabel3.setText("书架位置");
       jLabel3.setBounds(new Rectangle(381, 112, 58, 20));
       jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel4.setForeground(Color.blue);
       jLabel4.setText("期刊语种");
       jLabel4.setBounds(new Rectangle(22, 112, 58, 20));
       jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel5.setForeground(Color.blue);
       jLabel5.setText("期刊分类");
       jLabel5.setBounds(new Rectangle(381, 18, 58, 20));
       jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel6.setForeground(Color.blue);
       jLabel6.setText("期刊名称");
       jLabel6.setBounds(new Rectangle(22, 18, 58, 20));
       jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel7.setForeground(Color.blue);
       jLabel7.setText("期刊编号");
       jLabel7.setBounds(new Rectangle(22, 49, 58, 20));
       jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel8.setForeground(Color.blue);
       jLabel8.setText("订阅代码");
       jLabel8.setBounds(new Rectangle(22, 81, 58, 20));
       jLabel9.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel9.setForeground(Color.blue);
       jLabel9.setText("期刊定价");
       jLabel9.setBounds(new Rectangle(381, 81, 58, 20));
       jLabel10.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel10.setForeground(Color.blue);
       jLabel10.setText("出 版 社");
       jLabel10.setBounds(new Rectangle(381, 49, 58, 20));
       jtxBookConcern1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxBookConcern1.setForeground(Color.blue);
       jtxBookConcern1.setBounds(new Rectangle(453, 49, 197, 23));
       jtxBookPurchaseMoney.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxBookPurchaseMoney.setForeground(Color.blue);
       jtxBookPurchaseMoney.setText("");
       jtxBookPurchaseMoney.setBounds(new Rectangle(453, 81, 197, 23));
       jtxBookStation.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxBookStation.setForeground(Color.blue);
       jtxBookStation.setText("");
       jtxBookStation.setBounds(new Rectangle(453, 112, 197, 23));
       jtxBookBeginHandlers1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxBookBeginHandlers1.setForeground(Color.blue);
       jtxBookBeginHandlers1.setEditable(false);
       jtxBookBeginHandlers1.setText("默认当前操作人员");
       jtxBookBeginHandlers1.setBounds(new Rectangle(453, 142, 197, 23));
       // 下拉菜单
       jtxBookType1.setText("请点击左边的类型选择");
       jtxBookType1.setEnabled(false);
       //
       jtxBookType1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxBookType1.setForeground(Color.magenta);
       jtxBookType1.setEditable(true);

       jtxBookType1.setBounds(new Rectangle(453, 18, 197, 23));
       jtxBookAuthor.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxBookAuthor.setForeground(Color.blue);
       jtxBookAuthor.setText("");
       jtxBookAuthor.setBounds(new Rectangle(86, 81, 197, 23));
       jtxBookNum1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxBookNum1.setForeground(Color.magenta);
       jtxBookNum1.setToolTipText("");
       jtxBookNum1.setText("填写完信息点击获取编号");
       jtxBookNum1.setBounds(new Rectangle(86, 49, 197, 23));
        jtxBookNum1.addMouseListener(new
                MagazineInfoSystemPanel_jtxBookNum1_mouseAdapter(this));
        jtxBookNum1.addActionListener(new
                MagazineInfoSystemPanel_jtxBookNum1_actionAdapter(this));

        jtxBookLanguage.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxBookLanguage.setForeground(Color.blue);
       jtxBookLanguage.setText("");
       jtxBookLanguage.setBounds(new Rectangle(87, 112, 197, 23));
        jtxBookName1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxBookName1.setForeground(Color.blue);
        jtxBookName1.setText("");
       jtxBookName1.setBounds(new Rectangle(86, 18, 197, 23));
        jtxBookName1.addHierarchyBoundsListener(new
                MagazineInfoSystemPanel_jtxBookName1_hierarchyBoundsAdapter(this));
        jtxBookBorrowMoneyNum1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxBookBorrowMoneyNum1.setForeground(Color.blue);
       jtxBookBorrowMoneyNum1.setText("");
       jtxBookBorrowMoneyNum1.setBounds(new Rectangle(87, 142, 197, 23));
       jLabel12.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel12.setForeground(Color.blue);
       jLabel12.setText("订阅代码");
       jLabel12.setBounds(new Rectangle(27, 81, 61, 14));
       jLabel13.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel13.setForeground(Color.blue);
       jLabel13.setText("期刊语种");
       jLabel13.setBounds(new Rectangle(27, 110, 61, 14));
        jtxBookName2.setEnabled(false);
        jtxBookName2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxBookName2.setForeground(Color.blue);
        jtxBookName2.setText("请点击输入名称");
       jtxBookName2.setBounds(new Rectangle(96, 19, 189, 23));
        jtxBookName2.addMouseListener(new
                MagazineInfoSystemPanel_jtxBookName2_mouseAdapter(this));
        jtxBookName2.addActionListener(new
                MagazineInfoSystemPanel_jtxBookName2_actionAdapter(this));
        jtxBookBeginHandlers2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxBookBeginHandlers2.setForeground(Color.blue);
       jtxBookBeginHandlers2.setEditable(false);
       jtxBookBeginHandlers2.setText("默认当前操作人员");
       jtxBookBeginHandlers2.setBounds(new Rectangle(465, 136, 189, 23));
       jtxBookStation2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxBookStation2.setForeground(Color.blue);
       jtxBookStation2.setBounds(new Rectangle(465, 105, 189, 23));
       jLabel14.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel14.setForeground(Color.blue);
       jLabel14.setText("操作人员");
       jLabel14.setBounds(new Rectangle(387, 140, 61, 14));
       jLabel15.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel15.setForeground(Color.blue);
       jLabel15.setText("入库时间");
       jLabel15.setBounds(new Rectangle(387, 83, 61, 14));
       jLabel16.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel16.setForeground(Color.blue);
       jLabel16.setText("期刊编号");
       jLabel16.setBounds(new Rectangle(27, 53, 61, 14));
       jtxBookPurchaseMoney2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxBookPurchaseMoney2.setForeground(Color.blue);
       jtxBookPurchaseMoney2.setBounds(new Rectangle(465, 76, 189, 23));
       jtxBookConcern2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxBookConcern2.setForeground(Color.blue);
       jtxBookConcern2.setBounds(new Rectangle(465, 48, 189, 23));
       jtxBookType2.setEnabled(false);
       jtxBookType2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxBookType2.setForeground(Color.blue);
       jtxBookType2.setEditable(true);
       jtxBookType2.setBounds(new Rectangle(465, 18, 189, 23));
       jLabel17.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel17.setForeground(Color.red);
       jLabel17.setText("增加数量");
       jLabel17.setBounds(new Rectangle(27, 141, 61, 14));
       jtxBookLanguage2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxBookLanguage2.setForeground(Color.blue);
       jtxBookLanguage2.setBounds(new Rectangle(96, 106, 189, 23));
       jLabel18.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel18.setForeground(Color.blue);
       jLabel18.setText("期刊名称");
       jLabel18.setBounds(new Rectangle(27, 23, 61, 14));
       jtxBookAuthor2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxBookAuthor2.setForeground(Color.blue);
       jtxBookAuthor2.setBounds(new Rectangle(96, 77, 189, 23));
       jtxBookNum2.setEnabled(false);
       jtxBookNum2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));