systemsetting.java

一个KTV管理系统

			jScrollPaneGoodsSetting.setBounds(new java.awt.Rectangle(2, 309,
					542, 169));
			jScrollPaneGoodsSetting.setViewportView(getJTableGoodsSetting());
		}
		return jScrollPaneGoodsSetting;
	}

	//创建商品表
	private JTable getJTableGoodsSetting() {
		if (jTableGoodsSetting == null) {
			DefaultTableModel model = null;
			Object[][] p = null;
			String[] n = { "商品名称", "商品单位", "商品成本价", "商品零售价", "商品库存量", "商品警报库存",
					"商品简拼" };

			Object[][] date = {};

			model = new DefaultTableModel(date, n);
			jTableGoodsSetting = new JTable(model);
			jTableGoodsSetting.addMouseListener(new MouseAdapter() {
				//添加了一个鼠标点击事件
				public void mouseClicked(MouseEvent e) {
					String[] value = getGoodsJTableValue();
					getJTextFieldgetGoodsName().setText(value[0].trim());
					jLabelgetGoodsName.setText(value[0].trim());
					getJTextFieldgetGoodsUnit().setText(value[1].trim());
					getJTextFieldgetGoodsCostPrice().setText(value[2].trim());
					getJTextFieldgetGoodsSellPrice().setText(value[3].trim());
					getJTextFieldgetGoodsStock().setText(value[4].trim());
					getJTextFieldgetGoodsAlert().setText(value[5].trim());
					getJTextFieldgetGoodsAbbreviation()
							.setText(value[6].trim());

				}
			});
			jTableGoodsSetting.setBounds(new java.awt.Rectangle(0, 0, 323, 80));
		}
		return jTableGoodsSetting;
	}

	//构造增加商品的方法
	private JButton getJButtonAddGoods() {
		if (jButtonAddGoods == null) {
			jButtonAddGoods = new JButton();
			jButtonAddGoods.setBounds(new java.awt.Rectangle(73,241,90,30));
			jButtonAddGoods.setText("增加商品");
			jButtonAddGoods.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					if (checkGoodsInputValue()) {
						Goods value;
						try {
							value = getGoodsInputValue();

							GoodsSettingControl control = new GoodsSettingControl();
							DefaultTableModel model = (DefaultTableModel) getJTableGoodsSetting()
									.getModel();

							if (control.insertGoodsInfo(value)) {
								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);
								JOptionPane.showMessageDialog(null, "数据插入成功",
										"插入提示", JOptionPane.YES_OPTION);

							}
						} catch (Exception e1) {
							// TODO Auto-generated catch block
							JOptionPane.showMessageDialog(null, "信息插入有误",
									"插入提示", JOptionPane.YES_OPTION);
						}
					}
				}
			});

		}
		return jButtonAddGoods;
	}

	//构造修改商品信息的方法
	private JButton getJButtonMidifyGoods() {
		if (jButtonMidifyGoods == null) {
			jButtonMidifyGoods = new JButton();
			jButtonMidifyGoods.setBounds(new java.awt.Rectangle(226,242,90,30));
			jButtonMidifyGoods.setText("修改商品");
			jButtonMidifyGoods.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					if (checkGoodsInputValue()) {
						if (jLabelgetGoodsName.getText().trim().equals(
								jTextFieldgetGoodsName.getText().trim())) {
							try {
								GoodsSettingControl control = new GoodsSettingControl();
								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);

								if (control.updateGoodsInfo(value)) {
									JOptionPane.showMessageDialog(null,
											"数据更改成功", "更改提示",
											JOptionPane.YES_OPTION);
								}
							} catch (Exception e1) {
								JOptionPane.showMessageDialog(null, "信息输入有误",
										"更改提示", JOptionPane.YES_OPTION);
								jTextFieldgetGoodsName
										.setText(jLabelgetGoodsName.getText()
												.trim());
							}
						} else {
							JOptionPane.showMessageDialog(null, "商品名称不能修改",
									"更改提示", JOptionPane.YES_OPTION);
							jTextFieldgetGoodsName.setText(jLabelgetGoodsName
									.getText().trim());
						}
					}
				}
			});
		}
		return jButtonMidifyGoods;
	}

	//构造删除商品的方法
	private JButton getJButtonDeleteGoods() {
		if (jButtonDeleteGoods == null) {
			jButtonDeleteGoods = new JButton();
			jButtonDeleteGoods.setBounds(new java.awt.Rectangle(394,240,90,30));
			jButtonDeleteGoods.setText("删除商品");
			jButtonDeleteGoods.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					try {
						if (!jLabelgetGoodsName.getText().equals("")) {
							DefaultTableModel model = (DefaultTableModel) getJTableGoodsSetting()
									.getModel();
							int row = getJTableGoodsSetting().getSelectedRow();
							GoodsSettingControl control = new GoodsSettingControl();
							String GoodsName = getJTableGoodsSetting()
									.getValueAt(row, 0).toString();

							if (control.deleteGoodsInfo(GoodsName)) {
								JOptionPane.showMessageDialog(null, "数据删除成功",
										"删除提示", JOptionPane.YES_OPTION);
								model.removeRow(row);
							}
						} else {
							JOptionPane.showMessageDialog(null, "请先选中您要删除的商品",
									"删除提示", JOptionPane.YES_OPTION);
						}
					} catch (Exception e1) {
						JOptionPane.showMessageDialog(null, "商品删除失败", "删除提示",
								JOptionPane.YES_OPTION);
					}
				}
			});
		}
		return jButtonDeleteGoods;
	}


	private JPanel getJPanelConsumedType() {
		if (jPanelConsumedType == null) {
			jLabelCosumedType = new JLabel();
			jLabelCosumedType.setBounds(new java.awt.Rectangle(36,209,106,20));
			jLabelCosumedType.setText("消费类型详细：");
			jLabelgetConsumedTypeName = new JLabel();
			jLabelgetConsumedTypeName.setBounds(new java.awt.Rectangle(158,29,100,20));
			jLabelgetConsumedTypeName.setText("");
			jLabelRebate = new JLabel();
			jLabelRebate.setBounds(new java.awt.Rectangle(47,73,80,20));
			jLabelRebate.setText("打折比率");
			jLabelConsumedTypeName = new JLabel();
			jLabelConsumedTypeName.setBounds(new java.awt.Rectangle(46,30,86,20));
			jLabelConsumedTypeName.setText("消费类型名称");
			jPanelConsumedType = new JPanel();
			jPanelConsumedType.setLayout(null);
			jPanelConsumedType.add(getJScrollPaneConsumedType(), null);
			jPanelConsumedType.add(getJButtonAddConsumedType(), null);
			jPanelConsumedType.add(getJButtonModifyConsumedType(), null);
			jPanelConsumedType.add(getJButtonDeleteConsumedType(), null);
			jPanelConsumedType.add(getJButtonResetConsumedType(), null);
			jPanelConsumedType.add(jLabelConsumedTypeName, null);
			jPanelConsumedType.add(jLabelRebate, null);
			jPanelConsumedType.add(getJTextFieldgetConsumedTypeName(), null);
			jPanelConsumedType.add(getJTextFieldgetRebate(), null);
			jPanelConsumedType.add(getJButtonMofifyConsumedFlush(), null);
			jPanelConsumedType.add(jLabelgetConsumedTypeName, null);
			jPanelConsumedType.add(jLabelCosumedType, null);
		}
		return jPanelConsumedType;
	}

	/**
	 * This method initializes jScrollPaneConsumedType
	 * 
	 * @return javax.swing.JScrollPane
	 */
	private JScrollPane getJScrollPaneConsumedType() {
		if (jScrollPaneConsumedType == null) {
			jScrollPaneConsumedType = new JScrollPane();
			jScrollPaneConsumedType.setBounds(new java.awt.Rectangle(2,241,542,235));

			jScrollPaneConsumedType.setViewportView(getJTableConsumedType());
		}
		return jScrollPaneConsumedType;
	}

	/**
	 * This method initializes jTableConsumedType
	 * 
	 * @return javax.swing.JTable
	 */
	//创建消费类型表
	private JTable getJTableConsumedType() {
		if (jTableConsumedType == null) {
			DefaultTableModel model = null;
			Object[][] p = null;
			String[] n = { "消费类型名称", "打折比率" };

			Object[][] date = {};

			model = new DefaultTableModel(date, n);
			jTableConsumedType = new JTable(model);
			jTableConsumedType.addMouseListener(new MouseAdapter() {
				//构造鼠标点击事件
				public void mouseClicked(MouseEvent e) {
					String[] value = getConsumedTypeJTableValue();
					getJTextFieldgetConsumedTypeName().setText(value[0].trim());
					jLabelgetConsumedTypeName.setText(value[0].trim());
					System.out.println(jLabelgetRoomNumber.getText());
					getJTextFieldgetRebate().setText(value[1].trim());

				}
			});
		}
		return jTableConsumedType;
	}

	//构造添加消费类型的方法
	private JButton getJButtonAddConsumedType() {
		if (jButtonAddConsumedType == null) {
			jButtonAddConsumedType = new JButton();
			jButtonAddConsumedType.setBounds(new java.awt.Rectangle(43,135,90,47));
			jButtonAddConsumedType.setText("增加类型");
			jButtonAddConsumedType.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					if (checkConsumedTypeInputValue()) {
						ConsumedTypeInfo value;
						try {
							value = getConsumedTypeInputValue();

							ConsumedTypeSettingControl control = new ConsumedTypeSettingControl();
							DefaultTableModel model = (DefaultTableModel) getJTableConsumedType()
									.getModel();
							//从控制层调DAO层的添加消费类型的方法

							if (control.insertConsumedTypeInfo(value)) {
								Object[] data = {
										value.getConsumedTypeName().trim(),
										String.valueOf(value.getRebate())
												.trim() };
								model.addRow(data);
								JOptionPane.showMessageDialog(null, "数据插入成功",
										"插入提示", JOptionPane.YES_OPTION);

							}
						} catch (Exception e1) {
							JOptionPane.showMessageDialog(null, "信息输入有误",
									"插入提示", JOptionPane.YES_OPTION);

						}
					}
				}
			});
		}
		return jButtonAddConsumedType;
	}

	//构造修改消费类型的方法
	private JButton getJButtonModifyConsumedType() {
		if (jButtonModifyConsumedType == null) {
			jButtonModifyConsumedType = new JButton();
			jButtonModifyConsumedType.setBounds(new java.awt.Rectangle(196,134,90,45));
			jButtonModifyConsumedType.setText("修改类型");
			jButtonModifyConsumedType.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					try {
						if (checkConsumedTypeInputValue()) {
							if(jLabelgetConsumedTypeName.getText().trim()
									.equals(
											jTextFieldgetConsumedTypeName
													.getText().trim())) {
								ConsumedTypeSettingControl control = new ConsumedTypeSettingControl();
								String consumedTypeName = getJTextFieldgetConsumedTypeName()
										.getText().trim();

								double rebate = Double
										.parseDouble(getJTextFieldgetRebate()
												.getText());

								ConsumedTypeInfo value = new ConsumedTypeInfo(
										consumedTypeName, rebate);

								if (control.updateConsumedTypeInfo(value)) {
									JOptionPane.showMessageDialog(null,
											"数据更改成功", "更改提示",
											JOptionPane.YES_OPTION);
								}
							} else {
								JOptionPane.showMessageDialog(null, "消费类型不能修改",
										"更改提示", JOptionPane.YES_OPTION);
								jTextFieldgetConsumedTypeName
										.setText(jLabelgetConsumedTypeName
												.getText().trim());
							}
						}
					} catch (Exception e1) {
						JOptionPane.showMessageDialog(null, "信息输入有误", "更改提示",
								JOptionPane.YES_OPTION);
						jTextFieldgetGoodsName.setText(jLabelgetGoodsName
								.getText().trim());
					}
				}
			});
		}
		return jButtonModifyConsumedType;
	}

	
    //构造删除消费类型的方法
	private JButton getJButtonDeleteConsumedType() {
		if (jButtonDeleteConsumedType == null) {
			jButtonDeleteConsumedType = new JButton();
			jButtonDeleteConsumedType.setBounds(new java.awt.Rectangle(347,134,90,46));
			jButtonDeleteConsumedType.setText("删除类型");
			jButtonDeleteConsumedType.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					try {
						if (!jLabelgetConsumedTypeName.getText().equals("")) {