readersystempanel.java~37~

一个功能强大的图书管理系统,是个人版,适合学习swing的初学者阅读.

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 jBtqkjy = new JButton();
    JButton jBttsjy = new JButton();
    FlowLayout flowLayout1 = new FlowLayout();
    JTabbedPane jTpRightM = new JTabbedPane();
    JPanel jTpRightBottomjPanel4 = new JPanel();
    JButton jButton1 = new JButton();
    JLabel jLabel1 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JPanel jTpRightBottomjPanel3 = new JPanel();
    JPanel jTpRightBottomjPanel2 = new JPanel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField jTextField5 = new JTextField();
    JLabel jLabel7 = new JLabel();
    JTextField jTextField6 = new JTextField();
    JTextField jTextField7 = new JTextField();
    JLabel jLabel8 = new JLabel();
    JButton jButton5 = new JButton();
    JLabel jLabel9 = new JLabel();
    JTextField jTextField9 = new JTextField();
    JLabel jLabel10 = new JLabel();
    JLabel jLabel11 = new JLabel();
    JTextField jTextField10 = new JTextField();
    JTextField jtxReaderNumG = new JTextField();
    JTextField jTextField12 = new JTextField();
    JLabel jLabel12 = new JLabel();
    JTextField jTextField13 = new JTextField();
    JTextField jTextField14 = new JTextField();
    JLabel jLabel13 = new JLabel();
    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 jTextField15 = new JTextField();
    JLabel jLabel16 = new JLabel();
    JTextField jTextField16 = 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[]{"学生","教师","社会读者"};

    JComboBox jtxType1;
    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();
    JTextArea jlbMassageG = new JTextArea();
    JPanel jPanelleftJ = new JPanel();
    JPanel jTpRightBottomjPanel1 = new JPanel();
    JPanel jPanelRigthJ = new JPanel();
    JPanel jPanelRigthY = new JPanel();
    JPanel jPanelLeftY = new JPanel();
    JPanel jPanel3 = 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 jTextField23 = new JTextField();
    JLabel jLabel24 = new JLabel();
    JPanel jPanel4 = new JPanel();
    JLabel jLabel25 = new JLabel();
    JTextField jTextField24 = new JTextField();
    JButton jButton3 = new JButton();
    JTextField jTextField25 = new JTextField();
    JLabel jLabel26 = new JLabel();
    JTextField jTextField26 = new JTextField();
    public ReaderSystemPanel(Dbcom db) {
        try {
            dh=db;
            jbInit();

        } 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
                                        ReaderSystemPanel_this_hierarchyBoundsAdapter(this));
        jPanelSystemTop.setBorder(BorderFactory.createEtchedBorder());
        jPanelSystemTop.setBounds(new Rectangle(3, 0, 774, 30));
        jPanelSystemTop.setLayout(flowLayout1);
        jBtqkjy.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jBtqkjy.setForeground(Color.blue);
        jBtqkjy.setText("读者档案管理");
        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));
        jTpRightBottomjPanel4.setLayout(null);
        jButton1.setBounds(new Rectangle(439, 190, 101, 28));
        jButton1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jButton1.setForeground(Color.blue);
        jButton1.setText("数据重置");
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel1.setForeground(Color.blue);
        jLabel1.setText("读者类型");
        jLabel1.setBounds(new Rectangle(15, 42, 62, 30));
        jTextField1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField1.setForeground(SystemColor.activeCaption);
        jTextField1.setText("");
        jTextField1.setBounds(new Rectangle(421, 152, 222, 27));
        jTpRightBottomjPanel3.setLayout(null);
        jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel4.setForeground(Color.blue);
        jLabel4.setText("使用期限");
        jLabel4.setBounds(new Rectangle(341, 148, 62, 30));
        jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel5.setForeground(Color.blue);
        jLabel5.setText("读者电话");
        jLabel5.setBounds(new Rectangle(341, 114, 62, 30));
        jTextField5.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField5.setForeground(SystemColor.activeCaption);
        jTextField5.setBounds(new Rectangle(420, 116, 222, 27));
        jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel7.setForeground(Color.blue);
        jLabel7.setText("办证日期");
        jLabel7.setBounds(new Rectangle(15, 150, 62, 30));
        jTextField6.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField6.setForeground(SystemColor.activeCaption);
        jTextField6.setBounds(new Rectangle(92, 152, 222, 27));
        jTextField7.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField7.setForeground(SystemColor.activeCaption);
        jTextField7.setText("");
        jTextField7.setBounds(new Rectangle(92, 116, 222, 27));
        jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel8.setForeground(Color.blue);
        jLabel8.setText("读者地址");
        jLabel8.setBounds(new Rectangle(15, 114, 62, 30));
        jButton5.setBounds(new Rectangle(62, 192, 101, 28));
        jButton5.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jButton5.setForeground(Color.blue);
        jButton5.setText("确认办理");
        jLabel9.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel9.setForeground(Color.blue);
        jLabel9.setText("是否借书");
        jLabel9.setBounds(new Rectangle(341, 38, 62, 30));
        jTextField9.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField9.setForeground(SystemColor.activeCaption);
        jTextField9.setText("");
        jTextField9.setBounds(new Rectangle(92, 43, 222, 27));
        jLabel10.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel10.setForeground(Color.blue);
        jLabel10.setText("读者编号");
        jLabel10.setBounds(new Rectangle(15, 5, 62, 30));
        jLabel11.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel11.setForeground(Color.blue);
        jLabel11.setText("证件编号");
        jLabel11.setBounds(new Rectangle(341, 77, 62, 30));
        jTextField10.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField10.setForeground(SystemColor.activeCaption);
        jTextField10.setBounds(new Rectangle(92, 81, 222, 27));
        jtxReaderNumG.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxReaderNumG.setForeground(SystemColor.activeCaption);
        jtxReaderNumG.setBounds(new Rectangle(92, 7, 222, 27));
        jtxReaderNumG.addMouseListener(new
                ReaderSystemPanel_jtxReaderNumG_mouseAdapter(this));
        jTextField12.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField12.setForeground(SystemColor.activeCaption);
        jTextField12.setBounds(new Rectangle(419, 43, 222, 27));
        jLabel12.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel12.setForeground(Color.blue);
        jLabel12.setText("证件类型");
        jLabel12.setBounds(new Rectangle(15, 78, 62, 30));
        jTextField13.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField13.setForeground(SystemColor.activeCaption);
        jTextField13.setText("");
        jTextField13.setBounds(new Rectangle(418, 7, 222, 27));
        jTextField14.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField14.setForeground(SystemColor.activeCaption);
        jTextField14.setText("");
        jTextField14.setBounds(new Rectangle(420, 81, 222, 27));
        jLabel13.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel13.setForeground(Color.blue);
        jLabel13.setText("读者姓名");
        jLabel13.setBounds(new Rectangle(341, 5, 62, 30));
        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));
        jTextField15.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField15.setForeground(SystemColor.activeCaption);
        jTextField15.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));
        jTextField16.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField16.setForeground(SystemColor.activeCaption);
        jTextField16.setText("");
        jTextField16.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);