• 大健康老年公寓管理系统设计与实现-计算机毕业设计源码+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 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 ew = new 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 params,JiesuanqingdanEntity jiesuanqingdan, 
            HttpServletRequest request){
            EntityWrapper ew = new 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 = new 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();
        }

     

     

     

  • 相关阅读:
    STM32CubeMX教程29 USB_HOST - 使用FatFs文件系统读写U盘
    微信小程序 蓝牙打印esc编码格式
    flutter iOS 缺少通知权限,缺少位置权限
    为何学linux及用处
    Redis入门到实战教程(基础篇)笔记
    LVS+Keepalived 高可用负载均衡集群
    ADB 命令大全
    别惊讶,我真的不建议你考华为认证,点进来看原因~
    Apache Doris 2.0.1 & 1.2.7 版本正式发布!
    Golang interface 接口详细原理和使用技巧
  • 原文地址:https://blog.csdn.net/qq_375279829/article/details/126880866