kehuchaxun.java

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

package internalFrame.jiBenXinXi;

import java.awt.Color;
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.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.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.ListSelectionModel;
import javax.swing.table.DefaultTableModel;

import model.TabKhinfo;

import org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;

import dao.UserDAO;

public class KeHuChaXun extends JInternalFrame
		implements
			ApplicationContextAware {
	private JTable table;

	private JTextField conditionContent;

	private JComboBox conditionBox2;

	private JComboBox conditionBox1;

	private UserDAO dao;

	private ApplicationContext appContext;

	public void setApplicationContext(ApplicationContext app)
			throws BeansException {
		appContext = app;
		dao = (UserDAO) appContext.getBean("DAOProxyTransactionFactory");
	}

	public KeHuChaXun() {
		super();
		setMaximizable(true);
		setIconifiable(true);
		setClosable(true);
		setTitle("客户信息查询");
		getContentPane().setLayout(new GridBagLayout());
		setBounds(100, 100, 609, 375);

		final JScrollPane scrollPane = new JScrollPane();
		scrollPane.setAutoscrolls(true);
		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;
		System.out.println("getContent=" + getContentPane());
		getContentPane().add(scrollPane, gridBagConstraints_6);
		table = new JTable();
		table.setEnabled(false);
		table.putClientProperty("Quaqua.Table.style", "striped");
		table.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
		table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
		table.setFont(new Font("", Font.PLAIN, 14));
		table.setGridColor(new Color(192, 192, 192));
		table.setShowGrid(true);
		String[] tableHeads = new String[]{"客户ID", "客户全称", "客户地址", "客户简称",
				"邮政编码", "电　　话", "传　　真", "联  系  人", "联系电话", "E-Mail", "开户银行",
				"银行账号"};
		final DefaultTableModel dftm = (DefaultTableModel) table.getModel();
		dftm.setColumnIdentifiers(tableHeads);
		scrollPane.setViewportView(table);

		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);

		conditionBox1 = new JComboBox();
		conditionBox1.setModel(new DefaultComboBoxModel(new String[]{"客户全称",
				"客户简称"}));
		conditionBox1.setFont(new Font("", Font.PLAIN, 14));
		final GridBagConstraints gridBagConstraints_1 = new GridBagConstraints();
		gridBagConstraints_1.gridy = 0;
		gridBagConstraints_1.gridx = 1;
		getContentPane().add(conditionBox1, gridBagConstraints_1);

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

		conditionContent = new JTextField();
		conditionContent.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(conditionContent, gridBagConstraints_3);

		final JButton queryButton = new JButton();
		queryButton.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				String condition, conditionOperation, conditionString;
				List list;
				condition = conditionBox1.getSelectedItem().toString().trim();
				conditionOperation = conditionBox2.getSelectedItem().toString()
						.trim();
				conditionString = conditionContent.getText().trim();
				System.out.println("conditionString is:" + conditionString);
				if (condition.equals("客户全称")) {
					if (conditionOperation.equals("等于"))
						list = dao
								.queryObject("from TabKhinfo where id.khname='"
										+ conditionString + "'");
					else
						list = dao
								.queryObject("from TabKhinfo where id.khname like '%"
										+ conditionString + "%'");
				} else {
					if (conditionOperation.equals("等于"))
						list = dao.queryObject("from TabKhinfo where id.jian='"
								+ conditionString + "'");
					else
						list = dao
								.queryObject("from TabKhinfo where id.jian like '%"
										+ conditionString + "%'");
				}
				updateTable(list, dftm);
			}
		});
		final GridBagConstraints gridBagConstraints_4 = new GridBagConstraints();
		gridBagConstraints_4.gridy = 0;
		gridBagConstraints_4.gridx = 4;
		getContentPane().add(queryButton, gridBagConstraints_4);
		queryButton.setFont(new Font("", Font.PLAIN, 12));
		queryButton.setText("查询");

		final JButton showAllButton = new JButton();
		showAllButton.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				conditionContent.setText("");
				List list = dao.queryObject("from TabKhinfo");
				updateTable(list, dftm);
			}
		});
		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(showAllButton, gridBagConstraints_5);
		showAllButton.setFont(new Font("", Font.PLAIN, 12));
		showAllButton.setText("显示全部数据");
	}

	private void updateTable(List list, final DefaultTableModel dftm) {
		int num = dftm.getRowCount();
		for (int i = 0; i < num; i++)
			dftm.removeRow(0);

		Iterator iterator = list.iterator();
		TabKhinfo khInfo;
		while (iterator.hasNext()) {
			khInfo = (TabKhinfo) iterator.next();
			Vector rowData = new Vector();
			rowData.add(khInfo.getId().trim());
			rowData.add(khInfo.getKhname().trim());
			rowData.add(khInfo.getAddress().trim());
			rowData.add(khInfo.getJian().trim());
			rowData.add(khInfo.getBianma().trim());
			rowData.add(khInfo.getTel().trim());
			rowData.add(khInfo.getFax().trim());
			rowData.add(khInfo.getLian().trim());
			rowData.add(khInfo.getLtel().trim());
			rowData.add(khInfo.getMail().trim());
			rowData.add(khInfo.getXinhang().trim());
			rowData.add(khInfo.getHao().trim());
			dftm.addRow(rowData);
		}
	}
}