clientmange.java

java开发的聊天软件

package chatserver;

import java.sql.*;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;

import com.borland.jbcl.layout.*;

/**
 * <p>Title: 聊天</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: 个人</p>
 *
 * @author Mothz
 * @version 1.0
 */
public class ClientMange
    extends JFrame {
    JPanel jPanel1 = new JPanel();
    PaneLayout paneLayout1 = new PaneLayout();
    JPanel jPanel2 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JTextField idNumber = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    BorderLayout borderLayout1 = new BorderLayout();
    JScrollPane jScrollPane1 = new JScrollPane();
    List List1 = new List();
    JButton jButton3 = new JButton();
    PopupMenu pou = new PopupMenu();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();

    public ClientMange() {
        try {
            //设置窗口左上的小图标
            this.setIconImage(Toolkit.getDefaultToolkit().createImage(
                "images/1.png"));
            jbInit();
        }
        catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setSize(450, 300);
        this.setTitle("用户管理");
        getContentPane().setLayout(paneLayout1);
        idNumber.setColumns(15);
        //设置 限制号码输入为数字
        idNumber.addKeyListener(new KeyAdapter() {
            public void keyTyped(KeyEvent event) {
                char ch = event.getKeyChar();
                if (ch < '0' || ch > '9') {
                    event.consume();
                }
            }
        });

        jPanel2.setLayout(borderLayout1);
        jButton1.addActionListener(new ClientMange_jButton1_actionAdapter(this));
        jButton2.addActionListener(new ClientMange_jButton2_actionAdapter(this));
        List1.addMouseListener(new ClientMange_List1_mouseAdapter(this));
        jButton3.setBorder(null);
        jButton3.setIcon(new ImageIcon(
            "images/shanchu.jpg"));
        jButton3.addActionListener(new ClientMange_jButton3_actionAdapter(this));
        jButton1.setBorder(null);
        jButton1.setIcon(new ImageIcon("images/chaxun.jpg"));
        jButton2.setBorder(null);
        jButton2.setIcon(new ImageIcon("images/all.jpg"));
        jLabel2.setText("已注册用户数:");
        jLabel3.setText("0");
        jLabel3.addAncestorListener(new ClientMange_jLabel3_ancestorAdapter(this));
        jPanel1.add(jLabel1);
        jPanel1.add(idNumber);
        jPanel1.add(jButton1);
        jPanel1.add(jButton2);
        jPanel1.add(jButton3);
        jPanel1.add(jLabel2);
        jPanel1.add(jLabel3);
        jLabel1.setText("输入ID:");
        jPanel2.add(jScrollPane1, java.awt.BorderLayout.CENTER);
        jScrollPane1.getViewport().add(List1);
        this.getContentPane().add(jPanel1,
                                  new PaneConstraints("jPanel1", "jPanel2",
            PaneConstraints.ROOT, 0.2F));
        this.getContentPane().add(jPanel2,
                                  new PaneConstraints("jPanel2", "jPanel2",
            PaneConstraints.BOTTOM, 0.8F));
    }

    //查询指定号码
    public void jButton1_actionPerformed(ActionEvent e) {
        if (idNumber.getText().trim().equals("")) {
            JOptionPane.showMessageDialog(null, "号码不可为空！");
        }
        else {
            //获得Staetment对象
            Statement stmt = linkData.getStatement();
            try {
                //查询号码
                ResultSet rs = stmt.executeQuery(
                    "SELECT * FROM clients WHERE id='" +
                    idNumber.getText().trim() + "'");
                if (rs.next()) {
                    /*先清空List信息，再添加查询到的信息*/
                    List1.removeAll();
                    //显示查询到的帐号
                    List1.add(rs.getString(1));
                }
                else {
                    JOptionPane.showMessageDialog(null,
                                                  "你查询的" +
                                                  idNumber.getText().trim() +
                                                  "不存在\n请重新输入！");
                    //号码栏清空
                    idNumber.setText("");
                }
            }
            catch (SQLException ex) {
                ex.printStackTrace();
            }
        }
    }

    //列出所有号码
    public void jButton2_actionPerformed(ActionEvent e) {
        Statement stmt = linkData.getStatement(); //获得Staetment对象
        try {
            //执行号码查询
            ResultSet rs = stmt.executeQuery("SELECT * FROM clients WHERE id");
            //清空列表
            List1.removeAll();
            //使用while循环 向list添加查询到的号码
            while (rs.next()) {
                List1.add(rs.getString(1));
            }
        }
        catch (SQLException ex) {
            ex.printStackTrace();
        }
    }

    public void List1_mousePressed(MouseEvent e) {

    }

    void m1_actionPerformed(ActionEvent e) {

    }

    //删除客户号码
    public void jButton3_actionPerformed(ActionEvent e) {
        if (List1.getSelectedItem() == null) {
            JOptionPane.showMessageDialog(null, "请选择要删除的号码！");
        }
        else {
            Statement stmt = linkData.getStatement(); //获得Staetment对象
            //获取列表选择的号码
            String wd = List1.getSelectedItem();
            Object[] options = {
                "确定删除", "取消"};
            //显示管理员 确认对话框
            int agr = JOptionPane.showOptionDialog(null,
                "你确定删除" + wd, "警告", JOptionPane.YES_OPTION,
                JOptionPane.WARNING_MESSAGE, null,
                options, options[0]);
            //判断管理员的选择
            if (agr == 0) {
                try {
                    //执行删除用户
                    stmt.executeUpdate("DELETE FROM clients WHERE id='" + wd +
                                       "'");
                    JOptionPane.showMessageDialog(null, "删除成功");
                    //列表移出删除的用户
                    List1.remove(wd);
                    //将注册用户数减1,并再次显示
                    //转换为int类型
                    int nm = Integer.parseInt(jLabel3.getText());
                    //-1计算
                    int cha = nm - 1;
                    //显示处理后的注册用户数
                    jLabel3.setText("" + cha);
                }
                catch (SQLException ex) {
                    ex.printStackTrace();
                }

            }
        }
    }

    //显示注册用户数
    public void jLabel3_ancestorAdded(AncestorEvent event) {
        //获取Statament对象
        Statement stmt = linkData.getStatement();
        try {
            //查询数据库个数
            ResultSet rs = stmt.executeQuery(
                "SELECT COUNT(*) AS ID FROM clients");
            //SELECT COUNT(*) AS fettle FROM ClientInformation where fettle=1//查询字段 指定数
            if (rs.next()) {
                //显示数据库个数
                jLabel3.setText("" + rs.getInt(1));
            }
        }
        catch (SQLException ex) {
            ex.printStackTrace();
        }

    }
}

class ClientMange_jLabel3_ancestorAdapter
    implements AncestorListener {
    private ClientMange adaptee;
    ClientMange_jLabel3_ancestorAdapter(ClientMange adaptee) {
        this.adaptee = adaptee;
    }

    public void ancestorAdded(AncestorEvent event) {
        adaptee.jLabel3_ancestorAdded(event);
    }

    public void ancestorRemoved(AncestorEvent event) {
    }

    public void ancestorMoved(AncestorEvent event) {
    }
}

class ClientMange_jButton3_actionAdapter
    implements ActionListener {
    private ClientMange adaptee;
    ClientMange_jButton3_actionAdapter(ClientMange adaptee) {
        this.adaptee = adaptee;
    }

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

class ClientMange_List1_mouseAdapter
    extends MouseAdapter {
    private ClientMange adaptee;
    ClientMange_List1_mouseAdapter(ClientMange adaptee) {
        this.adaptee = adaptee;
    }

    public void mousePressed(MouseEvent e) {
        adaptee.List1_mousePressed(e);
    }
}

class ClientMange_jButton2_actionAdapter
    implements ActionListener {
    private ClientMange adaptee;
    ClientMange_jButton2_actionAdapter(ClientMange adaptee) {
        this.adaptee = adaptee;
    }

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

class ClientMange_jButton1_actionAdapter
    implements ActionListener {
    private ClientMange adaptee;
    ClientMange_jButton1_actionAdapter(ClientMange adaptee) {
        this.adaptee = adaptee;
    }

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