dataframe.java

简单的留言版

package res;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JTextField;
import javax.swing.JRadioButton;
import javax.swing.JButton;
import javax.swing.JPasswordField;
import java.awt.Color;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JOptionPane;
import javax.swing.JComboBox;
import java.sql.*;
import java.awt.event.WindowEvent;
import java.awt.event.WindowAdapter;
import java.awt.Font;

/**
 * <p>Title: 注册窗口</p>
 *
 * <p>Description: 新同学的个人信息注册　</p>
 *
 * <p>Copyright: A1Q6073-未定义小组 2006</p>
 *
 * <p>Company: 北大青鸟Aptech(西安毕诚) </p>
 *
 * @author not 王亮　冯瑞　冯鹏　刘文涛 赵凡(按姓氏笔画排序)
 * @version 1.0
 */
public class DataFrame extends JFrame {
    public DataFrame(MainFrame mf) {
        try {
            mfd = mf;
            jbInit();
            Data();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    MainFrame mfd;
    TestImage tImage = new TestImage();
    JLabel lblDcall = new JLabel();
    JLabel lblDname = new JLabel();
    JLabel lblDsex = new JLabel();
    JTextField txtDcall = new JTextField();
    JLabel lblDpwd = new JLabel();
    JLabel lblDadds = new JLabel();
    JTextField txtDname = new JTextField();
    JTextField txtDadds = new JTextField();
    JTextField txtDmail = new JTextField();
    JLabel lblDmail = new JLabel();
    JButton btnDrework = new JButton();
    JTextField txtDpwd = new JTextField();
    JLabel lblDid = new JLabel();
    JTextField txtDid = new JTextField();
    JOptionPane oppMeg = new JOptionPane();
    JComboBox cmbDsex = new JComboBox();
    DBconnection db = new DBconnection();
    ResultSet rs;
    JLabel jLabel3 = new JLabel();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        tImage.setLayout(null);
        tImage.setBounds(new Rectangle(0, 0, 300, 400)); //面板图片大小,下行为需要插的图片
        tImage.setImage("Image\\df.jpg");
        tImage.setSize(300, 400);
        this.setResizable(false);
        setTitle("个人资料");
        lblDcall.setText("联系电话：");
        lblDcall.setBounds(new Rectangle(43, 194, 65, 17));
        lblDname.setText("姓　　名：");
        lblDname.setBounds(new Rectangle(43, 105, 74, 20));
        lblDsex.setText("性　　别：");
        lblDsex.setBounds(new Rectangle(43, 167, 78, 14));
        txtDcall.setBounds(new Rectangle(132, 193, 120, 20));
        lblDpwd.setText("密　　码：");
        lblDpwd.setBounds(new Rectangle(43, 134, 75, 15));
        lblDadds.setText("现住地址：");
        lblDadds.setBounds(new Rectangle(43, 250, 64, 16));
        txtDname.setBounds(new Rectangle(132, 103, 102, 19));
        txtDadds.setBounds(new Rectangle(132, 250, 120, 20));
        txtDmail.setBounds(new Rectangle(132, 223, 120, 19));
        lblDmail.setText("电子邮件：");
        lblDmail.setBounds(new Rectangle(43, 223, 64, 15));
        btnDrework.setBounds(new Rectangle(209, 288, 66, 21));
        btnDrework.setText("修改");
        btnDrework.addActionListener(new DataFrame_btnDsubmit_actionAdapter(this));
        txtDpwd.setBounds(new Rectangle(132, 130, 102, 20));
        lblDid.setText("学　　号：");
        lblDid.setBounds(new Rectangle(43, 73, 72, 24));
        txtDid.setBounds(new Rectangle(132, 73, 102, 22));
        cmbDsex.setBounds(new Rectangle(132, 162, 61, 19));
        this.addWindowListener(new DataFrame_this_windowAdapter(this));
        jLabel3.setForeground(Color.red);
        jLabel3.setText("*不能修改");
        jLabel3.setBounds(new Rectangle(237, 73, 67, 21));
        jLabel1.setForeground(Color.red);
        jLabel1.setText("*");
        jLabel1.setBounds(new Rectangle(237, 101, 10, 21));
        jLabel2.setForeground(Color.red);
        jLabel2.setText("* 至少6位");
        jLabel2.setBounds(new Rectangle(236, 130, 76, 21));
        this.add(tImage);
        tImage.add(txtDadds);
        tImage.add(btnDrework);
        tImage.add(lblDadds);
        tImage.add(lblDmail);
        tImage.add(txtDmail);
        tImage.add(lblDcall);
        tImage.add(txtDcall);
        tImage.add(lblDsex);
        tImage.add(lblDpwd);
        tImage.add(txtDpwd);
        tImage.add(lblDname);
        tImage.add(txtDname);
        tImage.add(lblDid);
        tImage.add(txtDid);
        tImage.add(cmbDsex);
        tImage.add(jLabel3);
        tImage.add(jLabel1);
        tImage.add(jLabel2);
    }

    public void Data() {
        String sql1 = "select * from stumeg where id='" +
                      mfd.txt1id.getText() + "'";
        rs = db.GetRs(sql1);
        try {
            rs.next();
            txtDid.setText(rs.getString(1));
            txtDid.setEditable(false);
            txtDname.setText(rs.getString(2));
            txtDpwd.setText(rs.getString(3));
            cmbDsex.removeAllItems();
            if(rs.getString(4).trim().equals("male")){
                cmbDsex.addItem(rs.getString(4).trim());
                cmbDsex.addItem("female");
            } else {
                cmbDsex.addItem(rs.getString(4).trim());
                cmbDsex.addItem("male");
            }
            txtDcall.setText(rs.getString(5));
            txtDmail.setText(rs.getString(6));
            txtDadds.setText(rs.getString(7));
        } catch (Exception ex) {

        }
        System.out.println(txtDid.getText());
    }

    /*修改注册事件*/
    public void btnDrework_actionPerformed(ActionEvent e) {
        //db.ResultSql("updata stumeg set sname='"+txtDname.getText()+"' where id='"+txtDid.getText()+"'");
        try {
            if (txtDname.getText().equals("")) {
                JOptionPane.showMessageDialog(this, "请输入姓名！");
            } else if (txtDname.getText().length() > 4) {
                JOptionPane.showMessageDialog(this, "姓名最多为四个字");
            } else if (txtDpwd.getText().equals("")) {
                JOptionPane.showMessageDialog(this, "请输入密码");
            } else if (txtDpwd.getText().length() < 6) {
                JOptionPane.showMessageDialog(this, "您输入的密码长度小于6位");
            } else {
                /*判断E-mail是否输入*/
                if (!txtDmail.getText().equals("")) {
                    int eml1 = txtDmail.getText().indexOf('@');
                    int eml2 = txtDmail.getText().indexOf('.');
                    /*判断E-mail格式正确性*/
                    if (eml1 > 0 && eml2 > 0 && eml2 > eml1) {
                        String sql2 =
                                "update StuMeg set sname='" +
                                txtDname.getText() + "',spwd='" +
                                txtDpwd.getText() + "',ssex='" +
                                cmbDsex.getSelectedItem() + "',sphone='" +
                                txtDcall.getText() + "',smail='" +
                                txtDmail.getText() + "',sadrs='" +
                                txtDadds.getText() + "' where id='" +
                                txtDid.getText() + "' ";
                        db.ResultSql(sql2);
                        mfd.select();
                        JOptionPane.showMessageDialog(this, "修改成功");
                    } else {
                        JOptionPane.showMessageDialog(this,
                                "您输入的E-mail格式不对");
                    }
                } else {
                    String sql2 = "update StuMeg set sname='" +
                                  txtDname.getText() + "',spwd='" +
                                  txtDpwd.getText() + "',ssex='" +
                                  cmbDsex.getSelectedItem() + "',sphone='" +
                                  txtDcall.getText() + "',smail='" +
                                  txtDmail.getText() + "',sadrs='" +
                                  txtDadds.getText() + "' where id='" +
                                  txtDid.getText() + "' ";
                    db.ResultSql(sql2);
                    mfd.select();
                    JOptionPane.showMessageDialog(this, "修改成功");
                }
            }
            //关闭  ResultSet 对象
            rs.close();
        } catch (Exception ex) {

        }
    }

    /*窗口关闭事件*/
    public void this_windowClosing(WindowEvent e) {
        //主窗口解锁
        mfd.setEnabled(true);
    }

}


class DataFrame_this_windowAdapter extends WindowAdapter {
    private DataFrame adaptee;
    DataFrame_this_windowAdapter(DataFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void windowClosed(WindowEvent e) {

    }

    public void windowClosing(WindowEvent e) {
        adaptee.this_windowClosing(e);
    }
}


class DataFrame_btnDsubmit_actionAdapter implements ActionListener {
    private DataFrame adaptee;
    DataFrame_btnDsubmit_actionAdapter(DataFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnDrework_actionPerformed(e);

    }
}