Java源码社

基于java的Swing+MySQL花店鲜花销售信息管理系统进销存(java+swing+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

281623222808

291623222808

301623222808

311623222808

基于java的Swing+MySQL花店鲜花销售信息管理系统进销存(java+swing+mysql)

管理员
admin 123456

普通员工
user 123456

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
	backgroundPanel.validate();
}

// 下拉框改变事件
@Override
public void actionPerformed(ActionEvent e) {
	if (e.getSource() == select_category) {
		refreshTablePanel();
	} else if (e.getSource() == select_warehouse) {
		refreshTablePanel();
	}

}

// 鼠标点击事件
@Override
public void mouseClicked(MouseEvent e) {
	if (e.getSource() == tool_add) {
		new AddStockInputJFrame(user, this);
	} else if (e.getSource() == tool_modify) {
		int row = table.getSelectedRow();
		if (row < 0) {
			JOptionPane.showMessageDialog(null, "请选择入库单");
		} else {
			new ModifyStockInputJFrame(this, table, row);
		}

	} else if (e.getSource() == tool_delete) {
		int row = table.getSelectedRow();
		if (row < 0) {
			JOptionPane.showMessageDialog(null, "请选择入库单");
		} else {
			String id = (String) table.getValueAt(row, 0);
			int result = JOptionPane.showConfirmDialog(null, "是否确定删除？", "用户提示", JOptionPane.YES_NO_OPTION);
			if (result == 0) {
				String[] params = { id };
				StockOrderServiceImpl stockOrderService = new StockOrderServiceImpl();
				try {
					int tempresult = stockOrderService.deleteStockInputById(params);
					if (tempresult > 0) {
						JOptionPane.showMessageDialog(null, "入库单删除成功！");
						refreshTablePanel();
					}
				} catch (Exception e1) {
					e1.printStackTrace();
				}
			}
		}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
	if (!name.isEmpty()) {
		sqlBuilder.append(" and g.name like '%" + paraArray[0] + "%' ");
	}
	if (!"全部".equals(paraArray[1])) {
		sqlBuilder.append(" and s.category_id='" + paraArray[1] + "' ");
	}
	if (!"全部".equals(paraArray[2])) {
		sqlBuilder.append(" and s.warehouse_id='" + paraArray[2] + "' ");
	}
	if (!"全部".equals(paraArray[3])) {
		sqlBuilder.append(" and s.handler_id='" + paraArray[3] + "' ");
	}
	String sql = sqlBuilder.toString();
	List<Object[]> list = dao.select(sql, 9, null);
	if (!list.isEmpty()) {
		for (Object[] object : list) {
			Vector temp = new Vector<String>();
			for (int i = 0; i < object.length; i++) {
				temp.add(object[i]);
			}
			rows.add(temp);
		}
	}

	return rows;
}

//通过id逻辑删除出库单
@Override
public int deleteStockOutputById(Object[] paraArray) throws Exception {
	BaseDaoImpl dao = new BaseDaoImpl();
	int result = 0;
	result = dao.update("update stock_order set del_flag='1' where id=?", paraArray);
	return result;
}

//通过id修改出库单
@Override
public int updateStockOutputById(Object[] paraArray) throws Exception {
	BaseDaoImpl dao = new BaseDaoImpl();
	int result = 0;
	result = dao.update("update stock_order set amount=? where id=?", paraArray);
	return result;
}

//插入出库单
@Override
public int insertStockOutput(Object[] paraArray) throws Exception {
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
	JLabel title = new JLabel("商品信息");
	title.setFont(MyFont.Static);

	labelPanel.add(title);
}

// 初始化商品信息面板
public void initContentPanel() {
	contentPanel = new JPanel(new GridLayout(6, 2));

	label_name = new JLabel("商品名称", JLabel.CENTER);
	label_price = new JLabel("商品价格", JLabel.CENTER);
	label_origin = new JLabel("商品产地", JLabel.CENTER);
	label_stock = new JLabel("商品库存", JLabel.CENTER);
	label_warehouse = new JLabel("所属仓库", JLabel.CENTER);
	label_category = new JLabel("所属分类", JLabel.CENTER);

	name = new JTextField("");
	price = new JTextField("");
	origin = new JTextField("");
	stock = new JTextField("");

	// 商品种类下拉框
	category = new JComboBox();
	CategoryServiceImpl categoryService = new CategoryServiceImpl();
	List<Object[]> list_category = null;
	try {
		list_category = categoryService.selectAll();
	} catch (Exception e) {
		e.printStackTrace();
	}
	if (list_category != null) {
		int sign = 0;
		for (int i = 0; i < list_category.size(); i++) {
			String id = (String) list_category.get(i)[0];
			String name = (String) list_category.get(i)[1];
			category.addItem(new Item(id, name));
		}
	}

	// 仓库下拉框
	warehouse = new JComboBox();
	WarehouseServiceImpl warehouseService = new WarehouseServiceImpl();
	List<Object[]> list_warehouse = null;
	try {
		list_warehouse = warehouseService.selectAll();
	} catch (Exception e) {
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54

// 初始化商品信息面板
public void initContentPanel() {
	contentPanel = new JPanel(new GridLayout(4, 2));

	label_name = new JLabel("商品名称", JLabel.CENTER);
	label_amount = new JLabel("入库数量", JLabel.CENTER);
	label_category = new JLabel("所属分类", JLabel.CENTER);
	label_warehouse = new JLabel("所属仓库", JLabel.CENTER);

	// 商品名称下拉框
	select_name = new JComboBox();
	GoodsServiceImpl goodsService = new GoodsServiceImpl();
	List<Object[]> list_goods = new ArrayList();
	try {
		list_goods = goodsService.selectAll();
	} catch (Exception e) {
		e.printStackTrace();
	}
	select_name.addItem(new Item("请选择", "请选择"));
	if (!list_goods.isEmpty()) {
		int sign = 0;
		for (Object[] object : list_goods) {

			select_name.addItem(new Item((String) object[0], (String) object[1]));
		}
	}
	select_name.addActionListener(this);

	amount = new JTextField("");
	select_category = new JComboBox();
	select_category.setEnabled(false);
	select_warehouse = new JComboBox();
	select_warehouse.setEnabled(false);

	contentPanel.add(label_name);
	contentPanel.add(select_name);
	contentPanel.add(label_amount);
	contentPanel.add(amount);
	contentPanel.add(label_category);
	contentPanel.add(select_category);
	contentPanel.add(label_warehouse);
	contentPanel.add(select_warehouse);

}

// 初始化按钮面板
public void initButtonPanel() {
	buttonPanel = new JPanel();

	button_add = new JButton("保存");
	button_add.setUI(new BEButtonUI().setNormalColor(BEButtonUI.NormalColor.lightBlue));
	button_add.setForeground(Color.white);
	button_add.setFont(MyFont.Static);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
		for (int i = 0; i < list_warehouse.size(); i++) {
			String id = (String) list_warehouse.get(i)[0];
			String name = (String) list_warehouse.get(i)[1];
			warehouse.addItem(new Item(id, name));
		}
	}

	contentPanel.add(label_name);
	contentPanel.add(name);
	contentPanel.add(label_price);
	contentPanel.add(price);
	contentPanel.add(label_origin);
	contentPanel.add(origin);
	contentPanel.add(label_stock);
	contentPanel.add(stock);
	contentPanel.add(label_category);
	contentPanel.add(category);
	contentPanel.add(label_warehouse);
	contentPanel.add(warehouse);

}

// 初始化按钮面板
public void initButtonPanel() {
	buttonPanel = new JPanel();

	button_add = new JButton("保存");
	button_add.setUI(new BEButtonUI().setNormalColor(BEButtonUI.NormalColor.lightBlue));
	button_add.setForeground(Color.white);
	button_add.setFont(MyFont.Static);
	button_add.addMouseListener(this);

	buttonPanel.add(button_add);
}

// 鼠标点击事件
@Override
public void mouseClicked(MouseEvent e) {
	if (e.getSource() == button_add) {

		String name_String = name.getText().trim();
		String price_String = price.getText().trim();
		String origin_String = origin.getText().trim();
		String stock_String = stock.getText().trim();

项目链接：
https://javayms.github.io?id=271623222808201cr
https://javayms.pages.dev?id=271623222808201cr