readersystemchaxunpanel.java

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

package booksboeeowreadsystem;

import javax.swing.JPanel;
import com.borland.internetbeans.IxTable;
import javax.swing.JButton;
import java.awt.FlowLayout;
import javax.swing.JScrollPane;
import javax.swing.border.TitledBorder;
import javax.swing.JTable;
import javax.swing.ButtonGroup;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.JTextArea;
import java.awt.Dimension;
import java.sql.SQLException;
import java.awt.event.HierarchyEvent;
import java.awt.event.ComponentEvent;
import java.awt.event.ActionEvent;
import java.awt.event.MouseEvent;
import java.awt.event.ComponentAdapter;
import java.awt.event.MouseAdapter;
import java.awt.event.HierarchyBoundsAdapter;
import java.awt.Rectangle;
import javax.swing.BorderFactory;
import java.awt.Font;
import java.awt.Color;
import java.awt.Insets;
import java.awt.SystemColor;
import java.sql.ResultSet;
import javax.swing.table.DefaultTableModel;
import javax.swing.JOptionPane;
import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionListener;


/**
 * <p>Title: 图书借阅系统</p>
 *
 * <p>Description: 科学的管理系统</p>
 *
 * <p>Copyright: 吴明卫小组</p>
 *
 * <p>Company: </p>
 *
 * @author 吴明卫
 * @version 1.0
 */
public class ReaderSystemChaXunPanel extends JPanel {

    IxTable ixTable1 = new IxTable();
     JPanel jPanelSystemTop = new JPanel();
     JButton jBtqkjy = new JButton();
    FlowLayout flowLayout1 = new FlowLayout();
     JPanel jTpRightM = new JPanel();
    JPanel jTpRightBottomjPanel3 = new JPanel();
    String[] ztype = new String[]{"学生","教师","社会读者"};

    String[] zheng = new String[] {"学生证", "身份证", "教师证","士兵证"};
     float [] yajinArry;
     int [] borrorbook;
    JPanel jPanelBottom = new JPanel();
     JScrollPane jScrollPane1 = new JScrollPane();
     TitledBorder titledBorder1 = new TitledBorder("");

     String[] title = new String[] {"读者编号", "读者姓名", "性别", "联系地址", "联系电话", "读者类型",
                      "是否借书", "可借书数量","办证日期","证件编号"};
     Object[][] date = new Object[1][title.length];
     JTable radearjTable = new JTable(date, title);
     JButton btnY = new JButton();
     JButton btnW = new JButton();
     JButton btnQ = new JButton();
     JPanel jPanel1btmm = new JPanel();
    ButtonGroup buttonGroupSex = new ButtonGroup();
     Dbcom dh;
     //当前读者编号是不是有效的读者
 //    boolean isReader=false;
     //当前读者的借书数量和最大量
     int readerNumTemp=0;
     int readerNumTempMax=0;
     //设置当前办证用户的押金
     float yj=0;
     String xnum = "";
    JPanel jPanelRigth1 = new JPanel();
     JLabel jLabel51 = new JLabel();
     JTextField jtxIsJieshu = new JTextField();
     JTextField jtxName = new JTextField();
     JTextArea jlbMassage = new JTextArea();
     JTextField jtxIsboorwre = new JTextField();
    JLabel jLabel52 = new JLabel();
     JLabel jLabel53 = new JLabel();
     JTextField jtxZhengjianNum = new JTextField();
     JLabel jLabel54 = new JLabel();
     JLabel jLabel55 = new JLabel();
     JTextArea jtxTelphone = new JTextArea();
     JLabel jLabel3 = new JLabel();
     JTextArea jtxAddress = new JTextArea();
     JLabel jLabel23 = new JLabel();
     JTextField jtxReaderNumZ = new JTextField();
     JLabel jLabel24 = new JLabel();
     JPanel jPanelLeft1 = new JPanel();
     JLabel jLabel25 = new JLabel();
     JTextField jtxAge = new JTextField();
    JTextField jtxType = new JTextField();
     JLabel jLabel26 = new JLabel();
     JTextField jtxBanzhengTime = new JTextField();
    JLabel topjLabel1 = new JLabel();
    JScrollPane jScrollPane2 = new JScrollPane();
    public ReaderSystemChaXunPanel(Dbcom db) {
         try {
             dh=db;
             jbInit();
             typeshow();

         } catch (Exception exception) {
             exception.printStackTrace();
         }

    }

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

        jPanelSystemTop.setBorder(BorderFactory.createEtchedBorder());
       jPanelSystemTop.setBounds(new Rectangle(1, 0, 774, 30));
       jPanelSystemTop.setLayout(flowLayout1);
       jBtqkjy.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jBtqkjy.setForeground(Color.blue);
       jBtqkjy.setText("读者档案查询");
        flowLayout1.setAlignment(FlowLayout.LEFT);
       flowLayout1.setHgap(0);
       flowLayout1.setVgap(0);
       jTpRightM.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jTpRightM.setForeground(Color.blue);
        jTpRightM.setBorder(BorderFactory.createEtchedBorder());
        jTpRightM.setBounds(new Rectangle(1, 28, 984, 273));
        jTpRightM.addComponentListener(new
                ReaderSystemChaXunPanel_jTpRightM_componentAdapter(this));
        jTpRightM.setLayout(null);

        jTpRightBottomjPanel3.setLayout(null);
        jPanelBottom.setBorder(BorderFactory.createEtchedBorder());
       jPanelBottom.setBounds(new Rectangle(8, 306, 775, 218));
        jPanelBottom.addComponentListener(new
                ReaderSystemChaXunPanel_jPanelBottom_componentAdapter(this));

        jPanelBottom.setLayout(null);
       jScrollPane1.setBorder(BorderFactory.createLineBorder(Color.black));
       jScrollPane1.setBounds(new Rectangle(5, 8, 717, 161));
        jScrollPane1.addComponentListener(new
                ReaderSystemChaXunPanel_jScrollPane1_componentAdapter(this));

        radearjTable.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       radearjTable.setForeground(Color.blue);
       radearjTable.getTableHeader().setFont(new java.awt.Font("宋体",
               Font.PLAIN, 14));
       radearjTable.getTableHeader().setForeground(Color.blue);
       radearjTable.setBorder(null);
       radearjTable.setGridColor(Color.cyan);
       radearjTable.setRowHeight(25);
        radearjTable.addMouseListener(new
                ReaderSystemChaXunPanel_radearjTable_mouseAdapter(this));
        btnY.setBounds(new Rectangle(470, 4, 107, 25));
       btnY.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       btnY.setForeground(Color.blue);
       btnY.setBorder(BorderFactory.createRaisedBevelBorder());
       btnY.setMargin(new Insets(2, 2, 2, 2));
       btnY.setText("查询已借书用户");
        btnY.addActionListener(new ReaderSystemChaXunPanel_btnY_actionAdapter(this));

        btnW.setBounds(new Rectangle(236, 4, 124, 24));
       btnW.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       btnW.setForeground(Color.blue);
       btnW.setBorder(BorderFactory.createRaisedBevelBorder());
       btnW.setMargin(new Insets(2, 2, 2, 2));
       btnW.setText("查询未借书用户");
        btnW.addActionListener(new ReaderSystemChaXunPanel_btnW_actionAdapter(this));

        btnQ.setBounds(new Rectangle(18, 4, 99, 25));
       btnQ.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       btnQ.setForeground(Color.blue);
       btnQ.setBorder(BorderFactory.createRaisedBevelBorder());
       btnQ.setMargin(new Insets(2, 2, 2, 2));
       btnQ.setText("查询全部用户");
        btnQ.addActionListener(new ReaderSystemChaXunPanel_btnQ_actionAdapter(this));

        jPanel1btmm.setBounds(new Rectangle(10, 176, 710, 35));
        jPanel1btmm.addComponentListener(new
                ReaderSystemChaXunPanel_jPanel1btmm_componentAdapter(this));

        jPanel1btmm.setLayout(null);
        jPanelRigth1.setBackground(SystemColor.control);
       jPanelRigth1.setBorder(null);
       jPanelRigth1.setToolTipText("");
       jPanelRigth1.setBounds(new Rectangle(338, 4, 589, 237));
       jPanelRigth1.setLayout(null);
       jLabel51.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel51.setForeground(Color.blue);
       jLabel51.setText("是否借书");
       jLabel51.setBounds(new Rectangle(10, 43, 62, 30));
        jtxIsJieshu.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxIsJieshu.setForeground(SystemColor.activeCaption);
        jtxIsJieshu.setBounds(new Rectangle(87, 48, 222, 27));
        jtxName.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxName.setForeground(SystemColor.activeCaption);
        jtxName.setText("");
        jtxName.setBounds(new Rectangle(87, 12, 222, 27));
       jlbMassage.setBackground(SystemColor.menu);
       jlbMassage.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jlbMassage.setForeground(Color.red);
       jlbMassage.setBorder(null);
       jlbMassage.setCaretColor(Color.pink);
        jlbMassage.setEditable(false);
        jlbMassage.setLineWrap(true);
        jtxIsboorwre.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxIsboorwre.setForeground(SystemColor.activeCaption);
        jtxIsboorwre.setText("");
        jtxIsboorwre.setBounds(new Rectangle(87, 120, 222, 27));
        jLabel52.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel52.setForeground(Color.blue);
       jLabel52.setText("证件编号");
       jLabel52.setBounds(new Rectangle(10, 82, 62, 30));
       jLabel53.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel53.setForeground(Color.blue);
       jLabel53.setText("读者姓名");
       jLabel53.setBounds(new Rectangle(10, 10, 62, 30));
        jtxZhengjianNum.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxZhengjianNum.setForeground(SystemColor.activeCaption);
        jtxZhengjianNum.setText("");
        jtxZhengjianNum.setBounds(new Rectangle(87, 86, 222, 27));
       jLabel54.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel54.setForeground(Color.blue);
       jLabel54.setText("可借书量");
       jLabel54.setBounds(new Rectangle(10, 116, 62, 30));
       jLabel55.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel55.setForeground(Color.blue);
       jLabel55.setText("读者电话");
       jLabel55.setBounds(new Rectangle(10, 165, 62, 30));
        jtxTelphone.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxTelphone.setForeground(SystemColor.activeCaption);
        jtxTelphone.setBorder(BorderFactory.createEtchedBorder());
        jtxTelphone.setLineWrap(true);
        jtxTelphone.setBounds(new Rectangle(86, 155, 222, 50));
       jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel3.setForeground(Color.blue);
       jLabel3.setText("读者编号");
       jLabel3.setBounds(new Rectangle(7, 6, 62, 30));
        jtxAddress.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxAddress.setForeground(SystemColor.activeCaption);
        jtxAddress.setBorder(BorderFactory.createEtchedBorder());
        jtxAddress.setText("");
        jtxAddress.setLineWrap(true);
        jtxAddress.setBounds(new Rectangle(82, 159, 222, 49));
       jLabel23.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel23.setForeground(Color.blue);
       jLabel23.setText("读者地址");
       jLabel23.setBounds(new Rectangle(7, 168, 62, 30));
       jtxReaderNumZ.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jtxReaderNumZ.setForeground(SystemColor.activeCaption);
       jtxReaderNumZ.setBounds(new Rectangle(84, 8, 222, 27));
        jtxReaderNumZ.addMouseListener(new
                ReaderSystemChaXunPanel_jtxReaderNumZ_mouseAdapter(this));

        jLabel24.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel24.setForeground(Color.blue);
       jLabel24.setText("办证日期");
       jLabel24.setBounds(new Rectangle(8, 115, 62, 30));
       jPanelLeft1.setBorder(null);
       jPanelLeft1.setBounds(new Rectangle(7, 4, 319, 237));
       jPanelLeft1.setLayout(null);
       jLabel25.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jLabel25.setForeground(Color.blue);
       jLabel25.setText("读者类型");
       jLabel25.setBounds(new Rectangle(7, 43, 62, 30));
        jtxAge.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxAge.setForeground(SystemColor.activeCaption);