小程序开发说明
开发语言：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);
}