JAVA结课作品——超市管理系统

桃扇骨 2024-03-31 11:44 53阅读 0赞

**项目描述：**一个简单的超市管理系统，能够实现用户登入和注册功能，共分为前台和后台两个主要界面，普通用户界面操作权限收到限制，只能对商品和销售记录进行简单查询操作，后台中可以进行商品的删除、修改、查询，可以查看用户信息，可以修改用户信息。具体的代码如下：

![688c3d9247d54b94b36420c4f4271cb3.png][]![f714196150b0411ca7293f71c2d4ef3d.png][]

![f8e3f792171d43168580783ccb135e92.png][]

**TooLUtil工具类：**在该类中定义一些方法，用于判断字符串是否为空、获取当前时间、对时间进行格式转化，同时获取当前用户登入，具体代码如下所示：

package cn.qinlimei.goodmanager.utils;
    
    import javax.xml.crypto.Data;
    import java.text.Format;
    import java.text.SimpleDateFormat;
    import java.util.Date;
    
    /**
     * 在该类中定义一些方法，用于判断字符串是否为空、获取当前时间、对时间进行格式转化
     * 获取当前用户登入
     */
    public class ToolUtil {
    
        //判断字符串是否为空
        public static boolean isEmpty(String str){
            if(str!=null&& !"".equals(str.trim())){//字符串两端的空格去掉
                return false;//不是空的返回false
            }
            return true;//空的话就返回真
        }
    
        //获取当前系统时间所对应的毫秒值
        public static Long getTime(){
            long time=System.currentTimeMillis();
            return time;
        }
    
        //将一个long类型的毫秒值转换成指定格式的日期字符串
        public static String getDataByTime(long time){
            SimpleDateFormat format=new SimpleDateFormat("yyyy-MM-dd");
            Date date=new Date(time);
            String value=format.format(date);
            return value;
        }
    }

**LoginFrm类：**实现用户登入的类

package cn.qinlimei.goodmanager.jframe;
    
    import cn.qinlimei.goodmanager.dao.UserDao;
    import cn.qinlimei.goodmanager.model.User;
    import cn.qinlimei.goodmanager.utils.Dbutil;
    import cn.qinlimei.goodmanager.utils.ToolUtil;
    import cn.qinlimei.goodmanager.model.Goods;
    
    import javax.swing.*;
    import java.awt.*;
    import java.awt.event.ActionEvent;
    import java.awt.event.ActionListener;
    import java.sql.Connection;
    
    //用户实现登入的界面
    public class LoginFrm extends JFrame {
        public static User currentUser;//当登入成功后，使用该变量存储登入的用户
        private JFrame jf;//登入界面的窗体组件
        private JTextField userNameText;//输入用户名的文本框
        private JTextField passwordText;//输入密码的文本框
        private JComboBox comboBox;//用户角色的下拉选择框
    
        //创建一个UserDao对象
        private UserDao userDao=new UserDao();
    
        public LoginFrm(){
            //初始化窗体组件
            jf=new JFrame("超市管理系统");
            jf.getContentPane().setFont(new Font("幼圆",Font.BOLD,14));
            jf.setBounds(600,250,500,467);
            jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
            jf.getContentPane().setLayout(null);
    
            //初始化展示用户名三个字所需要的标签
            JLabel label;
            label=new JLabel("用户名:");
            label.setForeground(Color.BLACK);
            label.setFont(new Font("幼圆",Font.BOLD,16));
            label.setBounds(110,80,75,40);
            jf.getContentPane().add(label);
    
            //初始化初始化用户名文本框组件
            userNameText=new JTextField();
            userNameText.setFont(new Font("幼圆",Font.BOLD,14));
            userNameText.setForeground(Color.BLACK);
            userNameText.setBounds(198,83,164,30);
            jf.getContentPane().add(userNameText);
            userNameText.setColumns(10);
    
            //初始化展示密码两个字所需要的标签
            JLabel label_1;
            label_1=new JLabel("密码:");
            label_1.setForeground(Color.BLACK);
            label_1.setFont(new Font("幼圆",Font.BOLD,16));
            label_1.setBounds(120,150,65,40);
            jf.getContentPane().add(label_1);
    
            //初始化密码输入的文本框组件
            passwordText=new JTextField();
            passwordText.setFont(new Font("幼圆",Font.BOLD,14));
            passwordText.setForeground(Color.BLACK);
            passwordText.setColumns(10);
            passwordText.setBounds(198,152,164,30);
            jf.getContentPane().add(passwordText);
    
            //初始化展示权限两个字的标签
            JLabel label_2;
            label_2=new JLabel("权限");
            label_2.setForeground(Color.BLACK);
            label_2.setFont(new Font("幼圆",Font.BOLD,15));
            label_2.setBounds(144,250,45,29);
            jf.getContentPane().add(label_2);
    
            //初始化角色选择的下拉框组件
            comboBox=new JComboBox();
            comboBox.setBounds(199,254,127,25);
            comboBox.addItem("普通成员");
            comboBox.addItem("管理员");
            jf.getContentPane().add(comboBox);
    
            //初始化登入按钮
            JButton button=new JButton("登入");
    
            //给登入按钮添加一个动作监听器
            button.addActionListener(new ActionListener() {
                @Override
                public void actionPerformed(ActionEvent e) {   //编写登入的业务逻辑
                    checkLogih();
                }
            });
            button.setBounds(153,320,65,29);
            jf.getContentPane().add(button);
    
            //初始化注册按钮
            JButton button_1=new JButton("注册");
    
            //给注册按钮添加一个动作监听器
            button_1.addActionListener(new ActionListener() {
                @Override
                public void actionPerformed(ActionEvent e) {    //编写注册的业务逻辑
                    regUser();//去注册界面的方法
                }
            });
            button_1.setBounds(263,320,65,29);
            jf.getContentPane().add(button_1);
    
            //初始化展示 用户登入标题所需要的标签
            JLabel lbNewLable_1;
            lbNewLable_1=new JLabel("用户登入");
            lbNewLable_1.setFont(new Font("幼圆",Font.BOLD,25));
            lbNewLable_1.setBounds(200,10,122,51);
            jf.getContentPane().add(lbNewLable_1);
    
            //让图形界面显示且不可改变大小
            jf.setVisible(true);
            jf.setResizable(false);
        }
    
        //去注册页面所对应的方法
        public void regUser(){
            //把当前的jf页面隐藏掉
            jf.setVisible(false);
            new RegFram();
        }
    
        //完成用户登入的业务逻辑
        public void checkLogih(){
    
            //获取用户输入的用户名和密码
            String userName= userNameText.getText();
            String password= passwordText.getText();
            int index=comboBox.getSelectedIndex();
            if(ToolUtil.isEmpty(userName)||ToolUtil.isEmpty(password)){
                JOptionPane.showMessageDialog(null,"用户名和密码不能为空！");
                return;
            }
    
            //把数据封装到User中
            User user=new User();
            user.setUername(userName);
            user.setUerpassword(password);
            if(index==0){
                user.setRole(1);
            }else{
                user.setRole(2);
            }
    
            //获取一个链接对象
            Connection connection=null;
            try {
                connection= Dbutil.getConnection();
                User login=userDao.login(connection,user);
                if(login==null){
                    JOptionPane.showMessageDialog(null,"登入失败");
                }else{
                    currentUser =login;//记录当前登入的用户
                    if(index==0){  //等于0说明选择的是普通用户
                        jf.dispose();
                        new UserMenuFrm();  //普通用户的登入界面
                    }else{
                        jf.dispose();
                        new AdminMenuFrm();  //管理员的登入界面
                    }
                }
            } catch (Exception e) {
                e.printStackTrace();
            }finally {
                try {
                    Dbutil.closeConnection(connection);
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
    
        }
    
    
        public static void main(String[] args) {
            LoginFrm loginFrm=new LoginFrm();
        }
    }

**AdminMenuFrm类：**实现部门管理的类

package cn.qinlimei.goodmanager.jframe;
    
    import cn.qinlimei.goodmanager.dao.DepartmentDao;
    import cn.qinlimei.goodmanager.model.Department;
    import cn.qinlimei.goodmanager.utils.Dbutil;
    import cn.qinlimei.goodmanager.utils.ToolUtil;
    
    import javax.swing.*;
    import java.awt.*;
    import java.awt.event.*;
    import java.sql.Connection;
    
    public class AdminMenuFrm extends JFrame {
        private JFrame jf;
        private JTextField textField;
        private JButton btnNewButton;
        private JTextArea textArea;
    
        private DepartmentDao departmentDao=new DepartmentDao();
    
        public AdminMenuFrm(){
    
            //初始化界面所需要的窗体组件
            jf=new JFrame("管理员");
            jf.setBounds(400,100,600,429);
            jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
            jf.getContentPane().setLayout(null);
    
            //初始化展示部门类别四个字所对应的标签
            JLabel label_1=new JLabel();
            label_1.setFont(new Font("幼圆",Font.BOLD,14));
            label_1.setText("部门名称：");
            label_1.setBounds(112,38,75,26);
            jf.getContentPane().add(label_1);
    
            //初始化输入部门名称的文本框
            textField=new JTextField();
            textField.setBounds(197,38,241,26);
            jf.getContentPane().add(textField);
    
            //初始化展示部门编号所对应的标签
            JLabel label=new JLabel();
            label.setFont(new Font("幼圆",Font.BOLD,14));
            label.setText("部门编号：");
            label.setBounds(112,120,75,26);
            jf.getContentPane().add(label);
    
            //初始化输入部门编号所需要的文本框
            textArea=new JTextArea();
            textArea.setColumns(10);
            textArea.setRows(5);
            textArea.setBackground(Color.WHITE);
            textArea.setBounds(197,114,241,25);
            jf.getContentPane().add(textArea);
    
    
    
            //初始化 添加 按钮
            btnNewButton=new JButton("添加");
            btnNewButton.addActionListener(new ActionListener() {
                @Override
                public void actionPerformed(ActionEvent e) {//添加按钮的业务逻辑
    
                    //获取部门名称和部门编号
                   String typeName= textField.getText();
                   int typeRemrke= Integer.parseInt(textArea.getText());
    
                   //判断是否为空
                    if(ToolUtil.isEmpty(typeName)||ToolUtil.isEmpty(String.valueOf(typeRemrke))){
                        JOptionPane.showMessageDialog(null,"请输入相关信息");
                        return;
                    }
    
                    //把数据封装到部门对象中
                    Department department=new Department();
                    department.setDepartmentname(typeName);
                    department.setDepartmentid(typeRemrke);
    
    
                    //获取链接对象
                    Connection connection=null;
                    try {
                        //把数据保存在数据库中
                        connection=Dbutil.getConnection();
                        //调用部门管理中的方法进行信息保存
                        int i=departmentDao.add(connection,department);
                        if(i==1){
                            JOptionPane.showMessageDialog(null,"添加成功");
                            reset();
                        }else if(i==2){
                            JOptionPane.showMessageDialog(null,"添加失败，已存在！");
                        }else{
                            JOptionPane.showMessageDialog(null,"添加失败！");
                        }
    
                    } catch (Exception ex) {
                        ex.printStackTrace();
                    }finally {
                        if(connection !=null){
                            try {
                                Dbutil.closeConnection(connection);
                            } catch (Exception ex) {
                                ex.printStackTrace();
                            }
                        }
                    }
    
    
                }
            });
            btnNewButton.setFont(new Font("幼圆",Font.BOLD,14));
            btnNewButton.setBounds(182,281,80,26);
            jf.getContentPane().add(btnNewButton);
    
            //创建重置按钮
            JButton button=new JButton("重置");
            button.addActionListener(new ActionListener() {
                @Override
                public void actionPerformed(ActionEvent e) {
                    reset();
    
                }
            });
            button.setFont(new Font("幼圆",Font.BOLD,14));
            button.setBounds(360,281,80,26);
            jf.getContentPane().add(button);
    
    
    
            //创建菜单栏组件
            JMenuBar menuBar=new JMenuBar();
            jf.setJMenuBar(menuBar);
    
            //添加部门管理菜单
            JMenu mnNewMeun=new JMenu("部门管理");
            menuBar.add(mnNewMeun);
    
            //添加部门 选项
            JMenuItem mntmNewMenuItem=new JMenuItem("部门添加");
            mnNewMeun.add(mntmNewMenuItem);
    
            //添加部门修改选项
            JMenuItem mntmNewMenuItem_1=new JMenuItem("部门修改");
            mntmNewMenuItem_1.addMouseListener(new MouseAdapter() {
                @Override
                public void mousePressed(MouseEvent evt) {
                    jf.dispose();
                    new AddminTypeEdit();//部门修改的界面
    
                }
            });
            mnNewMeun.add(mntmNewMenuItem_1);
    
            //添加商品管理菜单
            JMenu mnNewMeun_2=new JMenu("商品管理");
            menuBar.add(mnNewMeun_2);
    
            //添加商品添加选项
            JMenuItem mntmNewMenuItem_2=new JMenuItem("添加商品");
            mntmNewMenuItem_2.addMouseListener(new MouseAdapter() {
                @Override
                public void mousePressed(MouseEvent evt) {
                    jf.dispose();
                    new AdmingoodAdd();
    
                }
            });
            mnNewMeun_2.add(mntmNewMenuItem_2);
    
            //添加商品修改
            JMenuItem mntmNewMenuItem_3=new JMenuItem("商品修改");
            mntmNewMenuItem_3.addMouseListener(new MouseAdapter() {
                @Override
                public void mousePressed(MouseEvent evt) {
                    jf.dispose();
                    new AddmingoodEdit();
    
                }
            });
            mnNewMeun_2.add(mntmNewMenuItem_3);
    
            //添加用户管理菜单
            JMenu menu1=new JMenu("员工管理");
            menuBar.add(menu1);
    
            //添加用户选项
            JMenuItem mntmNewMenuItem_4=new JMenuItem("添加员工");
            mntmNewMenuItem_4.addMouseListener(new MouseAdapter() {
                @Override
                public void mousePressed(MouseEvent evt) {
                    jf.dispose();
                    new AddminUserinfo();
    
                }
            });
            menu1.add(mntmNewMenuItem_4);
    
            //添加流水信息选项
            JMenuItem mntmNewMenuItem_5=new JMenuItem("流水信息");
            mntmNewMenuItem_5.addMouseListener(new MouseAdapter() {
                @Override
                public void mousePressed(MouseEvent evt) {
                    jf.dispose();
                    new Addminflowinfo();
    
                }
            });
            menu1.add(mntmNewMenuItem_5);
    
            //添加退出系统菜单
            JMenu mnNewMeun_1=new JMenu("退出系统");
            mnNewMeun_1.addMouseListener(new MouseAdapter() {
                @Override
                public void mousePressed(MouseEvent evt) {
                    JOptionPane.showMessageDialog(null,"欢迎下次使用！");
                    jf.dispose();
                }
            });
            menuBar.add(mnNewMeun_1);
    
            jf.setVisible(true);
            jf.setResizable(false);
    
        }
    
        public void reset(){
            this.textField.setText("");
            this.textArea.setText("");
        }
    
        public static void main(String[] args) {
            new AdminMenuFrm();
        }
    
    }

**AdmingoodAdd类：**实现商品管理的类：

package cn.qinlimei.goodmanager.jframe;
    
    import cn.qinlimei.goodmanager.dao.GoodsDao;
    import cn.qinlimei.goodmanager.model.Goods;
    import cn.qinlimei.goodmanager.utils.Dbutil;
    import cn.qinlimei.goodmanager.utils.ToolUtil;
    
    import javax.swing.*;
    import javax.swing.border.TitledBorder;
    import java.awt.*;
    import java.awt.event.ActionEvent;
    import java.awt.event.ActionListener;
    import java.awt.event.MouseAdapter;
    import java.awt.event.MouseEvent;
    import java.math.BigDecimal;
    import java.sql.Connection;
    
    public class AdmingoodAdd extends Exception {
        private JFrame jf;//展示添加图书组件的窗体组件
        private JTextField textField_1;//输入商品名所需要的文本框
        private JTextField textField_2;//输入编号文本框
        private JTextField textField_3;//输入条形码文本框
        private JTextField textField_4;//输入产地文本框
        private JTextField textField_5;//输入产商文本框
        private JTextField textField_6;//输入规文本框
        private JTextField textField_7;//输入文本框
        private JTextField textField_8;//输入售价文本框
        private JTextField textField_9;//输入库存文本框
        private JTextField textField_10;//库存下限文本框
        //创建商品Dao对象
        private GoodsDao goodsDao=new GoodsDao();
    
        public AdmingoodAdd() {
            //初始化商品添加窗口组件
            jf = new JFrame("管理员界面");
            jf.setBounds(400, 100, 611, 450);
            jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
            jf.getContentPane().setLayout(null);
    
            //创建一个添加商品信息所对应的面板组件
            JPanel panel = new JPanel();
            panel.setBorder(new TitledBorder(null, "书籍添加", TitledBorder.LEADING, TitledBorder.TOP, null, Color.black));
            panel.setBounds(23, 21, 554, 350);
            jf.getContentPane().add(panel);
            panel.setLayout(null);
    
            //创建展示商品名所需要的标签
            JLabel lblNewLabel=new JLabel("名称：");
            lblNewLabel.setFont(new Font("幼圆",Font.BOLD,14));
            lblNewLabel.setBounds(55,31,45,27);
            panel.add(lblNewLabel);
    
            //初始化输入商品名所需的文本框
            textField_1=new JTextField();
            textField_1.setBounds(101,31,129,27);
            panel.add(textField_1);
            textField_1.setColumns(10);
    
            //创建展示编号所需要的标签
            JLabel lblNewLabel_2=new JLabel("编号：");
            lblNewLabel_2.setFont(new Font("幼圆",Font.BOLD,14));
            lblNewLabel_2.setBounds(294,31,45,27);
            panel.add(lblNewLabel_2);
    
            //初始化编号文本框
            textField_2=new JTextField();
            textField_2.setBounds(340,31,128,27);
            panel.add(textField_2);
            textField_2.setColumns(10);
    
            //创建展示条形码所需要的标签
            JLabel lblNewLabel_3=new JLabel("条形码：");
            lblNewLabel_3.setFont(new Font("幼圆",Font.BOLD,14));
            lblNewLabel_3.setBounds(43,79,60,27);
            panel.add(lblNewLabel_3);
    
            //初始化输入条形码文本框
            textField_3=new JTextField();
            textField_3.setBounds(101,79,129,27);
            panel.add(textField_3);
            textField_3.setColumns(10);
    
            //创建展示产地的标签
            JLabel lblNewLabel_4=new JLabel("产地：");
            lblNewLabel_4.setFont(new Font("幼圆",Font.BOLD,14));
            lblNewLabel_4.setBounds(294,79,60,27);
            panel.add(lblNewLabel_4);
    
            //初始化产地文本
            textField_4=new JTextField();
            textField_4.setBounds(340,79,129,27);
            panel.add(textField_4);
            textField_4.setColumns(10);
    
            //产商标签
            JLabel lblNewLabel_5=new JLabel("产商：");
            lblNewLabel_5.setFont(new Font("幼圆",Font.BOLD,14));
            lblNewLabel_5.setBounds(55,127,60,27);
            panel.add(lblNewLabel_5);
    
            //初始化产商文本
            textField_5=new JTextField();
            textField_5.setBounds(101,127,129,27);
            panel.add(textField_5);
            textField_5.setColumns(10);
    
            //规格标签
            JLabel lblNewLabel_6=new JLabel("规格：");
            lblNewLabel_6.setFont(new Font("幼圆",Font.BOLD,14));
            lblNewLabel_6.setBounds(294,127,60,27);
            panel.add(lblNewLabel_6);
    
            //初始化规格文本
            textField_6=new JTextField();
            textField_6.setBounds(340,127,129,27);
            panel.add(textField_6);
            textField_6.setColumns(10);
    
            //进价标签
            JLabel lblNewLabel_7=new JLabel("进价：");
            lblNewLabel_7.setFont(new Font("幼圆",Font.BOLD,14));
            lblNewLabel_7.setBounds(45,175,60,27);
            panel.add(lblNewLabel_7);
    
            //进价文本
            textField_7=new JTextField();
            textField_7.setBounds(101,175,129,27);
            panel.add(textField_7);
            textField_7.setColumns(10);
    
            //售价标签
            JLabel lblNewLabel_8=new JLabel("售价：");
            lblNewLabel_8.setFont(new Font("幼圆",Font.BOLD,14));
            lblNewLabel_8.setBounds(294,175,45,27);
            panel.add(lblNewLabel_8);
    
            //售价文本
            textField_8=new JTextField();
            textField_8.setBounds(340,175,129,27);
            panel.add(textField_8);
            textField_8.setColumns(10);
    
            //库存标签
            JLabel lblNewLabel_9=new JLabel("库存：");
            lblNewLabel_9.setFont(new Font("幼圆",Font.BOLD,14));
            lblNewLabel_9.setBounds(45,223,45,27);
            panel.add(lblNewLabel_9);
    
            //库存文本
            textField_9=new JTextField();
            textField_9.setBounds(101,223,129,27);
            panel.add(textField_9);
            textField_9.setColumns(10);
    
            //库存下限标签
            JLabel lblNewLabel_10=new JLabel("下限：");
            lblNewLabel_10.setFont(new Font("幼圆",Font.BOLD,14));
            lblNewLabel_10.setBounds(294,223,45,27);
            panel.add(lblNewLabel_10);
    
            //库存下限文本
            textField_10=new JTextField();
            textField_10.setBounds(340,223,129,27);
            panel.add(textField_10);
            textField_10.setColumns(10);
    
            //查询数据库获取类别数据
    
            //创建添加按钮
            JButton btnNewButton=new JButton("添加");
            btnNewButton.addActionListener(new ActionListener() {
                @Override
                public void actionPerformed(ActionEvent e) {  //添加商品的业务逻辑代码
                    //从文本框中获取用户输入的数据
                    String goodname=textField_1.getText();
                    String goodid=textField_2.getText();
                    String goodtxm=textField_3.getText();
                    String goodcd=textField_4.getText();
                    String goodcs=textField_5.getText();
                    String goodgg=textField_6.getText();
                    String goodjj=textField_7.getText();
                    String goodsj=textField_8.getText();
                    String goodkc=textField_9.getText();
                    String goodxx=textField_10.getText();
    
                    //对数据进行校验
                    if(ToolUtil.isEmpty(goodname)||
                            ToolUtil.isEmpty(goodid)||
                            ToolUtil.isEmpty(goodtxm)||
                            ToolUtil.isEmpty(goodcd)||
                            ToolUtil.isEmpty(goodcs)||
                            ToolUtil.isEmpty(goodgg)||
                            ToolUtil.isEmpty(goodjj)||
                            ToolUtil.isEmpty(goodsj)||
                            ToolUtil.isEmpty(goodkc)||
                            ToolUtil.isEmpty(goodxx)){
                        JOptionPane.showMessageDialog(null,"请输入相关内容！");
                        return;
    
                    }
    
                    //因为从文本框中得到的是字符串类型的数据，无法将整形等数据赋给商品对象中的整形等数据，因此要进行数据解析
                    Integer bianhao;//编号
                    Double jinjia;//进价
                    Double shoujia;//售价
                    Integer kucun;//库存
                    Integer kcxiaxian;//库存下限
    
                    try {
                        bianhao=Integer.parseInt(goodid);
                        jinjia= new BigDecimal(goodjj).setScale(2).doubleValue();//保留两位小数点
                        shoujia= new BigDecimal(goodsj).setScale(2).doubleValue();
                        kucun=Integer.parseInt(goodkc);
                        kcxiaxian=Integer.parseInt(goodxx);
    
                    }catch (Exception e1){
                        JOptionPane.showMessageDialog(null,"参数错误！");
                        return;
                    }
    
                    //创建一个商品对象用来封装参数
                    Goods goods=new Goods();
                    goods.setGoodtxm(goodtxm);
                    goods.setGoodid(bianhao);
                    goods.setGoodname(goodname);
                    goods.setGoodcd(goodcd);
                    goods.setGoodgg(goodgg);
                    goods.setGoodcj(goodcs);
                    goods.setGoodj(jinjia);
                    goods.setGoodsj(shoujia);
                    goods.setGoodxx(kcxiaxian);
                    goods.setGoodkc(kucun);
    
                    //获取链接对象进行数据保存操作
                    Connection connection=null;
                    try {
                        connection=Dbutil.getConnection();
                        //调用商品dao中的方法完成数据保存
                        int i=goodsDao.add(connection,goods);//会返回一个整形
                        if(i==1){
                            JOptionPane.showMessageDialog(null,"添加成功！");
                            reset();//进行清空操作
                        }else {
                            JOptionPane.showMessageDialog(null,"添加失败！");
                        }
    
    
    
                    } catch (Exception ex) {
                        ex.printStackTrace();
                    }finally {
                        if(connection!=null){
                            try {
                                Dbutil.closeConnection(connection);
                            } catch (Exception ex) {
                                ex.printStackTrace();
                            }
                        }
                    }
    
    
                }
            });
            btnNewButton.setFont(new Font("幼圆",Font.BOLD,14));
            btnNewButton.setBounds(124,280,77,27);
            panel.add(btnNewButton);
    
            //创建重置按钮
            JButton button=new JButton("重置");
            button.addActionListener(new ActionListener() {
                @Override
                public void actionPerformed(ActionEvent e) {
                    reset();
                }
            });
            button.setFont(new Font("幼圆",Font.BOLD,14));
            button.setBounds(329,280,77,27);
            panel.add(button);
    
            //创建菜单栏组件
            JMenuBar menuBar=new JMenuBar();
            jf.setJMenuBar(menuBar);
    
            //添加部门管理菜单
            JMenu mnNewMenu=new JMenu("部门管理");
            menuBar.add(mnNewMenu);
    
            //添加  添加部门选项
            JMenuItem mntmNewMenuItem=new JMenuItem("部门添加");
            mntmNewMenuItem.addMouseListener(new MouseAdapter() {
                @Override
                public void mousePressed(MouseEvent evt) {
                    jf.dispose();
                    new AdminMenuFrm();
    
                }
            });
            mnNewMenu.add(mntmNewMenuItem);
    
            //添加   部门修改选项
            JMenuItem mntmNewMenuItem_1=new JMenuItem("部门修改");
            mntmNewMenuItem_1.addMouseListener(new MouseAdapter() {
                @Override
                public void mousePressed(MouseEvent evt) {
                    jf.dispose();
                    new AddminTypeEdit();
    
                }
            });
            mnNewMenu.add(mntmNewMenuItem_1);
    
            //商品管理菜单
            JMenu mnNewMenu_2=new JMenu("商品管理");
            menuBar.add(mnNewMenu_2);
    
            //商品添加 选项
            JMenuItem mntmNewMenuItem_2=new JMenuItem("商品添加");
            mnNewMenu_2.add(mntmNewMenuItem_2);
    
            //商品修改 选项
            JMenuItem mntmNewMenuItem_3=new JMenuItem("商品修改");
            mntmNewMenuItem_3.addMouseListener(new MouseAdapter() {
                @Override
                public void mousePressed(MouseEvent evt) {
                    jf.dispose();
                    new AddmingoodEdit();//商品修改的界面
    
                }
            });
            mnNewMenu_2.add(mntmNewMenuItem_3);
    
            //员工管理菜单
            JMenu menu1=new JMenu("员工管理");
            menuBar.add(menu1);
    
            //添加员工  选项
            JMenuItem mntnNewMenuItem_4=new JMenuItem("员工信息");
            mntnNewMenuItem_4.addMouseListener(new MouseAdapter() {
                @Override
                public void mousePressed(MouseEvent evt) {
                    jf.dispose();
                    new AddminUserinfo();//进入员工管理的界面
    
                }
            });
            menu1.add(mntnNewMenuItem_4);
    
            //添加流水信息菜单选项
            JMenuItem mntnNewMenuItem_5=new JMenuItem("流水信息");
            mntnNewMenuItem_5.addMouseListener(new MouseAdapter() {
                @Override
                public void mousePressed(MouseEvent evt) {
                    jf.dispose();
                    new Addminflowinfo();
    
                }
            });
            menu1.add(mntnNewMenuItem_5);
    
            //添加退出系统菜单
            JMenu mnNewMenu_1=new JMenu("退出系统");
            mnNewMenu_1.addMouseListener(new MouseAdapter() {
                @Override
                public void mousePressed(MouseEvent evt) {
                    JOptionPane.showMessageDialog(null,"欢迎下次使用！");
                    jf.dispose();
    
                }
            });
            menuBar.add(mnNewMenu_1);
    
    
            //展示jf,并且不可改变大小
            jf.setVisible(true);
            jf.setResizable(false);
    
        }
    
        public void reset(){
            //清空所有文本框中的内容
            textField_1.setText("");
            textField_2.setText("");
            textField_3.setText("");
            textField_4.setText("");
            textField_5.setText("");
            textField_6.setText("");
            textField_7.setText("");
            textField_8.setText("");
            textField_9.setText("");
            textField_10.setText("");
        }
    
    
        public static void main(String[] args) {
            new AdmingoodAdd();
        }
    }

**AdminUserinfo类：**实现员工管理的类：

package cn.qinlimei.goodmanager.jframe;
    
    import cn.qinlimei.goodmanager.dao.StaffDao;
    import cn.qinlimei.goodmanager.dao.UserDao;
    import cn.qinlimei.goodmanager.model.Goods;
    import cn.qinlimei.goodmanager.model.UserStaff;
    import cn.qinlimei.goodmanager.utils.Dbutil;
    import cn.qinlimei.goodmanager.utils.ToolUtil;
    
    import javax.swing.*;
    import javax.swing.border.TitledBorder;
    import javax.swing.table.DefaultTableModel;
    import java.awt.*;
    import java.awt.event.ActionEvent;
    import java.awt.event.ActionListener;
    import java.awt.event.MouseAdapter;
    import java.awt.event.MouseEvent;
    import java.sql.Connection;
    import java.sql.ResultSet;
    import java.util.Date;
    import java.util.Vector;
    
    import static cn.qinlimei.goodmanager.utils.ToolUtil.getDataByTime;
    
    public class AddminUserinfo {
        private JFrame jf;//展示用户管理界面的窗体组件
        private JTable table;//展示员工信息的表格组件
        private DefaultTableModel model;//封装部门信息所需要的表格数据模型组件
        private JTextField textField;//输入工号所需要的文本框组件
        private JTextField textField_1;//输入ID所需要的文本框
        private JTextField textField_2;//输入名文本框
        private JTextField textField_3;//输入sex文本框
        private JTextField textField_4;//输入身份证文本框
        private JTextField textField_5;//输入birth文本框
        private JTextField textField_6;//输入phone本框
        private JTextField textField_7;//输入did文本框
    
        private StaffDao staffDao=new StaffDao();
    
        public AddminUserinfo(){
            jf=new JFrame("管理员界面");
            jf.setBounds(400,50,600,680);
            jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    
            JMenuBar menuBar=new JMenuBar();
            jf.setJMenuBar(menuBar);
    
            //添加部门管理菜单
            JMenu mnNewMenu=new JMenu("部门管理");
            menuBar.add(mnNewMenu);
    
            //添加  添加部门选项
            JMenuItem mntmNewMenuItem=new JMenuItem("部门添加");
            mntmNewMenuItem.addMouseListener(new MouseAdapter() {
                @Override
                public void mousePressed(MouseEvent evt) {
                    jf.dispose();
                    new AdminMenuFrm();
    
                }
            });
            mnNewMenu.add(mntmNewMenuItem);
    
            //添加   部门修改选项
            JMenuItem mntmNewMenuItem_1=new JMenuItem("部门修改");
            mntmNewMenuItem_1.addMouseListener(new MouseAdapter() {
                @Override
                public void mousePressed(MouseEvent evt) {
                    jf.dispose();
                    new AddminTypeEdit();
                }
            });
            mnNewMenu.add(mntmNewMenuItem_1);
    
            //商品管理菜单
            JMenu mnNewMenu_2=new JMenu("商品管理");
            menuBar.add(mnNewMenu_2);
    
            //商品添加 选项
            JMenuItem mntmNewMenuItem_2=new JMenuItem("商品添加");
            mntmNewMenuItem_2.addMouseListener(new MouseAdapter() {
                @Override
                public void mousePressed(MouseEvent evt) {
                    jf.dispose();
                    new AdmingoodAdd();//商品添加的界面
    
                }
            });
            mnNewMenu_2.add(mntmNewMenuItem_2);
    
            //商品修改 选项
            JMenuItem mntmNewMenuItem_3=new JMenuItem("商品修改");
            mnNewMenu_2.add(mntmNewMenuItem_3);
    
            //员工管理菜单
            JMenu menu1=new JMenu("员工管理");
            menuBar.add(menu1);
    
            //添加员工  选项
            JMenuItem mntnNewMenuItem_4=new JMenuItem("员工信息");
            menu1.add(mntnNewMenuItem_4);
    
            //添加流水信息菜单选项
            JMenuItem mntnNewMenuItem_5=new JMenuItem("流水信息");
            mntnNewMenuItem_5.addMouseListener(new MouseAdapter() {
                @Override
                public void mousePressed(MouseEvent evt) {
                    jf.dispose();
                    new Addminflowinfo();
    
                }
            });
            menu1.add(mntnNewMenuItem_5);
    
            //添加退出系统菜单
            JMenu mnNewMenu_1=new JMenu("退出系统");
            mnNewMenu_1.addMouseListener(new MouseAdapter() {
                @Override
                public void mousePressed(MouseEvent evt) {
                    JOptionPane.showMessageDialog(null,"欢迎下次使用！");
                    jf.dispose();
    
                }
            });
            menuBar.add(mnNewMenu_1);
    
            //创建查询的操作面板
            JPanel panel = new JPanel();
            panel.setBorder(new TitledBorder(null, "员工查询", TitledBorder.LEADING, TitledBorder.TOP, null, Color.black));
            panel.setBounds(20, 10, 541, 78);
            jf.getContentPane().add(panel);
            panel.setLayout(null);
            jf.getContentPane().setLayout(null);
    
            //初始化查询字段所对应的
            JLabel lblNewLabel=new JLabel("工号：");
            lblNewLabel.setFont(new Font("幼圆",Font.BOLD,14));
            lblNewLabel.setBounds(125,31,45,27);
            panel.add(lblNewLabel);
    
            //初始化输入查询关键字所对应的文本框
            textField=new JTextField();
            textField.setBounds(185,28,146,24);
            panel.add(textField);
            textField.setColumns(10);
    
            //创建查询按钮
            JButton button=new JButton("查询");
            button.addActionListener(new ActionListener() {
                @Override
                public void actionPerformed(ActionEvent e) {
                    String staffid=textField.getText();
                    int gonghao=Integer.parseInt(staffid);
                    UserStaff userStaff=new UserStaff();
                    userStaff.setStaffid(gonghao);
                    putDtates(userStaff);
    
                }
            });
            button.setFont(new Font("幼圆",Font.BOLD,14));
            button.setBounds(352,28,81,25);
            panel.add(button);
    
    
            //创建员工查询的面板
            JPanel panel_1 = new JPanel();
            panel_1.setBorder(new TitledBorder(null, "员工信息", TitledBorder.LEADING, TitledBorder.TOP, null, Color.black));
            panel_1.setBounds(20, 105, 541, 195);
            panel_1.setLayout(null);
    
            //展示商品信息所对应的表头数据
            String[]title={"工号","姓名","性别","身份证","出生日期","电话","部门"};
    
            //展示商品信息所需要的二维数组
            String[][]dates={};
    
            //初始化展示商品信息所对应的表格数据模型
            model=new DefaultTableModel(dates,title);
    
            //初始化表格组件
            table=new JTable(model);
    
            //查询数据库获取的所有员工信息
            putDtates(new UserStaff());
    
    
            table.addMouseListener(new MouseAdapter() {
                @Override
                public void mousePressed(MouseEvent evt) {
                    typeTableMousePressed();
    
                }
            });
    
            //添加到面板中
            panel_1.setLayout(null);
            JScrollPane jscrollPane=new JScrollPane();
            jscrollPane.setBounds(20,22,496,154);
            jscrollPane.setViewportView(table);
            panel_1.add(jscrollPane);
            jf.getContentPane().add(panel_1);
    
            //创建编辑商品信息所对应的面板
            JPanel panel_2 = new JPanel();
            panel_2.setBorder(new TitledBorder(null, "员工编辑", TitledBorder.LEADING, TitledBorder.TOP, null, Color.black));
            panel_2.setBounds(20, 310, 541, 292);
            jf.getContentPane().add(panel_2);
            panel_2.setLayout(null);
    
            //创建展示商品名所需要的标签
            JLabel lblNewLabel_1=new JLabel("姓名：");
            lblNewLabel_1.setFont(new Font("幼圆",Font.BOLD,14));
            lblNewLabel_1.setBounds(55,31,45,27);
            panel_2.add(lblNewLabel_1);
    
            //初始化输入商品名所需的文本框
            textField_1=new JTextField();
            textField_1.setBounds(101,31,129,27);
            panel_2.add(textField_1);
            textField_1.setColumns(10);
    
            //创建展示编号所需要的标签
            JLabel lblNewLabel_2=new JLabel("工号：");
            lblNewLabel_2.setFont(new Font("幼圆",Font.BOLD,14));
            lblNewLabel_2.setBounds(294,31,45,27);
            panel_2.add(lblNewLabel_2);
    
            //初始化编号文本框
            textField_2=new JTextField();
            textField_2.setBounds(340,31,128,27);
            panel_2.add(textField_2);
            textField_2.setColumns(10);
    
            //创建展示条形码所需要的标签
            JLabel lblNewLabel_3=new JLabel("性别：");
            lblNewLabel_3.setFont(new Font("幼圆",Font.BOLD,14));
            lblNewLabel_3.setBounds(54,79,60,27);
            panel_2.add(lblNewLabel_3);
    
            //初始化输入条形码文本框
            textField_3=new JTextField();
            textField_3.setBounds(101,79,129,27);
            panel_2.add(textField_3);
            textField_3.setColumns(10);
    
            //创建展示产地的标签
            JLabel lblNewLabel_4=new JLabel("身份证：");
            lblNewLabel_4.setFont(new Font("幼圆",Font.BOLD,14));
            lblNewLabel_4.setBounds(277,79,60,27);
            panel_2.add(lblNewLabel_4);
    
            //初始化产地文本
            textField_4=new JTextField();
            textField_4.setBounds(340,79,129,27);
            panel_2.add(textField_4);
            textField_4.setColumns(10);
    
            //产商标签
            JLabel lblNewLabel_5=new JLabel("出生日期：");
            lblNewLabel_5.setFont(new Font("幼圆",Font.BOLD,14));
            lblNewLabel_5.setBounds(23,127,75,27);
            panel_2.add(lblNewLabel_5);
    
            //初始化产商文本
            textField_5=new JTextField();
            textField_5.setBounds(101,127,129,27);
            panel_2.add(textField_5);
            textField_5.setColumns(10);
    
            //规格标签
            JLabel lblNewLabel_6=new JLabel("电话：");
            lblNewLabel_6.setFont(new Font("幼圆",Font.BOLD,14));
            lblNewLabel_6.setBounds(289,127,60,27);
            panel_2.add(lblNewLabel_6);
    
            //初始化规格文本
            textField_6=new JTextField();
            textField_6.setBounds(340,127,129,27);
            panel_2.add(textField_6);
            textField_6.setColumns(10);
    
            //进价标签
            JLabel lblNewLabel_7=new JLabel("部门：");
            lblNewLabel_7.setFont(new Font("幼圆",Font.BOLD,14));
            lblNewLabel_7.setBounds(55,175,60,27);
            panel_2.add(lblNewLabel_7);
    
            //进价文本
            textField_7=new JTextField();
            textField_7.setBounds(101,175,129,27);
            panel_2.add(textField_7);
            textField_7.setColumns(10);
    
            JButton btnNewButton_1=new JButton("修改");
            btnNewButton_1.addActionListener(new ActionListener() {
                @Override
                public void actionPerformed(ActionEvent e) {
                    String staffid=textField_1.getText();
                    String staffname=textField_2.getText();
                    String staffsex=textField_3.getText();
                    String staffsfz=textField_4.getText();
                    String staffbirth=textField_5.getText();
                    String staffphone=textField_6.getText();
                    String staffdid=textField_7.getText();
    
                    if(ToolUtil.isEmpty(staffid)||
                            ToolUtil.isEmpty(staffname)||
                            ToolUtil.isEmpty(staffsex)||
                            ToolUtil.isEmpty(staffsfz)||
                            ToolUtil.isEmpty(staffbirth)||
                            ToolUtil.isEmpty(staffphone)||
                            ToolUtil.isEmpty(staffdid)){
                        JOptionPane.showMessageDialog(null,"请输入相关内容！");
                        return;
                    }
    
                    //封装到userstaff
                    UserStaff userStaff=new UserStaff();
                    userStaff.setStaffid(Integer.parseInt(staffid));
                    userStaff.setStaffname(staffname);
                    userStaff.setStaffsex(staffsex);
                    userStaff.setStaffsfz(staffsfz);
                    userStaff.setStaffbirthday(new Date(staffbirth));
                    userStaff.setStaffphone(staffphone);
                    userStaff.setStaffdid(Integer.parseInt(staffdid));
    
                    //获取链接
                    Connection connection=null;
                    try {
                        connection=Dbutil.getConnection();
                        //调用修改函数
                        int i=staffDao.update(connection,userStaff);
                        if(i==1){
                            JOptionPane.showMessageDialog(null,"修改成功！");
                            putDtates(new UserStaff());
                        }else{
                            JOptionPane.showMessageDialog(null,"修改失败！");
                        }
    
    
    
    
                    } catch (Exception ex) {
                        ex.printStackTrace();
                    }finally {
                        if(connection!=null){
                            try {
                                Dbutil.closeConnection(connection);
                            } catch (Exception ex) {
                                ex.printStackTrace();
                            }
                        }
                    }
    
                }
            });
            btnNewButton_1.setBounds(230,240,93,25);
            btnNewButton_1.setFont(new Font("幼圆",Font.BOLD,14));
            panel_2.add(btnNewButton_1);
    
    
    
           //展示jf,并且不可改变大小
            jf.setVisible(true);
            jf.setResizable(false);
    
    
        }
    
    
    
        public void typeTableMousePressed(){
            //获取用户所选择的行索引
            int row=table.getSelectedRow();
            //拿到书的编号
            //拿这行所对应的数据  index表示第几行 0表示第一列 1表示第二列
            textField_1.setText(table.getValueAt(row,0).toString());
            textField_2.setText(table.getValueAt(row,1).toString());
            textField_3.setText(table.getValueAt(row,2).toString());
            textField_4.setText(table.getValueAt(row,3).toString());
            textField_5.setText(table.getValueAt(row,4).toString());
            textField_6.setText(table.getValueAt(row,5).toString());
            textField_7.setText(table.getValueAt(row,6).toString());
    
    
        }
    
    
        public void putDtates(UserStaff staff){
            //将获得的对应数据给数据模型对象
            DefaultTableModel model=(DefaultTableModel) table.getModel();
            model.setRowCount(0);//设置总的行数
    
            //获取链接对象
            Connection connection=null;
            try {
                connection= Dbutil.getConnection();
                //调用UserDao中的方法进行查询
                ResultSet resultSet=staffDao.list(connection,staff);
                //如果有数据的话
                while (resultSet.next()){
                    Vector rowData=new Vector();
                    //拿数据
                    rowData.add(resultSet.getInt("staff_id"));//编码1
                    rowData.add(resultSet.getString("staff_name"));//商品名称2
                    rowData.add(resultSet.getString("staff_sex"));//条形码3
                    rowData.add(resultSet.getString("staff_sfz"));//产地4
                    rowData.add(resultSet.getDate("staff_birthday"));//产商5
                    rowData.add(resultSet.getString("staff_phone"));//规格型号6
                    rowData.add(resultSet.getInt("did"));//库存7
    
    
                    //将行数据添加到数据模型中
                    model.addRow(rowData);
                }
    
            } catch (Exception e) {
                e.printStackTrace();
            }finally {
                if(connection!=null){
                    try {
                        Dbutil.closeConnection(connection);
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                }
            }
    
    
    
        }
    
    
    
        public static void main(String[] args) {
            new AddminUserinfo();
        }
    }

**实现结果如下：**

![2bd98b1ed9cb4480912e5efb5d85acf8.png][]![62a7b8a539cd4350837d1b1609cfb59b.png][]

[688c3d9247d54b94b36420c4f4271cb3.png]: https://img-blog.csdnimg.cn/688c3d9247d54b94b36420c4f4271cb3.png
[f714196150b0411ca7293f71c2d4ef3d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/bf1523ff541f4e34856b36892b5b1f7f.png
[f8e3f792171d43168580783ccb135e92.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/34697d65d8034853beb34c8c8f393639.png
[2bd98b1ed9cb4480912e5efb5d85acf8.png]: https://img-blog.csdnimg.cn/2bd98b1ed9cb4480912e5efb5d85acf8.png
[62a7b8a539cd4350837d1b1609cfb59b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/8b230efa9e1744769d3e3f79bf654628.png