扫一扫，关注我们
微信号：375279829
开发语言：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
* @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("查询结算清单成功").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();
}
客服QQ