Java源码社

基于java的Swing+MySQL进销存系统(java+gui)

更新于

运行环境

Java≥8、MySQL≥5.7

开发工具

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

适用

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

功能说明

070123042402

080123042402

100123042402

基于java的Swing+MySQL进销存系统(java+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
44
45
46
47
48
49
50
51
            }
            s.close();     // 释放Statement对象
            con.close();   // 关闭到MySQL服务器的连接
		}catch(SQLException sql_e) {     // 都是SQLExceptionss
            System.out.println("chuku2"+sql_e);
        }
	}
	
});

name.addActionListener(new ActionListener(){

	@Override
	public void actionPerformed(ActionEvent arg0) {
		// TODO Auto-generated method stub
		String select_lei=fenlei.getSelectedItem().toString();
		String select_name;
		if(name.getSelectedItem()!=null){
			select_name=name.getSelectedItem().toString();
			try {//插入
	            Connection con = DriverManager.getConnection(conURL, StartApplication.mysqlname, StartApplication.mysqlpassword);  // 连接数据库
	            Statement s = con.createStatement();  // Statement类用来提交SQL语句
	            String select="select num from goods where lei='"+select_lei+"' and name='"+select_name+"'"; 
	            ResultSet rs = s.executeQuery(select);  // 提交查询，返回的表格保存在rs中
	            while(rs.next()){
	            	lblNewLabel.setText(rs.getString("num"));
	            	break;
	            }
	            s.close();     // 释放Statement对象
	            con.close();   // 关闭到MySQL服务器的连接
			}catch(SQLException sql_e) {     // 都是SQLExceptionss
	            System.out.println("chuku3"+sql_e);
	        }
		}
		
	}
	
});
JLabel label_5 = new JLabel("\u98DF\u54C1\u540D\u79F0\uFF1A");
GridBagConstraints gbc_label_5 = new GridBagConstraints();
gbc_label_5.anchor = GridBagConstraints.EAST;
gbc_label_5.insets = new Insets(0, 0, 5, 5);
gbc_label_5.gridx = 3;
gbc_label_5.gridy = 0;
panel_2.add(label_5, gbc_label_5);



JLabel label_6 = new JLabel("\u5355\u4EF7\uFF1A");
GridBagConstraints gbc_label_6 = new GridBagConstraints();
gbc_label_6.anchor = GridBagConstraints.EAST;
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

public void init(){
	JPanel panel = new JPanel();
	panel.setBackground(Color.WHITE);
	panel.setBounds(39, 372, 568, 188);
	add(panel);
	panel.setLayout(null);
	panel.setVisible(false);
	panel.setBorder (BorderFactory.createTitledBorder ("添加员工"));
	
	JPanel panel1= new JPanel();
	panel1.setBounds(39, 372, 568, 188);
	add(panel1);
	panel1.setBackground(Color.WHITE);
	panel1.setLayout(null);
	panel1.setVisible(false);
	panel1.setBorder (BorderFactory.createTitledBorder ("修改员工"));
	
	JPanel panel2= new JPanel();
	panel2.setBounds(39, 372, 568, 188);
	add(panel2);
	panel2.setBackground(Color.WHITE);
	panel2.setLayout(null);
	panel2.setVisible(false);
	panel2.setBorder (BorderFactory.createTitledBorder ("查询员工 "));
	
	
	JLabel add_label = new JLabel("\u59D3\u540D\uFF1A");
	add_label.setFont(new Font("宋体", Font.PLAIN, 15));
	add_label.setBounds(19, 24, 71, 21);
	panel.add(add_label);
	
	add_name = new JTextField();
	add_name.setBounds(100, 24, 93, 21);
	panel.add(add_name);
	add_name.setColumns(10);
	
	JLabel add_label_1 = new JLabel("\u5BB6\u5EAD\u4F4F\u5740\uFF1A");
	add_label_1.setFont(new Font("宋体", Font.PLAIN, 15));
	add_label_1.setBounds(203, 100, 82, 30);
	panel.add(add_label_1);
	
	add_addr = new JTextField();
	add_addr.setBounds(282, 105, 262, 21);
	panel.add(add_addr);
	add_addr.setColumns(10);
	
	JLabel add_label_5 = new JLabel("\u51FA\u751F\u5E74\u6708\uFF1A");
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
				            	Vector<String> rowV = new Vector<String>();
				            	rowV.add(rs.getString("lei"));
				    			rowV.add(rs.getString("name"));
				    			rowV.add(rs.getString("tel"));
				    			tableValueV.add(rowV);
				    			System.out.println(rs.getString("lei"));
				    			
				            }
				            tableModel.setDataVector(tableValueV,columnNameV); 
			    			int  rowCount = table.getRowCount();   
			    			table.getSelectionModel().setSelectionInterval(rowCount-1 , rowCount- 1 );   
			    			Rectangle rect = table.getCellRect(rowCount-1 ,  0 ,  true );
			    			table.scrollRectToVisible(rect);  
				            s.close();     // 释放Statement对象
				            con.close();   // 关闭到MySQL服务器的连接
				            TableColumnModel   cm   =   table.getColumnModel(); 
				    		TableColumn   column  = cm.getColumn(0);//得到第i个列对象   
				    		  column.setPreferredWidth(140);//将此列的首选宽度设置为 preferredWidth。
				    		  TableColumn   column1  = cm.getColumn(1);//得到第i个列对象   
				    		  column1.setPreferredWidth(140);//将此列的首选宽度设置为 preferredWidth。
				    		  TableColumn   column2  = cm.getColumn(2);
				    		  column2.setPreferredWidth(140);
				    		  
				        }
				        catch(SQLException sql_e) {     // 都是SQLExceptionss
				            System.out.println(sql_e);
				        }
						
					}
					
				});
				panel2.add(canel);
				
				
				
				
			}
			
			
}

package messagejpanel;

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
	        textField2.setText(ob.toString());
	        textField3.setText(oc.toString());
	    }
	    else{
	    	textField1.setText("");  //给文本框赋值
	        textField2.setText("");
	        textField3.setText("");
	    }
	}

	@Override
	public void mouseEntered(MouseEvent arg0) {
		// TODO Auto-generated method stub
		
	}

	@Override
	public void mouseExited(MouseEvent arg0) {
		// TODO Auto-generated method stub
		
	}

	@Override
	public void mousePressed(MouseEvent arg0) {
		// TODO Auto-generated method stub
		
	}

	@Override
	public void mouseReleased(MouseEvent arg0) {
		// TODO Auto-generated method stub
		
	}
	
});

   
   
JButton btnNewButton = new JButton("\u4FEE\u6539");
btnNewButton.addActionListener(new ActionListener() {
	public void actionPerformed(ActionEvent arg0) {
		if(panel1.isVisible()==false){
			panel1.setVisible(true);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
			numberAxis.setTickUnit(unit);
			
	}
}
package messagejpanel;








public class Dingdan_chaxun extends JPanel {
	private JTextField message;
	private JComboBox leixing;
	private JComboBox tiaojian;
	private JComboBox fangshi;
	private JTable table;
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
		        catch(ClassNotFoundException cnf_e) {  // 如果找不到驱动类
		            System.out.println("Driver Not Found: " + cnf_e);
		        }

		        boolean flag=false;
		        try {
		            Connection con = DriverManager.getConnection(conURL, "root", "");  // 连接数据库

		            Statement s = con.createStatement();  // Statement类用来提交SQL语句
		            Statement s1 = con.createStatement();  // Statement类用来提交SQL语句
	
		            ResultSet rs = s.executeQuery("select * from user");  // 提交查询，返回的表格保存在rs中

		            while(rs.next()) {  // ResultSet指针指向下一个“行”
		               if(a.equals(rs.getString("name"))){flag=true;break;}
		            }
		            
		            if(flag){
		            	JOptionPane.showMessageDialog(Test.frame, "该用户已存在","错误",2);
		            }
		            else{
		            	JOptionPane.showMessageDialog(Test.frame, a+"添加成功","用户添加成功",1);
		            	String insert = "insert into user(name,password) values('"+a+"','"+b+"')";  
						s1.executeUpdate(insert);
		            }
					
					
		            s.close();     // 释放Statement对象
		            con.close();   // 关闭到MySQL服务器的连接
		        }
		        catch(SQLException sql_e) {     // 都是SQLException
		            System.out.println(sql_e);
		        }
			}
		});
		btnNewButton.setBounds(81, 187, 93, 23);
		contentPane.add(btnNewButton);
		
		JButton btnNewButton_1 = new JButton("\u91CD\u7F6E");
		btnNewButton_1.setBounds(223, 187, 93, 23);
		contentPane.add(btnNewButton_1);*/
	}
}
package jframe;


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