waiterframe.java

一个KTV管理系统

package view.mainframe.operationqueryframe;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.File;
import java.util.Iterator;
import java.util.Vector;
import javax.swing.JButton;
import javax.swing.JFileChooser;
import javax.swing.JFrame;
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.UIManager;
import javax.swing.table.DefaultTableModel;

import common.centerwindow.CenterWindow;
import common.checkinputvalue.Check;
import dao.WaiterConsumedDao;
import dao.consumeddao.GoodsConsumedDao;
import dao.consumeddao.GuestConsumedDao;
import view.mainframe.guestconsumed.guestcheckoutframe.GuestCheckOutFrame;
import view.mainframe.guestconsumed.guestcheckoutframe.GuestTable;
import view.mainframe.systemmaintenance.Waitertable;
import vo.GuestConsumedInfo;
import vo.WaiterInfo;

//服务生查询信息界面
public class WaiterFrame extends JFrame implements ActionListener {
	File file = null;

	JFileChooser filechooser = new JFileChooser();

	private JFrame jFrame = null;

	private JPanel jContentPane = null;

	private JScrollPane jScrollPane = null;

	private JPanel jPanel = null;

	private JButton jButton1 = null;

	private JButton jButton2 = null;

	private JButton jButtonExport = null;

	private JLabel jLabel = null;

	private JScrollPane jScrollPane1 = null;

	private JTable jTable = null;

	private JPanel jPanel1 = null;

	private JLabel jLabel1 = null;

	private JTable jTableWaiterQuery = null;

	private static WaiterFrame instance = null;

	private static JFrame jFrameWaiter = null;

	private JTextField jTextFieldgetWaiterQuery = null;

	private JTextField jTextFieldgetRoomNumber = null;

	private JTextField consumedIdTextField = null;

	private boolean hasWaiterConsumedInfo() {
		return new WaiterConsumedDao().hasWaiterConsumedInfo();
	}

	// 测试方法
	public static void main(String[] args) {
		WaiterFrame s = new WaiterFrame();
		s.getJFrame();
	}

	public static WaiterFrame getInstance() {
		if (instance == null) {
			instance = new WaiterFrame();
		}
		instance.jTableWaiterQuery = instance.getJTable();
		instance.jFrameWaiter.setVisible(true);
		return instance;
	}

	public WaiterFrame() {
		try {
			UIManager.setLookAndFeel("com.nilo.plaf.nimrod.NimRODLookAndFeel");
			// 渲染主界面
		} catch (Exception e1) {
			e1.printStackTrace();
		}
		getJFrame();
	}

	// 获取服务生信息表格
	private JTable getJTable() {
		if (jTable == null) {
			Object[][] p = null;
			String[] n = { "编号", "姓名", "性别", "联系方式", "服务区域", "服务等级" };
			DefaultTableModel md = new DefaultTableModel(p, n);
			jTable = new JTable(md);
			jTableWaiterQuery = new JTable(md);
			jTableWaiterQuery.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
		}
		DefaultTableModel model = (DefaultTableModel) jTableWaiterQuery
				.getModel();
		int rows = model.getRowCount();
		// 删除表格中目前的数据
		for (int i = rows - 1; i >= 0; i--) {
			model.removeRow(i);
		}
		return jTable;
	}

	/**
	 * This method initializes jFrame 初始化面板
	 * 
	 * @return javax.swing.JFrame
	 */
	public JFrame getJFrame() {
		if (jFrame == null) {

			jFrame = new JFrame();
			jFrame.setSize(new java.awt.Dimension(558, 351));
			jFrame.setTitle("服务生查询");
			new CenterWindow().centerWindow(jFrame);
			jFrame.setContentPane(getJContentPane());
			jFrame.setVisible(true);
		}
		return jFrame;
	}

	// 主面板
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(getJScrollPane(), null);
			jContentPane.add(getJPanel(), null);
			jContentPane.add(getJPanel1(), null);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jScrollPane 滚动条面板
	 * 
	 * @return javax.swing.JScrollPane
	 */
	private JScrollPane getJScrollPane() {
		if (jScrollPane == null) {
			jScrollPane = new JScrollPane();
			jScrollPane.setBounds(new java.awt.Rectangle(11, 90, 544, 331));
			jScrollPane.setViewportView(getJScrollPane1());
		}
		return jScrollPane;
	}

	/**
	 * This method initializes jPanel
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJPanel() {
		if (jPanel == null) {
			jLabel = new JLabel();
			jLabel.setBounds(new java.awt.Rectangle(4, 9, 82, 25));
			jLabel.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
			jLabel.setText("服务生编号");
			jPanel = new JPanel();
			jPanel.setLayout(null);
			jPanel.setBounds(new java.awt.Rectangle(14, 9, 543, 47));
			jPanel.add(getJButton2(), null);
			jPanel.add(getJButton1(), null);
			jPanel.add(jButtonExport(), null);
			jPanel.add(getJTextField(), null);
			jPanel.add(jLabel, null);
		}
		return jPanel;
	}

	// 刷新按纽
	private JButton getJButton1() {
		if (jButton1 == null) {
			jButton1 = new JButton();
			jButton1.setBounds(new java.awt.Rectangle(334, 10, 60, 28));
			jButton1.setText("刷新");
			jButton1.addActionListener(this);
		}
		return jButton1;
	}

	/**
	 * This method initializes jButton2
	 * 
	 * @return javax.swing.JButton
	 */
	// 查询按纽
	private JButton getJButton2() {
		if (jButton2 == null) {
			jButton2 = new JButton();
			jButton2.setBounds(new java.awt.Rectangle(215, 9, 60, 28));
			jButton2.setText("查询");
			jButton2.addActionListener(this);
		}
		return jButton2;
	}

	/**
	 * This method initializes jButton3
	 * 
	 * @return javax.swing.JButton
	 */
	// 导出数据按纽
	private JButton jButtonExport() {
		if (jButtonExport == null) {
			jButtonExport = new JButton();
			jButtonExport.setText("导出");
			jButtonExport.setBounds(new java.awt.Rectangle(443, 9, 60, 28));
			jButtonExport
					.addActionListener(new java.awt.event.ActionListener() {
						public void actionPerformed(java.awt.event.ActionEvent e) {
							try {
								if (file != null)
									filechooser.setSelectedFile(file);

								int returnVal = filechooser
										.showSaveDialog(WaiterFrame.this);

								if (returnVal == JFileChooser.APPROVE_OPTION) {
									file = filechooser.getSelectedFile();
									String path = file.getPath();
									System.out.println(path);
//									String getText = consumedIdTextField
//											.getText().trim();
									if (hasWaiterConsumedInfo()) {
										Waitertable tt = new Waitertable();
										Vector veDta = Waitertable
												.getVectorData();
										tt.writeExcelOfFile(path, veDta, null);
										JOptionPane.showMessageDialog(null,
												"恭喜您!您的表已经导到指定的位置", "提示信息",
												JOptionPane.WARNING_MESSAGE);

									} else {
										JOptionPane.showMessageDialog(null,
												"消费明细不存在", "提示信息",
												JOptionPane.YES_OPTION);
									}

								}
							} catch (Exception ex) {
								JOptionPane.showMessageDialog(null, "导出错误",
										"提示信息", JOptionPane.YES_OPTION);
							}
						}
					});
		}
		return jButtonExport;
	}

	/**
	 * This method initializes jTextField
	 * 
	 * @return javax.swing.JTextField
	 */
	private JTextField getJTextField() {
		if (jTextFieldgetWaiterQuery == null) {
			jTextFieldgetWaiterQuery = new JTextField();
			jTextFieldgetWaiterQuery.setBounds(new java.awt.Rectangle(96, 10,
					105, 26));
		}
		return jTextFieldgetWaiterQuery;
	}

	/**
	 * This method initializes jScrollPane1 滚动面板
	 * 
	 * @return javax.swing.JScrollPane
	 */
	private JScrollPane getJScrollPane1() {
		if (jScrollPane1 == null) {
			jScrollPane1 = new JScrollPane();
			jScrollPane1.setViewportView(getJTable());
		}
		return jScrollPane1;
	}

	/**
	 * This method initializes jTable
	 * 
	 * @return javax.swing.JTable
	 */
	/**
	 * This method initializes jPanel1
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJPanel1() {
		if (jPanel1 == null) {
			jLabel1 = new JLabel();
			jLabel1.setText("服务生信息");
			jLabel1.setForeground(new java.awt.Color(0, 0, 109));
			jLabel1.setBounds(new java.awt.Rectangle(187, 5, 60, 18));
			jLabel1.setFont(new java.awt.Font("Dialog", java.awt.Font.ITALIC,
					12));
			jPanel1 = new JPanel();
			jPanel1.setLayout(null);
			jPanel1.setBounds(new java.awt.Rectangle(13, 56, 536, 29));
			jPanel1.setBackground(new java.awt.Color(171, 169, 207));
			jPanel1.add(jLabel1, null);
		}
		return jPanel1;
	}

	// 面板内组件的各个动作事件
	public void actionPerformed(ActionEvent e) {
		JButton jb = (JButton) e.getSource();
		DefaultTableModel model = (DefaultTableModel) jTableWaiterQuery
				.getModel();
		if (jb.getText().equals("查询")) {
			if (checkinput()) {
				String value = jTextFieldgetWaiterQuery.getText().trim();
				if (value.equals("")) {
					value = "0";
				}

				int rows = model.getRowCount();
				// 删除表格中目前的数据
				for (int i = rows - 1; i >= 0; i--) {
					model.removeRow(i);
				}
				Vector v = getConsumed(value);
				Iterator iter = v.iterator();
				while (iter.hasNext()) {
					WaiterInfo gci = (WaiterInfo) iter.next();
					Object[] date = { String.valueOf(gci.getWaiter_id()),
							String.valueOf(gci.getWaiter_name()),
							gci.getWaiter_sex(), gci.getWaiter_tel(),
							String.valueOf(gci.getWaiter_area()),
							gci.getLeveling() };
					model.addRow(date);
				}
			}
		}
		if (jb.getText().equals("刷新")) {
			int rows = model.getRowCount();
			// 删除表格中目前的数据
			for (int i = rows - 1; i >= 0; i--) {
				model.removeRow(i);
			}
			Vector v = getsConsumed();
			Iterator iter = v.iterator();
			while (iter.hasNext()) {
				WaiterInfo gci = (WaiterInfo) iter.next();
				Object[] date = { String.valueOf(gci.getWaiter_id()),
						String.valueOf(gci.getWaiter_name()),
						String.valueOf(gci.getWaiter_sex()),
						String.valueOf(gci.getWaiter_tel()),
						String.valueOf(gci.getWaiter_area()),
						String.valueOf(gci.getLeveling()) };
				model.addRow(date);
			}
		}
	}

	// 判断输入是否是真确信息的方法
	private boolean checkinput() {
		Check c = new Check();
		if (c.checkIsContainNumber(jTextFieldgetWaiterQuery.getText().trim())) {
			return true;
		} else {
			JOptionPane.showMessageDialog(null, "请输入正确的查询条件", "提示信息",
					JOptionPane.YES_OPTION);
		}
		return false;
	}

	private Vector getConsumed(String value) {

		return new GuestConsumedDao().getWaiterConsumedInfo(value);
	}

	// 从dao层调入数据的方法
	private Vector getsConsumed() {
		return new GuestConsumedDao().getsWaiterConsumedInfo();
	}

}