药店管理系统的设计与实现

1. 药店管理系统的设计与实现
   打开系统后为登录界面，用户输入账号密码后进入系统，系统分为管理员、药店销售员、药品采购员三类用户，不同类型用户显示界面不同。
   管理员功能：
   （1）库存管理：实现药品的增删改查，包括药品名称、规格、进货单价、销售单价、药品数量、厂商；
   （2）销售管理：销售记录的增删改查，包括药品名称、销售价、销售时间、销售数量，如果是会员，自动积分；
   （3）顾客会员管理：会员信息的增删改查，包括会员号、会员积分等；
   （4）员工信息管理：员工信息增删改查，包括员工账号、账号类型、密码等；
   （5）个人账号设置：包括修改密码等；
   销售员功能：
   （1）销售管理：销售记录的增删改查，包括药品名称、销售价、销售时间、销售数量，如果是会员，自动积分；
   （2）顾客会员管理：会员信息的增删改查，包括会员号、会员积分等；
   （3）个人账号设置：包括修改密码等；
   药品采购员功能：
   （1）进货管理：药品增加，包括新进药品的名称、规格、进货单价、进货数量、厂商，如果新进药品信息与库存药品信息不同，则需分开保存；
   （2）个人账号设置：修改密码等。

系统主要功能如下图：
Mysql的表结构：

medic表

record表

role表

user表

图片展示：

部分图片，请笑纳

部分图片如上

本项目使用了Github开源的swing主题WEBLAF，异步加载的话登录界面主题会乱掉，所以没有异步加载，需要先加载完主题才能显示出登陆界面，运行后需要等一两秒出现

代码：

WindowsMain.java

package top.lemenk.pm;
import javax.swing.*;
import javax.swing.table.AbstractTableModel;
import java.awt.*;
import java.awt.event.*;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Enumeration;
import java.util.HashMap;
import java.util.Map;
import java.util.Vector;
public class WindowsMain {private JFrame frame;private String userNow;public static void main(String[] args) {EventQueue.invokeLater(new Runnable() {@Overridepublic void run() {try {WindowsMain window = new WindowsMain();} catch (Exception e) {e.printStackTrace();}}});}private WindowsMain() {initialize();}private static void initialize() {JFrame frame = new JFrame("药店管理系统");frame.setBounds(100, 100, 800, 450);//窗口居中frame.setLocationRelativeTo(null);frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);frame.getContentPane().setLayout(null);frame.setVisible(true);//添加窗口组件JLabel label = new JLabel("欢迎进入药店管理系统！");JLabel labUsername = new JLabel("用户名");JLabel labPassword = new JLabel("密码");JTextField username = new JTextField(20);JPasswordField password = new JPasswordField(20);JButton btn1 = new JButton("登录");JButton btn2 = new JButton("退出");frame.getContentPane().add(label);frame.getContentPane().add(labUsername);frame.getContentPane().add(labPassword);frame.getContentPane().add(username);frame.getContentPane().add(password);frame.getContentPane().add(btn1);frame.getContentPane().add(btn2);//设置组件属性label.setBounds(220, 40, 360, 75);labUsername.setBounds(260, 150, 60, 40);labPassword.setBounds(265, 220, 60, 40);username.setBounds(320, 150, 180, 40);password.setBounds(320, 220, 180, 40);btn1.setBounds(250, 290, 100, 30);btn2.setBounds(420, 290, 100, 30);//设置文字的字体及大小label.setFont(new Font("", Font.BOLD, 30));//设置按钮功能//登录btn1.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {//登陆验证if (username.getText().trim().length() == 0 || new String(password.getPassword()).trim().length() == 0) {JOptionPane.showMessageDialog(null, "用户名密码不允许为空");return;} else {String loginName = username.getText().trim();String loginPwd = new String(password.getPassword()).trim();//查询数据库Connection con = SqlOperation.getConnection();Statement statement = null;ResultSet rs = null;try {statement = con.createStatement();} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}String sql = null;//向表中传入数据sql = "SELECT * FROM user WHERE username=" + loginName + " AND password=" + loginPwd;try {assert statement != null;rs = statement.executeQuery(sql);while (rs.next()) {if (!rs.getString("id").equals(0)) {System.out.println("登陆成功");//查询用户类别，进入不同的页面String roleId = rs.getString("role_id");String username = rs.getString("username");System.out.println(roleId);checkUserRole(roleId, username);frame.dispose();} else {JOptionPane.showMessageDialog(null, "用户名或密码错误");}}} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}SqlOperation.release(statement, con);}}});//退出btn2.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {System.exit(0);}});}//主界面的方法private static void checkUserRole(String roleId, String username) {if (roleId.equals("1")) {//管理员System.out.println("管理员");JFrame amdin = new JFrame("药店管理系统-管理员");amdin.setBounds(100, 100, 800, 450);//窗口居中amdin.setLocationRelativeTo(null);amdin.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);amdin.getContentPane().setLayout(null);amdin.setVisible(true);//添加窗口组件JButton btn1 = new JButton("员工管理");JButton btn2 = new JButton("库存管理");JButton btn3 = new JButton("销售管理");JButton btn4 = new JButton("账号设置");amdin.getContentPane().add(btn1);amdin.getContentPane().add(btn2);amdin.getContentPane().add(btn3);amdin.getContentPane().add(btn4);btn1.setBounds(125, 30, 100, 40);btn2.setBounds(275, 30, 100, 40);btn3.setBounds(425, 30, 100, 40);btn4.setBounds(575, 30, 100, 40);//员工管理按钮事件btn1.addActionListener(new ActionListener() {//创建一个表单String columns[] = {"序号", "用户名", "密码", "姓名", "所属角色"};Object cells[][] = new Object[9][5];@Overridepublic void actionPerformed(ActionEvent e) {Connection con = SqlOperation.getConnection();Statement statement = null;ResultSet rs = null;try {statement = con.createStatement();} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}String sql = null;sql = "SELECT user.id,username,password,name,role_name FROM user INNER JOIN role ON user.role_id=role.id";try {int count = 0;rs = statement.executeQuery(sql);while (rs.next()) {cells[count][0] = rs.getString("id");cells[count][1] = rs.getString("username");cells[count][2] = rs.getString("password");cells[count][3] = rs.getString("name");cells[count][4] = rs.getString("role_name");count++;}String title = "用户信息表";FTable fTable = new FTable(cells, columns, title);} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}try {statement.executeQuery(sql);} catch (SQLException e1) {e1.printStackTrace();}SqlOperation.release(statement, con);}});//库存管理按钮事件btn2.addActionListener(new ActionListener() {//创建一个表单String columns[] = {"序号", "药品名", "进价", "售价", "数量", "生产厂商"};Object cells[][] = new Object[9][6];@Overridepublic void actionPerformed(ActionEvent e) {Connection con = SqlOperation.getConnection();Statement statement = null;ResultSet rs = null;try {statement = con.createStatement();} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}String sql = null;sql = "SELECT * FROM medic";try {int count = 0;rs = statement.executeQuery(sql);while (rs.next()) {cells[count][0] = rs.getString("id");cells[count][1] = rs.getString("medic_name");cells[count][2] = rs.getString("input_price");cells[count][3] = rs.getString("price");cells[count][4] = rs.getString("num");cells[count][5] = rs.getString("address");count++;}String title = "药品信息表";FTable fTable = new FTable(cells, columns, title);} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}try {statement.executeQuery(sql);} catch (SQLException e1) {e1.printStackTrace();}SqlOperation.release(statement, con);}});//销售管理按钮事件btn3.addActionListener(new ActionListener() {//创建一个表单String columns[] = {"序号", "药品名", "售价", "数量", "销售时间"};Object cells[][] = new Object[9][5];@Overridepublic void actionPerformed(ActionEvent e) {Connection con = SqlOperation.getConnection();Statement statement = null;ResultSet rs = null;try {statement = con.createStatement();} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}String sql = null;sql = "SELECT record.id,medic_name,price,num,time FROM record INNER JOIN medic ON record.medic_id=medic.id";try {int count = 0;rs = statement.executeQuery(sql);while (rs.next()) {cells[count][0] = rs.getString("id");cells[count][1] = rs.getString("medic_name");cells[count][2] = rs.getString("price");cells[count][3] = rs.getString("num");cells[count][4] = rs.getString("time");count++;}String title = "销售信息表";FTable fTable = new FTable(cells, columns, title);} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}try {statement.executeQuery(sql);} catch (SQLException e1) {e1.printStackTrace();}SqlOperation.release(statement, con);}});//用户管理按钮事件btn4.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {JLabel info = new JLabel("修改密码");JLabel labNewPwd = new JLabel("请输入新的密码：");JTextField newPwd = new JTextField(20);JButton btn = new JButton("确定修改");amdin.getContentPane().add(labNewPwd);amdin.getContentPane().add(info);amdin.getContentPane().add(newPwd);amdin.getContentPane().add(btn);info.setBounds(320, 90, 200, 75);labNewPwd.setBounds(250, 195, 150, 50);newPwd.setBounds(380, 200, 200, 40);btn.setBounds(350, 300, 100, 30);info.setFont(new Font("", Font.BOLD, 30));labNewPwd.setFont(new Font("", 0, 15));btn.addMouseListener(new MouseAdapter() {@Overridepublic void mouseClicked(MouseEvent e) {Connection con = SqlOperation.getConnection();Statement statement = null;ResultSet rs = null;String loginPwd = newPwd.getText().trim();try {statement = con.createStatement();} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}String sql = null;sql = "UPDATE user SET PASSWORD = " + loginPwd + " WHERE username = " + username;try {int a = statement.executeUpdate(sql);if (a == 1) {JOptionPane.showMessageDialog(null, "修改密码成功");info.setVisible(false);labNewPwd.setVisible(false);newPwd.setVisible(false);btn.setVisible(false);}} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}SqlOperation.release(statement, con);}});}});}//管理员else if (roleId.equals("2")) {//销售员方法System.out.println("销售员");JFrame sale = new JFrame("药店管理系统-销售员");sale.setBounds(100, 100, 800, 450);//窗口居中sale.setLocationRelativeTo(null);sale.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);sale.getContentPane().setLayout(null);sale.setVisible(true);//添加窗口组件JButton btn1 = new JButton("销售管理");JButton btn2 = new JButton("会员管理");JButton btn3 = new JButton("账号管理");sale.getContentPane().add(btn1);sale.getContentPane().add(btn2);sale.getContentPane().add(btn3);btn1.setBounds(160, 30, 100, 40);btn2.setBounds(320, 30, 100, 40);btn3.setBounds(480, 30, 100, 40);//销售管理按钮事件btn1.addActionListener(new ActionListener() {//创建一个表单String columns[] = {"序号", "药品名", "售价", "数量", "销售时间"};Object cells[][] = new Object[9][5];@Overridepublic void actionPerformed(ActionEvent e) {Connection con = SqlOperation.getConnection();Statement statement = null;ResultSet rs = null;try {statement = con.createStatement();} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}String sql = null;sql = "SELECT record.id,medic_name,price,num,time FROM record INNER JOIN medic ON record.medic_id=medic.id";try {int count = 0;rs = statement.executeQuery(sql);while (rs.next()) {cells[count][0] = rs.getString("id");cells[count][1] = rs.getString("medic_name");cells[count][2] = rs.getString("price");cells[count][3] = rs.getString("num");cells[count][4] = rs.getString("time");count++;}String title = "销售信息表";FTable fTable = new FTable(cells, columns, title);} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}try {statement.executeQuery(sql);} catch (SQLException e1) {e1.printStackTrace();}SqlOperation.release(statement, con);}});//会员管理按钮事件btn2.addActionListener(new ActionListener() {//创建一个表单String columns[] = {"序号", "用户名", "姓名", "所属角色"};Object cells[][] = new Object[9][4];@Overridepublic void actionPerformed(ActionEvent e) {Connection con = SqlOperation.getConnection();Statement statement = null;ResultSet rs = null;try {statement = con.createStatement();} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}String sql = null;sql = "SELECT user.id,username,name,role_name FROM user INNER JOIN role ON user.role_id=role.id";try {int count = 0;rs = statement.executeQuery(sql);while (rs.next()) {cells[count][0] = rs.getString("id");cells[count][1] = rs.getString("username");cells[count][2] = rs.getString("name");cells[count][3] = rs.getString("role_name");count++;}String title = "会员信息表";FTable fTable = new FTable(cells, columns, title);} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}try {statement.executeQuery(sql);} catch (SQLException e1) {e1.printStackTrace();}SqlOperation.release(statement, con);}});//用户管理按钮事件btn3.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {JLabel info = new JLabel("修改密码");JLabel labNewPwd = new JLabel("请输入新的密码：");JTextField newPwd = new JTextField(20);JButton btn = new JButton("确定修改");sale.getContentPane().add(labNewPwd);sale.getContentPane().add(info);sale.getContentPane().add(newPwd);sale.getContentPane().add(btn);info.setBounds(320, 90, 200, 75);labNewPwd.setBounds(250, 195, 150, 50);newPwd.setBounds(380, 200, 200, 40);btn.setBounds(350, 300, 100, 30);info.setFont(new Font("", Font.BOLD, 30));labNewPwd.setFont(new Font("", 0, 15));btn.addMouseListener(new MouseAdapter() {@Overridepublic void mouseClicked(MouseEvent e) {Connection con = SqlOperation.getConnection();Statement statement = null;ResultSet rs = null;String loginPwd = newPwd.getText().trim();try {statement = con.createStatement();} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}String sql = null;sql = "UPDATE user SET PASSWORD = " + loginPwd + " WHERE username = " + username;try {int a = statement.executeUpdate(sql);if (a == 1) {JOptionPane.showMessageDialog(null, "修改密码成功");info.setVisible(false);labNewPwd.setVisible(false);newPwd.setVisible(false);btn.setVisible(false);}} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}SqlOperation.release(statement, con);}});}});}//销售员else {//进货员方法System.out.println("进货员");JFrame goods = new JFrame("药店管理系统-进货员");goods.setBounds(100, 100, 800, 450);//窗口居中goods.setLocationRelativeTo(null);goods.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);goods.getContentPane().setLayout(null);goods.setVisible(true);//添加窗口组件JButton btn1 = new JButton("进货管理");JButton btn2 = new JButton("账号管理");goods.getContentPane().add(btn1);goods.getContentPane().add(btn2);btn1.setBounds(250, 30, 100, 40);btn2.setBounds(450, 30, 100, 40);//编号对话框确定键监听事件btn1.addMouseListener(new MouseAdapter() {@Overridepublic void mouseClicked(MouseEvent e) {JFrame addgoods = new JFrame("药店管理系统-进货员");addgoods.setBounds(100, 100, 800, 450);//窗口居中addgoods.setLocationRelativeTo(null);addgoods.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);addgoods.getContentPane().setLayout(null);addgoods.setVisible(true);JLabel add = new JLabel("添加货物");JLabel labName = new JLabel("药品名");JLabel labInPrice = new JLabel("进价");JLabel labNum = new JLabel("数量");JLabel labAddress = new JLabel("生产厂家");JTextField name = new JTextField(20);JTextField inPrice = new JTextField(20);JTextField num = new JTextField(20);JTextField address = new JTextField(20);JButton btn = new JButton("确定");JButton btn5 = new JButton("取消");addgoods.getContentPane().add(add);addgoods.getContentPane().add(labName);addgoods.getContentPane().add(labInPrice);addgoods.getContentPane().add(labNum);addgoods.getContentPane().add(labAddress);addgoods.getContentPane().add(name);addgoods.getContentPane().add(inPrice);addgoods.getContentPane().add(num);addgoods.getContentPane().add(address);addgoods.getContentPane().add(btn);addgoods.getContentPane().add(btn5);add.setBounds(320, 80, 200, 75);labName.setBounds(120, 150, 80, 40);name.setBounds(220, 150, 120, 40);labInPrice.setBounds(460, 150, 80, 40);inPrice.setBounds(560, 150, 120, 40);labNum.setBounds(120, 220, 80, 40);num.setBounds(220, 220, 120, 40);labAddress.setBounds(460, 220, 80, 40);address.setBounds(560, 220, 120, 40);btn.setBounds(250, 300, 100, 30);btn5.setBounds(400, 300, 100, 30);add.setFont(new Font("", Font.BOLD, 30));labName.setFont(new Font("", 0, 15));labInPrice.setFont(new Font("", 0, 15));labNum.setFont(new Font("", 0, 15));labAddress.setFont(new Font("", 0, 15));//编号对话框确定键监听事件btn.addMouseListener(new MouseAdapter() {@Overridepublic void mouseClicked(MouseEvent e) {///获取输入的信息if (name.getText().equals("") || inPrice.getText().equals("") || num.getText().equals("") || address.getText().equals("")) {JOptionPane.showMessageDialog(null, "表单不能为空！");} else {Connection con = SqlOperation.getConnection();Statement statement = null;try {statement = con.createStatement();} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}String sql = null;//向表中传入数据sql = "INSERT INTO medic(medic_name,input_price,num,address) VALUES (" + "'" + name.getText() + "'" + "," + inPrice.getText() + "," + num.getText() + "," + "'" + address.getText() + "'" + ")";try {int a = statement.executeUpdate(sql);if (a == 1) {JOptionPane.showMessageDialog(null, "添加成功");addgoods.dispose();}} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}SqlOperation.release(statement, con);}}});btn5.addMouseListener(new MouseAdapter() {@Overridepublic void mouseClicked(MouseEvent e) {addgoods.dispose();}});}});//用户管理按钮事件btn2.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {JFrame updatePwd = new JFrame("药店管理系统-进货员");updatePwd.setBounds(100, 100, 800, 450);//窗口居中updatePwd.setLocationRelativeTo(null);updatePwd.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);updatePwd.getContentPane().setLayout(null);updatePwd.setVisible(true);//添加窗口组件JButton btn1 = new JButton("进货管理");JButton btn2 = new JButton("账号管理");updatePwd.getContentPane().add(btn1);updatePwd.getContentPane().add(btn2);JLabel info = new JLabel("修改密码");JLabel labNewPwd = new JLabel("请输入新的密码：");JTextField newPwd = new JTextField(20);JButton btn = new JButton("确定修改");JButton btn3 = new JButton("取消");updatePwd.getContentPane().add(labNewPwd);updatePwd.getContentPane().add(info);updatePwd.getContentPane().add(newPwd);updatePwd.getContentPane().add(btn);updatePwd.getContentPane().add(btn3);info.setBounds(320, 90, 200, 75);labNewPwd.setBounds(250, 195, 150, 50);newPwd.setBounds(380, 200, 200, 40);btn.setBounds(250, 300, 100, 30);btn3.setBounds(400, 300, 100, 30);info.setFont(new Font("", Font.BOLD, 30));labNewPwd.setFont(new Font("", 0, 15));btn.addMouseListener(new MouseAdapter() {@Overridepublic void mouseClicked(MouseEvent e) {Connection con = SqlOperation.getConnection();Statement statement = null;ResultSet rs = null;String loginPwd = newPwd.getText().trim();try {statement = con.createStatement();} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}if (loginPwd!=""){String sql = null;sql = "UPDATE user SET PASSWORD = " + loginPwd + " WHERE username = " + username;try {int a = statement.executeUpdate(sql);if (a == 1) {JOptionPane.showMessageDialog(null, "修改密码成功");updatePwd.dispose();}} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}SqlOperation.release(statement, con);}else {JOptionPane.showMessageDialog(null, "新密码不能为空");}}});btn3.addMouseListener(new MouseAdapter() {@Overridepublic void mouseClicked(MouseEvent e) {updatePwd.dispose();}});}});}//药品采购员}
}

SqlOperation.java

package top.lemenk.pm;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class SqlOperation {public static void addGoods() throws Exception {}static Connection getConnection() {String driverClass = "com.mysql.jdbc.Driver";String jdbcUrl = "jdbc:mysql://localhost:3305/pm";String user = "root";String password = "ROOT";try {Class.forName(driverClass);} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}Connection con = null;try {con = DriverManager.getConnection(jdbcUrl, user, password);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return con;}static void release(Statement statement, Connection con) {if (statement != null) {try {statement.close();} catch (Exception e2) {e2.printStackTrace();}}if (con != null) {try {con.close();} catch (Exception e2) {e2.printStackTrace();}}}}

FTable.java

``

package top.lemenk.pm;import javax.swing.*;import javax.swing.table.DefaultTableCellRenderer;import java.awt.*;import java.awt.event.WindowAdapter;import java.awt.event.WindowEvent;
public class FTable {public FTable() {}public FTable(Object[][] playerInfo,String[] Names,String title) {JFrame f = new JFrame();// 以Names和playerInfo为参数，创建一个表格JTable table = new JTable(playerInfo, Names);// 设置此表视图的首选大小f.setLocation(550,250);table.setRowHeight(50);table.setFont(new Font("微软雅黑", Font.BOLD, 15));DefaultTableCellRenderer cr = new DefaultTableCellRenderer();cr.setHorizontalAlignment(JLabel.CENTER);table.setDefaultRenderer(Object.class,cr);table.setPreferredScrollableViewportSize(new Dimension(800, 450));// 将表格加入到滚动条组件中JScrollPane scrollPane = new JScrollPane(table);f.getContentPane().add(scrollPane, BorderLayout.CENTER);// 再将滚动条组件添加到中间容器中f.setTitle(title);f.pack();f.setVisible(true);f.addWindowListener(new WindowAdapter() {@Overridepublic void windowClosing(WindowEvent e) {f.dispose();}});}
}

拒绝白嫖，点赞再走！