大健康老年公寓管理系統(tǒng)設(shè)計與實現(xiàn)-計算機畢業(yè)設(shè)計源碼+LW文檔
開發(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
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫腳本：
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 '創(chuàng)建時間',
? `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 '床位狀態(tài)',
? `xiangxijieshao` longtext COMMENT '詳細介紹',
? `clicktime` datetime DEFAULT NULL COMMENT '最近點擊時間',
? `clicknum` int(11) DEFAULT '0' COMMENT '點擊次數(shù)',
? 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','空置','<p>詳細介紹1</p>','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 '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? 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 '創(chuàng)建時間',
? `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 '房間狀態(tài)',
? `kongxianchuangwei` int(11) DEFAULT NULL COMMENT '空閑床位',
? `fangjianhuanjing` longtext COMMENT '房間環(huán)境',
? `fangjianjieshao` longtext COMMENT '房間介紹',
? `clicktime` datetime DEFAULT NULL COMMENT '最近點擊時間',
? `clicknum` int(11) DEFAULT '0' COMMENT '點擊次數(shù)',
? 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,'房間環(huán)境1','<p>房間介紹1</p>','2022-02-16 20:23:14',2),(62,'2022-02-16 12:15:22','房間號2','樓層2','客房類型2','upload/fangjianxinxi_fangjiantupian2.jpg','房間面積2','已滿',2,'房間環(huán)境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,'房間環(huán)境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,'房間環(huán)境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,'房間環(huán)境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,'房間環(huán)境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 '創(chuàng)建時間',
? `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 '護理內(nèi)容',
? `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','特級護理','護理內(nèi)容1','2022-02-16 20:15:22','備注1','護理賬號1','護理姓名1'),(132,'2022-02-16 12:15:22','姓名2','年齡2','手機2','特級護理','護理內(nèi)容2','2022-02-16 20:15:22','備注2','護理賬號2','護理姓名2'),(133,'2022-02-16 12:15:22','姓名3','年齡3','手機3','特級護理','護理內(nèi)容3','2022-02-16 20:15:22','備注3','護理賬號3','護理姓名3'),(134,'2022-02-16 12:15:22','姓名4','年齡4','手機4','特級護理','護理內(nèi)容4','2022-02-16 20:15:22','備注4','護理賬號4','護理姓名4'),(135,'2022-02-16 12:15:22','姓名5','年齡5','手機5','特級護理','護理內(nèi)容5','2022-02-16 20:15:22','備注5','護理賬號5','護理姓名5'),(136,'2022-02-16 12:15:22','姓名6','年齡6','手機6','特級護理','護理內(nèi)容6','2022-02-16 20:15:22','備注6','護理賬號6','護理姓名6'),(1645014250411,'2022-02-16 12:24:10','你好','年齡1','13823888881','一級護理','<p>第三方電商發(fā)多少發(fā)送到發(fā)多少</p>','2022-02-16 20:24:06','時代發(fā)送到','44','護理姓名1');
業(yè)務(wù)邏輯代碼：
/**
?* 結(jié)算清單
?* 后端接口
?* @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<JiesuanqingdanEntity> ew = new EntityWrapper<JiesuanqingdanEntity>();
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<JiesuanqingdanEntity> ew = new EntityWrapper<JiesuanqingdanEntity>();
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<JiesuanqingdanEntity> ew = new EntityWrapper<JiesuanqingdanEntity>();
? ? ? 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("查詢結(jié)算清單成功").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();
? ? }
