frmupd.java

现代社会离不开手机和电话

import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.*;

// Referenced classes of package telmanagersystem:
//            SQL

public class frmUpd extends JInternalFrame
    implements ActionListener
{

    public frmUpd()
    {
        super("修改信息", false, true, false, true);
        sql = new SQL();
        jpn = new JPanel();
        jpc = new JPanel();
        jps = new JPanel();
        jl_yname = new JLabel("原姓名");
        jcb_yname = new JComboBox();
        jl_name = new JLabel("姓名");
        jtf_name = new JTextField(30);
        jl_add = new JLabel("地址");
        jtf_add = new JTextField(30);
        jl_tel = new JLabel("电话D");
        jtf_tel = new JTextField(30);
        jb_ok = new JButton("确定");
        jb_no = new JButton("取消");
        jpn.add(jl_yname);
        jpn.add(jcb_yname);
        jpc.add(jl_name);
        jpc.add(jtf_name);
        jpc.add(jl_add);
        jpc.add(jtf_add);
        jpc.add(jl_tel);
        jpc.add(jtf_tel);
        jps.add(jb_ok);
        jps.add(jb_no);
        jb_ok.addActionListener(this);
        jb_no.addActionListener(this);
        jcb_yname.addActionListener(this);
        getContentPane().setLayout(new BorderLayout());
        getContentPane().add(jpn, "North");
        getContentPane().add(jpc, "Center");
        getContentPane().add(jps, "South");
        setDefaultCloseOperation(2);
        setSize(400, 200);
        setVisible(true);
        playallname();
    }

    public void actionPerformed(ActionEvent actionevent)
    {
        if(actionevent.getSource() == jb_ok)
        {
            String s = jcb_yname.getSelectedItem().toString().trim();
            String s1 = jtf_name.getText().trim();
            String s2 = jtf_add.getText().trim();
            String s3 = jtf_tel.getText().trim();
            if(s1.equals("") || s3.equals(""))
            {
                JOptionPane.showMessageDialog(this, "名字或电话不能为空", "错误信息", 0);
            } else
            {
                sql.update(s, s1, s2, s3);
                JOptionPane.showMessageDialog(this,  "修改信息成功", "插入信息", 1);
                jcb_yname.removeActionListener(this);
                playallname();
                jcb_yname.setSelectedItem(s1);
                jcb_yname.addActionListener(this);
            }
        }
        if(actionevent.getSource() == jb_no)
            setVisible(false);
        if(actionevent.getSource() == jcb_yname)
            playname4all();
    }

    public void playallname()
    {
        jcb_yname.removeAllItems();
        try
        {
            String s;
            for(ResultSet resultset = sql.selectallname(); resultset.next(); jcb_yname.addItem(s))
                s = resultset.getString("name");

        }
        catch(SQLException sqlexception)
        {
            System.out.println(sqlexception.getMessage());
        }
    }

    public void playname4all()
    {
        try
        {
            String s = jcb_yname.getSelectedItem().toString();
            ResultSet resultset = sql.selectname4all(s);
            resultset.next();
            String s1 = resultset.getString("name");
            String s2 = resultset.getString("add");
            String s3 = resultset.getString("tel");
            jtf_name.setText(s1);
            jtf_add.setText(s2);
            jtf_tel.setText(s3);
        }
        catch(SQLException sqlexception)
        {
            System.out.println(sqlexception.getMessage());
        }
    }

    SQL sql;
    JPanel jpn;
    JPanel jpc;
    JPanel jps;
    JLabel jl_yname;
    JComboBox jcb_yname;
    JLabel jl_name;
    JTextField jtf_name;
    JLabel jl_add;
    JTextField jtf_add;
    JLabel jl_tel;
    JTextField jtf_tel;
    JButton jb_ok;
    JButton jb_no;
}