一、概述
为了管理好商店库存信息，提升店铺管理工作效率，结合实际工作需要，设计和开发本系统，主要用于商店商品信息维护出入库等。包含商品库存信息查看、商品信息修改，新增商品信息，删除信息等功能。
二、功能清单
1、查询，如图
查询界面，请从数据库查询学生信息表数据并显示在控件上，通过底部功能菜单执行相应功能，添加、修改按钮点击后课弹出相应窗体执行相应操作，点击刷新按钮课刷新当前数据，删除按钮点击后可删除选中行数据并刷新
2、添加，如图
填写姓名和班级后，点击添加按钮后可添加数据
3、修改，如图
通过点击查询界面中“修改按钮”，可在修改界面修改当前选中行数据
三、数据库
注意：数据库名称为“班级_姓名”，如“1705_小白”。
表名称：tGoods
字段
四、评分规则（共100分）
实现代码：
数据库 链接: 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); } }
