updatepanel.java

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

package memberpane;

import java.sql.*;
import java.text.*;
import java.util.Date;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.border.*;
import javax.swing.table.*;
/**
 *
 * <p>Title: InsertPanel</p>
 *
 * <p>Description: 添加会员用的面板，包括会员的各项信息的录入</p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class UpdatePanel extends JPanel{
    /**
     * 构造器
     * @param table JTable: 该面板所依赖的表格对象
     */
    public UpdatePanel(JTable table) {
        this.table = table;
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    /**
     * 初始化
     * @throws Exception
     */
    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 UpdatePanel_saveButton_actionAdapter(this));
        cancelButton.setBounds(new Rectangle(434, 435, 91, 29));
        cancelButton.setText("退出");
        cancelButton.addActionListener(new
                                       UpdatePanel_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
            UpdatePanel_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
            UpdatePanel_enterDateComboBox_actionAdapter(this));
        endDateComboBox.setBounds(new Rectangle(441, 52, 131, 21));
        endDateComboBox.addItem(DATE_FORMAT.format(enddate));
        endDateComboBox.addActionListener(new
            UpdatePanel_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);

        int selectedRow = table.getSelectedRow();

        if(selectedRow != -1){//当确实有一行被选中的时候，可以对该行进行修改
            Connection conn = null;
            try {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            } catch (ClassNotFoundException ex) {
            }
            String dburl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=db.mdb";
            try {
                conn = DriverManager.getConnection(dburl);
            } catch (SQLException ex1) {
            }

            Statement stmtQuery = null;
            ResultSet  rs = null;
            try {
                stmtQuery = conn.createStatement();

                ID = (String)table.getValueAt(selectedRow,0);//ID赋值为当前行的第0位上的值，即会员的ID
                rs = stmtQuery.executeQuery("select * from VIP where ID =" + ID + "");
                rs.next();

                //获得所有字段值
                String Mname = rs.getString("Name");
                String Mvipid = rs.getString("VIPID");
                String Mvipkind = rs.getString("VIPKind");
                String Msex = rs.getString("Sex");
                String Mgrade = rs.getString("Grade");
                String Mphone = rs.getString("Phone");
                String Mmovephone = rs.getString("MovePhone");
                String Mbirthday = rs.getString("Birthday");
                String Mvalid = rs.getString("Valid");
                String Mpass = rs.getString("Pass");
                String Menterdate = rs.getString("EnterDate");
                String Menddate = rs.getString("EndDate");
                String Mbeginmoney = rs.getString("BeginMoney");
                String Mcurmoney = rs.getString("CurMoney");
                String Msumcost = rs.getString("SumCost");
                String Mbeginpoints = rs.getString("BeginPoints");
                String Mcurpoints = rs.getString("CurPoints");
                String Msumpoints = rs.getString("SumPoints");
                String Mminzu = rs.getString("MinZu");
                String Munit = rs.getString("Unit");
                String Maddress = rs.getString("Address");
                String Mpostcode = rs.getString("postcode");
                String Moccu = rs.getString("Occu");
                String Mcertid = rs.getString("CertID");
                String Memail = rs.getString("Email");
                String Mremark = rs.getString("Mem");

                //设置面板上所有会员信息值
                nameField.setText(Mname);
                sexComboBox.setSelectedItem(Msex);
                nationField.setText(Mminzu);
                memKindComboBox.setSelectedItem(Mvipkind);
                //暂时去掉ActionListener，避免在初始化的时候由于日期改变事件触发生成DateChooser询问对话框
                //日期修改结束后重新添加ActionListener
                birthdayComboBox.removeActionListener(birthdayComboBox.getActionListeners()[0]);
                birthdayComboBox.removeItemAt(0);
                birthdayComboBox.addItem(Mbirthday.substring(0,Mbirthday.indexOf(" ")));
                birthdayComboBox.addActionListener(new
                    UpdatePanel_birthdayComboBox_actionAdapter(this));
                //暂时去掉ActionListener，避免在初始化的时候由于日期改变事件触发生成DateChooser询问对话框
                //日期修改结束后重新添加ActionListener
                enterDateComboBox.removeActionListener(enterDateComboBox.getActionListeners()[0]);
                enterDateComboBox.removeItemAt(0);
                enterDateComboBox.addItem(Menterdate.substring(0,Menterdate.indexOf(" ")));
                enterDateComboBox.addActionListener(new
                    UpdatePanel_enterDateComboBox_actionAdapter(this));
                //暂时去掉ActionListener，避免在初始化的时候由于日期改变事件触发生成DateChooser询问对话框
                //日期修改结束后重新添加ActionListener
                endDateComboBox.removeActionListener(endDateComboBox.getActionListeners()[0]);
                endDateComboBox.removeItemAt(0);
                endDateComboBox.addItem(Menddate.substring(0,Menddate.indexOf(" ")));
                endDateComboBox.addActionListener(new
                    UpdatePanel_endDateComboBox_actionAdapter(this));

                unitField.setText(Munit);
                addressField.setText(Maddress);
                postcodeField.setText(Mpostcode);
                phoneField.setText(Mphone);
                careerField.setText(Moccu);
                mobiliField.setText(Mmovephone);
                certcodeField.setText(Mcertid);
                emailField.setText(Memail);
                memNumField.setText(Mvipid);