s1(java)项目实战（固定资产管理）（set_ deleteManager）

来源：互联网发布：淘宝logo设计理念编辑：程序博客网时间：2024/04/30 18:02

package set;

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

/**
* Title: 
*
* Description: 
*
* Copyright: Copyright (c) 2007
*
* Company: 
*
* @author not attributable
* @version 1.0
*/
public class deleteManager extends JDialog {
 private JTextArea jta_manager_delete_messaage = new JTextArea();
 private JComboBox manager_list;
 private JButton btn_ok = new JButton();
 private JButton btn_cancle = new JButton();
 private DBConnection dcon;
 private String user = "";

    public deleteManager(Frame owner, String title, boolean modal, String _user) {
        super(owner, title, modal);
        try {
            user = _user;
            setDefaultCloseOperation(DISPOSE_ON_CLOSE);
            jbInit();
            pack();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public deleteManager(String _user) {
        this(new Frame(), "管理员转帐", false, _user);
    }

    private void jbInit() throws Exception {
        this.getContentPane().setLayout(null);
        manager_list = new JComboBox(getmanager());
        jta_manager_delete_messaage.setBackground(new Color(236, 233, 216));
        jta_manager_delete_messaage.setFont(new java.awt.Font("Dialog",
                Font.BOLD, 14));
        jta_manager_delete_messaage.setToolTipText("");
        jta_manager_delete_messaage.setText("因为该管理员工有业务发生，请转入其他管理员");
        jta_manager_delete_messaage.setLineWrap(true);
        jta_manager_delete_messaage.setWrapStyleWord(true);
        jta_manager_delete_messaage.setEditable(false);
        jta_manager_delete_messaage.setBounds(new Rectangle(28, 12, 171, 51));
        this.getContentPane().setBackground(SystemColor.control);
        manager_list.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        manager_list.setBounds(new Rectangle(43, 69, 112, 30));
        btn_ok.setBounds(new Rectangle(25, 124, 65, 32));
        btn_ok.setText("确定");
        btn_cancle.setBounds(new Rectangle(113, 123, 60, 32));
        btn_cancle.setText("取消");
        this.getContentPane().add(jta_manager_delete_messaage);
        this.getContentPane().add(manager_list);
        this.getContentPane().add(btn_cancle);
        this.getContentPane().add(btn_ok);
        btn_cancle.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                cancleDialog();
            }
        });
        btn_ok.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                if (manager_list.getSelectedItem() != null &&
                    manager_list.getSelectedItem().toString().trim().length() !=
                    0) {

                    deldeteManager(manager_list.getSelectedItem().toString().trim());
                }
            }
        });
    }

//获取管理员列表
 private String[] getmanager() {
 dcon = new DBConnection();
 Vector v = dcon.select("Select manager_username from Manager");
 int count = v.size();
 String[] s = new String[count];
 for (int i = 0; i < count; i++) {
 s[i] = ((Vector) v.get(i)).get(0).toString();
 }
 return s;
 }

    //获取管理员id
    private String getManagerID(String username) {
        dcon = new DBConnection();
        String sql = "Select manager_id from Manager where manager_username = '" + username + "'";
        Vector v = dcon.select(sql);
        return ((Vector) v.get(0)).get(0).toString();
    }

//关闭对话框
    private void cancleDialog() {
        this.dispose();
    }

    //处理删除
    private void deldeteManager(String username) {
        if (username.trim().length() != 0) {
            dcon = new DBConnection();
            String newid = getManagerID(username);
            String oldid = getManagerID(user);
            String sql = "update Action set manager_id = '" + newid +
                         "' where manager_id = '" + oldid + "'";
            JOptionPane.showMessageDialog(this,
                                          "你成功的将" + user + "转入了" + username +
                                          "下");
            dcon.update(1, sql);

            if (!user.trim().equals("admin")) {
                sql = "delete from Manager where manager_id = '" + oldid +
                      "'";
                dcon.update(1, sql);
                JOptionPane.showMessageDialog(this,
                                              "你成功的删除了ID为" + oldid + "的操作员");
            } else {
                JOptionPane.showMessageDialog(this, "admin不能删除");
            }
             cancleDialog();
        }
    }
}