深圳哪家网站建设的公司好,摄影赚钱的网站,icp wordpress 模板,电子商务网站建设初学视频教程#x1f34a;作者#xff1a;计算机编程-吉哥 #x1f34a;简介#xff1a;专业从事JavaWeb程序开发#xff0c;微信小程序开发#xff0c;定制化项目、 源码、代码讲解、文档撰写、ppt制作。做自己喜欢的事#xff0c;生活就是快乐的。 #x1f34a;心愿#xff1a;点… 作者计算机编程-吉哥 简介专业从事JavaWeb程序开发微信小程序开发定制化项目、 源码、代码讲解、文档撰写、ppt制作。做自己喜欢的事生活就是快乐的。 心愿点赞 收藏 ⭐评论 文末获取源码联系 精彩专栏推荐订阅 不然下次找不到哟~Java毕业设计项目~热门选题推荐《1000套》 目录 1.技术选型
2.数据库表结构
3.开发工具
4.功能
4.1【角色】
4.2【前台功能模块】
4.3【后台功能模块】
5.项目演示截图
5.1 登录
5.2 个人中心
5.3 健康信息
5.4 监控信息详情
5.5 交友互动
5.6 远程求助
5.7 老人信息管理
5.8 监控信息管理
5.9 健康信息管理
5.10 费用收缴管理
6.数据库文件设计
7.核心代码
7.1 健康信息Controller
7.2 健康信息Service
7.3 健康信息ServiceImpl
7.4 健康信息DAO
8.参考文档 1.技术选型
springboot、mybatisplus、vue、elementui、html、css、js、mysql、jdk1.8
2.数据库表结构
10张
3.开发工具
idea、navicat
4.功能
4.1【角色】
管理员、用户
4.2【前台功能模块】
登录注册首页监控信息交友互动公告信息个人中心后台管理远程求助
4.3【后台功能模块】
登录首页个人中心老人信息管理监控信息管理健康信息管理费用收缴管理交友互动系统管理
5.项目演示截图 5.1 登录 5.2 个人中心 5.3 健康信息 5.4 监控信息详情 5.5 交友互动 5.6 远程求助 5.7 老人信息管理 5.8 监控信息管理 5.9 健康信息管理 5.10 费用收缴管理 6.数据库文件设计
CREATE TABLE chat (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,userid bigint(20) NOT NULL COMMENT 用户id,adminid bigint(20) DEFAULT NULL COMMENT 管理员id,ask longtext COMMENT 提问,reply longtext COMMENT 回复,isreply int(11) DEFAULT NULL COMMENT 是否回复,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT57 DEFAULT CHARSETutf8 COMMENT远程求助;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)
) ENGINEInnoDB AUTO_INCREMENT4 DEFAULT CHARSETutf8 COMMENT配置文件;CREATE TABLE feiyongshoujiao (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,jiaofeidanhao varchar(200) DEFAULT NULL COMMENT 缴费单号,jiaofeimingcheng varchar(200) DEFAULT NULL COMMENT 缴费名称,jiaofeileixing varchar(200) NOT NULL COMMENT 缴费类型,jiaofeijine int(11) NOT NULL COMMENT 缴费金额,jiaofeineirong longtext COMMENT 缴费内容,xinxibeizhu varchar(200) DEFAULT NULL COMMENT 信息备注,laorenxingming varchar(200) DEFAULT NULL COMMENT 老人姓名,xingbie varchar(200) DEFAULT NULL COMMENT 性别,lianxidianhua varchar(200) DEFAULT NULL COMMENT 联系电话,ispay varchar(200) DEFAULT 未支付 COMMENT 是否支付,PRIMARY KEY (id),UNIQUE KEY jiaofeidanhao (jiaofeidanhao)
) ENGINEInnoDB AUTO_INCREMENT47 DEFAULT CHARSETutf8 COMMENT费用收缴;CREATE TABLE forum (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,title varchar(200) DEFAULT NULL COMMENT 帖子标题,content longtext NOT NULL COMMENT 帖子内容,parentid bigint(20) DEFAULT NULL COMMENT 父节点id,userid bigint(20) NOT NULL COMMENT 用户id,username varchar(200) DEFAULT NULL COMMENT 用户名,isdone varchar(200) DEFAULT NULL COMMENT 状态,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT67 DEFAULT CHARSETutf8 COMMENT交友互动;CREATE TABLE jiankangxinxi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,laorenxingming varchar(200) DEFAULT NULL COMMENT 老人姓名,xingbie varchar(200) DEFAULT NULL COMMENT 性别,nianling int(11) DEFAULT NULL COMMENT 年龄,huanbingshi varchar(200) DEFAULT NULL,shengao varchar(200) DEFAULT NULL COMMENT 身高cm,tizhong varchar(200) DEFAULT NULL COMMENT 体重kg,xinlv varchar(200) DEFAULT NULL,xueya varchar(200) DEFAULT NULL,shentizhibiao longtext,jiankangfenxi longtext,faburiqi date DEFAULT NULL,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT37 DEFAULT CHARSETutf8 COMMENT健康信息;CREATE TABLE jiankongxinxi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,jiankongmingcheng varchar(200) NOT NULL COMMENT 监控名称,jiankongfengmian varchar(200) DEFAULT NULL COMMENT 监控封面,jiankongshipin varchar(200) DEFAULT NULL COMMENT 监控视频,jiankongshijian datetime DEFAULT NULL,jiankongshuoming longtext,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT27 DEFAULT CHARSETutf8 COMMENT监控信息;CREATE TABLE laorenxinxi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,laorenxingming varchar(200) NOT NULL COMMENT 老人姓名,mima varchar(200) NOT NULL COMMENT 密码,xingbie varchar(200) DEFAULT NULL COMMENT 性别,zhaopian varchar(200) DEFAULT NULL COMMENT 照片,nianling int(11) DEFAULT NULL COMMENT 年龄,huanbingshi varchar(200) DEFAULT NULL COMMENT 患病史,shenfenzheng varchar(200) DEFAULT NULL COMMENT 身份证,lianxiren varchar(200) DEFAULT NULL COMMENT 联系人,lianxidianhua varchar(200) DEFAULT NULL COMMENT 联系电话,jiatingzhuzhi varchar(200) DEFAULT NULL COMMENT 家庭住址,PRIMARY KEY (id),UNIQUE KEY laorenxingming (laorenxingming)
) ENGINEInnoDB AUTO_INCREMENT17 DEFAULT CHARSETutf8 COMMENT老人信息;CREATE TABLE news (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,title varchar(200) NOT NULL COMMENT 标题,introduction longtext COMMENT 简介,picture varchar(200) NOT NULL COMMENT 图片,content longtext NOT NULL COMMENT 内容,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT77 DEFAULT CHARSETutf8 COMMENT公告信息;CREATE TABLE token (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,userid bigint(20) NOT NULL COMMENT 用户id,username varchar(100) NOT NULL COMMENT 用户名,tablename varchar(100) DEFAULT NULL COMMENT 表名,role varchar(100) DEFAULT NULL COMMENT 角色,token varchar(200) NOT NULL COMMENT 密码,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 新增时间,expiratedtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 过期时间,PRIMARY KEY (id)
) ENGINEInnoDB DEFAULT CHARSETutf8 COMMENTtoken表;CREATE TABLE users (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,username varchar(100) NOT NULL COMMENT 用户名,password varchar(100) NOT NULL COMMENT 密码,role varchar(100) DEFAULT 管理员 COMMENT 角色,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 新增时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT2 DEFAULT CHARSETutf8 COMMENT用户表;7.核心代码
7.1 健康信息Controller
package com.controller;/*** 健康信息* 后端接口* author 计算机编程-吉哥*/
RestController
RequestMapping(/jiankangxinxi)
public class JiankangxinxiController {Autowiredprivate JiankangxinxiService jiankangxinxiService;/*** 后端列表*/RequestMapping(/page)public R page(RequestParam MapString, Object params,JiankangxinxiEntity jiankangxinxi,RequestParam(required false) DateTimeFormat(patternyyyy-MM-dd) Date faburiqistart,RequestParam(required false) DateTimeFormat(patternyyyy-MM-dd) Date faburiqiend,HttpServletRequest request){String tableName request.getSession().getAttribute(tableName).toString();if(tableName.equals(laorenxinxi)) {jiankangxinxi.setLaorenxingming((String)request.getSession().getAttribute(username));}EntityWrapperJiankangxinxiEntity ew new EntityWrapperJiankangxinxiEntity();if(faburiqistart!null) ew.ge(faburiqi, faburiqistart);if(faburiqiend!null) ew.le(faburiqi, faburiqiend);PageUtils page jiankangxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, jiankangxinxi), params), params));return R.ok().put(data, page);}/*** 前端列表*/IgnoreAuthRequestMapping(/list)public R list(RequestParam MapString, Object params,JiankangxinxiEntity jiankangxinxi, RequestParam(required false) DateTimeFormat(patternyyyy-MM-dd) Date faburiqistart,RequestParam(required false) DateTimeFormat(patternyyyy-MM-dd) Date faburiqiend,HttpServletRequest request){EntityWrapperJiankangxinxiEntity ew new EntityWrapperJiankangxinxiEntity();if(faburiqistart!null) ew.ge(faburiqi, faburiqistart);if(faburiqiend!null) ew.le(faburiqi, faburiqiend);PageUtils page jiankangxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, jiankangxinxi), params), params));return R.ok().put(data, page);}/*** 列表*/RequestMapping(/lists)public R list( JiankangxinxiEntity jiankangxinxi){EntityWrapperJiankangxinxiEntity ew new EntityWrapperJiankangxinxiEntity();ew.allEq(MPUtil.allEQMapPre( jiankangxinxi, jiankangxinxi)); return R.ok().put(data, jiankangxinxiService.selectListView(ew));}/*** 查询*/RequestMapping(/query)public R query(JiankangxinxiEntity jiankangxinxi){EntityWrapper JiankangxinxiEntity ew new EntityWrapper JiankangxinxiEntity();ew.allEq(MPUtil.allEQMapPre( jiankangxinxi, jiankangxinxi)); JiankangxinxiView jiankangxinxiView jiankangxinxiService.selectView(ew);return R.ok(查询健康信息成功).put(data, jiankangxinxiView);}/*** 后端详情*/RequestMapping(/info/{id})public R info(PathVariable(id) Long id){JiankangxinxiEntity jiankangxinxi jiankangxinxiService.selectById(id);return R.ok().put(data, jiankangxinxi);}/*** 前端详情*/IgnoreAuthRequestMapping(/detail/{id})public R detail(PathVariable(id) Long id){JiankangxinxiEntity jiankangxinxi jiankangxinxiService.selectById(id);return R.ok().put(data, jiankangxinxi);}/*** 后端保存*/RequestMapping(/save)public R save(RequestBody JiankangxinxiEntity jiankangxinxi, HttpServletRequest request){jiankangxinxi.setId(new Date().getTime()new Double(Math.floor(Math.random()*1000)).longValue());//ValidatorUtils.validateEntity(jiankangxinxi);jiankangxinxiService.insert(jiankangxinxi);return R.ok();}/*** 前端保存*/RequestMapping(/add)public R add(RequestBody JiankangxinxiEntity jiankangxinxi, HttpServletRequest request){jiankangxinxi.setId(new Date().getTime()new Double(Math.floor(Math.random()*1000)).longValue());//ValidatorUtils.validateEntity(jiankangxinxi);jiankangxinxiService.insert(jiankangxinxi);return R.ok();}/*** 修改*/RequestMapping(/update)Transactionalpublic R update(RequestBody JiankangxinxiEntity jiankangxinxi, HttpServletRequest request){//ValidatorUtils.validateEntity(jiankangxinxi);jiankangxinxiService.updateById(jiankangxinxi);//全部更新return R.ok();}/*** 删除*/RequestMapping(/delete)public R delete(RequestBody Long[] ids){jiankangxinxiService.deleteBatchIds(Arrays.asList(ids));return R.ok();}/*** 提醒接口*/RequestMapping(/remind/{columnName}/{type})public R remindCount(PathVariable(columnName) String columnName, HttpServletRequest request, PathVariable(type) String type,RequestParam MapString, Object map) {map.put(column, columnName);map.put(type, type);if(type.equals(2)) {SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd);Calendar c Calendar.getInstance();Date remindStartDate null;Date remindEndDate null;if(map.get(remindstart)!null) {Integer remindStart Integer.parseInt(map.get(remindstart).toString());c.setTime(new Date()); c.add(Calendar.DAY_OF_MONTH,remindStart);remindStartDate c.getTime();map.put(remindstart, sdf.format(remindStartDate));}if(map.get(remindend)!null) {Integer remindEnd Integer.parseInt(map.get(remindend).toString());c.setTime(new Date());c.add(Calendar.DAY_OF_MONTH,remindEnd);remindEndDate c.getTime();map.put(remindend, sdf.format(remindEndDate));}}WrapperJiankangxinxiEntity wrapper new EntityWrapperJiankangxinxiEntity();if(map.get(remindstart)!null) {wrapper.ge(columnName, map.get(remindstart));}if(map.get(remindend)!null) {wrapper.le(columnName, map.get(remindend));}String tableName request.getSession().getAttribute(tableName).toString();if(tableName.equals(laorenxinxi)) {wrapper.eq(laorenxingming, (String)request.getSession().getAttribute(username));}int count jiankangxinxiService.selectCount(wrapper);return R.ok().put(count, count);}}7.2 健康信息Service
package com.service;/*** 健康信息** author 计算机编程-吉哥*/
public interface JiankangxinxiService extends IServiceJiankangxinxiEntity {PageUtils queryPage(MapString, Object params);ListJiankangxinxiVO selectListVO(WrapperJiankangxinxiEntity wrapper);JiankangxinxiVO selectVO(Param(ew) WrapperJiankangxinxiEntity wrapper);ListJiankangxinxiView selectListView(WrapperJiankangxinxiEntity wrapper);JiankangxinxiView selectView(Param(ew) WrapperJiankangxinxiEntity wrapper);PageUtils queryPage(MapString, Object params,WrapperJiankangxinxiEntity wrapper);}
7.3 健康信息ServiceImpl
package com.service.impl;Service(jiankangxinxiService)
public class JiankangxinxiServiceImpl extends ServiceImplJiankangxinxiDao, JiankangxinxiEntity implements JiankangxinxiService {Overridepublic PageUtils queryPage(MapString, Object params) {PageJiankangxinxiEntity page this.selectPage(new QueryJiankangxinxiEntity(params).getPage(),new EntityWrapperJiankangxinxiEntity());return new PageUtils(page);}Overridepublic PageUtils queryPage(MapString, Object params, WrapperJiankangxinxiEntity wrapper) {PageJiankangxinxiView page new QueryJiankangxinxiView(params).getPage();page.setRecords(baseMapper.selectListView(page,wrapper));PageUtils pageUtil new PageUtils(page);return pageUtil;}Overridepublic ListJiankangxinxiVO selectListVO(WrapperJiankangxinxiEntity wrapper) {return baseMapper.selectListVO(wrapper);}Overridepublic JiankangxinxiVO selectVO(WrapperJiankangxinxiEntity wrapper) {return baseMapper.selectVO(wrapper);}Overridepublic ListJiankangxinxiView selectListView(WrapperJiankangxinxiEntity wrapper) {return baseMapper.selectListView(wrapper);}Overridepublic JiankangxinxiView selectView(WrapperJiankangxinxiEntity wrapper) {return baseMapper.selectView(wrapper);}}7.4 健康信息DAO
package com.dao;/*** 健康信息* * author 计算机编程-吉哥*/
public interface JiankangxinxiDao extends BaseMapperJiankangxinxiEntity {ListJiankangxinxiVO selectListVO(Param(ew) WrapperJiankangxinxiEntity wrapper);JiankangxinxiVO selectVO(Param(ew) WrapperJiankangxinxiEntity wrapper);ListJiankangxinxiView selectListView(Param(ew) WrapperJiankangxinxiEntity wrapper);ListJiankangxinxiView selectListView(Pagination page,Param(ew) WrapperJiankangxinxiEntity wrapper);JiankangxinxiView selectView(Param(ew) WrapperJiankangxinxiEntity wrapper);}8.参考文档 你可能还有感兴趣的项目 更多项目推荐:计算机毕业设计项目 如果大家有任何疑虑请在下方咨询或评论
