qcquestionsearch.java

JAVA源代码实现spring+hibernate配置实例

package internalFrame.xiTongSheZhi;
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.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;
import model.Qcinfo;
import org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;
import dao.UserDAO;
public class QcQuestionSearch extends JInternalFrame implements
ApplicationContextAware{
    private static final long serialVersionUID = -136032733839142751L;
	private JButton button;
	   private JTable table;
	   private JTextField textField;
	   private JComboBox comboBox_1;
	   private JComboBox comboBox;
	   private UserDAO dao;
       private ApplicationContext appContext;
		   public void setApplicationContext(ApplicationContext app)
		   throws BeansException {
	       appContext = app;
	       dao = (UserDAO) appContext.getBean("DAOProxyTransactionFactory");
	       //Admin user = (Admin) 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();
					Qcinfo qcinfo = (Qcinfo) iterator.next();
					//vector.add(kucun.getId());
					vector.add(qcinfo.getPono().trim());
					vector.add(qcinfo.getPonum());
					vector.add(qcinfo.getQuestion01());
					vector.add(qcinfo.getQuestion02());
					vector.add(qcinfo.getQuestion03());
					vector.add(qcinfo.getQuestion04());
					vector.add(qcinfo.getQuestion05());
					vector.add(qcinfo.getQuestion06());
					vector.add(qcinfo.getQuestion07());
					vector.add(qcinfo.getQuestion08());
					vector.add(qcinfo.getQuestion09());
					vector.add(qcinfo.getQuestion10());
					tm.addRow(vector);
				}
			}
		   public QcQuestionSearch(){
		   super();
			setMaximizable(true);
			setIconifiable(true);
			setClosable(true);
			setTitle("中检查询");
			getContentPane().setLayout(new GridBagLayout());
			setBounds(0,0,800,600);

			table = new JTable();
			table.setEnabled(false);
			table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
			final DefaultTableModel tm = new DefaultTableModel(new String[] {
					"制单号","工序号","问题一", "问题二", "问题三", "问题四", "问题五", "问题六", "问题七", "问题八", "问题九","问题十"}, 0);
			table.setModel(tm);
			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=null, operation;
					String content = textField.getText();
					switch (comboBox.getSelectedIndex()) {
					case 0:
						condition = "Pono";
						break;
					case 1:
						condition = "Ponum";
						break;
					
					}
					switch (comboBox_1.getSelectedIndex()) {
					case 0:
						operation = "= '"+content+"'";
						break;
					case 1:
						operation = "like '%"+content+"%'";
						break;
				    default:
						operation = "= '"+content+"'";
						break;
					}
					list=dao.queryObject("from Qcinfo where "+ condition+" "+operation +"order by id.pono,id.ponum");
					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 Qcinfo order by id.pono,id.ponum");
					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);
		   }

}