dailypperationsystempanel.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 DailyPperationSystemPanel extends JPanel {
    DefaultMutableTreeNode books = new DefaultMutableTreeNode("所有图书");
     String[] title = {"图书名称","图书编号","图书类别编号","作者名","出版社","可借数量","定价","语言种类","入库时间"};
     int title_size=title.length;
     Dbcom db;
     //  DefaultMutableTreeNode books1 = new DefaultMutableTreeNode("");
    Object[][] date;
    public DailyPperationSystemPanel( 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 jBttsjy = new JButton();
    JTree jTreBooks = new JTree(books,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 typeTemp="";
    //当前读者的借书数量和最大量
    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.addHierarchyBoundsListener(new
                DailyPperationSystemPanel_this_hierarchyBoundsAdapter(this));
        this.addComponentListener(new
                DailyPperationSystemPanel_this_componentAdapter(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);
        jBttsjy.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jBttsjy.setForeground(Color.blue);
        jBttsjy.setText("图书借阅");

        jSpSystemPanel.setBounds(new Rectangle(2, 30, this.getWidth()-5,(this.getHeight()-5)));
        jSpSystemPanel.addComponentListener(new
                DailyPperationSystemPanel_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, 190));
        jTpRightBottom.addMouseListener(new
                DailyPperationSystemPanel_jTpRightBottom_mouseAdapter(this));
        jPaneRightBottom.setBorder(BorderFactory.createEtchedBorder());
        jPaneRightBottom.setBounds(new Rectangle( -1, 187, 705, 199));
        jPaneRightBottom.addComponentListener(new
                DailyPperationSystemPanel_jPaneRightBottom_componentAdapter(this));

        jPaneRightBottom.setLayout(null);
        jTpRightBottomjPanel3.setLayout(null);
        btnReset.setBounds(new Rectangle(357, 137, 73, 25));
        btnReset.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        btnReset.setForeground(Color.blue);
        btnReset.setText("重置");
        btnReset.addActionListener(new
                DailyPperationSystemPanel_btnReset_actionAdapter(this));

        jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel2.setForeground(Color.blue);
        jLabel2.setText("图书编号");
        jLabel2.setBounds(new Rectangle(11, 49, 56, 16));
        jTxbookNum.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxbookNum.setForeground(SystemColor.activeCaption);
        jTxbookNum.setText("");
        jTxbookNum.setBounds(new Rectangle(76, 44, 155, 22));
        jTpRightBottomjPanel4.setLayout(null);
        jTpRightBottomPane1.setLayout(null);

        jPanelRightTop.setBorder(BorderFactory.createEtchedBorder());
        jPanelRightTop.setBounds(new Rectangle(1, 2, 693, 185));
        jPanelRightTop.setLayout(null);
        jTreBooks.addMouseListener(new
                DailyPperationSystemPanel_jTreBooks_mouseAdapter(this));
        jTpRightBottomjPanel2.setLayout(null);

        jScright.addHierarchyBoundsListener(new
                DailyPperationSystemPanel_jScright_hierarchyBoundsAdapter(this));
        jScright.addComponentListener(new
                DailyPperationSystemPanel_jScright_componentAdapter(this));
        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(12, 78, 56, 16));
        jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel5.setForeground(Color.blue);
        jLabel5.setText("图书的定价");
        jLabel5.setBounds(new Rectangle(260, 78, 82, 16));
        jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel7.setForeground(Color.blue);
        jLabel7.setText("图书类别名");
        jLabel7.setBounds(new Rectangle(260, 16, 82, 16));
        jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel8.setForeground(Color.blue);
        jLabel8.setText("图书出版社");
        jLabel8.setBounds(new Rectangle(260, 49, 82, 16));
        jLabel9.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel9.setForeground(Color.blue);
        jLabel9.setText("图书名称");
        jLabel9.setBounds(new Rectangle(11, 16, 56, 16));
        jTxbookAuthor.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxbookAuthor.setForeground(SystemColor.activeCaption);
        jTxbookAuthor.setBounds(new Rectangle(76, 76, 155, 22));
        jTxpurchaseMoney.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxpurchaseMoney.setForeground(SystemColor.activeCaption);
        jTxpurchaseMoney.setBounds(new Rectangle(342, 76, 195, 22));
        jTxbookType.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxbookType.setForeground(SystemColor.activeCaption);
        jTxbookType.setBounds(new Rectangle(342, 14, 195, 22));
        jTxbookConcern.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxbookConcern.setForeground(SystemColor.activeCaption);
        jTxbookConcern.setText("");
        jTxbookConcern.setBounds(new Rectangle(342, 44, 195, 22));
        jTxbookName.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxbookName.setForeground(SystemColor.activeCaption);
        jTxbookName.setText("");
        jTxbookName.setBounds(new Rectangle(76, 13, 155, 22));
        btnQueren.setBounds(new Rectangle(99, 136, 73, 25));
        btnQueren.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        btnQueren.setForeground(Color.blue);
        btnQueren.setText("借书");
        btnQueren.addActionListener(new
                DailyPperationSystemPanel_btnQueren_actionAdapter(this));
        jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel6.setForeground(Color.blue);
        jLabel6.setText("图书出版社");
        jLabel6.setBounds(new Rectangle(260, 49, 82, 16));
        jLabel10.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel10.setForeground(Color.blue);
        jLabel10.setText("图书作者");
        jLabel10.setBounds(new Rectangle(12, 78, 56, 16));
        jTxpurchaseMoneyX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxpurchaseMoneyX.setForeground(SystemColor.activeCaption);
        jTxpurchaseMoneyX.setText("");
        jTxpurchaseMoneyX.setBounds(new Rectangle(342, 76, 155, 22));
        jButton5.setBounds(new Rectangle(358, 137, 73, 25));
        jButton5.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jButton5.setForeground(Color.blue);
        jButton5.setText("重置");
        jtxbookTypeX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxbookTypeX.setForeground(SystemColor.activeCaption);
        jtxbookTypeX.setText("");
        jtxbookTypeX.setBounds(new Rectangle(342, 14, 155, 22));
        jLabel11.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel11.setForeground(Color.blue);
        jLabel11.setText("图书类别名");
        jLabel11.setBounds(new Rectangle(260, 16, 82, 16));
        jLabel12.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel12.setForeground(Color.blue);
        jLabel12.setText("图书编号");
        jLabel12.setBounds(new Rectangle(11, 49, 56, 16));
        jButton6.setBounds(new Rectangle(92, 137, 73, 25));
        jButton6.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jButton6.setForeground(Color.blue);
        jButton6.setText("续借");
        jtxbooksNumX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxbooksNumX.setForeground(SystemColor.activeCaption);
        jtxbooksNumX.setBounds(new Rectangle(76, 44, 155, 22));
        jtxbooksNamex.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxbooksNamex.setForeground(SystemColor.activeCaption);
        jtxbooksNamex.setBounds(new Rectangle(76, 13, 155, 22));
        jTxbookConcernX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxbookConcernX.setForeground(SystemColor.activeCaption);
        jTxbookConcernX.setBounds(new Rectangle(341, 44, 155, 22));
        jLabel13.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel13.setForeground(Color.blue);
        jLabel13.setText("图书名称");
        jLabel13.setBounds(new Rectangle(11, 16, 56, 16));
        jTxbookAuthorX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxbookAuthorX.setForeground(SystemColor.activeCaption);
        jTxbookAuthorX.setText("");
        jTxbookAuthorX.setBounds(new Rectangle(76, 76, 155, 22));
        jLabel14.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel14.setForeground(Color.blue);
        jLabel14.setText("图书的定价");
        jLabel14.setBounds(new Rectangle(260, 78, 82, 16));
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel1.setForeground(Color.blue);
        jLabel1.setText("图书出版社");
        jLabel1.setBounds(new Rectangle(260, 49, 82, 16));
        jLabel15.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel15.setForeground(Color.blue);
        jLabel15.setText("图书作者");
        jLabel15.setBounds(new Rectangle(12, 78, 56, 16));
        jTxpurchaseMoneyG.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxpurchaseMoneyG.setForeground(SystemColor.activeCaption);
        jTxpurchaseMoneyG.setText("");
        jTxpurchaseMoneyG.setBounds(new Rectangle(342, 76, 155, 22));
        jButton1.setBounds(new Rectangle(356, 138, 73, 25));
        jButton1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jButton1.setForeground(Color.blue);
        jButton1.setText("重置");
        jTxbookTypeG.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxbookTypeG.setForeground(SystemColor.activeCaption);
        jTxbookTypeG.setText("");
        jTxbookTypeG.setBounds(new Rectangle(342, 14, 155, 22));
        jLabel16.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel16.setForeground(Color.blue);