Java Swing设计简单商品信息管理系统(java swing+mysql+eclipse)

一、概述

为了管理好商店库存信息，提升店铺管理工作效率，结合实际工作需要，设计和开发本系统，主要用于商店商品信息维护出入库等。包含商品库存信息查看、商品信息修改，新增商品信息，删除信息等功能。

二、功能清单

​​1、查询，如图​​

查询界面，请从数据库查询学生信息表数据并显示在控件上，通过底部功能菜单执行相应功能，添加、修改按钮点击后课弹出相应窗体执行相应操作，点击刷新按钮课刷新当前数据，删除按钮点击后可删除选中行数据并刷新

​​2、添加，如图​​

填写姓名和班级后，点击添加按钮后可添加数据

​​3、修改，如图​​

通过点击查询界面中“修改按钮”，可在修改界面修改当前选中行数据

三、数据库

注意：数据库名称为“班级_姓名”，如“1705_小白”。

表名称：tGoods

字段

字段名	数据类型	描述	约束
goodsID	int	商品编号	主键自增长
name	varchar(20)	商品名称
typeName	varchar(20)	类别名称
stock	Int	库存

四、评分规则（共100分）

标题	分值
合理注释	10分
命名规范	10分
查询	20分
修改	10分
删除	10分
添加	10分
数据库创建	10分
数据库连接	10分
整体效果	10分

实现代码：

数据库 链接: https://pan-yz.chaoxing.com/external/m/file/483246110958415872

Java文件 链接: https://pan-yz.chaoxing.com/external/m/file/483246085097291776

数据库：

-- ----------------------------
-- Table structure for tgoods
-- ----------------------------
DROP TABLE IF EXISTS `tgoods`;
CREATE TABLE `tgoods` (
  `goodsID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `typeName` varchar(20) DEFAULT NULL,
  `stock` int(11) DEFAULT NULL,
  PRIMARY KEY (`goodsID`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tgoods
-- ----------------------------
INSERT INTO `tgoods` VALUES ('9', '统一冰红茶', '饮料', '24');
INSERT INTO `tgoods` VALUES ('10', '娃哈哈营养快线', '饮料', '23');

com.test.db >>> DbConnection

package com.test.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.jdbc.Statement;

public class DbConnection {
    //驱动类的类名
    private static final String DRIVERNAME="com.mysql.jdbc.Driver";
    //连接数据的URL路径
    private static final String URL="jdbc:mysql://localhost:3306/1902_杨明金";
    //数据库登录账号
    private static final String USER="root";
    //数据库登录密码
    private static final String PASSWORD="root123";
    //加载驱动
    static{
        try {
            Class.forName(DRIVERNAME);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
    //获取数据库连接
    public static Connection getConnection() {
              try {
        return DriverManager.getConnection(URL,USER,PASSWORD);
               } catch (SQLException e) {   
        e.printStackTrace();
               }
            return null;
    }
    //查询
    public static ResultSet query(String sql) {
        System.out.println(sql);
        //获取连接
        Connection connection=getConnection();
        PreparedStatement psd;
        try {
            psd = connection.prepareStatement(sql);
            return psd.executeQuery();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }
    //增、删、改、查
        public static int updataInfo(String sql) {
            System.out.println(sql);
            //获取连接
            Connection connection=getConnection();
            try {
                PreparedStatement psd=connection.prepareStatement(sql);
                return psd.executeUpdate();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            return 0;
        }
    //关闭连接
    public  static  void colse(ResultSet rs,Statement stmt,Connection  conn) throws Exception{
              try { if (rs != null){ rs.close(); }
                             if (stmt != null) { stmt.cancel(); }
         if (conn != null) { conn.close(); }
       } catch (Exception e) {
           e.printStackTrace(); throw new Exception();
       }
    }
}

com.test.entity >>> Goods

package com.test.entity;

public class Goods {
  private int goodsID;//商品ID
  private String name;//商品名称
  private String typeName;//商品类别
  private int stock;//库存

  public Goods(int goodsID, String name, String typeName, int stock) {
    super();
    this.goodsID = goodsID;
    this.name = name;
    this.typeName = typeName;
    this.stock = stock;
  }

  public Goods() {
    super();
  }

  public int getGoodsID() {
    return goodsID;
  }

  public void setGoodsID(int goodsID) {
    this.goodsID = goodsID;
  }

  public String getName() {
    return name;
  }

  public void setName(String name) {
    this.name = name;
  }

  public String getTypeName() {
    return typeName;
  }

  public void setTypeName(String typeName) {
    this.typeName = typeName;
  }

  public int getStock() {
    return stock;
  }

  public void setStock(int stock) {
    this.stock = stock;
  }

}

com.test.controller >>> Updata

package com.test.controller;

import com.test.db.DbConnection;

public class Updata {
  //添加数据
  public static int addData(String sql) {

    return DbConnection.updataInfo(sql);
  }
}

com.test.controller >>> Select

package com.test.controller;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import com.test.db.DbConnection;
import com.test.entity.Goods;

public class Select {
  public static Object[][] getGoods() {
    String sql = "SELECT * FROM tgoods";

    ResultSet resultSet = DbConnection.query(sql);
    ArrayList<Goods> list=new ArrayList<Goods>();
    try {
      while (resultSet.next()) {
        Goods goods=new Goods();
        goods.setGoodsID(resultSet.getInt(1));
        goods.setName(resultSet.getString(2));
        goods.setTypeName(resultSet.getString(3));
        goods.setStock(resultSet.getInt(4));
        list.add(goods);
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
    Object[][] objects=new Object[list.size()][4];
    for(int i=0;i<list.size();i++) {
      objects[i][0]=list.get(i).getGoodsID();
      objects[i][1]=list.get(i).getName();
      objects[i][2]=list.get(i).getTypeName();
      objects[i][3]=list.get(i).getStock();
    }
    return objects;
  }

}

com.test.View >>> IndexGUI

package com.test.view;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;

import com.test.controller.Select;
import com.test.controller.Updata;
import com.test.entity.Goods;

public class IndexGUI extends JFrame {

  Object[] columnNames = {"商品编号","名称","类别名称","库存"};
  Object[][] data = Select.getGoods();
  DefaultTableModel df = new DefaultTableModel(data, columnNames);

  public IndexGUI() {
    super("商品信息管理");
    this.setBounds(0, 0, 780, 500);
    this.setLocationRelativeTo(null);//让窗口在屏幕中间显示
    this.setResizable(false);//让窗口大小不可改变
    this.setLayout(null);

    JTable jTable=new JTable(df);
    JScrollPane jp = new JScrollPane(jTable);
    jp.setBounds(0, 10, 780, 350);
    this.add(jp);

    JButton tj = new JButton("添加");
    tj.setBounds(50, 400, 100, 30);
    tj.addActionListener(new ActionListener() {
      @Override
      public void actionPerformed(ActionEvent e) {
        IncreaseGUL i = new IncreaseGUL();
        i.setVisible(true);
      }
    });

    JButton sc = new JButton("删除");
    sc.setBounds(180, 400, 100, 30);
    sc.addActionListener(new ActionListener() {
      @Override
      public void actionPerformed(ActionEvent e) {
        if (jTable.getSelectedColumn()<0) {
          JOptionPane.showMessageDialog(null, "请选中要删除的数据！");
        } else {
          int goodsID = Integer.parseInt(jTable.getValueAt(jTable.getSelectedRow(), 0).toString());
          String sql="delete from tgoods where goodsid="+goodsID;
          Updata updata = new Updata();
          int result = updata.addData(sql);
          if (result>0) {
            JOptionPane.showMessageDialog(null, "删除成功！");
            JOptionPane.showMessageDialog(null, "记得刷新一下哦！");
          } else {
            JOptionPane.showMessageDialog(null, "删除失败！");
          }
        }
      }
    });

    JButton xg = new JButton("修改");
    xg.setBounds(310, 400, 100, 30);
    xg.addActionListener(new ActionListener() {
      @Override
      public void actionPerformed(ActionEvent e) {
        if (jTable.getSelectedColumn()<0) {
          JOptionPane.showMessageDialog(null, "请选择要修改的数据！");
        } else {
          int goodsID = Integer.parseInt(jTable.getValueAt(jTable.getSelectedRow(), 0).toString());
          String name = jTable.getValueAt(jTable.getSelectedRow(), 1).toString();
          String typeName = jTable.getValueAt(jTable.getSelectedRow(), 2).toString();
          int stock = Integer.parseInt(jTable.getValueAt(jTable.getSelectedRow(), 3).toString());
          Goods goods = new Goods(goodsID,name,typeName,stock);
          ModifyGUI modifyGUI = new ModifyGUI(goods);
          modifyGUI.setVisible(true);
        }

      }
    });

    JButton sx = new JButton("刷新");
    sx.setBounds(440, 400, 100, 30);
    sx.addActionListener(new ActionListener() {
      @Override
      public void actionPerformed(ActionEvent e) {
        Object[][] data = Select.getGoods();
        df.setDataVector(data, columnNames);
      }
    });

    this.add(tj);
    this.add(sc);
    this.add(xg);
    this.add(sx);
  }

}

com.test.View >>> IncreaseGUL

package com.test.view;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;

import com.test.controller.Updata;

public class IncreaseGUL extends JFrame implements ActionListener {
  JTextField name = new JTextField();
  JTextField type = new JTextField();
  JTextField num = new JTextField();
  public IncreaseGUL() {
    super.setTitle("添加商品");
    this.setBounds(0, 0, 780, 250);
    this.setLocationRelativeTo(null);
    this.setResizable(false);
    this.setLayout(null);

    JLabel nameT = new JLabel("名称");
    nameT.setBounds(50, 30, 40, 25);
    name.setBounds(100, 30, 145, 30);

    JLabel typeT = new JLabel("类别");
    typeT.setBounds(280, 30, 40, 25);
    type.setBounds(335, 30, 145, 30);

    JLabel numT = new JLabel("数量");
    numT.setBounds(515, 30, 40, 25);
    num.setBounds(575, 30, 145, 30);

    JButton tj = new JButton("添加");
    tj.setBounds(100, 115, 100, 30);
    tj.addActionListener(this);

    this.add(nameT);
    this.add(name);
    this.add(typeT);
    this.add(type);
    this.add(numT);
    this.add(num);
    this.add(tj);
  }

  @Override
  public void actionPerformed(ActionEvent e) {
    String sql = null;
    String addName = name.getText();
    String addType = type.getText();
    String addNum = num.getText();
    if (addName.equals("")||addType.equals("")||addNum.equals("")) {
      JOptionPane.showMessageDialog(null, "请完整输入要添加的数据");
    } else {
      sql="INSERT INTO tgoods VALUES("+"null,'"+addName+"','"+addType+"','"+addNum+"')";
      int result = Updata.addData(sql);
      if (result>0) {
        JOptionPane.showMessageDialog(null, "添加成功！");
                JOptionPane.showMessageDialog(null, "记得刷新一下哦！");
        dispose();
        IndexGUI i = new IndexGUI();
      } else {
        JOptionPane.showMessageDialog(null, "添加失败！");
      }
    }
  }
}

com.test.View >>> ModifyGUI

package com.test.view;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import com.test.controller.Updata;
import com.test.entity.Goods;

public class ModifyGUI extends JFrame implements ActionListener {

  JTextField name = new JTextField();
  JTextField type = new JTextField();
  JTextField num = new JTextField();
  int id;
  public ModifyGUI(Goods goods) {
    super.setTitle("修改商品");
    this.setBounds(0, 0, 780, 250);
    this.setLocationRelativeTo(null);
    this.setLayout(null);

    JLabel nameT = new JLabel("名称");
    nameT.setBounds(50, 30, 40, 25);
    name.setBounds(100, 30, 145, 30);

    JLabel typeT = new JLabel("类别");
    typeT.setBounds(280, 30, 40, 25);
    type.setBounds(335, 30, 145, 30);

    JLabel numT = new JLabel("库存");
    numT.setBounds(515, 30, 40, 25);
    num.setBounds(575, 30, 145, 30);

    JButton xg = new JButton("修改");
    xg.setBounds(100, 115, 100, 30);
    xg.addActionListener(this);

    this.add(nameT);
    this.add(name);
    this.add(typeT);
    this.add(type);
    this.add(numT);
    this.add(num);
    this.add(xg);

    name.setText(goods.getName());
    type.setText(goods.getTypeName());
    num.setText(Integer.toString(goods.getStock()));
    id = goods.getGoodsID();
  }

  @Override
  public void actionPerformed(ActionEvent e) {
    String sql = null;
    String addName = name.getText();
    String addType = type.getText();
    int addNum = Integer.parseInt(num.getText());
    if (addName.equals("")||addType.equals("")||addNum==0) {
      JOptionPane.showMessageDialog(null, "请完整输入要修改的数据");
    }else {
      Updata up=new Updata();

      sql="UPDATE tgoods SET "+"name='"+addName+"',typeName='"+addType+"',stock='"+addNum+"'where goodsid="+id;
      int result = Updata.addData(sql);
      Updata.addData(sql);
      if (result>0) {
        JOptionPane.showMessageDialog(null, "修改成功！");
                JOptionPane.showMessageDialog(null, "记得刷新一下哦！");
        dispose();
        IndexGUI i = new IndexGUI();
        i.setVisible(true);
      } else {
        JOptionPane.showMessageDialog(null, "修改失败！");
      }
    }
  }
}

com.test.Test >>> Test

package com.test.Test;

import com.test.view.IndexGUI;

public class Test {
  public static void main(String[] args) {
    IndexGUI i = new IndexGUI();
    i.setVisible(true);
  }
}