insertpanel.java~123~

会员管理系统的一个子模块

package memberpane;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.border.*;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Vector;
import javax.swing.table.DefaultTableModel;

public class InsertPanel extends JPanel{
    public InsertPanel(JTable table) {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        this.table = table;
    }

    private void jbInit() throws Exception {
        border1 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
            Color.white, new Color(178, 178, 178));
        titledBorder1 = new TitledBorder(BorderFactory.createEtchedBorder(
            EtchedBorder.RAISED, Color.white, new Color(148, 145, 140)), "基本资料");
        this.setLayout(null);
        panelAbove.setBorder(titledBorder1);
        panelAbove.setBounds(new Rectangle(10, 10, 603, 206));
        panelAbove.setLayout(null);
        this.setBackground(SystemColor.control);
        this.setBorder(null);
        panelDown.setBorder(titledBorder1);
        panelDown.setBounds(new Rectangle(10, 222, 603, 206));
        panelDown.setLayout(null);
        saveButton.setBounds(new Rectangle(307, 435, 91, 29));
        saveButton.setText("保存");
        saveButton.addActionListener(new InsertPanel_saveButton_actionAdapter(this));
        cancelButton.setBounds(new Rectangle(434, 435, 91, 29));
        cancelButton.setText("退出");
        cancelButton.addActionListener(new
                                       InsertPanel_cancelButton_actionAdapter(this));
        nameField.setBounds(new Rectangle(80, 21, 85, 21));
        nameLabel.setText("姓    名");
        nameLabel.setBounds(new Rectangle(23, 21, 58, 21));
        sexComboBox.setBounds(new Rectangle(224, 21, 85, 21));
        sexComboBox.addItem("男");
        sexComboBox.addItem("女");
        sexLabel.setText("性别");
        sexLabel.setBounds(new Rectangle(183, 21, 58, 21));
        nationLabel.setText("民族");
        nationLabel.setBounds(new Rectangle(332, 21, 58, 21));
        nationField.setBounds(new Rectangle(395, 21, 85, 21));
        memKindComboBox.setBounds(new Rectangle(80, 46, 139, 21));
        memKindComboBox.addItem("普通会员");
        memKindComboBox.addItem("包月会员");
        memKindComboBox.addItem("包年会员");
        memKindComboBox.addItem("银卡");
        memKindComboBox.addItem("金卡");
        memKindComboBox.addItem("销售会员");
        memKindComboBox.addItem("百册卡");
        memKindLabel.setText("会员类别");
        memKindLabel.setBounds(new Rectangle(23, 46, 58, 21));
        birthdayComboBox.setBounds(new Rectangle(395, 46, 140, 21));
        birthdayComboBox.addItem(DATE_FORMAT.format(birthday));
        birthdayComboBox.addActionListener(new
            InsertPanel_birthdayComboBox_actionAdapter(this));
        birthdayLabel.setText("出生日期");
        birthdayLabel.setBounds(new Rectangle(332, 46, 58, 21));
        unitLabel.setText("工作单位");
        unitLabel.setBounds(new Rectangle(23, 72, 58, 21));
        addressLabel.setText("联系地址");
        addressLabel.setBounds(new Rectangle(23, 97, 58, 21));
        postcodeLabel.setText("邮政编码");
        postcodeLabel.setBounds(new Rectangle(23, 122, 58, 21));
        unitField.setBounds(new Rectangle(80, 72, 455, 21));
        addressField.setBounds(new Rectangle(80, 97, 455, 21));
        postcodeField.setBounds(new Rectangle(80, 122, 126, 21));
        phoneLabel.setText("联系电话");
        phoneLabel.setBounds(new Rectangle(279, 122, 58, 21));
        phoneField.setBounds(new Rectangle(340, 122, 195, 21));
        careerLabel.setText("会员职业");
        careerLabel.setBounds(new Rectangle(23, 148, 58, 21));
        sertcodeLabel.setText("证件号码");
        sertcodeLabel.setBounds(new Rectangle(23, 173, 58, 21));
        mobileLabel.setText("手机");
        mobileLabel.setBounds(new Rectangle(279, 148, 58, 21));
        emailLabel.setText("电子邮箱");
        emailLabel.setBounds(new Rectangle(279, 173, 58, 21));
        careerField.setBounds(new Rectangle(80, 148, 166, 21));
        certcodeField.setBounds(new Rectangle(80, 173, 166, 21));
        mobiliField.setBounds(new Rectangle(340, 148, 195, 21));
        emailField.setBounds(new Rectangle(340, 173, 195, 21));
        memNumLabel.setText("会员卡号");
        memNumLabel.setBounds(new Rectangle(23, 29, 55, 16));
        memNumField.setBounds(new Rectangle(80, 24, 99, 21));
        validCheckBox.setSelected(true);
        validCheckBox.setText("当前有效");
        validCheckBox.setBounds(new Rectangle(225, 25, 90, 21));
        passwordLabel.setText("使用密码");
        passwordLabel.setBounds(new Rectangle(328, 25, 55, 16));
        passwordField.setBounds(new Rectangle(388, 27, 137, 21));
        gradeComboBox.setBounds(new Rectangle(80, 53, 99, 21));
        gradeComboBox.addItem("金牌");
        gradeComboBox.addItem("银牌");
        gradeComboBox.addItem("铜牌");
        gradeComboBox.addItem("普通");
        enterDateComboBox.setBounds(new Rectangle(250, 53, 131, 21));
        enterDateComboBox.addItem(DATE_FORMAT.format(enterdate));
        enterDateComboBox.addActionListener(new
            InsertPanel_enterDateComboBox_actionAdapter(this));
        endDateComboBox.setBounds(new Rectangle(441, 52, 131, 21));
        endDateComboBox.addItem(DATE_FORMAT.format(enddate));
        endDateComboBox.addActionListener(new
            InsertPanel_endDateComboBox_actionAdapter(this));
        gradeLabel.setText("会员级别");
        gradeLabel.setBounds(new Rectangle(23, 57, 55, 16));
        enterDateLabel.setText("登记日期");
        enterDateLabel.setBounds(new Rectangle(192, 57, 55, 16));
        endDateLabel.setText("到期日期");
        endDateLabel.setBounds(new Rectangle(385, 56, 55, 16));
        beginMoneyLabel.setText("初始储值");
        beginMoneyLabel.setBounds(new Rectangle(23, 84, 55, 16));
        beginPointsLabel.setText("初始积分");
        beginPointsLabel.setBounds(new Rectangle(23, 112, 55, 16));
        beginMoneyField.setBounds(new Rectangle(80, 82, 99, 21));
        beginPointsField.setBounds(new Rectangle(80, 108, 99, 21));
        curMoneyLabel.setText("当前储值");
        curMoneyLabel.setBounds(new Rectangle(192, 84, 55, 16));
        curPointsLabel.setText("当前积分");
        curPointsLabel.setBounds(new Rectangle(192, 112, 55, 16));
        curMoneyField.setBounds(new Rectangle(250, 82, 131, 21));
        curPointsField.setBounds(new Rectangle(250, 108, 131, 21));
        consumLabel.setText("累计消费");
        consumLabel.setBounds(new Rectangle(385, 84, 55, 16));
        sumPointsLabel.setText("累计积分");
        sumPointsLabel.setBounds(new Rectangle(385, 113, 55, 16));
        consumField.setBounds(new Rectangle(441, 82, 131, 21));
        sumPointsField.setBounds(new Rectangle(441, 108, 131, 21));
        remarkLabel.setText("备注");
        remarkLabel.setBounds(new Rectangle(23, 139, 55, 16));
        remarkArea.setBorder(border1);
        remarkArea.setBounds(new Rectangle(80, 143, 492, 48));
        this.add(panelAbove);
        panelAbove.add(sexComboBox);
        panelAbove.add(memKindLabel);
        panelAbove.add(unitLabel);
        panelAbove.add(addressLabel);
        panelAbove.add(postcodeLabel);
        panelAbove.add(careerLabel);
        panelAbove.add(sertcodeLabel);
        panelAbove.add(nameLabel);
        panelAbove.add(certcodeField);
        panelAbove.add(careerField);
        panelAbove.add(postcodeField);
        panelAbove.add(addressField);
        panelAbove.add(unitField);
        panelAbove.add(memKindComboBox);
        panelAbove.add(nameField);
        panelAbove.add(sexLabel);
        panelAbove.add(nationField);
        panelAbove.add(birthdayComboBox);
        panelAbove.add(phoneLabel);
        panelAbove.add(mobileLabel);
        panelAbove.add(emailLabel);
        panelAbove.add(phoneField);
        panelAbove.add(mobiliField);
        panelAbove.add(emailField);
        panelAbove.add(birthdayLabel);
        panelAbove.add(nationLabel);
        this.add(panelDown);
        panelDown.add(passwordLabel);
        panelDown.add(passwordField);
        panelDown.add(gradeLabel);
        panelDown.add(beginMoneyLabel);
        panelDown.add(beginPointsLabel);
        panelDown.add(beginMoneyField);
        panelDown.add(beginPointsField);
        panelDown.add(remarkLabel);
        panelDown.add(remarkArea);
        panelDown.add(memNumLabel);
        panelDown.add(validCheckBox);
        panelDown.add(gradeComboBox);
        panelDown.add(memNumField);
        panelDown.add(enterDateLabel);
        panelDown.add(enterDateComboBox);
        panelDown.add(curMoneyField);
        panelDown.add(curPointsField);
        panelDown.add(consumField);
        panelDown.add(sumPointsField);
        panelDown.add(endDateLabel);
        panelDown.add(consumLabel);
        panelDown.add(curMoneyLabel);
        panelDown.add(curPointsLabel);
        panelDown.add(sumPointsLabel);
        panelDown.add(endDateComboBox);
        this.add(saveButton);
        this.add(cancelButton);
    }

    JPanel panelAbove = new JPanel();
    TitledBorder titledBorder1 = new TitledBorder("");
    JPanel panelDown = new JPanel();
    JButton saveButton = new JButton();
    JButton cancelButton = new JButton();
    JTextField nameField = new JTextField();
    JLabel nameLabel = new JLabel();
    JComboBox sexComboBox = new JComboBox();
    JLabel sexLabel = new JLabel();
    JLabel nationLabel = new JLabel();
    JTextField nationField = new JTextField();
    JComboBox memKindComboBox = new JComboBox();
    JLabel memKindLabel = new JLabel();
    JComboBox birthdayComboBox = new JComboBox();
    JLabel birthdayLabel = new JLabel();
    JLabel unitLabel = new JLabel();
    JLabel addressLabel = new JLabel();
    JLabel postcodeLabel = new JLabel();
    JTextField unitField = new JTextField();
    JTextField addressField = new JTextField();
    JTextField postcodeField = new JTextField();
    JLabel phoneLabel = new JLabel();
    JTextField phoneField = new JTextField();
    JLabel careerLabel = new JLabel();
    JLabel sertcodeLabel = new JLabel();
    JLabel mobileLabel = new JLabel();
    JLabel emailLabel = new JLabel();
    JTextField careerField = new JTextField();
    JTextField certcodeField = new JTextField();
    JTextField mobiliField = new JTextField();
    JTextField emailField = new JTextField();
    JLabel memNumLabel = new JLabel();
    JTextField memNumField = new JTextField();
    JCheckBox validCheckBox = new JCheckBox();
    JLabel passwordLabel = new JLabel();
    JPasswordField passwordField = new JPasswordField();
    JComboBox gradeComboBox = new JComboBox();
    JComboBox enterDateComboBox = new JComboBox();
    JComboBox endDateComboBox = new JComboBox();
    JLabel gradeLabel = new JLabel();
    JLabel enterDateLabel = new JLabel();
    JLabel endDateLabel = new JLabel();
    JLabel beginMoneyLabel = new JLabel();