readersystempanel.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.border.TitledBorder;
import javax.swing.table.JTableHeader;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.InputMethodEvent;
import java.awt.event.InputMethodListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import javax.swing.table.DefaultTableModel;
import java.sql.SQLException;
import java.sql.*;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;

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

    IxTable ixTable1 = new IxTable();
    JPanel jPanelSystemTop = new JPanel();
    JButton jBttsjy = new JButton();
    FlowLayout flowLayout1 = new FlowLayout();
    JTabbedPane jTpRightM = new JTabbedPane();
    JPanel jTpRightBottomjPanel4 = new JPanel();
    JPanel jTpRightBottomjPanel3 = new JPanel();
    JPanel jTpRightBottomjPanel2 = new JPanel();
    JTextField jTextField4 = new JTextField();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel14 = new JLabel();
    JLabel jLabel15 = new JLabel();
    JButton jButton4 = new JButton();
    JTextField jTextField8 = new JTextField();
    JTextField jtxType2 = new JTextField();
    JLabel jLabel16 = new JLabel();
    JTextField jtxZhengjian2 = new JTextField();
    JTextField jTextField17 = new JTextField();
    JLabel jLabel17 = new JLabel();
    JLabel jLabel18 = new JLabel();
    JTextField jTextField18 = new JTextField();
    JLabel jLabel19 = new JLabel();
    JButton jButton6 = new JButton();
    JTextField jTextField19 = new JTextField();
    JTextField jTextField20 = new JTextField();
    JTextField jTextField21 = new JTextField();
    JLabel jLabel20 = new JLabel();
    JTextField jtxReaderNumY = new JTextField();
    JLabel jLabel21 = new JLabel();
    JLabel jLabel22 = new JLabel();
    JLabel jLabel32 = new JLabel();
    JLabel jLabel33 = new JLabel();
    JButton jButton2 = new JButton();
    JTextField jtxName1 = new JTextField();
    String[] ztype = new String[]{"教师","社会读者","学生"};

    JLabel jLabel34 = new JLabel();
    String[] zheng = new String[] {"学生证", "身份证", "教师证","士兵证"};
    float [] yajinArry;
    JComboBox jtxZhengjian1 = new JComboBox(zheng);
    JTextField jtxAdd1 = new JTextField();
    JLabel jLabel35 = new JLabel();
    JLabel jLabel36 = new JLabel();
    JButton jButton8 = new JButton();
    JTextField jtxTelphone1 = new JTextField();
    JTextField jtxZhengjianNum1 = new JTextField();
    JLabel jLabel38 = new JLabel();
    JTextField jtxNum1 = new JTextField();
    JLabel jLabel39 = new JLabel();
    JLabel jLabel40 = new JLabel();
    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();
    JLabel jLabel41 = new JLabel();
    JLabel jLabel42 = new JLabel();
    JTextField jtxYajin1 = new JTextField();
    JTextField jtxDangqianTime = new JTextField();
    JRadioButton jRadioButton1 = new JRadioButton();
    JRadioButton jRadioButton2 = new JRadioButton();
    ButtonGroup buttonGroupSex = new ButtonGroup();
    Dbcom dh;
    //当前读者编号是不是有效的读者
    boolean isReader=false;
    //当前读者的借书数量和最大量
    int readerNumTemp=0;
    int readerNumTempMax=0;
    //设置当前办证用户的押金
    float yj=0;
    String xnum = "";
    JTextArea jlbMassageY = new JTextArea();
    JPanel jPanelleftJ = new JPanel();
    JPanel jTpRightBottomjPanel1 = new JPanel();
    JPanel jPanelRigthJ = new JPanel();
    JPanel jPanelRigthY = new JPanel();
    JPanel jPanelLeftY = new JPanel();
    JPanel jPanelRigth1 = new JPanel();
    JLabel jLabel51 = new JLabel();
    JTextField jTextField38 = new JTextField();
    JTextField jTextField39 = new JTextField();
    JTextArea jlbMassage = new JTextArea();
    JTextField jTextField40 = new JTextField();
    JButton jButton11 = new JButton();
    JLabel jLabel52 = new JLabel();
    JLabel jLabel53 = new JLabel();
    JTextField jTextField41 = new JTextField();
    JLabel jLabel54 = new JLabel();
    JLabel jLabel55 = new JLabel();
    JTextField jTextField42 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField jTextField3 = new JTextField();
    JLabel jLabel23 = new JLabel();
    JTextField jtxReaderNumZ = new JTextField();
    JLabel jLabel24 = new JLabel();
    JPanel jPanelLeft1 = new JPanel();
    JLabel jLabel25 = new JLabel();
    JTextField jtxZhengjian3 = new JTextField();
    JButton jButton3 = new JButton();
    JTextField jtxType3 = new JTextField();
    JLabel jLabel26 = new JLabel();
    JTextField jTextField26 = new JTextField();
    JLabel jLabel1 = new JLabel();
    JTextField jtxType4 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JLabel jLabel2 = new JLabel();
    JTextField jTextField5 = new JTextField();
    JLabel jLabel4 = new JLabel();
    JButton jButton1 = new JButton();
    JTextField jtxZhengjian4 = new JTextField();
    JLabel jLabel5 = new JLabel();
    JPanel jPanelLeft2 = new JPanel();
    JTextField jtxReaderNumG1 = new JTextField();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JLabel jLabel10 = new JLabel();
    JTextField jTextField9 = new JTextField();
    JTextField jTextField10 = new JTextField();
    JLabel jLabel11 = new JLabel();
    JButton jButton5 = new JButton();
    JTextField jTextField11 = new JTextField();
    JTextArea jlbMassageG = new JTextArea();
    JTextField jTextField12 = new JTextField();
    JTextField jTextField13 = new JTextField();
    JPanel jPanelRigth2 = new JPanel();
    JLabel jLabel12 = new JLabel();
    JComboBox jtxType1 = new JComboBox(ztype);

    public ReaderSystemPanel(Dbcom db) {
        try {
            dh=db;
            typeshow();
            jbInit();

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

    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setBorder(BorderFactory.createEtchedBorder());
        this.setPreferredSize(new Dimension(200, 200));
        this.setBounds(new Rectangle(3, 60, 790, 535));
        this.addHierarchyBoundsListener(new
                                        ReaderSystemPanel_this_hierarchyBoundsAdapter(this));
        jPanelSystemTop.setBorder(BorderFactory.createEtchedBorder());
        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("读者管理");
        flowLayout1.setAlignment(FlowLayout.LEFT);
        flowLayout1.setHgap(0);
        flowLayout1.setVgap(0);
        jTpRightM.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTpRightM.setForeground(Color.blue);
        jTpRightM.setBounds(new Rectangle(1, 30, 781, 273));
        jTpRightM.addMouseListener(new ReaderSystemPanel_jTpRightM_mouseAdapter(this));
        jTpRightBottomjPanel4.setLayout(null);
        jTpRightBottomjPanel3.setLayout(null);
        jTpRightBottomjPanel2.setLayout(null);
        jTextField4.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField4.setForeground(SystemColor.activeCaption);
        jTextField4.setText("");
        jTextField4.setBounds(new Rectangle(97, 160, 222, 27));
        jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel6.setForeground(Color.blue);
        jLabel6.setText("使用期限");
        jLabel6.setBounds(new Rectangle(11, 154, 62, 30));
        jLabel14.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel14.setForeground(Color.blue);
        jLabel14.setText("读者地址");
        jLabel14.setBounds(new Rectangle(22, 122, 62, 30));
        jLabel15.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel15.setForeground(Color.blue);
        jLabel15.setText("证件类型");
        jLabel15.setBounds(new Rectangle(20, 82, 62, 30));
        jButton4.setBounds(new Rectangle(93, 199, 101, 28));
        jButton4.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jButton4.setForeground(Color.blue);
        jButton4.setText("确认办理");
        jTextField8.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField8.setForeground(SystemColor.activeCaption);
        jTextField8.setBounds(new Rectangle(88, 9, 222, 27));
        jtxType2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxType2.setForeground(SystemColor.activeCaption);
        jtxType2.setBounds(new Rectangle(97, 47, 222, 27));
        jLabel16.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel16.setForeground(Color.blue);
        jLabel16.setText("证件编号");
        jLabel16.setBounds(new Rectangle(11, 79, 62, 30));
        jtxZhengjian2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxZhengjian2.setForeground(SystemColor.activeCaption);
        jtxZhengjian2.setText("");
        jtxZhengjian2.setBounds(new Rectangle(97, 85, 222, 27));
        jTextField17.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField17.setForeground(SystemColor.activeCaption);
        jTextField17.setBounds(new Rectangle(97, 124, 222, 27));
        jLabel17.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel17.setForeground(Color.blue);
        jLabel17.setText("读者类型");
        jLabel17.setBounds(new Rectangle(20, 46, 62, 30));
        jLabel18.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel18.setForeground(Color.blue);
        jLabel18.setText("读者姓名");
        jLabel18.setBounds(new Rectangle(11, 7, 62, 30));
        jTextField18.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField18.setForeground(SystemColor.activeCaption);
        jTextField18.setText("");
        jTextField18.setBounds(new Rectangle(89, 45, 222, 27));
        jLabel19.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel19.setForeground(Color.blue);
        jLabel19.setText("办证日期");
        jLabel19.setBounds(new Rectangle(23, 158, 62, 30));
        jButton6.setBounds(new Rectangle(129, 196, 101, 28));
        jButton6.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jButton6.setForeground(Color.blue);
        jButton6.setText("数据重置");
        jTextField19.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField19.setForeground(SystemColor.activeCaption);
        jTextField19.setBounds(new Rectangle(91, 158, 222, 27));
        jTextField20.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField20.setForeground(SystemColor.activeCaption);
        jTextField20.setText("");
        jTextField20.setBounds(new Rectangle(90, 122, 222, 27));
        jTextField21.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField21.setForeground(SystemColor.activeCaption);
        jTextField21.setBounds(new Rectangle(90, 83, 222, 27));
        jLabel20.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel20.setForeground(Color.blue);
        jLabel20.setText("是否借书");
        jLabel20.setBounds(new Rectangle(11, 40, 62, 30));
        jtxReaderNumY.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxReaderNumY.setForeground(SystemColor.activeCaption);
        jtxReaderNumY.setText("");
        jtxReaderNumY.setBounds(new Rectangle(97, 11, 222, 27));
        jtxReaderNumY.addMouseListener(new
                ReaderSystemPanel_jtxReaderNumY_mouseAdapter(this));
        jLabel21.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel21.setForeground(Color.blue);
        jLabel21.setText("读者编号");
        jLabel21.setBounds(new Rectangle(20, 9, 62, 30));
        jLabel22.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel22.setForeground(Color.blue);
        jLabel22.setText("读者电话");
        jLabel22.setBounds(new Rectangle(11, 120, 62, 30));
        jLabel32.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel32.setForeground(Color.blue);
        jLabel32.setText("读者地址");
        jLabel32.setBounds(new Rectangle(18, 109, 62, 30));
        jLabel33.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel33.setForeground(Color.blue);
        jLabel33.setText("证件类型");
        jLabel33.setBounds(new Rectangle(15, 73, 62, 30));
        jButton2.setBounds(new Rectangle(78, 188, 101, 28));
        jButton2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jButton2.setForeground(Color.blue);
        jButton2.setText("确认办理");
        jButton2.addActionListener(new ReaderSystemPanel_jButton2_actionAdapter(this));
        jtxName1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxName1.setForeground(SystemColor.activeCaption);
        jtxName1.setBounds(new Rectangle(97, 10, 222, 27));