scgly.java

来自「基于Java——SQL2005 的java课程设计 仓库管理系统。主要功能」· Java 代码 · 共 199 行

package windows;



import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Insets;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.util.Iterator;
import java.util.List;

import javax.swing.JButton;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;

import model.TbUserlist;
import Login.Login;

import sql.sql;
public class SCGLY extends JInternalFrame {
	private JTextField loginName;
	private JTextField passField;
	private JTextField userName;
	private JTable table;
	private DefaultTableModel dftm;
	private String[] columnNames;
	String msg="";
	int type=JOptionPane.PLAIN_MESSAGE;
	private TbUserlist user = Login.getUser();
	public SCGLY() {
		super();
		if(user.getQuan().equals("超级管理员")){
		setBounds(160, 100, 491, 287);
		setTitle("管理员管理之删除管理员");
		setClosable(true);
		setLayout(new GridBagLayout());
		setIconifiable(true);
		final JScrollPane scrollPane = new JScrollPane();
		final GridBagConstraints gridBagConstraints = new GridBagConstraints();
		gridBagConstraints.weightx = 1.0;
		gridBagConstraints.insets = new Insets(0, 0, 20, 0);
		gridBagConstraints.gridwidth = 12;
		gridBagConstraints.fill = GridBagConstraints.BOTH;
		gridBagConstraints.weighty = 1.0;
		gridBagConstraints.gridx = 0;
		gridBagConstraints.gridy = 0;
		gridBagConstraints.ipadx = 35;
		gridBagConstraints.ipady = -195;
		add(scrollPane, gridBagConstraints);

		table = new JTable();
		table.setShowGrid(true);
		dftm = (DefaultTableModel) table.getModel();
		columnNames = new String[]{"管理员姓名", "用户名", "密码", "权限"};
		dftm.setColumnIdentifiers(columnNames);
		initTable();
		
		table.addMouseListener(new MouseAdapter() {
			public void mouseClicked(final MouseEvent e) {
				String uName, passstr, logName;
				int selRow = table.getSelectedRow();
				uName = table.getValueAt(selRow, 1).toString().trim();
				passstr = table.getValueAt(selRow, 2).toString().trim();
				logName = table.getValueAt(selRow, 0).toString().trim();
				userName.setText(uName);
				passField.setText(passstr);
				loginName.setText(logName);
			}
		});
		scrollPane.setViewportView(table);
		//scrollPane.add(table);

		final JLabel label = new JLabel();
		final GridBagConstraints gridBagConstraints_3 = new GridBagConstraints();
		gridBagConstraints_3.gridy = 2;
		gridBagConstraints_3.gridx = 0;
		add(label, gridBagConstraints_3);
		label.setText("管理员姓名：");

		userName = new JTextField();
		userName.setEditable(false);
		final GridBagConstraints gridBagConstraints_4 = new GridBagConstraints();
		gridBagConstraints_4.insets = new Insets(0, 0, 0, 10);
		gridBagConstraints_4.fill = GridBagConstraints.HORIZONTAL;
		gridBagConstraints_4.weightx = 1.0;
		gridBagConstraints_4.gridy = 2;
		gridBagConstraints_4.gridx = 3;
		add(userName, gridBagConstraints_4);

		final JLabel label_2 = new JLabel();
		label_2.setText("用户名：");
		final GridBagConstraints gridBagConstraints_7 = new GridBagConstraints();
		gridBagConstraints_7.gridy = 2;
		gridBagConstraints_7.gridx = 4;
		add(label_2, gridBagConstraints_7);

		loginName = new JTextField();
		loginName.setEditable(false);
		final GridBagConstraints gridBagConstraints_8 = new GridBagConstraints();
		gridBagConstraints_8.weightx = 1.0;
		gridBagConstraints_8.insets = new Insets(0, 0, 0, 10);
		gridBagConstraints_8.fill = GridBagConstraints.HORIZONTAL;
		gridBagConstraints_8.gridy = 2;
		gridBagConstraints_8.gridx = 5;
		add(loginName, gridBagConstraints_8);

		final JLabel label_1 = new JLabel();
		final GridBagConstraints gridBagConstraints_6 = new GridBagConstraints();
		gridBagConstraints_6.gridy = 2;
		gridBagConstraints_6.gridx = 6;
		add(label_1, gridBagConstraints_6);
		label_1.setText("密码：");

		passField = new JTextField();
		final GridBagConstraints gridBagConstraints_5 = new GridBagConstraints();
		gridBagConstraints_5.insets = new Insets(0, 0, 0, 10);
		gridBagConstraints_5.fill = GridBagConstraints.HORIZONTAL;
		gridBagConstraints_5.weightx = 1.0;
		gridBagConstraints_5.gridy = 2;
		gridBagConstraints_5.gridx = 7;
		add(passField, gridBagConstraints_5);
		passField.setEditable(false);

		final JButton button = new JButton("删除");
		final GridBagConstraints gridBagConstraints_1 = new GridBagConstraints();
		gridBagConstraints_1.insets = new Insets(5, 0, 5, 0);
		gridBagConstraints_1.gridy = 7;
		gridBagConstraints_1.gridx = 4;
		add(button, gridBagConstraints_1);
		button.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				JOptionPane   j   =   new   JOptionPane("你是否删除改管理员？", JOptionPane.INFORMATION_MESSAGE,JOptionPane.YES_NO_OPTION,null,new   Object[]{"   是   ","   否   "});   
				Object[]   xx   =   j.getOptions();   
				int op=JOptionPane.showOptionDialog(SCGLY.this,"你是否删除改管理员？","E时代仓库信息管理系统删除管理员提示",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE,null,xx,"   是   ");  
				//if(i==1)dispose();	
				//int op = JOptionPane.showConfirmDialog(SCGLY.this,	"确认要删除该操作员？");
				if (op == 0) {
					sql.delete("delete tb_userlist where username='"
							+ userName.getText() + "'");
					loginName.setText("");
					passField.setText("");
					userName.setText("");
					initTable();
				}
			}
		});

		final JButton button_1 = new JButton("关闭");
		final GridBagConstraints gridBagConstraints_2 = new GridBagConstraints();
		gridBagConstraints_2.insets = new Insets(5, 0, 5, 0);
		gridBagConstraints_2.gridy = 7;
		gridBagConstraints_2.gridx = 6;
		add(button_1, gridBagConstraints_2);
		button_1.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				dispose();
			}
		});
		}
		else{
			type=JOptionPane.ERROR_MESSAGE;
			msg="你没有删除管理员的权限";
			JOptionPane.showMessageDialog(SCGLY.this, msg, "E时代仓库信息管理系统删除管理员提示", type);
			//管理员没有权限管理的权限
		}	
	}
		
	public void initTable() {
		String sqlyuju = "select * from tb_userlist where ";
		List ul = sql.findForList(sqlyuju + "quan='" + "管理员" + "'");
		//List ul = sql.getUsers();
		Iterator it = ul.iterator();
		String[] data = new String[4];
		dftm.setDataVector(null, columnNames);
		int rowCount=dftm.getRowCount();
		for(int i=0;i<rowCount;i++) {
			dftm.removeRow(0);	
		}
		while (it.hasNext()) {
			List userlist = (List) it.next();
			data[0] = (String) userlist.get(0);
			data[1] = (String) userlist.get(1);
			data[2] = (String) userlist.get(2);
			data[3] = ((String) userlist.get(3));
			dftm.addRow(data);
		}
		setVisible(true);
	}
}