systemsetting.java

一个KTV管理系统

			});
		}
		return jButtonAddRoom;
	}
	
	
	/**
	 *构造输入插值的方法
	 */
	private ConsumedTypeInfo getConsumedTypeInputValue() throws Exception {
		ConsumedTypeInfo value = null;
		String consumedTypeName = "";
		double rebate = 0;
		consumedTypeName = jTextFieldgetConsumedTypeName.getText().trim();
		rebate = Double.parseDouble(jTextFieldgetRebate.getText().trim());
		value = new ConsumedTypeInfo(consumedTypeName, rebate);
		return value;
	}

	private Operator getOperatorInputValue() {
		Operator value = null;
		int operatorId = 0;
		String operatorName = "";
		String operatorLevel = "";
		operatorId = Integer.parseInt(jTextFieldgetOperatorId.getText().trim());
		operatorName = jTextFieldgetOperatorName.getText().trim();
		operatorLevel = jComboBoxOperatorLevel.getSelectedItem().toString()
				.trim();
		value = new Operator(operatorId, operatorName, operatorLevel, "123");
		return value;
	}

	private Goods getGoodsInputValue() throws Exception {
		Goods value = null;
		String goodsName = "";
		String goodsUnit = "";
		double goodsCostPrice = 0.0;
		double goodsSellPrice = 0.0;
		int goodsStock = 0;
		int goodsAlert = 0;
		String goodsAbbreviation = "";
		goodsName = jTextFieldgetGoodsName.getText().trim();
		goodsUnit = jTextFieldgetGoodsUnit.getText().trim();
		goodsCostPrice = Double.parseDouble(jTextFieldgetGoodsCostPrice
				.getText().trim());
		goodsSellPrice = Double.parseDouble(jTextFieldgetGoodsSellPrice
				.getText().trim());
		goodsStock = Integer.parseInt(jTextFieldgetGoodsStock.getText().trim());

		goodsAlert = Integer.parseInt(jTextFieldgetGoodsAlert.getText().trim());
		goodsAbbreviation = jTextFieldgetGoodsAbbreviation.getText().trim();

		value = new Goods(goodsName, goodsUnit, goodsCostPrice, goodsSellPrice,
				goodsStock, goodsAlert, goodsAbbreviation);
		return value;
	}

	private Room getRoomInputValue() {
		Room value = null;
		String roomNumber = "";
		String roomType = "";
		int roomPrice = 0;
		String roomName = "";
		String roomStatement = "";
		int roomCapacity = 0;
		roomNumber = jTextFieldgetRoomNumber.getText().trim();
		roomType = jComboBoxgetRoomType.getSelectedItem().toString().trim();
		roomPrice = Integer.parseInt(jTextFieldgetRoomPrice.getText().trim());
		roomName = jTextFieldgetRoomName.getText().trim();
		roomStatement = jComboBoxgetRoomStatement.getSelectedItem().toString()
				.trim();
		roomCapacity = Integer.parseInt(jTextFieldgetRoomCapacity.getText()
				.trim());
		int consumedId = 0;
		value = new Room(roomNumber, roomType, roomPrice, roomName,
				roomStatement, roomCapacity, consumedId);
		return value;
	}

	
	//构建删除包间的方法
	private JButton getJButtonDeleteRoom() {
		if (jButtonDeleteRoom == null) {
			jButtonDeleteRoom = new JButton();
			jButtonDeleteRoom
					.setBounds(new java.awt.Rectangle(420,194,90,30));
			jButtonDeleteRoom.setText("删除包间");
			jButtonDeleteRoom.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					//只有当包间被选中且包间处于可用或是停用状态时,才能被删除.
					try {
						if (!jLabelgetRoomNumber.getText().equals("")) {
							if (jComboBoxgetRoomStatement.getSelectedItem()
									.toString().trim().equals("可用")
									| jComboBoxgetRoomStatement
											.getSelectedItem().toString()
											.trim().equals("停用")) {
								DefaultTableModel model = (DefaultTableModel) getJTableRoomSetting()
										.getModel();
								int row = getJTableRoomSetting()
										.getSelectedRow();
								RoomSettingControl control = new RoomSettingControl();
								String roomNumber = getJTableRoomSetting()
										.getValueAt(row, 0).toString();

								if (control.deleteRoomInfo(roomNumber)) {
									JOptionPane.showMessageDialog(null,
											"删除包间成功", "删除提示",
											JOptionPane.YES_OPTION);
									model.removeRow(row);
									

								}
							} else {
								JOptionPane.showMessageDialog(null,
										"只能删除可用或停用房间", "插入提示",
										JOptionPane.YES_OPTION);
							}
						} else {
							JOptionPane.showMessageDialog(null, "请先选中您要删除的包间",
									"删除提示", JOptionPane.YES_OPTION);

						}
					} catch (Exception e1) {
						JOptionPane.showMessageDialog(null, "包间删除失败", "插入提示",
								JOptionPane.YES_OPTION);
					}
				}
			});
		}
		return jButtonDeleteRoom;
	}

	
	//构建通过房间类型过滤房间的方法
	private JComboBox getJComboBoxRoomType() {
		if (jComboBoxRoomType == null) {
			jComboBoxRoomType = new JComboBox();
			jComboBoxRoomType.addItem("");
			jComboBoxRoomType.addItem("小型包间");
			jComboBoxRoomType.addItem("中型包间");
			jComboBoxRoomType.addItem("大型包间");
			jComboBoxRoomType.addItem("豪华包间");
			jComboBoxRoomType.setBounds(new java.awt.Rectangle(134, 245, 120,
					20));
			jComboBoxRoomType.addItemListener(new ItemListener() {

				public void itemStateChanged(ItemEvent e) {

					DefaultTableModel model = (DefaultTableModel) getJTableRoomSetting()
							.getModel();
					int rows = model.getRowCount();
					//循环删除表中的数据
					for (int i = rows - 1; i >= 0; i--) {
						model.removeRow(i);
					}
					RoomSettingControl control = new RoomSettingControl();
					Vector v = control
							.getRoomStatementInfo(getJComboBoxRoomType()
									.getSelectedItem().toString().trim());
					Iterator iter = v.iterator();
					while (iter.hasNext()) {
						Room value = (Room) iter.next();
						Object[] data = { value.getRoomNumber(),
								value.getRoomType(),
								String.valueOf(value.getRoomPrice()),
								value.getRoomName(), value.getRoomStatement(),
								String.valueOf(value.getRoomCapacity()),
								String.valueOf(value.getConsumedId()) };
						model.addRow(data);
					}

				}

			});
		}
		return jComboBoxRoomType;
	}

	//构建修改房间信息的方法
	private JButton getJButtonModifyRoom() {
		if (jButtonModifyRoom == null) {
			jButtonModifyRoom = new JButton();
			jButtonModifyRoom
					.setBounds(new java.awt.Rectangle(286,195,90,30));
			jButtonModifyRoom.setText("修改包间");
			jButtonModifyRoom.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					if (checkRoomInputValue()) {
						//只有当包间处于停用或可用状态时才能修改,包间号码不能修改
						if (jComboBoxgetRoomStatement.getSelectedItem()
								.toString().trim().equals("可用")
								| jComboBoxgetRoomStatement.getSelectedItem()
										.toString().trim().equals("停用")) {
							if (jLabelgetRoomNumber.getText().trim().equals(
									jTextFieldgetRoomNumber.getText().trim())) {
								RoomSettingControl control = new RoomSettingControl();
								String room_number = getJTextFieldgetRoomNumber()
										.getText();
								String room_type = getJComboBoxgetRoomType()
										.getSelectedItem().toString().trim();

								String room_price = getJTextFieldgetRoomPrice()
										.getText();
								String room_name = getJTextFieldgetRoomName()
										.getText();
								String room_statement = getJComboBoxgetRoomStatement()
										.getSelectedItem().toString().trim();
								String room_capacity = getJTextFieldgetRoomCapacity()
										.getText();
								Room value = new Room(room_number, room_type,
										Integer.parseInt(room_price),
										room_name, room_statement, Integer
												.parseInt(room_capacity), 0);

								if (control.updateRoomInfo(value)) {
									JOptionPane.showMessageDialog(null,
											"包间修改成功", "更改提示",
											JOptionPane.YES_OPTION);
									
								}
							} else {
								JOptionPane.showMessageDialog(null, "包间号码不能修改",
										"更改提示", JOptionPane.YES_OPTION);
								jTextFieldgetRoomNumber
										.setText(jLabelgetRoomNumber.getText()
												.trim());
							}
						}
					}
				}
			});

		}
		return jButtonModifyRoom;
	}

	
	private JPanel getJPanelGoodsSetting() {
		if (jPanelGoodsSetting == null) {
			jLabelgetGoodsName = new JLabel();
			jLabelgetGoodsName.setBounds(new java.awt.Rectangle(160, 30, 100,
					20));
			jLabelgetGoodsName.setText("");
			jLabelGoodsAbbreviation = new JLabel();
			jLabelGoodsAbbreviation.setBounds(new java.awt.Rectangle(49,199,80,20));
			jLabelGoodsAbbreviation.setText("商品简拼");
			jLabelGoodsAlert = new JLabel();
			jLabelGoodsAlert
					.setBounds(new java.awt.Rectangle(300, 150, 80, 20));
			jLabelGoodsAlert.setText("商品警报库存");
			jLabelGoodsStock = new JLabel();
			jLabelGoodsStock.setBounds(new java.awt.Rectangle(50, 150, 80, 20));
			jLabelGoodsStock.setText("商品库存量");
			jLabelGoodsSellPrice = new JLabel();
			jLabelGoodsSellPrice.setBounds(new java.awt.Rectangle(300, 90, 80,
					20));
			jLabelGoodsSellPrice.setText("商品零售价");
			jLabelGoodsCostPrice = new JLabel();
			jLabelGoodsCostPrice.setBounds(new java.awt.Rectangle(50, 90, 80,
					20));
			jLabelGoodsCostPrice.setText("商品成本价");
			jLabelGoodsUnit = new JLabel();
			jLabelGoodsUnit.setBounds(new java.awt.Rectangle(300, 30, 80, 20));
			jLabelGoodsUnit.setText("商品单位");
			jLabelGoodsName = new JLabel();
			jLabelGoodsName.setBounds(new java.awt.Rectangle(50, 30, 80, 20));
			jLabelGoodsName.setText("商品名称");
			jLabelAbbreviation = new JLabel();
			jLabelAbbreviation.setBounds(new java.awt.Rectangle(19, 280, 110,
					20));
			jLabelAbbreviation.setText("按商品简拼过滤");
			jPanelGoodsSetting = new JPanel();
			jPanelGoodsSetting.setLayout(null);
			jPanelGoodsSetting.add(jLabelAbbreviation, null);
			jPanelGoodsSetting.add(getJTextFieldgetAbbreviation(), null);
			jPanelGoodsSetting.add(getJScrollPaneGoodsSetting(), null);
			jPanelGoodsSetting.add(getJButtonAddGoods(), null);
			jPanelGoodsSetting.add(getJButtonMidifyGoods(), null);
			jPanelGoodsSetting.add(getJButtonDeleteGoods(), null);
			jPanelGoodsSetting.add(getJButtonResetGoods(), null);
			jPanelGoodsSetting.add(jLabelGoodsName, null);
			jPanelGoodsSetting.add(jLabelGoodsUnit, null);
			jPanelGoodsSetting.add(jLabelGoodsCostPrice, null);
			jPanelGoodsSetting.add(jLabelGoodsSellPrice, null);
			jPanelGoodsSetting.add(jLabelGoodsStock, null);
			jPanelGoodsSetting.add(jLabelGoodsAlert, null);
			jPanelGoodsSetting.add(jLabelGoodsAbbreviation, null);
			jPanelGoodsSetting.add(getJTextFieldgetGoodsName(), null);
			jPanelGoodsSetting.add(getJTextFieldgetGoodsUnit(), null);
			jPanelGoodsSetting.add(getJTextFieldgetGoodsCostPrice(), null);
			jPanelGoodsSetting.add(getJTextFieldgetGoodsSellPrice(), null);
			jPanelGoodsSetting.add(getJTextFieldgetGoodsStock(), null);
			jPanelGoodsSetting.add(getJTextFieldgetGoodsAlert(), null);
			jPanelGoodsSetting.add(getJTextFieldgetGoodsAbbreviation(), null);
			jPanelGoodsSetting.add(getJButtonGoodsSettingFlush(), null);
			jPanelGoodsSetting.add(jLabelgetGoodsName, null);
		}
		return jPanelGoodsSetting;
	}

    //构建通过商品简写过滤数据的方法
	private JTextField getJTextFieldgetAbbreviation() {
		if (jTextFieldgetAbbreviation == null) {
			jTextFieldgetAbbreviation = new JTextField();
			jTextFieldgetAbbreviation.setBounds(new java.awt.Rectangle(141,
					280, 120, 20));
			 DefaultTableModel model = (DefaultTableModel)
			 getJTableRoomSetting()
			 .getModel();
			 //循环删除数据的方法
			 int rows = model.getRowCount();
			 for (int i = rows - 1; i >= 0; i--) {
			 model.removeRow(i);
			 }
			 RoomSettingControl control = new RoomSettingControl();
			 Vector v = control
			 .getRoomStatementInfo(getJComboBoxRoomType()
			 .getSelectedItem().toString().trim());
			 Iterator iter = v.iterator();
			 while (iter.hasNext()) {
			 Room value = (Room) iter.next();
			 Object[] data = { value.getRoomNumber(),
			 value.getRoomType(),
			 String.valueOf(value.getRoomPrice()),
			 value.getRoomName(), value.getRoomStatement(),
			 String.valueOf(value.getRoomCapacity()),
			 String.valueOf(value.getConsumedId()) };
			 model.addRow(data);
			 }
			jTextFieldgetAbbreviation.addKeyListener(new KeyAdapter() {
				//构建一个接收鼠标键盘事件的监听接口
				public void keyReleased(KeyEvent e) {
					DefaultTableModel model = (DefaultTableModel) getJTableGoodsSetting()
							.getModel();
					int rows = model.getRowCount();
					//循环删除数据的方法
					for (int i = rows - 1; i >= 0; i--) {
						model.removeRow(i);
					}
					GoodsSettingControl control = new GoodsSettingControl();
					Vector v = control
							.getGoodsAbbreviationInfo(getJTextFieldgetAbbreviation()
									.getText().trim());
					Iterator iter = v.iterator();
					while (iter.hasNext()) {
						Goods value = (Goods) iter.next();
						Object[] data = { value.getGoodsName(),
								value.getGoodsUnit(),
								String.valueOf(value.getGoodsCostPrice()),
								String.valueOf(value.getGoodsSellPrice()),
								String.valueOf(value.getGoodsStock()),
								String.valueOf(value.getGoodsAlert()),
								value.getGoodsAbbreviation() };
						model.addRow(data);
					}
				}

			});

		}
		return jTextFieldgetAbbreviation;
	}

	/**
	 * This method initializes jScrollPaneGoodsSetting
	 * 
	 * @return javax.swing.JScrollPane
	 */
	private JScrollPane getJScrollPaneGoodsSetting() {
		if (jScrollPaneGoodsSetting == null) {
			jScrollPaneGoodsSetting = new JScrollPane();