基于微信小程序的高校餐廳食品留樣管理系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+LW文檔
小程序開發(fā)說明
開發(fā)語言：Java
框架：ssm
JDK版本：JDK1.8
服務(wù)器：tomcat7
數(shù)據(jù)庫：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫工具：Navicat11
開發(fā)軟件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
瀏覽器：谷歌瀏覽器
小程序框架：uniapp
小程序開發(fā)軟件：HBuilder X
小程序運(yùn)行軟件：微信開發(fā)者
數(shù)據(jù)庫腳本：
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 '創(chuàng)建時(shí)間',
? `bingjubianhao` varchar(200) DEFAULT NULL COMMENT '冰柜編號(hào)',
? `bingjupinpai` varchar(200) DEFAULT NULL COMMENT '冰柜品牌',
? `bingjuguige` varchar(200) DEFAULT NULL COMMENT '冰柜規(guī)格',
? `bingjurongliang` varchar(200) DEFAULT NULL COMMENT '冰柜容量',
? `bingjuweizhi` varchar(200) DEFAULT NULL COMMENT '冰柜位置',
? `bingjubiaoqian` varchar(200) DEFAULT NULL COMMENT '冰柜標(biāo)簽',
? 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','冰柜編號(hào)1','冰柜品牌1','冰柜規(guī)格1','冰柜容量1','冰柜位置1','冰柜標(biāo)簽1'),(32,'2022-04-26 14:53:09','冰柜編號(hào)2','冰柜品牌2','冰柜規(guī)格2','冰柜容量2','冰柜位置2','冰柜標(biāo)簽2'),(33,'2022-04-26 14:53:09','冰柜編號(hào)3','冰柜品牌3','冰柜規(guī)格3','冰柜容量3','冰柜位置3','冰柜標(biāo)簽3'),(34,'2022-04-26 14:53:09','冰柜編號(hào)4','冰柜品牌4','冰柜規(guī)格4','冰柜容量4','冰柜位置4','冰柜標(biāo)簽4'),(35,'2022-04-26 14:53:09','冰柜編號(hào)5','冰柜品牌5','冰柜規(guī)格5','冰柜容量5','冰柜位置5','冰柜標(biāo)簽5'),(36,'2022-04-26 14:53:09','冰柜編號(hào)6','冰柜品牌6','冰柜規(guī)格6','冰柜容量6','冰柜位置6','冰柜標(biāo)簽6'),(1650985154673,'2022-04-26 14:59:14','001','美的','100*160','60L','東食堂','基于微信小程序的高校餐廳食品留樣管理系統(tǒng)');
/*!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 '創(chuàng)建時(shí)間',
? `chuangkoubianhao` varchar(200) DEFAULT NULL COMMENT '窗口編號(hào)',
? `fuzeren` varchar(200) DEFAULT NULL COMMENT '負(fù)責(zé)人',
? `mima` varchar(200) DEFAULT NULL COMMENT '密碼',
? `xingbie` varchar(200) DEFAULT NULL COMMENT '性別',
? `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '聯(lián)系電話',
? `touxiang` varchar(200) DEFAULT NULL COMMENT '頭像',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext COMMENT '審核回復(fù)',
? PRIMARY KEY (`id`),
? UNIQUE KEY `chuangkoubianhao` (`chuangkoubianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1650985355380 DEFAULT CHARSET=utf8 COMMENT='窗口負(fù)責(zé)人';
/*!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','窗口編號(hào)1','負(fù)責(zé)人1','123456','男','13823888881','upload/chuangkoufuzeren_touxiang1.jpg','否','要審核通過才能登錄'),(12,'2022-04-26 14:53:09','窗口編號(hào)2','負(fù)責(zé)人2','123456','男','13823888882','upload/chuangkoufuzeren_touxiang2.jpg','是',''),(13,'2022-04-26 14:53:09','窗口編號(hào)3','負(fù)責(zé)人3','123456','男','13823888883','upload/chuangkoufuzeren_touxiang3.jpg','是',''),(14,'2022-04-26 14:53:09','窗口編號(hào)4','負(fù)責(zé)人4','123456','男','13823888884','upload/chuangkoufuzeren_touxiang4.jpg','是',''),(15,'2022-04-26 14:53:09','窗口編號(hào)5','負(fù)責(zé)人5','123456','男','13823888885','upload/chuangkoufuzeren_touxiang5.jpg','是',''),(16,'2022-04-26 14:53:09','窗口編號(hào)6','負(fù)責(zé)人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 '創(chuàng)建時(shí)間',
? `yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '員工工號(hào)',
? `yuangongxingming` varchar(200) DEFAULT NULL COMMENT '員工姓名',
? `mima` varchar(200) DEFAULT NULL COMMENT '密碼',
? `xingbie` varchar(200) DEFAULT NULL COMMENT '性別',
? `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '聯(lián)系電話',
? `touxiang` varchar(200) DEFAULT NULL COMMENT '頭像',
? `chuangkoubianhao` varchar(200) DEFAULT NULL COMMENT '窗口編號(hào)',
? 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','員工工號(hào)1','員工姓名1','123456','男','13823888881','upload/chuangkouyuangong_touxiang1.jpg','窗口編號(hào)1'),(22,'2022-04-26 14:53:09','員工工號(hào)2','員工姓名2','123456','男','13823888882','upload/chuangkouyuangong_touxiang2.jpg','窗口編號(hào)2'),(23,'2022-04-26 14:53:09','員工工號(hào)3','員工姓名3','123456','男','13823888883','upload/chuangkouyuangong_touxiang3.jpg','窗口編號(hào)3'),(24,'2022-04-26 14:53:09','員工工號(hào)4','員工姓名4','123456','男','13823888884','upload/chuangkouyuangong_touxiang4.jpg','窗口編號(hào)4'),(25,'2022-04-26 14:53:09','員工工號(hào)5','員工姓名5','123456','男','13823888885','upload/chuangkouyuangong_touxiang5.jpg','窗口編號(hào)5'),(26,'2022-04-26 14:53:09','員工工號(hào)6','員工姓名6','123456','男','13823888886','upload/chuangkouyuangong_touxiang6.jpg','窗口編號(hào)6'),(1650985500525,'2022-04-26 15:05:00','222','李繼軍','222','男','13612512514','upload/1650985499959.jpg','111');
/*!40000 ALTER TABLE `chuangkouyuangong` ENABLE KEYS */;
業(yè)務(wù)邏輯代碼：
/**
?* 冰柜
?* 后端接口
?* @author?
?* @email?
?* @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);
? ? }
? ??
