0
0

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

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

  ![](https://img-blog.csdnimg.cn/688c3d9247d54b94b36420c4f4271cb3.png)![](https://img-blog.csdnimg.cn/f714196150b0411ca7293f71c2d4ef3d.png)

                        ![](https://img-blog.csdnimg.cn/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();
    }
}

实现结果如下：

标签： java 开发语言 c++
本文转载自: https://blog.csdn.net/MayMarch/article/details/128046201
版权归原作者 MayMarch 所有， 如有侵权，请联系我们删除。
登录后发布评论

“JAVA结课作品——超市管理系统”的评论:

还没有评论
关于作者
...
overfit同步小助手
文章同步
相关阅读

【ESP32看这一篇就够了】ESP32-S3采用VSCode+IDF环境+入门开发(20240829)

vscode侧边工具栏不见了找回方法

Idea Maven Jar版本冲突的排查与解决

探索校企合作新模式：职业院校大数据专业实验（实训）室建设指南

Flink-Source的使用

大数据与分析：数据爬取的艺术与实践

【大数据测试spark+kafka-详细教程（附带实例）】

文章导航