Java源码社

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

更新于

运行环境

Java≥8、MySQL≥5.7

开发工具

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

适用

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

功能说明

390123062402

400123062402

410123062402

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

功能介绍：用户管理、药品库存管理、进销管理、营销管理、药品购入、药品售出、药市信息

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

private JLabel medicinelogindateJLabel = new JLabel("登记日期：  ");
private JTextField medicinelogindateJTexFed = new JTextField();
private JPanel bottomAllJpane = new JPanel(){
	public void paintComponent(Graphics g) {  
        super.paintComponent(g);  
        ImageIcon icon;  
	    Image img; 
		icon = new ImageIcon("E:\\图片册\\puu.jpg");// 背景图片 
		img = icon.getImage();
        g.drawImage(img, 0, 0,this.getWidth(), this.getHeight(), this);
        } 
};

private JPanel bottonPageJpanel = new JPanel(){
	public void paintComponent(Graphics g) {  
        super.paintComponent(g);  
        ImageIcon icon;  
	    Image img; 
		icon = new ImageIcon("E:\\图片册\\puu.jpg");// 背景图片 
		img = icon.getImage();
        g.drawImage(img, 0, 0,this.getWidth(), this.getHeight(), this);
        } 
};
private JPanel southJpanel;
private JButton cancelBtn;
private JButton confirmBtn;

public MarketOutRecords(MarketView arel) {
	this.arel = arel;
	setTitle("售货记录");

	buildUi();

	setSize(400, 270);
	setLocationRelativeTo(null);
	setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	setVisible(true);
}
public void buildUi() {
	setLayout(new BorderLayout(20, 20));
	centerJpanel.setPreferredSize(new Dimension(400,170));
	centerJpanel.setLayout(new GridLayout(3, 2));
	
	
	centerJpanel.add(medicineIdJLabel);
	medicineIdJLabel.setFont(new Font("Dialog",1,15));
	centerJpanel.add(medicineIdJTexFed);
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

}

/**
 * 查找所有员工
 *
 * @return
 * @throws SQLException
 */
private ArrayList<Object[]> getEmployeesByDb(int begin, int size) throws SQLException {
    ArrayList<Object[]> employeeslist = new ArrayList<Object[]>();
    // 查询sql语句
    String sql = "select * from EmployeeInfo limit " + begin + "," + size + "";
    // 查询数据
    ResultSet result = new SqlHelper().query(sql, new String[]{});
    if (result != null) {
        while (result.next()) {
            Object rows[] = new Object[6];
            rows[0] = result.getString(1);
            rows[1] = result.getString(3);
            rows[2] = result.getString(4).equals("0") ? "女" : "男";
            rows[3] = result.getString(5);
            rows[4] = result.getString(6);
            rows[5] = result.getString(7).equals("0") ? "普通员工" : "管理员";
            employeeslist.add(rows);
        }

    } else {
        JOptionPane.showConfirmDialog(null, "没有查询到员工", "提示", JOptionPane.WARNING_MESSAGE);

    }
    return employeeslist;
}

private int getDataCount() throws SQLException {
    int count = 0;
    String sql = "select count(*) as count from EmployeeInfo";
    // 查询数据
    ResultSet result = new SqlHelper().query(sql, new String[]{});
    if (result != null && result.next()) {
        count = result.getInt(1);

    }
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
				if(selectIndex == -1){
					JOptionPane.showConfirmDialog(null, "请先选中一行","提示",JOptionPane.WARNING_MESSAGE);
					
				}else{
					Object[] row = datas.get(selectIndex);
					String eid = (String) row[0];
					deleteRecordsById(eid);
				}
					
			}
			private void deleteRecordsById(String mrid){
				String sql = "delete from marketrecords where mrid='"+mrid+"';";
				boolean result = new SqlHelper().update(sql, new String[]{});
				if (result) {
					refreshJTable();
				}else{
					JOptionPane.showConfirmDialog(null, "移除失败!","提示",JOptionPane.WARNING_MESSAGE);
					
				}
			
			}
	}

	

package com.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
50

public class RegiestView extends JFrame {

	private JPanel centerJpanel = new JPanel(){
		public void paintComponent(Graphics g){
			super.paintComponent(g);
			ImageIcon icon=new ImageIcon("E:\\图片册\\pu.jpg");
			int width=centerJpanel.getWidth();
			int heigh=centerJpanel.getHeight();
			g.drawImage(icon.getImage(), 0, 0, width,heigh,null);
		}
	};

	private JLabel userIdJLabel = new JLabel("用户号");
	private JTextField userIdJTexFed = new JTextField();

	private JLabel passwordJLabel = new JLabel("密码");
	private JTextField passwordJTexFed = new JTextField();;

	private JLabel userNameJLabel = new JLabel("姓名");
	private JTextField userNameJTexFed = new JTextField();;

	private JLabel sexJLabel = new JLabel("性别");
	private String sexvalue[] = { "女", "男" };
	private JComboBox sexJcomBox = new JComboBox(sexvalue);

	
	private JLabel ageJLabel = new JLabel("年龄");
	private JTextField ageJTexFed = new JTextField();;

	private JLabel isAdminJLabel = new JLabel("是否管理员");
	
	private String isAdminvalue[] = { "普通用户", "管理员" };
	private JComboBox isAdminJcomBox = new JComboBox(isAdminvalue);

	
	private JPanel southJpanel;
	private JButton cancelBtn;
	private JButton regiestBtn;
	
	public RegiestView() {
		setTitle("注册界面");
		buildUi();

		setSize(400, 300);
		setLocationRelativeTo(null);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		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
39
40
41
42
43
44
45
46
47
		img = icon.getImage();
        //下面这行是为了背景图片可以跟随窗口自行调整大小，可以自己设置成固定大小  
        g.drawImage(img, 0, 0,this.getWidth(), this.getHeight(), this);
        } 
};
//实例化用户名密码控件
label1=new JLabel("用户：");
label1.setFont(new Font("Dialog",1,15));
userName = new JTextField(24);
label2=new JLabel("密码：");
label2.setFont(new Font("Dialog",1,15));
password = new JPasswordField(24);

//添加用户名密码控件到 中间容器中
centerJpanel.add(label1);
centerJpanel.add(userName);
centerJpanel.add(label2);
centerJpanel.add(password);
centerJpanel.setBackground(null);
//实列化欢迎字，并添加到根容器的北边

JLabel label3 = new JLabel("药品管理系统");
label3.setHorizontalAlignment(JLabel.CENTER);
label3.setFont(new Font("Dialog",1,20));
label3.setForeground(Color.green);
label3.setBackground(Color.white);
bgPanel.add(label3,BorderLayout.NORTH);
//添加中间容器到根容器的中间
bgPanel.add(centerJpanel,BorderLayout.CENTER);


southJpanel = new JPanel();
southJpanel.setBackground(Color.white);
regiestBtn = new JButton("注册");
regiestBtn.setBackground(Color.lightGray);
regiestBtn.setSize(100, 60);
southJpanel.add(regiestBtn);
southJpanel.setBackground(Color.white);
regiestBtn.addActionListener(new ActionListener() {
	
	@Override
	public void actionPerformed(ActionEvent e) {
		new RegiestView();
		
	}
});

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
			
			if(selectIndex == -1){
				JOptionPane.showConfirmDialog(null, "请先选中一行","提示",JOptionPane.WARNING_MESSAGE);
				
			}else{
				Object[] row = datas.get(selectIndex);
				String eid = (String) row[0];
				deleteMedicineById(eid);
			}
				
		}
		private void deleteMedicineById(String meid){
			String sql = "delete from medicine where meid='"+meid+"';";
			boolean result = new SqlHelper().update(sql, new String[]{});
			if (result) {
				refreshJTable();
			}else{
				JOptionPane.showConfirmDialog(null, "移除失败!","提示",JOptionPane.WARNING_MESSAGE);
				
			}
		
		}
}
package com.view;




public class MarketView extends JPanel {

    private DefaultTableModel dtm2 = new DefaultTableModel();
    private DefaultTableModel dtm3 = new DefaultTableModel();
    private JTable empelJtable = new JTable(dtm2);
    private JTable mempelJtable = new JTable(dtm3);
    private JPanel bottomAllJpane = new JPanel();

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