dailpperationsystemmagzinchaxunpanel.java

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

package booksboeeowreadsystem;

import java.awt.*;

import javax.swing.*;
import javax.swing.tree.DefaultMutableTreeNode;
import com.borland.internetbeans.IxTable;
import java.awt.event.ActionEvent;
import java.awt.event.ComponentEvent;
import java.awt.event.HierarchyEvent;
import java.awt.event.HierarchyBoundsAdapter;
import java.awt.event.ComponentAdapter;
import javax.swing.table.DefaultTableModel;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.awt.event.MouseEvent;
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 DailPperationSystemMagzinChaXunPanel 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();
    JLabel jLabel5 = new JLabel();
    JTextField jtxMagazineNum = new JTextField();


    public DailPperationSystemMagzinChaXunPanel(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
                DailPperationSystemMagzinChaXunPanel_this_componentAdapter(this));
        this.addHierarchyBoundsListener(new
                DailPperationSystemMagzinChaXunPanel_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
                DailPperationSystemMagzinChaXunPanel_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
                DailPperationSystemMagzinChaXunPanel_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.addComponentListener(new
                DailPperationSystemMagzinChaXunPanel_jTpRightBottom_componentAdapter(this));
        jTpRightBottom.setLayout(null);

        jPaneRightBottom.setBorder(BorderFactory.createEtchedBorder());
        jPaneRightBottom.setBounds(new Rectangle( -1, 187, 705, 199));
        jPaneRightBottom.addComponentListener(new
                DailPperationSystemMagzinChaXunPanel_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
                DailPperationSystemMagzinChaXunPanel_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(7, 73, 82, 16));
        jLabel10.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel10.setForeground(Color.magenta);
        jLabel10.setText("到期时间");
        jLabel10.setBounds(new Rectangle(7, 284, 82, 16));
        jTxpurchaseMoneyX.setEnabled(false);
        jTxpurchaseMoneyX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxpurchaseMoneyX.setForeground(SystemColor.activeCaption);
        jTxpurchaseMoneyX.setText("");
        jTxpurchaseMoneyX.setBounds(new Rectangle(82, 98, 145, 22));
        jButton5.setBounds(new Rectangle(139, 396, 73, 25));
        jButton5.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jButton5.setForeground(Color.blue);
        jButton5.setText("重置");
        jtxbookTypeX.setEnabled(false);
        jtxbookTypeX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxbookTypeX.setForeground(SystemColor.activeCaption);
        jtxbookTypeX.setText("");
        jtxbookTypeX.setBounds(new Rectangle(82, 42, 145, 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(7, 194, 82, 16));
        jButton6.setBounds(new Rectangle(14, 397, 73, 25));
        jButton6.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jButton6.setForeground(Color.blue);
        jButton6.setText("续借");
        jtxbooksNumX.setEnabled(false);
        jtxbooksNumX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxbooksNumX.setForeground(SystemColor.activeCaption);
        jtxbooksNumX.setBounds(new Rectangle(82, 191, 145, 22));
        jtxbooksNamex.setEnabled(false);
        jtxbooksNamex.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxbooksNamex.setForeground(SystemColor.activeCaption);
        jtxbooksNamex.setBounds(new Rectangle(82, 157, 145, 22));
        jTxbookConcernX.setEnabled(false);
        jTxbookConcernX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxbookConcernX.setForeground(SystemColor.activeCaption);
        jTxbookConcernX.setBounds(new Rectangle(82, 70, 145, 22));
        jLabel13.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel13.setForeground(Color.blue);
        jLabel13.setText("读者性别");
        jLabel13.setBounds(new Rectangle(7, 160, 82, 16));
        jTxbookAuthorX.setEnabled(false);
        jTxbookAuthorX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxbookAuthorX.setForeground(SystemColor.activeCaption);
        jTxbookAuthorX.setText("");
        jTxbookAuthorX.setBounds(new Rectangle(82, 281, 145, 22));
        jLabel14.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel14.setForeground(Color.blue);
        jLabel14.setText("读者电话");
        jLabel14.setBounds(new Rectangle(7, 101, 82, 16));


        jLabel27.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel27.setForeground(Color.blue);
        jLabel27.setText("读者地址");
        jLabel27.setBounds(new Rectangle(7, 130, 82, 16));
        jTxReaderNumX.setBackground(Color.white);
        jTxReaderNumX.setEnabled(false);
        jTxReaderNumX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxReaderNumX.setForeground(Color.magenta);
        jTxReaderNumX.setBounds(new Rectangle(82, 251, 145, 22));


        jLabel28.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel28.setForeground(Color.magenta);
        jLabel28.setText("借书日期");
        jLabel28.setBounds(new Rectangle(7, 254, 82, 16));
        jTxNumberX.setBackground(Color.white);
        jTxNumberX.setEnabled(false);
        jTxNumberX.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTxNumberX.setForeground(Color.magenta);
        jTxNumberX.setBounds(new Rectangle(82, 127, 145, 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.addComponentListener(new
                DailPperationSystemMagzinChaXunPanel_jPanRight_componentAdapter(this));
        jPanRight.addHierarchyBoundsListener(new
                DailPperationSystemMagzinChaXunPanel_jPanRight_hierarchyBoundsAdapter(this));

        jPanel1.setLayout(null);



        jLabel33.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel33.setForeground(Color.blue);
        jLabel33.setText("读者姓名");
        jLabel33.setBounds(new Rectangle(7, 45, 82, 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
                DailPperationSystemMagzinChaXunPanel_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(false);
        jTextField1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField1.setForeground(SystemColor.activeCaption);
        jTextField1.setBounds(new Rectangle(83, 314, 145, 22));
        jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel2.setForeground(Color.magenta);
        jLabel2.setText("证件有效期");
        jLabel2.setBounds(new Rectangle(8, 319, 82, 16));
        jTextField2.setEnabled(false);
        jTextField2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField2.setForeground(SystemColor.activeCaption);
        jTextField2.setBounds(new Rectangle(82, 220, 145, 22));
        jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel3.setForeground(Color.blue);
        jLabel3.setText("办证日期");
        jLabel3.setBounds(new Rectangle(7, 223, 82, 16));
        jPanel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));