大健康老年公寓管理系统的开发与实现 - 计算机毕业设计源代码及LW文档

开发语言：Java 框架：ssm JDK版本：JDK1.8 服务器：tomcat7 数据库：mysql 5.7（一定要5.7版本） 数据库工具：Navicat11 开发软件：eclipse/myeclipse/idea Maven包：Maven3.3.9 浏览器：谷歌浏览器

数据库脚本：

DROP TABLE IF EXISTS ​​chuangweixinxi​​; /*!40101 SET @saved_cs_client = @@character_set_client /; /!40101 SET character_set_client = utf8 /; CREATE TABLE ​​chuangweixinxi​​​ ( ​​id​​ bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', ​​​addtime​​​ timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', ​​​fangjianhao​​​ varchar(200) DEFAULT NULL COMMENT '房间号', ​​​chuangweihao​​​ varchar(200) NOT NULL COMMENT '床位号', ​​​tupian​​​ varchar(200) DEFAULT NULL COMMENT '图片', ​​​weizhi​​​ varchar(200) DEFAULT NULL COMMENT '位置', ​​​chuangweizhuangtai​​​ varchar(200) DEFAULT NULL COMMENT '床位状态', ​​​xiangxijieshao​​​ longtext COMMENT '详细介绍', ​​​clicktime​​​ datetime DEFAULT NULL COMMENT '最近点击时间', ​​​clicknum​​​ int(11) DEFAULT '0' COMMENT '点击次数', PRIMARY KEY (​​​id​​​), UNIQUE KEY ​​​chuangweihao​​​ (​​​chuangweihao​​​) ) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='床位信息'; /!40101 SET character_set_client = @saved_cs_client */;

-- -- Dumping data for table ​​chuangweixinxi​​ --

LOCK TABLES ​​chuangweixinxi​​ WRITE; /*!40000 ALTER TABLE ​​chuangweixinxi​​ DISABLE KEYS /; INSERT INTO ​​chuangweixinxi​​​ VALUES (71,'2022-02-16 12:15:22','305','床位号1','upload/chuangweixinxi_tupian1.jpg','位置1','空置','

详细介绍1

','2022-02-16 20:23:21',2),(72,'2022-02-16 12:15:22','房间号2','床位号2','upload/chuangweixinxi_tupian2.jpg','位置2','空置','详细介绍2','2022-02-16 20:15:22',2),(73,'2022-02-16 12:15:22','房间号3','床位号3','upload/chuangweixinxi_tupian3.jpg','位置3','空置','详细介绍3','2022-02-16 20:15:22',3),(74,'2022-02-16 12:15:22','房间号4','床位号4','upload/chuangweixinxi_tupian4.jpg','位置4','空置','详细介绍4','2022-02-16 20:15:22',4),(75,'2022-02-16 12:15:22','房间号5','床位号5','upload/chuangweixinxi_tupian5.jpg','位置5','空置','详细介绍5','2022-02-16 20:15:22',5),(76,'2022-02-16 12:15:22','房间号6','床位号6','upload/chuangweixinxi_tupian6.jpg','位置6','空置','详细介绍6','2022-02-16 20:15:22',6); /!40000 ALTER TABLE ​​chuangweixinxi​​ ENABLE KEYS */;

UNLOCK TABLES;

-- -- Table structure for table ​​config​​ --

DROP TABLE IF EXISTS ​​config​​; /*!40101 SET @saved_cs_client = @@character_set_client /; /!40101 SET character_set_client = utf8 /; CREATE TABLE ​​config​​​ ( ​​id​​ bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', ​​​name​​​ varchar(100) NOT NULL COMMENT '配置参数名称', ​​​value​​​ varchar(100) DEFAULT NULL COMMENT '配置参数值', PRIMARY KEY (​​​id​​​) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件'; /!40101 SET character_set_client = @saved_cs_client */;

-- -- Dumping data for table ​​config​​ --

LOCK TABLES ​​config​​ WRITE; /*!40000 ALTER TABLE ​​config​​ DISABLE KEYS /; INSERT INTO ​​config​​​ VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg'); /!40000 ALTER TABLE ​​config​​ ENABLE KEYS */; UNLOCK TABLES;

-- -- Table structure for table ​​fangjianxinxi​​ --

DROP TABLE IF EXISTS ​​fangjianxinxi​​; /*!40101 SET @saved_cs_client = @@character_set_client /; /!40101 SET character_set_client = utf8 /; CREATE TABLE ​​fangjianxinxi​​​ ( ​​id​​ bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', ​​​addtime​​​ timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', ​​​fangjianhao​​​ varchar(200) NOT NULL COMMENT '房间号', ​​​louceng​​​ varchar(200) DEFAULT NULL COMMENT '楼层', ​​​kefangleixing​​​ varchar(200) DEFAULT NULL COMMENT '客房类型', ​​​fangjiantupian​​​ varchar(200) DEFAULT NULL COMMENT '房间图片', ​​​fangjianmianji​​​ varchar(200) DEFAULT NULL COMMENT '房间面积', ​​​fangjianzhuangtai​​​ varchar(200) DEFAULT NULL COMMENT '房间状态', ​​​kongxianchuangwei​​​ int(11) DEFAULT NULL COMMENT '空闲床位', ​​​fangjianhuanjing​​​ longtext COMMENT '房间环境', ​​​fangjianjieshao​​​ longtext COMMENT '房间介绍', ​​​clicktime​​​ datetime DEFAULT NULL COMMENT '最近点击时间', ​​​clicknum​​​ int(11) DEFAULT '0' COMMENT '点击次数', PRIMARY KEY (​​​id​​​) ) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='房间信息'; /!40101 SET character_set_client = @saved_cs_client */;

-- -- Dumping data for table ​​fangjianxinxi​​ --

LOCK TABLES ​​fangjianxinxi​​ WRITE; /*!40000 ALTER TABLE ​​fangjianxinxi​​ DISABLE KEYS /; INSERT INTO ​​fangjianxinxi​​​ VALUES (61,'2022-02-16 12:15:22','305','楼层1','客房类型1','upload/fangjianxinxi_fangjiantupian1.jpg','房间面积1','已满',1,'房间环境1','

房间介绍1

','2022-02-16 20:23:14',2),(62,'2022-02-16 12:15:22','房间号2','楼层2','客房类型2','upload/fangjianxinxi_fangjiantupian2.jpg','房间面积2','已满',2,'房间环境2','房间介绍2','2022-02-16 20:15:22',2),(63,'2022-02-16 12:15:22','房间号3','楼层3','客房类型3','upload/fangjianxinxi_fangjiantupian3.jpg','房间面积3','已满',3,'房间环境3','房间介绍3','2022-02-16 20:15:22',3),(64,'2022-02-16 12:15:22','房间号4','楼层4','客房类型4','upload/fangjianxinxi_fangjiantupian4.jpg','房间面积4','已满',4,'房间环境4','房间介绍4','2022-02-16 20:15:22',4),(65,'2022-02-16 12:15:22','房间号5','楼层5','客房类型5','upload/fangjianxinxi_fangjiantupian5.jpg','房间面积5','已满',5,'房间环境5','房间介绍5','2022-02-16 20:15:22',5),(66,'2022-02-16 12:15:22','房间号6','楼层6','客房类型6','upload/fangjianxinxi_fangjiantupian6.jpg','房间面积6','已满',6,'房间环境6','房间介绍6','2022-02-16 20:15:22',6); /!40000 ALTER TABLE ​​fangjianxinxi​​ ENABLE KEYS */;

UNLOCK TABLES;

-- -- Table structure for table ​​hulijilu​​ --

DROP TABLE IF EXISTS ​​hulijilu​​; /*!40101 SET @saved_cs_client = @@character_set_client /; /!40101 SET character_set_client = utf8 /; CREATE TABLE ​​hulijilu​​​ ( ​​id​​ bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', ​​​addtime​​​ timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', ​​​xingming​​​ varchar(200) DEFAULT NULL COMMENT '姓名', ​​​nianling​​​ varchar(200) DEFAULT NULL COMMENT '年龄', ​​​shouji​​​ varchar(200) DEFAULT NULL COMMENT '手机', ​​​hulidengji​​​ varchar(200) DEFAULT NULL COMMENT '护理等级', ​​​hulineirong​​​ longtext COMMENT '护理内容', ​​​hulishijian​​​ datetime DEFAULT NULL COMMENT '护理时间', ​​​beizhu​​​ varchar(200) DEFAULT NULL COMMENT '备注', ​​​hulizhanghao​​​ varchar(200) DEFAULT NULL COMMENT '护理账号', ​​​hulixingming​​​ varchar(200) DEFAULT NULL COMMENT '护理姓名', PRIMARY KEY (​​​id​​​) ) ENGINE=InnoDB AUTO_INCREMENT=1645014250412 DEFAULT CHARSET=utf8 COMMENT='护理记录'; /!40101 SET character_set_client = @saved_cs_client */;

-- -- Dumping data for table ​​hulijilu​​ --

LOCK TABLES ​​hulijilu​​ WRITE; /*!40000 ALTER TABLE ​​hulijilu​​ DISABLE KEYS */; INSERT INTO ​​hulijilu​​ VALUES (131,'2022-02-16 12:15:22','姓名1','年龄1','手机1','特级护理','护理内容1','2022-02-16 20:15:22','备注1','护理账号1','护理姓名1'),(132,'2022-02-16 12:15:22','姓名2','年龄2','手机2','特级护理','护理内容2','2022-02-16 20:15:22','备注2','护理账号2','护理姓名2'),(133,'2022-02-16 12:15:22','姓名3','年龄3','手机3','特级护理','护理内容3','2022-02-16 20:15:22','备注3','护理账号3','护理姓名3'),(134,'2022-02-16 12:15:22','姓名4','年龄4','手机4','特级护理','护理内容4','2022-02-16 20:15:22','备注4','护理账号4','护理姓名4'),(135,'2022-02-16 12:15:22','姓名5','年龄5','手机5','特级护理','护理内容5','2022-02-16 20:15:22','备注5','护理账号5','护理姓名5'),(136,'2022-02-16 12:15:22','姓名6','年龄6','手机6','特级护理','护理内容6','2022-02-16 20:15:22','备注6','护理账号6','护理姓名6'),(1645014250411,'2022-02-16 12:24:10','你好','年龄1','13823888881','一级护理','

第三方电商发多少发送到发多少

','2022-02-16 20:24:06','时代发送到','44','护理姓名1');

业务逻辑代码：

/**

• 结算清单
• 后端接口
• @author
• @email
• @date 2022-02-16 20:15:07 */ @RestController @RequestMapping("/jiesuanqingdan") public class JiesuanqingdanController { @Autowired private JiesuanqingdanService jiesuanqingdanService;
  /**

• 后端列表 */ @RequestMapping("/page") public R page(@RequestParam Map<String, Object> params,JiesuanqingdanEntity jiesuanqingdan, HttpServletRequest request){
  String tableName = request.getSession().getAttribute("tableName").toString(); if(tableName.equals("laoren")) { jiesuanqingdan.setXingming((String)request.getSession().getAttribute("username")); } if(tableName.equals("shoufeirenyuan")) { jiesuanqingdan.setShoufeizhanghao((String)request.getSession().getAttribute("username")); } EntityWrapper(); PageUtils page = jiesuanqingdanService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, jiesuanqingdan), params), params)); return R.ok().put("data", page); }

/**

• 前端列表 */ @IgnoreAuth @RequestMapping("/list") public R list(@RequestParam Map<String, Object> params,JiesuanqingdanEntity jiesuanqingdan, HttpServletRequest request){ EntityWrapper(); PageUtils page = jiesuanqingdanService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, jiesuanqingdan), params), params)); return R.ok().put("data", page); }

/**

• 列表 */ @RequestMapping("/lists") public R list( JiesuanqingdanEntity jiesuanqingdan){ EntityWrapper(); ew.allEq(MPUtil.allEQMapPre( jiesuanqingdan, "jiesuanqingdan")); return R.ok().put("data", jiesuanqingdanService.selectListView(ew)); }

/**

• 查询 */ @RequestMapping("/query") public R query(JiesuanqingdanEntity jiesuanqingdan){ EntityWrapper< JiesuanqingdanEntity> ew = new EntityWrapper< JiesuanqingdanEntity>(); ew.allEq(MPUtil.allEQMapPre( jiesuanqingdan, "jiesuanqingdan")); JiesuanqingdanView jiesuanqingdanView = jiesuanqingdanService.selectView(ew); return R.ok("查询结算清单成功").put("data", jiesuanqingdanView); }

/**

• 后端详情 */ @RequestMapping("/info/{id}") public R info(@PathVariable("id") Long id){ JiesuanqingdanEntity jiesuanqingdan = jiesuanqingdanService.selectById(id); return R.ok().put("data", jiesuanqingdan); }

/**

• 前端详情 */ @IgnoreAuth @RequestMapping("/detail/{id}") public R detail(@PathVariable("id") Long id){ JiesuanqingdanEntity jiesuanqingdan = jiesuanqingdanService.selectById(id); return R.ok().put("data", jiesuanqingdan); }

/**

• 后端保存 */ @RequestMapping("/save") public R save(@RequestBody JiesuanqingdanEntity jiesuanqingdan, HttpServletRequest request){ jiesuanqingdan.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());//ValidatorUtils.validateEntity(jiesuanqingdan);
  jiesuanqingdanService.insert(jiesuanqingdan); return R.ok(); }

/**

• 前端保存 */ @RequestMapping("/add") public R add(@RequestBody JiesuanqingdanEntity jiesuanqingdan, HttpServletRequest request){ jiesuanqingdan.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());​​//ValidatorUtils.validateEntity​​(jiesuanqingdan);
  jiesuanqingdanService.insert(jiesuanqingdan); return R.ok(); }