養(yǎng)老院管理系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+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 `caiwutongji`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `caiwutongji` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `tongjibianhao` varchar(200) DEFAULT NULL COMMENT '統(tǒng)計(jì)編號(hào)',
? `dangyueshouru` float DEFAULT NULL COMMENT '當(dāng)月收入',
? `dangyuezhichu` float DEFAULT NULL COMMENT '當(dāng)月支出',
? `chunlirun` float DEFAULT NULL COMMENT '純利潤(rùn)',
? `dengjiriqi` date DEFAULT NULL COMMENT '登記日期',
? PRIMARY KEY (`id`),
? UNIQUE KEY `tongjibianhao` (`tongjibianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=237 DEFAULT CHARSET=utf8 COMMENT='財(cái)務(wù)統(tǒng)計(jì)';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `caiwutongji`
--
LOCK TABLES `caiwutongji` WRITE;
/*!40000 ALTER TABLE `caiwutongji` DISABLE KEYS */;
INSERT INTO `caiwutongji` VALUES (231,'2022-03-22 14:11:46','1111111111',1,1,1,'2022-03-22'),(232,'2022-03-22 14:11:46','2222222222',2,2,2,'2022-03-22'),(233,'2022-03-22 14:11:46','3333333333',3,3,3,'2022-03-22'),(234,'2022-03-22 14:11:46','4444444444',4,4,4,'2022-03-22'),(235,'2022-03-22 14:11:46','5555555555',5,5,5,'2022-03-22'),(236,'2022-03-22 14:11:46','6666666666',6,6,6,'2022-03-22');
/*!40000 ALTER TABLE `caiwutongji` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `chuangwei`
--
DROP TABLE IF EXISTS `chuangwei`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chuangwei` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `fangjianhao` varchar(200) DEFAULT NULL COMMENT '房間號(hào)',
? `loufangmingcheng` varchar(200) DEFAULT NULL COMMENT '樓房名稱',
? `chuangweihao` varchar(200) NOT NULL COMMENT '床位號(hào)',
? `chuangweizhuangtai` varchar(200) DEFAULT NULL COMMENT '床位狀態(tài)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='床位';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chuangwei`
--
LOCK TABLES `chuangwei` WRITE;
/*!40000 ALTER TABLE `chuangwei` DISABLE KEYS */;
INSERT INTO `chuangwei` VALUES (51,'2022-03-22 14:11:46','房間號(hào)1','樓房名稱1','床位號(hào)1','已使用'),(52,'2022-03-22 14:11:46','房間號(hào)2','樓房名稱2','床位號(hào)2','已使用'),(53,'2022-03-22 14:11:46','房間號(hào)3','樓房名稱3','床位號(hào)3','已使用'),(54,'2022-03-22 14:11:46','房間號(hào)4','樓房名稱4','床位號(hào)4','已使用'),(55,'2022-03-22 14:11:46','房間號(hào)5','樓房名稱5','床位號(hào)5','已使用'),(56,'2022-03-22 14:11:46','房間號(hào)6','樓房名稱6','床位號(hào)6','已使用');
/*!40000 ALTER TABLE `chuangwei` 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 `fangjianziliao`
--
DROP TABLE IF EXISTS `fangjianziliao`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fangjianziliao` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `fangjianhao` varchar(200) DEFAULT NULL COMMENT '房間號(hào)',
? `loufangmingcheng` varchar(200) DEFAULT NULL COMMENT '樓房名稱',
? `fangjianmianji` varchar(200) DEFAULT NULL COMMENT '房間面積',
? `fangjiansheshi` longtext COMMENT '房間設(shè)施',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='房間資料';
/*!40101 SET character_set_client = @saved_cs_client */;
業(yè)務(wù)邏輯代碼：
? ? /**
? ? ?* 后端列表
? ? ?*/
? ? @RequestMapping("/page")
? ? public R page(@RequestParam Map<String, Object> params,ZhuanfangdengjiEntity zhuanfangdengji,?
HttpServletRequest request){
String tableName = request.getSession().getAttribute("tableName").toString();
if(tableName.equals("jiashu")) {
zhuanfangdengji.setJiashuzhanghao((String)request.getSession().getAttribute("username"));
}
if(tableName.equals("hugong")) {
zhuanfangdengji.setHugonggonghao((String)request.getSession().getAttribute("username"));
}
? ? ? ? EntityWrapper<ZhuanfangdengjiEntity> ew = new EntityWrapper<ZhuanfangdengjiEntity>();
PageUtils page = zhuanfangdengjiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, zhuanfangdengji), params), params));
? ? ? ? return R.ok().put("data", page);
? ? }
? ??
? ? /**
? ? ?* 前端列表
? ? ?*/
@IgnoreAuth
? ? @RequestMapping("/list")
? ? public R list(@RequestParam Map<String, Object> params,ZhuanfangdengjiEntity zhuanfangdengji,?
HttpServletRequest request){
? ? ? ? EntityWrapper<ZhuanfangdengjiEntity> ew = new EntityWrapper<ZhuanfangdengjiEntity>();
PageUtils page = zhuanfangdengjiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, zhuanfangdengji), params), params));
? ? ? ? return R.ok().put("data", page);
? ? }
/**
? ? ?* 列表
? ? ?*/
? ? @RequestMapping("/lists")
? ? public R list( ZhuanfangdengjiEntity zhuanfangdengji){
? ? ? ? EntityWrapper<ZhuanfangdengjiEntity> ew = new EntityWrapper<ZhuanfangdengjiEntity>();
? ? ? ew.allEq(MPUtil.allEQMapPre( zhuanfangdengji, "zhuanfangdengji"));?
? ? ? ? return R.ok().put("data", zhuanfangdengjiService.selectListView(ew));
? ? }
/**
? ? ?* 查詢
? ? ?*/
? ? @RequestMapping("/query")
? ? public R query(ZhuanfangdengjiEntity zhuanfangdengji){
? ? ? ? EntityWrapper< ZhuanfangdengjiEntity> ew = new EntityWrapper< ZhuanfangdengjiEntity>();
? ew.allEq(MPUtil.allEQMapPre( zhuanfangdengji, "zhuanfangdengji"));?
ZhuanfangdengjiView zhuanfangdengjiView =? zhuanfangdengjiService.selectView(ew);
return R.ok("查詢轉(zhuǎn)房登記成功").put("data", zhuanfangdengjiView);
? ? }
? ? /**
? ? ?* 后端詳情
? ? ?*/
? ? @RequestMapping("/info/{id}")
? ? public R info(@PathVariable("id") Long id){
? ? ? ? ZhuanfangdengjiEntity zhuanfangdengji = zhuanfangdengjiService.selectById(id);
? ? ? ? return R.ok().put("data", zhuanfangdengji);
? ? }
? ? /**
? ? ?* 前端詳情
? ? ?*/
@IgnoreAuth
? ? @RequestMapping("/detail/{id}")
? ? public R detail(@PathVariable("id") Long id){
? ? ? ? ZhuanfangdengjiEntity zhuanfangdengji = zhuanfangdengjiService.selectById(id);
? ? ? ? return R.ok().put("data", zhuanfangdengji);
? ? }
? ??
? ? /**
? ? ?* 后端保存
? ? ?*/
? ? @RequestMapping("/save")
? ? public R save(@RequestBody ZhuanfangdengjiEntity zhuanfangdengji, HttpServletRequest request){
? ? zhuanfangdengji.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
? ? //ValidatorUtils.validateEntity(zhuanfangdengji);
? ? ? ? zhuanfangdengjiService.insert(zhuanfangdengji);
? ? ? ? return R.ok();
? ? }
? ??
? ? /**
? ? ?* 前端保存
? ? ?*/
? ? @RequestMapping("/add")
? ? public R add(@RequestBody ZhuanfangdengjiEntity zhuanfangdengji, HttpServletRequest request){
? ? zhuanfangdengji.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
? ? //ValidatorUtils.validateEntity(zhuanfangdengji);
? ? ? ? zhuanfangdengjiService.insert(zhuanfangdengji);
? ? ? ? return R.ok();
? ? }
