基于微信小程序的高校餐厅食品留样管理系统-计算机毕业设计源码

小程序开发说明

开发语言：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 ‘头像’,

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 */;

/*!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

* @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);

}