项目描述：一个简单的超市管理系统，能够实现用户登入和注册功能，共分为前台和后台两个主要界面，普通用户界面操作权限收到限制，只能对商品和销售记录进行简单查询操作，后台中可以进行商品的删除、修改、查询，可以查看用户信息，可以修改用户信息。具体的代码如下：
** 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();
}
}
实现结果如下：
本文转载自: https://blog.csdn.net/MayMarch/article/details/128046201
版权归原作者 MayMarch 所有， 如有侵权，请联系我们删除。
版权归原作者 MayMarch 所有， 如有侵权，请联系我们删除。