dailypperationmagezinsystempanel.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 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;
import javax.swing.table.JTableHeader;
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 DailyPperationMagezinSystemPanel extends JPanel {

    DefaultMutableTreeNode qikan = new DefaultMutableTreeNode("所有期刊");
    String[] title = {"期刊编号","期刊名称","期刊类别编号","出版社","订阅代码","可借数量","入库时间","语言种类","定价","是否可用","书架位置"};
      int title_size=title.length;
      Dbcom db;
      //  DefaultMutableTreeNode books1 = new DefaultMutableTreeNode("");
     Object[][] date;

     public DailyPperationMagezinSystemPanel(Dbcom db) {
         this.db=db;
         try {

                 jbInit();
                 loginTree();

         } catch (Exception exception) {
             exception.printStackTrace();
         }
     }
     IxTable ixTable1 = new IxTable();
     JScrollPane jScright = new JScrollPane();
     JScrollPane jScleft = new JScrollPane();
     JPanel jPanelSystemTop = new JPanel();
     JButton jBtqkjy = 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 jTpRightBottomjPanel3 = new JPanel();
     JButton btnReset = new JButton();
     JPanel jTpRightBottomPane1 = new JPanel();
     JLabel jLabel2 = new JLabel();
     JTextField jTxbookNum = new JTextField();
     JPanel jTpRightBottomjPanel4 = new JPanel();
     JPanel jTpRightBottomjPanel2 = new JPanel();
     JPanel jPanelRightTop = new JPanel();
     JTable jTabRightTop =new JTable();
     JScrollPane jScrollPane1 = new JScrollPane(jTabRightTop);
     JLabel jLabel4 = new JLabel();
     JLabel jLabel5 = new JLabel();
     JLabel jLabel7 = new JLabel();
     JLabel jLabel8 = new JLabel();
     JLabel jLabel9 = new JLabel();
     JTextField jTxbookAuthor = new JTextField();
     JTextField jTxpurchaseMoney = new JTextField();
     JTextField jTxbookType = new JTextField();
     JTextField jTxbookConcern = new JTextField();
     JTextField jTxbookName = new JTextField();
     JButton btnQueren = new JButton();
     JLabel jLabel6 = new JLabel();
     JLabel jLabel10 = new JLabel();
     JTextField jTxpurchaseMoneyX = new JTextField();
     JButton jButton5 = new JButton();
     JTextField jtxbookTypeX = new JTextField();
     JLabel jLabel11 = new JLabel();
     JLabel jLabel12 = new JLabel();
     JButton jButton6 = new JButton();
     JTextField jtxbooksNumX = new JTextField();
     JTextField jtxbooksNamex = new JTextField();
     JTextField jTxbookConcernX = new JTextField();
     JLabel jLabel13 = new JLabel();
     JTextField jTxbookAuthorX = new JTextField();
     JLabel jLabel14 = new JLabel();
     JLabel jLabel1 = new JLabel();
     JLabel jLabel15 = new JLabel();
     JTextField jTxpurchaseMoneyG = new JTextField();
     JButton jButton1 = new JButton();
     JTextField jTxbookTypeG = new JTextField();
     JLabel jLabel16 = new JLabel();
     JLabel jLabel17 = new JLabel();
     JButton btnReturnBooks = new JButton();
     JTextField jTxbookNumG = new JTextField();
     JTextField jtxbooksNameG = new JTextField();
     JTextField jTxbookConcernG = new JTextField();
     JLabel jLabel18 = new JLabel();
     JTextField jTxbookAuthorG = new JTextField();
     JLabel jLabel19 = new JLabel();
     JLabel jLabel3 = new JLabel();
     JLabel jLabel20 = new JLabel();
     JTextField jTxpurchaseMoneyD = new JTextField();
     JButton btnRsectD = new JButton();
     JTextField jTxbookTypeD = new JTextField();
     JLabel jLabel21 = new JLabel();
     JLabel jLabel22 = new JLabel();
     JButton BtnQuerenD = new JButton();
     JTextField jTxbookNumD = new JTextField();
     JTextField jtxbooksNamexD = new JTextField();
     JTextField jTxbookConcernD = new JTextField();
     JLabel jLabel23 = new JLabel();
     JTextField jTxbookAuthorD = new JTextField();
     JLabel jLabel24 = new JLabel();
     JLabel jLabel25 = new JLabel();
     JLabel jTxNumber = new JLabel();
     JTextField jTxreaderNum = new JTextField();
     JLabel jLabel26 = new JLabel();
     JLabel jLabel27 = new JLabel();
     JTextField jTxReaderNumX = new JTextField();
     JLabel jLabel28 = new JLabel();
     JTextField jTxNumberX = new JTextField();
     JLabel jLabel29 = new JLabel();
     JTextField jTxReaderNumG = new JTextField();
     JLabel jLabel30 = new JLabel();
     JTextField jTxNumberG = new JTextField();
     JLabel jLabel31 = new JLabel();
     JTextField jTxReaderNumD = new JTextField();
     JLabel jLabel32 = new JLabel();
     JTextField jTxNumberD = new JTextField();
     //期刊类别临时存储变量
     String fenlei="";
     //当前读者的借书数量和最大量
     int readerNumTemp=0;
     int readerNumTempMax=0;
     //当前读者编号是不是有效的读者
     boolean isReader=false;


     private void jbInit() throws Exception {

         this.setLayout(null);
         this.setBackground(SystemColor.menu);
         this.setBounds(new Rectangle(3, 60, 790, 535));
        this.addComponentListener(new
                DailyPperationMagezinSystemPanel_this_componentAdapter(this));
        this.addHierarchyBoundsListener(new
                DailyPperationMagezinSystemPanel_this_hierarchyBoundsAdapter(this));

        //     books1.add(books);
         jTabRightTop.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
         jTabRightTop.setForeground(Color.blue);
         jTabRightTop.setGridColor(Color.pink);
         jPanelSystemTop.setBounds(new Rectangle(3, 0, 774, 30));
         jPanelSystemTop.setLayout(flowLayout1);
         jBtqkjy.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jBtqkjy.setForeground(Color.blue);
         jBtqkjy.setText("期刊借阅");
        jSpSystemPanel.setBounds(new Rectangle(2, 30, this.getWidth()-5,(this.getHeight()-5)));
        jSpSystemPanel.addComponentListener(new
                DailyPperationMagezinSystemPanel_jSpSystemPanel_componentAdapter(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.setBorder(null);
         jTpRightBottom.setToolTipText("");
         jTpRightBottom.setBounds(new Rectangle(2, 2, 704, 223));
        jTpRightBottom.addMouseListener(new
                DailyPperationMagezinSystemPanel_jTpRightBottom_mouseAdapter(this));

        jPaneRightBottom.setBorder(BorderFactory.createEtchedBorder());
         jPaneRightBottom.setBounds(new Rectangle( -1, 187, 705, 235));
        jPaneRightBottom.addComponentListener(new
                DailyPperationMagezinSystemPanel_jPaneRightBottom_componentAdapter(this));

        jPaneRightBottom.setLayout(null);
         jTpRightBottomjPanel3.setLayout(null);
         btnReset.setBounds(new Rectangle(420, 156, 73, 25));
         btnReset.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         btnReset.setForeground(Color.blue);
         btnReset.setText("重置");
        btnReset.addActionListener(new
                DailyPperationMagezinSystemPanel_btnReset_actionAdapter(this));
        jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel2.setForeground(Color.blue);
         jLabel2.setText("期刊编号");
         jLabel2.setBounds(new Rectangle(28, 50, 56, 16));
         jTxbookNum.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jTxbookNum.setForeground(SystemColor.activeCaption);
         jTxbookNum.setText("");
         jTxbookNum.setBounds(new Rectangle(93, 45, 155, 22));
         jTpRightBottomjPanel4.setLayout(null);
         jTpRightBottomPane1.setLayout(null);

         jPanelRightTop.setBorder(BorderFactory.createEtchedBorder());
         jPanelRightTop.setBounds(new Rectangle(1, 2, 693, 185));
         jPanelRightTop.setLayout(null);

         jTpRightBottomjPanel2.setLayout(null);


         jTpRightBottomjPanel4.setBackground(SystemColor.menu);

         jTpRightBottomjPanel4.setBorder(null);
         jTpRightBottomPane1.setBackground(SystemColor.menu);
         jTpRightBottomPane1.setBorder(null);
         jTpRightBottomjPanel2.setBackground(SystemColor.menu);
         jTpRightBottomjPanel2.setBorder(null);
         jTpRightBottomjPanel3.setBackground(SystemColor.menu);
         jTpRightBottomjPanel3.setBorder(null);
         jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel4.setForeground(Color.blue);
         jLabel4.setText("订阅编号");
         jLabel4.setBounds(new Rectangle(29, 79, 56, 16));
         jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel5.setForeground(Color.blue);
         jLabel5.setText("期刊的定价");
         jLabel5.setBounds(new Rectangle(323, 78, 82, 16));
         jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel7.setForeground(Color.blue);
         jLabel7.setText("期刊类别名");
         jLabel7.setBounds(new Rectangle(323, 16, 82, 16));
         jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel8.setForeground(Color.blue);
         jLabel8.setText("期刊出版社");
         jLabel8.setBounds(new Rectangle(323, 49, 82, 16));
         jLabel9.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel9.setForeground(Color.blue);
         jLabel9.setText("期刊名称");
         jLabel9.setBounds(new Rectangle(28, 17, 56, 16));
         jTxbookAuthor.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jTxbookAuthor.setForeground(SystemColor.activeCaption);
         jTxbookAuthor.setBounds(new Rectangle(93, 77, 155, 22));
         jTxpurchaseMoney.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jTxpurchaseMoney.setForeground(SystemColor.activeCaption);
         jTxpurchaseMoney.setBounds(new Rectangle(405, 76, 195, 22));
         jTxbookType.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jTxbookType.setForeground(SystemColor.activeCaption);
         jTxbookType.setBounds(new Rectangle(405, 14, 195, 22));
         jTxbookConcern.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jTxbookConcern.setForeground(SystemColor.activeCaption);
         jTxbookConcern.setText("");
         jTxbookConcern.setBounds(new Rectangle(405, 44, 195, 22));
         jTxbookName.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jTxbookName.setForeground(SystemColor.activeCaption);
         jTxbookName.setText("");
         jTxbookName.setBounds(new Rectangle(93, 14, 155, 22));
         btnQueren.setBounds(new Rectangle(116, 156, 73, 25));
         btnQueren.setFont(new java.awt.Font("宋体", Font.BOLD, 16));
         btnQueren.setForeground(Color.red);
         btnQueren.setText("借阅");
        btnQueren.addActionListener(new
                DailyPperationMagezinSystemPanel_btnQueren_actionAdapter(this));

        jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel6.setForeground(Color.blue);
         jLabel6.setText("图书出版社");
         jLabel6.setBounds(new Rectangle(346, 47, 82, 16));
         jLabel10.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel10.setForeground(Color.blue);
         jLabel10.setText("订阅编号");
         jLabel10.setBounds(new Rectangle(33, 77, 56, 16));
         jTxpurchaseMoneyX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jTxpurchaseMoneyX.setForeground(SystemColor.activeCaption);
         jTxpurchaseMoneyX.setText("");
         jTxpurchaseMoneyX.setBounds(new Rectangle(428, 74, 155, 22));
         jButton5.setBounds(new Rectangle(444, 156, 73, 25));
         jButton5.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jButton5.setForeground(Color.blue);
         jButton5.setText("重置");
        jButton5.addActionListener(new
                DailyPperationMagezinSystemPanel_jButton5_actionAdapter(this));
        jtxbookTypeX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jtxbookTypeX.setForeground(SystemColor.activeCaption);
         jtxbookTypeX.setText("");
         jtxbookTypeX.setBounds(new Rectangle(428, 12, 155, 22));
         jLabel11.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel11.setForeground(Color.blue);
         jLabel11.setText("期刊类别名");
         jLabel11.setBounds(new Rectangle(346, 14, 82, 16));
         jLabel12.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
         jLabel12.setForeground(Color.blue);
         jLabel12.setText("期刊编号");
         jLabel12.setBounds(new Rectangle(32, 48, 56, 16));
         jButton6.setBounds(new Rectangle(113, 156, 73, 25));
         jButton6.setFont(new java.awt.Font("宋体", Font.BOLD, 16));
         jButton6.setForeground(Color.red);