dailypperationsystembookschaxunpanel1.java

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

package booksboeeowreadsystem;

import java.awt.*;

import javax.swing.*;
import java.awt.event.ComponentEvent;
import java.awt.event.MouseEvent;
import java.sql.ResultSet;
import javax.swing.table.DefaultTableModel;
import java.awt.event.ActionEvent;
import java.sql.SQLException;
import java.awt.event.HierarchyEvent;
import com.borland.internetbeans.IxTable;
import javax.swing.tree.DefaultMutableTreeNode;
import java.awt.event.HierarchyBoundsAdapter;
import java.awt.event.ComponentAdapter;
import java.awt.event.MouseAdapter;
import java.awt.event.ActionListener;

/**
 * <p>Title: 图书借阅系统</p>
 *
 * <p>Description: 科学的管理系统</p>
 *
 * <p>Copyright: 吴明卫小组</p>
 *
 * <p>Company: </p>
 *
 * @author 吴明卫
 * @version 1.0
 */
public class DailyPperationSystemBooksChaXunPanel1 extends JPanel {
    DefaultMutableTreeNode books = new DefaultMutableTreeNode("所有图书");
    String[] title = { "图书编号","借出数量","图书名称","图书出版社","图书定价","入库时间","可用数量"};

    String[] titleReader = new String[] {"读者编号", "读者姓名", "读者类型","办证日期","借书时间","借书操作员","借书到期时间"};
    String[] titleReader2 = new String[] {"读者编号", "读者姓名", "性别", "联系地址", "联系电话", "读者类型","办证日期","借书时间","借书操作员","借书到期时间","是否归还","图书编号","证件注销时间","开户操作员","证件名称","证件编号","证件到期时间","损坏图书数量","证件是否有效","现有借书数量"};
    int title_size = title.length;
    Dbcom db;
    //  DefaultMutableTreeNode books1 = new DefaultMutableTreeNode("");
    Object[][] date= new Object[1][title_size];
     Object[][] dateReader = new Object[1][titleReader.length];
     Object[][] dataReader2 = new Object[1][titleReader2.length];

    IxTable ixTable1 = new IxTable();
    JScrollPane jScright = new JScrollPane();
    JScrollPane jScleft = new JScrollPane();
    JPanel jPanelSystemTop = new JPanel();
    JButton jBtyqts = new JButton();
    JSplitPane jSpSystemPanel = new JSplitPane();
    FlowLayout flowLayout1 = new FlowLayout();
    JPanel jPanRight = new JPanel();
    JPanel jTpRightBottom = new JPanel();
    JPanel jPaneRightBottom = new JPanel();
    JPanel jPanelRightTop = new JPanel();

    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 jLabel27 = new JLabel();
    JTextField jTxReaderNumX = new JTextField();
    JLabel jLabel28 = new JLabel();
    JTextField jTxNumberX = new JTextField();
    String typeTemp = "";
    //当前读者的借书数量和最大量
    int readerNumTemp = 0;
    int readerNumTempMax = 0;
    //当前读者编号是不是有效的读者
    boolean isReader = false;
    JPanel jPanel1 = new JPanel();
    JLabel jLabel33 = new JLabel();
    JTable jTableReader = new JTable(dateReader,titleReader);
    JLabel jLabel1 = new JLabel();
    JTable jTabBooks = new JTable(date,title);
    JScrollPane jScrollPane1 = new JScrollPane(jTabBooks);
    JScrollPane jScrollPaneBottom = new JScrollPane(jTableReader);
    JLabel jLabelTop = new JLabel();
    JTextField jTextField1 = new JTextField();
    JLabel jLabel2 = new JLabel();
    JTextField jTextField2 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JPanel jPanel2 = new JPanel();
    JPanel jPanel3 = new JPanel();
    JButton jButtonB = new JButton();
    JButton jButtonC = new JButton();
    JButton jButtonA = new JButton();
    JLabel jLabel4 = new JLabel();
    JButton jButtonD = new JButton();
    JTextField jtxBooksNum = new JTextField();
    JLabel jLabel5 = new JLabel();
    public DailyPperationSystemBooksChaXunPanel1(Dbcom db) {
            try {
                this.db=db;
                jbInit();
                yuqiserchar(0);
            } catch (Exception exception) {
                exception.printStackTrace();
            }
    }

    private void jbInit() throws Exception {

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

        //     books1.add(books);
        jTabBooks.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTabBooks.setForeground(Color.blue);
        jTabBooks.setGridColor(SystemColor.inactiveCaption);
        jTabBooks.getTableHeader().setFont(new java.awt.Font("宋体",
                Font.PLAIN, 14));
        jTabBooks.getTableHeader().setForeground(Color.blue);
        jTabBooks.setRowHeight(20);
        jTabBooks.setSelectionBackground(Color.pink);
        jTabBooks.addMouseListener(new
                DailyPperationSystemBooksChaXunPanel1_jTabBooks_mouseAdapter(this));

        jPanelSystemTop.setBounds(new Rectangle(3, 0, 774, 30));
        jPanelSystemTop.setLayout(flowLayout1);
        jBtyqts.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jBtyqts.setForeground(Color.blue);
        jBtyqts.setText("逾期图书查询");
        jSpSystemPanel.setBorder(BorderFactory.createEtchedBorder());
        jSpSystemPanel.setBounds(new Rectangle(2, 30, this.getWidth() - 5,
                                               (this.getHeight() - 5)));
        jSpSystemPanel.addComponentListener(new
                                            DailyPperationSystemBooksChaXunPanel1_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, 26, 704, 166));
        jTpRightBottom.setLayout(null);
        jTpRightBottom.addComponentListener(new
                DailyPperationSystemBooksChaXunPanel1_jTpRightBottom_componentAdapter(this));
        jPaneRightBottom.setBorder(BorderFactory.createEtchedBorder());
        jPaneRightBottom.setBounds(new Rectangle( -1, 187, 705, 199));
        jPaneRightBottom.addComponentListener(new
                                              DailyPperationSystemBooksChaXunPanel1_jPaneRightBottom_componentAdapter(this));

        jPaneRightBottom.setLayout(null);
        //jSpSystemPanel.setDividerLocation(0.74);
        jPanelRightTop.setBorder(BorderFactory.createEtchedBorder());
        jPanelRightTop.setBounds(new Rectangle(1, 26, 693, 161));
        jPanelRightTop.addComponentListener(new
                DailyPperationSystemBooksChaXunPanel1_jPanelRightTop_componentAdapter(this));
        jPanelRightTop.setLayout(null);
        jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel6.setForeground(Color.blue);
        jLabel6.setText("读者编号");
        jLabel6.setBounds(new Rectangle(2, 72, 76, 16));
        jLabel10.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel10.setForeground(Color.magenta);
        jLabel10.setText("到期时间");
        jLabel10.setBounds(new Rectangle(2, 278, 76, 16));
        jTxpurchaseMoneyX.setEnabled(true);
        jTxpurchaseMoneyX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxpurchaseMoneyX.setForeground(SystemColor.activeCaption);
        jTxpurchaseMoneyX.setText("");
        jTxpurchaseMoneyX.setBounds(new Rectangle(75, 97, 154, 22));
        jButton5.setBounds(new Rectangle(142, 377, 73, 25));
        jButton5.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jButton5.setForeground(Color.blue);
        jButton5.setText("重置");
        jtxbookTypeX.setEnabled(true);
        jtxbookTypeX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxbookTypeX.setForeground(SystemColor.activeCaption);
        jtxbookTypeX.setText("");
        jtxbookTypeX.setBounds(new Rectangle(75, 41, 154, 22));
        jLabel11.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel11.setForeground(Color.blue);
        jLabel11.setText("逾期图书借阅者信息");
        jLabel11.setBounds(new Rectangle(42, 15, 136, 16));
        jLabel12.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel12.setForeground(Color.blue);
        jLabel12.setText("借书数量");
        jLabel12.setBounds(new Rectangle(2, 189, 76, 16));
        jButton6.setBounds(new Rectangle(17, 378, 73, 25));
        jButton6.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jButton6.setForeground(Color.blue);
        jButton6.setText("续借");
        jtxbooksNumX.setEnabled(true);
        jtxbooksNumX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxbooksNumX.setForeground(SystemColor.activeCaption);
        jtxbooksNumX.setBounds(new Rectangle(75, 186, 154, 22));
        jtxbooksNamex.setEnabled(true);
        jtxbooksNamex.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxbooksNamex.setForeground(SystemColor.activeCaption);
        jtxbooksNamex.setBounds(new Rectangle(75, 156, 154, 22));
        jTxbookConcernX.setEnabled(true);
        jTxbookConcernX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxbookConcernX.setForeground(SystemColor.activeCaption);
        jTxbookConcernX.setBounds(new Rectangle(75, 69, 154, 22));
        jLabel13.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel13.setForeground(Color.blue);
        jLabel13.setText("读者性别");
        jLabel13.setBounds(new Rectangle(2, 159, 76, 16));
        jTxbookAuthorX.setEnabled(true);
        jTxbookAuthorX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxbookAuthorX.setForeground(SystemColor.activeCaption);
        jTxbookAuthorX.setText("");
        jTxbookAuthorX.setBounds(new Rectangle(75, 275, 154, 22));
        jLabel14.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel14.setForeground(Color.blue);
        jLabel14.setText("读者电话");
        jLabel14.setBounds(new Rectangle(2, 100, 76, 16));


        jLabel27.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel27.setForeground(Color.blue);
        jLabel27.setText("读者地址");
        jLabel27.setBounds(new Rectangle(2, 129, 76, 16));
        jTxReaderNumX.setBackground(Color.white);
        jTxReaderNumX.setEnabled(true);
        jTxReaderNumX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxReaderNumX.setForeground(Color.magenta);
        jTxReaderNumX.setBounds(new Rectangle(75, 245, 154, 22));


        jLabel28.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel28.setForeground(Color.magenta);
        jLabel28.setText("借书日期");
        jLabel28.setBounds(new Rectangle(2, 248, 76, 16));
        jTxNumberX.setBackground(Color.white);
        jTxNumberX.setEnabled(true);
        jTxNumberX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxNumberX.setForeground(Color.magenta);
        jTxNumberX.setBounds(new Rectangle(75, 126, 154, 22));
        jSpSystemPanel.setSize((this.getWidth()) - 5, (this.getHeight() - 5));
        jPanRight.setSize((jSpSystemPanel.getWidth() - jScleft.getWidth()),
                          (jSpSystemPanel.getHeight() - 1));
        jPanRight.setBorder(BorderFactory.createLineBorder(Color.black));
        jPanRight.addHierarchyBoundsListener(new
                DailyPperationSystemBooksChaXunPanel1_jPanRight_hierarchyBoundsAdapter(this));
        jPanRight.addComponentListener(new
                                       DailyPperationSystemBooksChaXunPanel1_jPanRight_componentAdapter(this));
        jPanel1.setLayout(null);
        jScright.addHierarchyBoundsListener(new
                                            DailyPperationSystemBooksChaXunPanel1_jScright_hierarchyBoundsAdapter(this));
        jScright.addComponentListener(new
                                      DailyPperationSystemBooksChaXunPanel1_jScright_componentAdapter(this));


        jLabel33.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel33.setForeground(Color.blue);
        jLabel33.setText("读者姓名");
        jLabel33.setBounds(new Rectangle(2, 44, 76, 16));

        jTableReader.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTableReader.setForeground(Color.blue);
        jTableReader.getTableHeader().setFont(new java.awt.Font("宋体",
                Font.PLAIN, 14));
        jTableReader.getTableHeader().setForeground(Color.blue);
        jTableReader.setRowHeight(20);
        jTableReader.setSelectionBackground(Color.pink);
        jTableReader.addMouseListener(new
                DailyPperationSystemBooksChaXunPanel1_jTableReader_mouseAdapter(this));

        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel1.setForeground(Color.blue);
        jLabel1.setText("预期图书借阅读者列表");
        jLabel1.setBounds(new Rectangle(70, 7, 140, 22));
        jLabelTop.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabelTop.setForeground(Color.blue);
        jLabelTop.setText("预期图书列表");
        jLabelTop.setBounds(new Rectangle(183, 7, 90, 22));
        // jScleft.setSize(300,200);
        jScrollPaneBottom.setBounds(1,1,jTpRightBottom.getWidth()-1,jTpRightBottom.getHeight()-1);
        jScrollPaneBottom.setBounds(new Rectangle(131, 5, 450, 400));
        jTextField1.setEnabled(true);
        jTextField1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField1.setForeground(SystemColor.activeCaption);
        jTextField1.setBounds(new Rectangle(75, 304, 154, 22));
        jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel2.setForeground(Color.magenta);
        jLabel2.setText("证件有效期");
        jLabel2.setBounds(new Rectangle(2, 307, 76, 16));
        jTextField2.setEnabled(true);
        jTextField2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField2.setForeground(SystemColor.activeCaption);
        jTextField2.setBounds(new Rectangle(75, 216, 154, 22));
        jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel3.setForeground(Color.blue);
        jLabel3.setText("办证日期");
        jLabel3.setBounds(new Rectangle(2, 219, 76, 16));
        jPanel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));