java swing开发进销存管理系统

此套系统首先分为五大部分，分别为登录、首页、基础数据、进销存管理、用户管理，首页为欢迎页面，基础数据下设商品管理功能模块，进销存管理下设销售单、入库单、出库单、仓库管理四个功能模块，用户管理为单独功能模块。此套系统首先分为五大部分，分别为登录、首页、基础数据、进销存管理、用户管理，首页为欢迎页面，基础数据下设商品管理功能模块，进销存管理下设销售单、入库单、出库单、仓库管理四个功能模块，用户管理为单独功能模块。

源码中有部分问题，已经修复。

运行截图

商品管理页面

项目截图

数据库截图

数据库文件

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50509
Source Host           : localhost:3306
Source Database       : salesmanagement

Target Server Type    : MYSQL
Target Server Version : 50509
File Encoding         : 65001

Date: 2017-04-19 18:59:39
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `category`
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` varchar(100) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `del_flag` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`del_flag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES ('1', '最代码', '0');

-- ----------------------------
-- Table structure for `goods`
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `id` varchar(100) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `price` double(3,2) DEFAULT NULL,
  `origin` varchar(100) DEFAULT NULL,
  `stock` double(3,2) DEFAULT NULL,
  `warehouse_id` varchar(100) DEFAULT NULL,
  `category_id` varchar(100) DEFAULT NULL,
  `del_flag` int(2) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES ('817fbfa3668446c3909bc11d9b5e0c13', 'spring mvc源码', '2.00', 'zuidaima.com', '0.00', 'e097dc68778d4ee78bb7b6b6f9401799', '1', '0');
INSERT INTO `goods` VALUES ('b8679e3e00884f318106cf7c34f71847', 'java源码', '3.00', 'zuidaiam.com', '5.00', 'e097dc68778d4ee78bb7b6b6f9401799', '1', '0');

-- ----------------------------
-- Table structure for `sale_order`
-- ----------------------------
DROP TABLE IF EXISTS `sale_order`;
CREATE TABLE `sale_order` (
  `id` varchar(100) NOT NULL,
  `bill_no` varchar(100) DEFAULT NULL,
  `amount` double(3,2) DEFAULT NULL,
  `handler_id` varchar(100) DEFAULT NULL,
  `category_id` varchar(100) DEFAULT NULL,
  `warehouse_id` varchar(100) DEFAULT NULL,
  `goods_id` varchar(100) DEFAULT NULL,
  `del_flag` int(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sale_order
-- ----------------------------
INSERT INTO `sale_order` VALUES ('db320bc2d5814563a8f901a719762ad4', '17041918530001', '2.00', '1', '1', 'e097dc68778d4ee78bb7b6b6f9401799', '817fbfa3668446c3909bc11d9b5e0c13', null);

-- ----------------------------
-- Table structure for `stock_order`
-- ----------------------------
DROP TABLE IF EXISTS `stock_order`;
CREATE TABLE `stock_order` (
  `id` varchar(100) NOT NULL,
  `bill_no` varchar(100) NOT NULL,
  `handler_id` varchar(100) NOT NULL,
  `warehouse_id` varchar(100) DEFAULT NULL,
  `category_id` varchar(100) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `goods_id` varchar(100) DEFAULT NULL,
  `sign` int(10) DEFAULT NULL,
  `del_flag` int(2) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of stock_order
-- ----------------------------
INSERT INTO `stock_order` VALUES ('2500244829bb4e6ab4c5fb71a98626bc', '17041918530002', '1', 'e097dc68778d4ee78bb7b6b6f9401799', '1', '2', '817fbfa3668446c3909bc11d9b5e0c13', '1', '0');

-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `identity` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'zuidaima', '111111', '1');

-- ----------------------------
-- Table structure for `warehouse`
-- ----------------------------
DROP TABLE IF EXISTS `warehouse`;
CREATE TABLE `warehouse` (
  `id` varchar(100) NOT NULL,
  `name` varchar(200) NOT NULL,
  `del_flag` int(2) NOT NULL DEFAULT '0',
  `sort` int(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of warehouse
-- ----------------------------
INSERT INTO `warehouse` VALUES ('e097dc68778d4ee78bb7b6b6f9401799', 'zuidaima源码', '0', null);
INSERT INTO `warehouse` VALUES ('24cf1496ebd14beebeb43850285f4e2b', 'zuidaima博客', '0', null);

由最代码官方编辑于2017-4-19 19:01:05