开发语言：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′,’空置’,'<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 ‘配置参数名称’,
`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′,'<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,’房间环境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′,’一级护理’,'<p>第三方电商发多少发送到发多少</p>’,’2022-02-16 20:24:06′,’时代发送到’,’44’,’护理姓名1′);
业务逻辑代码：
/**
* 结算清单
* 后端接口
* @author
* @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(“查询结算清单成功”).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();
}