kucunchaxun.java

企业进销存管理 包括了基本的企业管理的基本功能

package internalFrame.kuCunGuanLi;
import java.awt.Font;
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.KeyAdapter;
import java.awt.event.KeyEvent;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;
import model.TabKucun;
import model.Userlist;
import org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;
import dao.UserDAO;
public class KuCunChaXun extends JInternalFrame implements
		ApplicationContextAware {
	private JButton button;
	private JTable table;
	private JTextField textField;
	private JComboBox comboBox_1;
	private JComboBox comboBox;
	private UserDAO dao;
	private Userlist user;
	private ApplicationContext appContext;
	public void setApplicationContext(ApplicationContext app)
			throws BeansException {
		appContext = app;
		dao = (UserDAO) appContext.getBean("DAOProxyTransactionFactory");
		user = (Userlist) appContext.getBean("loginUser");
	}
	private void updateTable(final DefaultTableModel tm, Iterator iterator) {
		int num = tm.getRowCount();
		for (int i = 0; i < num; i++)
			tm.removeRow(0);
		while (iterator.hasNext()) {
			Vector vector = new Vector();
			TabKucun kucun = (TabKucun) iterator.next();
			vector.add(kucun.getId().trim());
			vector.add(kucun.getSpname().trim());
			vector.add(kucun.getJc().trim());
			vector.add(kucun.getCd().trim());
			vector.add(kucun.getGg().trim());
			vector.add(kucun.getBz().trim());
			vector.add(kucun.getDw().trim());
			vector.add(kucun.getDj());
			vector.add(kucun.getKcsl());
			vector.add(kucun.getDj() * kucun.getKcsl());
			tm.addRow(vector);
		}
	}
	public KuCunChaXun() {
		super();
		setMaximizable(true);
		setIconifiable(true);
		setClosable(true);
		setTitle("库存查询");
		getContentPane().setLayout(new GridBagLayout());
		setBounds(100, 100, 609, 375);

		table = new JTable();
		table.setEnabled(false);
		table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
		final DefaultTableModel tm = new DefaultTableModel(new String[] {
				"库存编号","商品名称", "简称", "产地", "规格", "包装", "单位", "单价", "库存数量", "库存金额" }, 0);
		table.setModel(tm);
		table.putClientProperty("Quaqua.Table.style", "striped");

		final JLabel label = new JLabel();
		label.setFont(new Font("", Font.PLAIN, 14));
		label.setText(" 选择查询条件：");
		final GridBagConstraints gridBagConstraints = new GridBagConstraints();
		gridBagConstraints.gridy = 0;
		gridBagConstraints.gridx = 0;
		getContentPane().add(label, gridBagConstraints);

		comboBox = new JComboBox();
		comboBox.setModel(new DefaultComboBoxModel(new String[] { "库存编号",
				"商品名称", "简称", "库存数量" }));
		comboBox.setFont(new Font("", Font.PLAIN, 14));
		final GridBagConstraints gridBagConstraints_1 = new GridBagConstraints();
		gridBagConstraints_1.gridy = 0;
		gridBagConstraints_1.gridx = 1;
		getContentPane().add(comboBox, gridBagConstraints_1);

		comboBox_1 = new JComboBox();
		comboBox_1.setModel(new DefaultComboBoxModel(new String[] { "等于", "包含",
				"大于", "小于" }));
		comboBox_1.setFont(new Font("", Font.PLAIN, 14));
		final GridBagConstraints gridBagConstraints_2 = new GridBagConstraints();
		gridBagConstraints_2.gridy = 0;
		gridBagConstraints_2.gridx = 2;
		getContentPane().add(comboBox_1, gridBagConstraints_2);

		textField = new JTextField();
		textField.addKeyListener(new KeyAdapter() {
			public void keyPressed(final KeyEvent e) {
				if(e.getKeyCode()==10)
					button.doClick();
			}
		});
		textField.setFont(new Font("", Font.PLAIN, 14));
		final GridBagConstraints gridBagConstraints_3 = new GridBagConstraints();
		gridBagConstraints_3.ipadx = 105;
		gridBagConstraints_3.insets = new Insets(0, 10, 0, 10);
		gridBagConstraints_3.fill = GridBagConstraints.HORIZONTAL;
		gridBagConstraints_3.weightx = 1.0;
		gridBagConstraints_3.gridy = 0;
		gridBagConstraints_3.gridx = 3;
		getContentPane().add(textField, gridBagConstraints_3);
		button = new JButton();
		button.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				List list;
				String condition, operation;
				String content = textField.getText();
				switch (comboBox.getSelectedIndex()) {
				case 0:
					condition = "id";
					break;
				case 1:
					condition = "spname";
					break;
				case 2:
					condition = "jc";
					break;
				case 3:
					condition = "kcsl";
					break;
				default:
					condition = "id";
					break;
				}
				switch (comboBox_1.getSelectedIndex()) {
				case 0:
					operation = "= '"+content+"'";
					break;
				case 1:
					operation = "like '%"+content+"%'";
					break;
				case 2:
					if(!condition.equals("kcsl")){
						JOptionPane.showMessageDialog(getContentPane(), "只有库存数量能查询大于小于");
						return;
					}
					operation = "> "+content;
					break;
				case 3:
					if(!condition.equals("kcsl")){
						JOptionPane.showMessageDialog(getContentPane(), "只有库存数量能查询大于小于");
						return;
					}
					operation = "< "+content;
					break;
				default:
					operation = "= '"+content+"'";
					break;
				}
				list=dao.queryObject("from TabKucun where "+ condition+" "+operation);
				updateTable(tm, list.iterator());
			}
		});
		final GridBagConstraints gridBagConstraints_4 = new GridBagConstraints();
		gridBagConstraints_4.gridy = 0;
		gridBagConstraints_4.gridx = 4;
		getContentPane().add(button, gridBagConstraints_4);
		button.setFont(new Font("", Font.PLAIN, 12));
		button.setText("查询");
		final JButton button_1 = new JButton();
		button_1.setSelected(true);
		button_1.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				textField.setText("");
				List list = dao.queryObject("from TabKucun");
				Iterator iterator = list.iterator();
				updateTable(tm, iterator);
			}
		});
		final GridBagConstraints gridBagConstraints_5 = new GridBagConstraints();
		gridBagConstraints_5.insets = new Insets(0, 0, 0, 10);
		gridBagConstraints_5.anchor = GridBagConstraints.WEST;
		gridBagConstraints_5.gridy = 0;
		gridBagConstraints_5.gridx = 5;
		getContentPane().add(button_1, gridBagConstraints_5);
		button_1.setFont(new Font("", Font.PLAIN, 12));
		button_1.setText("显示全部数据");
		final JScrollPane scrollPane = new JScrollPane();
		final GridBagConstraints gridBagConstraints_6 = new GridBagConstraints();
		gridBagConstraints_6.weighty = 1.0;
		gridBagConstraints_6.anchor = GridBagConstraints.NORTH;
		gridBagConstraints_6.insets = new Insets(0, 10, 5, 10);
		gridBagConstraints_6.fill = GridBagConstraints.BOTH;
		gridBagConstraints_6.gridwidth = 6;
		gridBagConstraints_6.gridy = 1;
		gridBagConstraints_6.gridx = 0;
		getContentPane().add(scrollPane, gridBagConstraints_6);
		scrollPane.setViewportView(table);
	}
}