package set;
import java.awt.*;import java.awt.event.*;import java.util.*;import tools.*;import javax.swing.*;
/** * <p>Title: </p> * * <p>Description: </p> * * <p>Copyright: Copyright (c) 2007</p> * * <p>Company: </p> * * @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(); } }}
