updatepanel.java~44~

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

                memNumField.setText(Mvipid);
                if(Mvalid.equals("1")) validCheckBox.setSelected(true); else validCheckBox.setSelected(false);
                passwordField.setText(Mpass);
                gradeComboBox.setSelectedItem(Mgrade);
                beginMoneyField.setText(Mbeginmoney);
                curMoneyField.setText(Mcurmoney);
                consumField.setText(Msumcost);
                beginPointsField.setText(Mbeginpoints);
                curPointsField.setText(Mcurpoints);
                sumPointsField.setText(Msumpoints);
                remarkArea.setText(Mremark);

                conn.close();
        }catch (SQLException ex) {
            System.out.println(ex.getStackTrace());
        }} else {
        }
    }

    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();
    JLabel beginPointsLabel = new JLabel();
    JTextField beginMoneyField = new JTextField();
    JTextField beginPointsField = new JTextField();
    JLabel curMoneyLabel = new JLabel();
    JLabel curPointsLabel = new JLabel();
    JTextField curMoneyField = new JTextField();
    JTextField curPointsField = new JTextField();
    JLabel consumLabel = new JLabel();
    JLabel sumPointsLabel = new JLabel();
    JTextField consumField = new JTextField();
    JTextField sumPointsField = new JTextField();
    JLabel remarkLabel = new JLabel();
    JTextArea remarkArea = new JTextArea();
    Border border1 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
        Color.white, new Color(178, 178, 178));
    JTable table = null;
    //简单的日期格式
    private static final DateFormat DATE_FORMAT = new SimpleDateFormat("yyyy-MM-dd");
    //DateChooser,用于日期的选择
    private static final DateChooser DATE_CHOOSER = new DateChooser((JFrame)null,"日期选择");
    Date birthday = new Date();//日期
    Date enterdate = new Date();
    Date enddate = new Date();
    private String ID = "-1";//记录将要修改的会员的ID号，如果为-1，则说明尚无选定的会员。选择String类型是为了符合其数据库类型

    public void cancelButton_actionPerformed(ActionEvent e) {
        //通过当前panel得到其所依附的JFrame，需要四次getParent()
        //从底层向上分别为：UpdatePanel->JPanel->JLayeredPane->JRootPane->JFrame
        JFrame frame = (JFrame)this.getParent().getParent().getParent().getParent();
        frame.setVisible(false);
        frame.dispose();
    }

    public void saveButton_actionPerformed(ActionEvent e) {
        if(table.getSelectedRow() == -1)//如果没有被选中的行，直接返回
            return;
        //获得新添加会员的各个属性
        String Mname = nameField.getText();
        String Msex = (String)(sexComboBox.getSelectedItem());
        String Mminzu = nationField.getText();
        String Mvipkind = (String)(memKindComboBox.getSelectedItem());
        String Mbirthday = (String)birthdayComboBox.getSelectedItem();
        String Munit = unitField.getText();
        String Maddress = addressField.getText();
        String Mpostcode = postcodeField.getText();
        String Mphone = phoneField.getText();
        String Moccu = careerField.getText();
        String Mmovephone = mobiliField.getText();
        String Mcertid = certcodeField.getText();
        String Memail = emailField.getText();
        String Mvipid = memNumField.getText();
        int Mvalid = validCheckBox.isSelected() ? 1 : 0;
        char[] pass = passwordField.getPassword();
        String Mpass = new String(pass);
        String Mgrade = (String)(gradeComboBox.getSelectedItem());
        String MenterDate = (String)enterDateComboBox.getSelectedItem();
        String Menddate = (String)endDateComboBox.getSelectedItem();
        String Mbeginmoney = beginMoneyField.getText().length() == 0 ? "0" : beginMoneyField.getText();//如果未填写，则默认为"0"
        String Mcurmoney = curMoneyField.getText().length() == 0 ? "0" : curMoneyField.getText();
        String Msumcost = consumField.getText().length() == 0 ? "0" : consumField.getText();
        String Mbeginpoints = beginPointsField.getText().length() == 0 ? "0" : beginPointsField.getText();
        String Mcurpoints = curPointsField.getText().length() == 0 ? "0" : curPointsField.getText();
        String Msumpoints = sumPointsField.getText().length() == 0 ? "0" : sumPointsField.getText();
        String Mremark = remarkArea.getText().length() == 0 ? " " : remarkArea.getText();

        //连接数据库
        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 stmtUpdate = null;
        Statement stmtQuery = null;
        ResultSet  rs = null;
        try {
            stmtUpdate = conn.createStatement();

            //更新数据库
            stmtUpdate.executeUpdate("update VIP set Name = '" + Mname + "',"
                                     +"Sex = '" + Msex + "',"
                                     +"MinZu = '" + Mminzu + "',"
                                     +"VIPID = '" + Mvipid + "',"
                                     +"VIPKind = '" + Mvipkind + "',"
                                     +"Birthday = '" + Mbirthday + "',"
                                     +"Unit = '" + Munit + "',"
                                     +"Address = '" + Maddress + "',"
                                     +"postcode = '" + Mpostcode + "',"
                                     +"Phone = '" + Mphone + "',"
                                     +"Occu = '" + Moccu + "',"
                                     +"MovePhone = '" + Mmovephone + "',"
                                     +"CertID = '" + Mcertid + "',"
                                     +"Email = '" + Memail + "',"
                                     +"Valid = '" + Mvalid + "',"
                                     +"Pass = '" + Mpass + "',"
                                     +"Grade = '" + Mgrade + "',"
                                     +"EnterDate = '" + MenterDate + "',"
                                     +"EndDate = '" + Menddate + "',"
                                     +"BeginMoney = '" + Mbeginmoney + "',"
                                     +"SumCost = '" + Msumcost + "',"
                                     +"BeginPoints = '" + Mbeginpoints + "',"
                                     +"CurPoints = '" + Mcurpoints + "',"
                                     +"SumPoints = '" + Msumpoints + "',"
                                     +"Mem = '" + Mremark + "'"
                                     +" where ID = "+ID);

            //更新表，得到当前选中的表的一行，修改其中每列的值
            DefaultTableModel tm = (DefaultTableModel)table.getModel();
            int selectedRow = table.getSelectedRow();

            tm.setValueAt(Mname,selectedRow,1);
            tm.setValueAt(Mvipid,selectedRow,2);
            tm.setValueAt(Msex,selectedRow,3);
            tm.setValueAt(Mgrade,selectedRow,4);
            tm.setValueAt(Mphone,selectedRow,5);
            tm.setValueAt(Mmovephone,selectedRow,6);
            tm.setValueAt(Mbirthday,selectedRow,7);
            tm.setValueAt(Mvalid,selectedRow,8);
            tm.setValueAt(Mpass,selectedRow,9);
            tm.setValueAt(MenterDate,selectedRow,10);
            tm.setValueAt(Menddate,selectedRow,11);
            tm.setValueAt(Mbeginmoney,selectedRow,12);
            tm.setValueAt(Mcurmoney,selectedRow,13);
            tm.setValueAt(Msumcost,selectedRow,14);
            tm.setValueAt(Mbeginpoints,selectedRow,15);
            tm.setValueAt(Mcurpoints,selectedRow,16);
            tm.setValueAt(Msumpoints,selectedRow,17);
            tm.setValueAt(Mminzu,selectedRow,18);
            tm.setValueAt(Munit,selectedRow,19);
            tm.setValueAt(Maddress,selectedRow,20);
            tm.setValueAt(Mpostcode,selectedRow,21);
            tm.setValueAt(Moccu,selectedRow,22);
            tm.setValueAt(Mcertid,selectedRow,23);
            tm.setValueAt(Memail,selectedRow,24);

            table.repaint();
            conn.close();
        }catch (SQLException ex) {
            System.out.println(ex.getStackTrace());
        }
        //退出
        cancelButton_actionPerformed(e);
    }

    public void birthdayComboBox_actionPerformed(ActionEvent e) {
        DATE_CHOOSER.setLocation(birthdayComboBox.getX() + DATE_CHOOSER.getWidth() / 2,
                                 birthdayComboBox.getY() + DATE_CHOOSER.getHeight() / 2 + birthdayComboBox.getHeight());
        Date day = DATE_CHOOSER.select(birthday);
        if(day != null){
            birthdayComboBox.removeItemAt(0);
            birthdayComboBox.addItem(DATE_FORMAT.format(day));
            birthday = day;
        }
    }

    public void enterDateComboBox_actionPerformed(ActionEvent e) {
        DATE_CHOOSER.setLocation(enterDateComboBox.getX() + DATE_CHOOSER.getWidth() / 2,
                                 enterDateComboBox.getY() + DATE_CHOOSER.getHeight() / 2 + enterDateComboBox.getHeight());
        Date day = DATE_CHOOSER.select(enterdate);
        if(day != null){
            enterDateComboBox.removeItemAt(0);
            enterDateComboBox.addItem(DATE_FORMAT.format(day));
            enterdate = day;
        }
    }

    public void endDateComboBox_actionPerformed(ActionEvent e) {
        DATE_CHOOSER.setLocation(endDateComboBox.getX() + DATE_CHOOSER.getWidth() / 2,
                                 endDateComboBox.getY() + DATE_CHOOSER.getHeight() / 2 + endDateComboBox.getHeight());
        Date day = DATE_CHOOSER.select(enddate);
        if(day != null){
            endDateComboBox.removeItemAt(0);
            endDateComboBox.addItem(DATE_FORMAT.format(day));
            enddate = day;
        }
    }
}

class UpdatePanel_endDateComboBox_actionAdapter
    implements ActionListener {
    private UpdatePanel adaptee;
    UpdatePanel_endDateComboBox_actionAdapter(UpdatePanel adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.endDateComboBox_actionPerformed(e);
    }
}

class UpdatePanel_enterDateComboBox_actionAdapter
    implements ActionListener {
    private UpdatePanel adaptee;
    UpdatePanel_enterDateComboBox_actionAdapter(UpdatePanel adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.enterDateComboBox_actionPerformed(e);
    }
}

class UpdatePanel_birthdayComboBox_actionAdapter
    implements ActionListener {
    private UpdatePanel adaptee;
    UpdatePanel_birthdayComboBox_actionAdapter(UpdatePanel adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.birthdayComboBox_actionPerformed(e);
    }
}

class UpdatePanel_saveButton_actionAdapter
    implements ActionListener {
    private UpdatePanel adaptee;
    UpdatePanel_saveButton_actionAdapter(UpdatePanel adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.saveButton_actionPerformed(e);
    }
}

class UpdatePanel_cancelButton_actionAdapter
    implements ActionListener {
    private UpdatePanel adaptee;
    UpdatePanel_cancelButton_actionAdapter(UpdatePanel adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.cancelButton_actionPerformed(e);
    }
}