一、系统介绍
======
1.开发环境
开发工具:IDEA2018
JDK版本:jdk1.8
Mysql版本:8.0.13
2.技术选型
Java+Spring+SpringMVC+Mybatis+Jsp+Mysql
3.系统功能
1.用户登录系统。
2.对订单的增删改查。
3.对供应商的增删改查。
4.对用户的增删改查。
4.数据库文件
/*
Navicat Premium Data Transfer
Source Server : MYSQL
Source Server Type : MySQL
Source Server Version : 80013
Source Host : localhost:3306
Source Schema : ssm_supermarket
Target Server Type : MySQL
Target Server Version : 80013
File Encoding : 65001
Date: 03/12/2021 11:15:20
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
– Table structure for smbms_address
DROP TABLE IF EXISTS smbms_address
;
CREATE TABLE smbms_address
(
id
bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键ID’,
contact
varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT ‘联系人姓名’,
addressDesc
varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT ‘收货地址明细’,
postCode
varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT ‘邮编’,
tel
varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT ‘联系人电话’,
createdBy
bigint(20) NULL DEFAULT NULL COMMENT ‘创建者’,
creationDate
datetime NULL DEFAULT NULL COMMENT ‘创建时间’,
modifyBy
bigint(20) NULL DEFAULT NULL COMMENT ‘修改者’,
modifyDate
datetime NULL DEFAULT NULL COMMENT ‘修改时间’,
userId
bigint(20) NULL DEFAULT NULL COMMENT ‘用户ID’,
PRIMARY KEY (id
) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = DYNAMIC;
– Records of smbms_address
INSERT INTO smbms_address
VALUES (1, ‘王丽’, ‘北京市东城区东交民巷44号’, ‘100010’, ‘13678789999’, 1, ‘2016-04-13 00:00:00’, NULL, NULL, 1);
INSERT INTO smbms_address
VALUES (2, ‘张红丽’, ‘北京市海淀区丹棱街3号’, ‘100000’, ‘18567672312’, 1, ‘2016-04-13 00:00:00’, NULL, NULL, 1);
INSERT INTO smbms_address
VALUES (3, ‘任志强’, ‘北京市东城区美术馆后街23号’, ‘100021’, ‘13387906742’, 1, ‘2016-04-13 00:00:00’, NULL, NULL, 1);
INSERT INTO smbms_address
VALUES (4, ‘曹颖’, ‘北京市朝阳区朝阳门南大街14号’, ‘100053’, ‘13568902323’, 1, ‘2016-04-13 00:00:00’, NULL, NULL, 2);
INSERT INTO smbms_address
VALUES (5, ‘李慧’, ‘北京市西城区三里河路南三巷3号’, ‘100032’, ‘18032356666’, 1, ‘2016-04-13 00:00:00’, NULL, NULL, 3);
INSERT INTO smbms_address
VALUES (6, ‘王国强’, ‘北京市顺义区高丽营镇金马工业区18号’, ‘100061’, ‘13787882222’, 1, ‘2016-04-13 00:00:00’, NULL, NULL, 3);
– Table structure for smbms_bill
DROP TABLE IF EXISTS smbms_bill
;
CREATE TABLE smbms_bill
(
id
bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键ID’,
billCode
varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT ‘账单编码’,
productName
varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT ‘商品名称’,
productDesc
varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT ‘商品描述’,
productUnit
varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT ‘商品单位’,
productCount
decimal(20, 2) NULL DEFAULT NULL COMMENT ‘商品数量’,
totalPrice
decimal(20, 2) NULL DEFAULT NULL COMMENT ‘商品总额’,
isPayment
int(10) NULL DEFAULT NULL COMMENT ‘是否支付(1:未支付 2:已支付)’,
createdBy
bigint(20) NULL DEFAULT NULL COMMENT ‘创建者(userId)’,
creationDate
datetime NULL DEFAULT NULL COMMENT ‘创建时间’,
modifyBy
bigint(20) NULL DEFAULT NULL COMMENT ‘更新者(userId)’,
modifyDate
datetime NULL DEFAULT NULL COMMENT ‘更新时间’,
providerId
bigint(20) NULL DEFAULT NULL COMMENT ‘供应商ID’,
PRIMARY KEY (id
) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = DYNAMIC;
– Records of smbms_bill
INSERT INTO smbms_bill
VALUES (1, ‘BILL2016_001’, ‘洗发水、护发素’, ‘日用品-洗发、护发’, ‘瓶’, 500.00, 25000.00, 2, 1, ‘2014-12-14 13:02:03’, NULL, NULL, 13);
INSERT INTO smbms_bill
VALUES (2, ‘BILL2016_002’, ‘香皂、肥皂、药皂’, ‘日用品-皂类’, ‘块’, 1000.00, 10000.00, 2, 1, ‘2016-03-23 04:20:40’, NULL, NULL, 13);
INSERT INTO smbms_bill
VALUES (3, ‘BILL2016_003’, ‘大豆油’,