基于微信小程序的高校餐厅食品留样管理系统设计与实现-计算机毕业设计源码+LW文档
小程序开发说明
开发语言：Java
框架：ssm
JDK版本：JDK1.8
服务器：tomcat7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
浏览器：谷歌浏览器
小程序框架：uniapp
小程序开发软件：HBuilder X
小程序运行软件：微信开发者
数据库脚本：
DROP TABLE IF EXISTS `bingju`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bingju` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`bingjubianhao` varchar(200) DEFAULT NULL COMMENT '冰柜编号',
`bingjupinpai` varchar(200) DEFAULT NULL COMMENT '冰柜品牌',
`bingjuguige` varchar(200) DEFAULT NULL COMMENT '冰柜规格',
`bingjurongliang` varchar(200) DEFAULT NULL COMMENT '冰柜容量',
`bingjuweizhi` varchar(200) DEFAULT NULL COMMENT '冰柜位置',
`bingjubiaoqian` varchar(200) DEFAULT NULL COMMENT '冰柜标签',
PRIMARY KEY (`id`),
UNIQUE KEY `bingjubianhao` (`bingjubianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1650985154674 DEFAULT CHARSET=utf8 COMMENT='冰柜';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bingju`
--
LOCK TABLES `bingju` WRITE;
/*!40000 ALTER TABLE `bingju` DISABLE KEYS */;
INSERT INTO `bingju` VALUES (31,'2022-04-26 14:53:09','冰柜编号1','冰柜品牌1','冰柜规格1','冰柜容量1','冰柜位置1','冰柜标签1'),(32,'2022-04-26 14:53:09','冰柜编号2','冰柜品牌2','冰柜规格2','冰柜容量2','冰柜位置2','冰柜标签2'),(33,'2022-04-26 14:53:09','冰柜编号3','冰柜品牌3','冰柜规格3','冰柜容量3','冰柜位置3','冰柜标签3'),(34,'2022-04-26 14:53:09','冰柜编号4','冰柜品牌4','冰柜规格4','冰柜容量4','冰柜位置4','冰柜标签4'),(35,'2022-04-26 14:53:09','冰柜编号5','冰柜品牌5','冰柜规格5','冰柜容量5','冰柜位置5','冰柜标签5'),(36,'2022-04-26 14:53:09','冰柜编号6','冰柜品牌6','冰柜规格6','冰柜容量6','冰柜位置6','冰柜标签6'),(1650985154673,'2022-04-26 14:59:14','001','美的','100*160','60L','东食堂','基于微信小程序的高校餐厅食品留样管理系统');
/*!40000 ALTER TABLE `bingju` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `chuangkoufuzeren`
--
DROP TABLE IF EXISTS `chuangkoufuzeren`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chuangkoufuzeren` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`chuangkoubianhao` varchar(200) DEFAULT NULL COMMENT '窗口编号',
`fuzeren` varchar(200) DEFAULT NULL COMMENT '负责人',
`mima` varchar(200) DEFAULT NULL COMMENT '密码',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`),
UNIQUE KEY `chuangkoubianhao` (`chuangkoubianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1650985355380 DEFAULT CHARSET=utf8 COMMENT='窗口负责人';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chuangkoufuzeren`
--
LOCK TABLES `chuangkoufuzeren` WRITE;
/*!40000 ALTER TABLE `chuangkoufuzeren` DISABLE KEYS */;
INSERT INTO `chuangkoufuzeren` VALUES (11,'2022-04-26 14:53:09','窗口编号1','负责人1','123456','男','13823888881','upload/chuangkoufuzeren_touxiang1.jpg','否','要审核通过才能登录'),(12,'2022-04-26 14:53:09','窗口编号2','负责人2','123456','男','13823888882','upload/chuangkoufuzeren_touxiang2.jpg','是',''),(13,'2022-04-26 14:53:09','窗口编号3','负责人3','123456','男','13823888883','upload/chuangkoufuzeren_touxiang3.jpg','是',''),(14,'2022-04-26 14:53:09','窗口编号4','负责人4','123456','男','13823888884','upload/chuangkoufuzeren_touxiang4.jpg','是',''),(15,'2022-04-26 14:53:09','窗口编号5','负责人5','123456','男','13823888885','upload/chuangkoufuzeren_touxiang5.jpg','是',''),(16,'2022-04-26 14:53:09','窗口编号6','负责人6','123456','男','13823888886','upload/chuangkoufuzeren_touxiang6.jpg','是',''),(1650985355379,'2022-04-26 15:02:35','111','胡月','111','女','13612514514','upload/1650985478777.jpg','是','11');
/*!40000 ALTER TABLE `chuangkoufuzeren` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `chuangkouyuangong`
--
DROP TABLE IF EXISTS `chuangkouyuangong`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chuangkouyuangong` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '员工工号',
`yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',
`mima` varchar(200) DEFAULT NULL COMMENT '密码',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
`chuangkoubianhao` varchar(200) DEFAULT NULL COMMENT '窗口编号',
PRIMARY KEY (`id`),
UNIQUE KEY `yuangonggonghao` (`yuangonggonghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1650985500526 DEFAULT CHARSET=utf8 COMMENT='窗口员工';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chuangkouyuangong`
--
LOCK TABLES `chuangkouyuangong` WRITE;
/*!40000 ALTER TABLE `chuangkouyuangong` DISABLE KEYS */;
INSERT INTO `chuangkouyuangong` VALUES (21,'2022-04-26 14:53:09','员工工号1','员工姓名1','123456','男','13823888881','upload/chuangkouyuangong_touxiang1.jpg','窗口编号1'),(22,'2022-04-26 14:53:09','员工工号2','员工姓名2','123456','男','13823888882','upload/chuangkouyuangong_touxiang2.jpg','窗口编号2'),(23,'2022-04-26 14:53:09','员工工号3','员工姓名3','123456','男','13823888883','upload/chuangkouyuangong_touxiang3.jpg','窗口编号3'),(24,'2022-04-26 14:53:09','员工工号4','员工姓名4','123456','男','13823888884','upload/chuangkouyuangong_touxiang4.jpg','窗口编号4'),(25,'2022-04-26 14:53:09','员工工号5','员工姓名5','123456','男','13823888885','upload/chuangkouyuangong_touxiang5.jpg','窗口编号5'),(26,'2022-04-26 14:53:09','员工工号6','员工姓名6','123456','男','13823888886','upload/chuangkouyuangong_touxiang6.jpg','窗口编号6'),(1650985500525,'2022-04-26 15:05:00','222','李继军','222','男','13612512514','upload/1650985499959.jpg','111');
/*!40000 ALTER TABLE `chuangkouyuangong` ENABLE KEYS */;
业务逻辑代码：
/**
* 冰柜
* 后端接口
* @author
* @date 2022-04-26 22:52:55
*/
@RestController
@RequestMapping("/bingju")
public class BingjuController {
@Autowired
private BingjuService bingjuService;
/**
* 后端列表
*/
@RequestMapping("/page")
public R page(@RequestParam Map<String, Object> params,BingjuEntity bingju,
HttpServletRequest request){
EntityWrapper<BingjuEntity> ew = new EntityWrapper<BingjuEntity>();
PageUtils page = bingjuService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, bingju), params), params));
return R.ok().put("data", page);
}
/**
* 前端列表
*/
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params,BingjuEntity bingju,
HttpServletRequest request){
EntityWrapper<BingjuEntity> ew = new EntityWrapper<BingjuEntity>();
PageUtils page = bingjuService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, bingju), params), params));
return R.ok().put("data", page);
}
/**
* 列表
*/
@RequestMapping("/lists")
public R list( BingjuEntity bingju){
EntityWrapper<BingjuEntity> ew = new EntityWrapper<BingjuEntity>();
ew.allEq(MPUtil.allEQMapPre( bingju, "bingju"));
return R.ok().put("data", bingjuService.selectListView(ew));
}
/**
* 查询
*/
@RequestMapping("/query")
public R query(BingjuEntity bingju){
EntityWrapper< BingjuEntity> ew = new EntityWrapper< BingjuEntity>();
ew.allEq(MPUtil.allEQMapPre( bingju, "bingju"));
BingjuView bingjuView = bingjuService.selectView(ew);
return R.ok("查询冰柜成功").put("data", bingjuView);
}
/**
* 后端详情
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id){
BingjuEntity bingju = bingjuService.selectById(id);
return R.ok().put("data", bingju);
}
/**
* 前端详情
*/
@RequestMapping("/detail/{id}")
public R detail(@PathVariable("id") Long id){
BingjuEntity bingju = bingjuService.selectById(id);
return R.ok().put("data", bingju);
}
