qxgl.java

基于Java——SQL2005 的java课程设计 仓库管理系统。主要功能

package windows;

import Login.Item;
import Login.Login;

import java.awt.Dimension;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Insets;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JComponent;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;
import javax.swing.event.InternalFrameAdapter;
import javax.swing.event.InternalFrameEvent;
import model.TbUserlist;
import sql.sql;
import windows.mainFrame;

public class QXGL extends JInternalFrame {
	private JTextField userName;
	private JComboBox quanXian;
	private JTextField name;
	private JTextField pass;
	private JButton modifyButton;
	private JButton closeButton;
	private JComboBox userCombo;
	private TbUserlist user = Login.getUser();
	String msg="";
	int type=JOptionPane.PLAIN_MESSAGE;
	public QXGL() {
		if(user.getQuan().equals("超级管理员")){			
		setClosable(true);
		setIconifiable(true);
		setBounds(200, 100, 450, 170);
		setTitle("管理员管理之权限管理");
		setLayout(new GridBagLayout());
		setVisible(true);

		final JLabel khName = new JLabel();
		khName.setText("用户名：");
		setupComponet(khName, 0, 0, 1, 0, false);
		userName = new JTextField();
		userName.setEditable(false);
		setupComponet(userName, 1, 0, 1, 125, true);

		final JLabel addressLabel = new JLabel("姓名：");
		setupComponet(addressLabel, 2, 0, 1, 0, false);
		name = new JTextField();
		name.setEditable(false);
		setupComponet(name, 3, 0, 1, 100, true);

		setupComponet(new JLabel("密码："), 0, 1, 1, 0, false);
		pass = new JPasswordField();
		pass.setEditable(false);
		setupComponet(pass, 1, 1, 1, 125, true);

		setupComponet(new JLabel("权限："), 2, 1, 1, 0, false);
		quanXian = new JComboBox(new String[]{"超级管理员", "管理员"});
		setupComponet(quanXian, 3, 1, 1, 100, true);

		setupComponet(new JLabel("选择用户"), 0, 2, 1, 0, false);
		userCombo = new JComboBox();
		userCombo.setPreferredSize(new Dimension(80, 21));
		// 处理用户信息的下拉选择框的选择事件
		userCombo.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				
				doUserSelectAction();
				quanXian.requestFocus();				
			}
		});
		// 定位用户信息的下拉选择框
		setupComponet(userCombo, 1, 2, 2, 0, true);
		modifyButton = new JButton("修改");
		//modifyButton.setEnabled(false);
		closeButton = new JButton("关闭");
		JPanel panel = new JPanel();
		panel.add(modifyButton);
		panel.add(closeButton);
		setupComponet(panel, 3, 2, 1, 0, false);
		
		
		userCombo.requestFocus();
		// 处理关闭按钮的单击事件
		closeButton.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				QXGL.this.doDefaultCloseAction();
			}
		});
		// 处理修改按钮的单击事件
		
		quanXian.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				modifyButton.requestFocus();
			}
		});
		// 处理修改按钮的单击事件
		
		
		modifyButton.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				Item item = (Item) userCombo.getSelectedItem();
				TbUserlist user =sql.getUser(item);
				int index = quanXian.getSelectedIndex();
				if (index == 0)
					user.setQuan("超级管理员");
				else
					user.setQuan("管理员");
				if (sql.updateUser(user) >= 1)
				{
					JOptionPane   j   =   new   JOptionPane("权限修改完成，是否继续修改权限？",   JOptionPane.QUESTION_MESSAGE,JOptionPane.YES_NO_OPTION,null,new   Object[]{"   是   ","   否   "});   
					Object[]   xx   =   j.getOptions();   
					int i=JOptionPane.showOptionDialog(QXGL.this,"权限修改完成，是否继续修改权限？","E时代仓库信息管理系统添加管理员提示",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE,null,xx,"   否   ");  
					if(i==1)dispose();		
					//JOptionPane.showMessageDialog(QXGL.this, "修改完成");
				}
				else
					JOptionPane.showMessageDialog(QXGL.this, "修改失败");
			}
		});
		// 窗体激活事件
		addInternalFrameListener(new InternalFrameAdapter() {
			public void internalFrameActivated(InternalFrameEvent e) {
				initComboBox();// 初始化用户下拉选择框
			}
		});
	}
	else{
		type=JOptionPane.ERROR_MESSAGE;
		msg="你没有权限管理的权限";
		JOptionPane.showMessageDialog(null, msg, "E时代仓库信息管理系统权限管理提示", type);
		//管理员没有权限管理的权限
	}	
	}
	// 初始化用户下拉选择框
	public void initComboBox() {
		//if()
		//List khInfo = sql.getUsers();
		String sqlyuju = "select * from tb_userlist where ";
		List khInfo = sql.findForList(sqlyuju + "quan='" + "管理员" + "'");
		//List khInfo =sql.
		List<Item> items = new ArrayList<Item>();
		userCombo.removeAllItems();
		for (Iterator iter = khInfo.iterator(); iter.hasNext();) {
			List element = (List) iter.next();
			Item item = new Item();
			item.setId(element.get(0).toString().trim());
			item.setName(element.get(1).toString().trim());
			if (items.contains(item))
				continue;
			items.add(item);
			userCombo.addItem(item);
		}
		
		doUserSelectAction();
	}
	// 设置组件位置并添加到容器中
	private void setupComponet(JComponent component, int gridx, int gridy,
			int gridwidth, int ipadx, boolean fill) {
		final GridBagConstraints gridBagConstrains = new GridBagConstraints();
		gridBagConstrains.gridx = gridx;
		gridBagConstrains.gridy = gridy;
		if (gridwidth > 1)
			gridBagConstrains.gridwidth = gridwidth;
		if (ipadx > 0)
			gridBagConstrains.ipadx = ipadx;
		gridBagConstrains.insets = new Insets(5, 1, 3, 1);
		if (fill)
			gridBagConstrains.fill = GridBagConstraints.HORIZONTAL;
		add(component, gridBagConstrains);
	}
	private void doUserSelectAction() {
		Item selectedItem;
		if (!(userCombo.getSelectedItem() instanceof Item)) {
			return;
		}
		selectedItem = (Item) userCombo.getSelectedItem();
		TbUserlist user = sql.getUser(selectedItem);
		userName.setText(user.getUsername());
		name.setText(user.getName());
		pass.setText(user.getPass());
		if (user.getQuan().equals("超级管理员"))
			quanXian.setSelectedIndex(0);
		else
			quanXian.setSelectedIndex(1);
	}
	
	
}