frmdel.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 frmDel extends JInternalFrame
    implements ActionListener
{

    public frmDel()
    {
        super("删除信息", false, true, false, true);
        sql = new SQL();
        jpn = new JPanel();
        jps = new JPanel();
        jl_name = new JLabel("姓名");
        jcb_name = new JComboBox();
        jb_ok = new JButton("确定");
        jb_no = new JButton("取消");
        jpn.add(jl_name);
        jpn.add(jcb_name);
        jps.add(jb_ok);
        jps.add(jb_no);
        jb_ok.addActionListener(this);
        jb_no.addActionListener(this);
        getContentPane().setLayout(new BorderLayout());
        getContentPane().add(jpn, "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_name.getSelectedItem().toString().trim();
			    if(s.equals(""))
			    {
			        JOptionPane.showMessageDialog(this, "库里已经没有存储的数据了", "删除错误", 0);
			    } else
			    {
			        sql.delete(s);
			        JOptionPane.showMessageDialog(this, "删除信息成功", "删除信息", 1);
			        playallname();
			    }
			}
		
        if(actionevent.getSource() == jb_no)
            setVisible(false);
    }

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

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

    SQL sql;
    JPanel jpn;
    JPanel jps;
    JLabel jl_name;
    JComboBox jcb_name;
    JButton jb_ok;
    JButton jb_no;
}