Java源码社

基于java的Swing+Java+MySQL商品管理系统(java+swing+mysql+gui)

更新于

运行环境

Java≥8、MySQL≥5.7

开发工具

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

适用

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

功能说明

商品信息管理，简单的增删改查

120123082502

130123082502

140123082502

150123082502

160123082502

170123082502

090123082502

100123082502

技术框架

Java Swing MySQL

基于java的Swing+Java+MySQL商品管理系统(java+swing+mysql+gui)

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
private JButton button;
private JButton button_1;

int goodsid;

public GoodsXG(Goods goods) {
	super("商品管理系统");
	this.setBounds(0, 0, 400, 450);
	this.setLocationRelativeTo(null);//让窗口在屏幕中间显示
	this.setResizable(false);//让窗口大小不可改变
	getContentPane().setLayout(null);
	
	JLabel label = new JLabel("商品编号：");
	label.setBounds(85, 89, 87, 22);
	getContentPane().add(label);
	
	id = new JTextField();
	id.setBounds(147, 90, 142, 21);
	getContentPane().add(id);
	id.setColumns(10);
	
	JLabel label_1 = new JLabel("商品名称");
	label_1.setBounds(85, 139, 87, 22);
	getContentPane().add(label_1);
	
	name = new JTextField();
	name.setColumns(10);
	name.setBounds(147, 140, 142, 21);
	getContentPane().add(name);
	
	JLabel label_2 = new JLabel("数量：");
	label_2.setBounds(85, 193, 87, 22);
	getContentPane().add(label_2);
	
	num = new JTextField();
	num.setColumns(10);
	num.setBounds(147, 194, 142, 21);
	getContentPane().add(num);
	
	JLabel label_3 = new JLabel("单价：");
	label_3.setBounds(85, 241, 87, 22);
	getContentPane().add(label_3);
	
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
	this.setResizable(false);//让窗口大小不可改变
	this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);//用户单击窗口的关闭按钮时程序执行的操作
	getContentPane().setLayout(null);
	
	JLabel label = new JLabel("请输入商品名称：");
	label.setBounds(151, 39, 112, 32);
	getContentPane().add(label);
	
	textField = new JTextField();
	textField.setBounds(263, 43, 127, 26);
	getContentPane().add(textField);
	textField.setColumns(10);
	
	JButton button = new JButton("查询");
	button.addActionListener(new ActionListener() {
		public void actionPerformed(ActionEvent arg0) {
			String sql = "SELECT goodsID,goodsname,num,price FROM goods WHERE goodsname LIKE '%"+textField.getText()+"%'";
			Object[][] data = Select.getGoods(sql);
			df.setDataVector(data, header);
		}
	});
	button.setBounds(411, 40, 90, 30);
	getContentPane().add(button);
	
	JButton button_1 = new JButton("添加");
	button_1.setBounds(559, 140, 90, 30);
	getContentPane().add(button_1);
	button_1.addActionListener(new ActionListener() {
		public void actionPerformed(ActionEvent arg0) {
			GoodsManage t = new GoodsManage();
			t.setVisible(true);
			dispose();
		}
	});
	
	JTable jTable = new JTable(df);
	JScrollPane jsp=new JScrollPane(jTable,v,h);
	jsp.setBounds(44, 103, 480, 282);
	getContentPane().add(jsp);
	
}
public static void main(String[] args) {
	GoodsManagement t = new GoodsManagement();
	t.setVisible(true);
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
        }
    }
}
package com.demo.view;
 
 
 
public class GoodsManagement extends JFrame {
 
	Select select = new Select();
	
	private JTextField textField;
	
	Object[] header= {"商品编号","商品名称","数量","单价"};
	String sql = "SELECT goodsID,goodsname,num,price FROM goods";
	Object[][] data= select.getGoods(sql);
	DefaultTableModel df = new DefaultTableModel(data, header);
	int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
	int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
	
	public GoodsManagement() {
		super("商品管理系统");
		this.setBounds(0, 0, 700, 450);
		this.setLocationRelativeTo(null);//让窗口在屏幕中间显示
		this.setResizable(false);//让窗口大小不可改变
		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);//用户单击窗口的关闭按钮时程序执行的操作
		getContentPane().setLayout(null);
		
		JLabel label = new JLabel("请输入商品名称：");
		label.setBounds(151, 39, 112, 32);
		getContentPane().add(label);
		
		textField = new JTextField();
		textField.setBounds(263, 43, 127, 26);
		getContentPane().add(textField);
		textField.setColumns(10);
		
		JButton button = new JButton("查询");
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
});
 
button_1.setBounds(535, 80, 127, 30);
getContentPane().add(button_1);

JButton button_2 = new JButton("修改商品");
button_2.setBounds(535, 140, 127, 30);
getContentPane().add(button_2);
button_2.addActionListener(new ActionListener() {
	@Override
	public void actionPerformed(ActionEvent e) {
		if (jTable.getSelectedColumn()<0) {
			JOptionPane.showMessageDialog(null, "请选择要修改的数据！");
		} else {
			int goodsID = Integer.parseInt(jTable.getValueAt(jTable.getSelectedRow(), 0).toString());
			String name = jTable.getValueAt(jTable.getSelectedRow(), 1).toString();
			int num = Integer.parseInt(jTable.getValueAt(jTable.getSelectedRow(), 2).toString());
			String price = jTable.getValueAt(jTable.getSelectedRow(), 3).toString();
			Goods goods = new Goods(goodsID,name,num,price);
			GoodsXG goodsXG = new GoodsXG(goods);
			goodsXG.setVisible(true);
		}
		
	}
});

JButton button_3 = new JButton("删除商品");
button_3.setBounds(535, 200, 127, 30);
getContentPane().add(button_3);
button_3.addActionListener(new ActionListener() {
	@Override
	public void actionPerformed(ActionEvent e) {
		if (jTable.getSelectedColumn()<0) {
			JOptionPane.showMessageDialog(null, "请选中要删除的数据！");
		} else {
			int goodsID = Integer.parseInt(jTable.getValueAt(jTable.getSelectedRow(), 0).toString());
			String sql="delete from goods where goodsid="+goodsID;
			int result = updata.addData(sql);
			if (result>0) {
				JOptionPane.showMessageDialog(null, "删除成功！");
				JOptionPane.showMessageDialog(null, "记得刷新一下哦！");
			} else {
				JOptionPane.showMessageDialog(null, "删除失败！");
			}
		}
	}
});

JButton button_4 = new JButton("添加商品");
button_4.setBounds(535, 258, 127, 30);
getContentPane().add(button_4);
button_4.addActionListener(new ActionListener() {
	public void actionPerformed(ActionEvent arg0) {
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
				String addPrice = price.getText();
				if (addName.equals("")||addName.equals("")||addNum.equals("")||addPrice.equals("")) {
					JOptionPane.showMessageDialog(null, "请完整输入要修改的数据");
				} else {
					String sql="UPDATE goods SET "+"Goodsid='"+addId+"',Goodsname='"+addName+"',num='"+addNum+"',price='"+addPrice+"'where goodsid="+goodsid;
					int result = Updata.addData(sql);
					if (result>0) {
						JOptionPane.showMessageDialog(null, "修改成功！");
		                JOptionPane.showMessageDialog(null, "记得刷新一下哦！");
						dispose();
//						GoodsManage i = new GoodsManage();
//						i.setVisible(true);
					} else {
						JOptionPane.showMessageDialog(null, "修改失败！");
					}
				}
 
			}
		});
		
		button_1 = new JButton("取消");
		button_1.setBounds(208, 317, 93, 23);
		getContentPane().add(button_1);
		button_1.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				dispose();
			}
		});
		
	}
	public static void main(String[] args) {
		GoodsXG g = new GoodsXG(null);
		g.setVisible(true);
	}
}
package com.demo.view;
 

 
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
	public void actionPerformed(ActionEvent e) {
		if (jTable.getSelectedColumn()<0) {
			JOptionPane.showMessageDialog(null, "请选中要删除的数据！");
		} else {
			int goodsID = Integer.parseInt(jTable.getValueAt(jTable.getSelectedRow(), 0).toString());
			String sql="delete from goods where goodsid="+goodsID;
			int result = updata.addData(sql);
			if (result>0) {
				JOptionPane.showMessageDialog(null, "删除成功！");
				JOptionPane.showMessageDialog(null, "记得刷新一下哦！");
			} else {
				JOptionPane.showMessageDialog(null, "删除失败！");
			}
		}
	}
});

JButton button_4 = new JButton("添加商品");
button_4.setBounds(535, 258, 127, 30);
getContentPane().add(button_4);
button_4.addActionListener(new ActionListener() {
	public void actionPerformed(ActionEvent arg0) {
		GoodsADD goodsAdd = new GoodsADD();
		goodsAdd.setVisible(true);
	}
});

JLabel label = new JLabel("商品编号：");
label.setBounds(40, 354, 112, 32);
getContentPane().add(label);

textField = new JTextField();
textField.setBounds(154, 358, 127, 26);
getContentPane().add(textField);
textField.setColumns(10);

JButton button = new JButton("按编号查询");
button.addActionListener(new ActionListener() {
	public void actionPerformed(ActionEvent arg0) {
		String sql = "SELECT goodsID,goodsname,num,price FROM goods WHERE goodsid LIKE '%"+textField.getText()+"%'";
		Object[][] data = Select.getGoods(sql);
		df.setDataVector(data, header);
	}
});
button.setBounds(305, 355, 112, 30);
getContentPane().add(button);

this.addWindowListener(new WindowAdapter() {

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