# big_data

**Repository Path**: Poel/big_data

## Basic Information

- **Project Name**: big_data
- **Description**: 1.jdk11，maven3
2.java，layui，jquery，css，html
3.图片转全景，超市记账（库存，流水，统计）
4.热部署

- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2020-08-13
- **Last Updated**: 2022-07-04

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

### 项目介绍
1.jdk11，maven3
2.java，layui，jquery，css，html
3.图片六面体转全景，超市记账（库存，流水，统计）
4.热部署
端口：8086
地址：118.25.51.83:8086/
通用跳转：redirect?page=界面名称
全景：118.25.51.83:8086/redirect?page=home

###部署
查看端口占用
lsof -i:8086

kill pid

重新部署 / 后台启动并输出到
java -jar degree-1.0.0.jar > /usr/degree/log.txt &

TODO：
文件上传


###初始化SQL
stock 表结构
```
CREATE TABLE `stock` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `stock_name` varchar(100) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '库存名称',
  `stock_price` decimal(10,2) NOT NULL COMMENT '价格',
  `stock_num` int(10) NOT NULL DEFAULT '0' COMMENT '数量',
  `description` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '描述',
  `stock_img` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '图片',
  `create_time` datetime NOT NULL,
  `create_user` varchar(10) CHARACTER SET utf8mb4 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8
```
stock 数据
```
INSERT INTO `stock`(`id`, `stock_name`, `stock_price`, `stock_num`, `description`, `stock_img`, `create_time`, `create_user`) VALUES (1, '白瓷砖', 40.00, 10, '白类很', '', '2020-08-14 13:37:46', '汲强龙');
INSERT INTO `stock`(`id`, `stock_name`, `stock_price`, `stock_num`, `description`, `stock_img`, `create_time`, `create_user`) VALUES (3, '灰瓷砖', 20.00, 10, '灰类很', '', '2020-08-14 13:38:44', '汲亿伟');
INSERT INTO `stock`(`id`, `stock_name`, `stock_price`, `stock_num`, `description`, `stock_img`, `create_time`, `create_user`) VALUES (4, '大理石', 50.00, 10, '搬不动', '', '2020-08-14 13:39:39', '汲亿伟');
INSERT INTO `stock`(`id`, `stock_name`, `stock_price`, `stock_num`, `description`, `stock_img`, `create_time`, `create_user`) VALUES (5, '大瓷砖', 12.00, 12, '网干酒醉', '', '2020-09-05 00:00:00', '汲强龙');
INSERT INTO `stock`(`id`, `stock_name`, `stock_price`, `stock_num`, `description`, `stock_img`, `create_time`, `create_user`) VALUES (6, '小瓷砖', 10.00, 10, '奸商', '', '2020-09-05 00:00:00', '汲强龙');

```

record 表结构
```
CREATE TABLE `record` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `stock_id` int(10) NOT NULL COMMENT '库存表id',
  `stock_num` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '库存数量',
  `description` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注',
  `create_time` datetime NOT NULL COMMENT '创建日期',
  `create_user` varchar(10) CHARACTER SET utf8mb4 NOT NULL COMMENT '创建人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8
```


record 数据
```
INSERT INTO `record`(`id`, `stock_id`, `stock_num`, `description`, `create_time`, `create_user`) VALUES (1, 1, 253.15, '买给后汲庄老汲30块砖', '2020-08-15 12:45:21', '汲亿伟');
INSERT INTO `record`(`id`, `stock_id`, `stock_num`, `description`, `create_time`, `create_user`) VALUES (2, 4, 124.35, '卖给汲亿伟20块大理石', '2020-08-29 00:00:00', '汲强龙');
INSERT INTO `record`(`id`, `stock_id`, `stock_num`, `description`, `create_time`, `create_user`) VALUES (4, 6, 200.55, '小磁针', '2020-08-15 00:00:00', '汲亿伟');
INSERT INTO `record`(`id`, `stock_id`, `stock_num`, `description`, `create_time`, `create_user`) VALUES (5, 6, 12.50, '发达', '2020-08-20 00:00:00', '汲亿伟');

```