一、概述

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

二、功能清单

1、查询，如图

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

2、添加，如图

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

3、修改，如图

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

三、数据库

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

表名称：tGoods

字段

四、评分规则（共100分）

实现代码：

数据库 链接: http://pan-yz.chaoxing.com/share/info/3eebc979630c47f2

Java文件 链接: http://pan-yz.chaoxing.com/share/info/40efc88a5fac721c

数据库：

-- ----------------------------
-- 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;//商品IDprivate 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() {@Overridepublic void actionPerformed(ActionEvent e) {dispose();IncreaseGUL i = new IncreaseGUL();i.setVisible(true);}});JButton sc = new JButton("删除");sc.setBounds(180, 400, 100, 30);sc.addActionListener(new ActionListener() {@Overridepublic 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() {@Overridepublic 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);dispose();}}});JButton sx = new JButton("刷新");sx.setBounds(440, 400, 100, 30);sx.addActionListener(new ActionListener() {@Overridepublic 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);}@Overridepublic 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, "添加成功！");dispose();IndexGUI i = new IndexGUI();i.setVisible(true);} 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();}@Overridepublic void actionPerformed(ActionEvent e) {String sql = null;String addName = name.getText();String addType = type.getText();int addNum = Integer.parseInt(num.getText());Goods goods = new Goods(id,addName,addType,addNum);if (addName.equals("")||addType.equals("")||addNum==0) {JOptionPane.showMessageDialog(null, "请完整输入要修改的数据");
//		}else if(addName==goods.getName()||addType==goods.getTypeName()||addNum==Integer.getInteger(num.getText())){
//			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, "修改成功！");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);}
}