-- ----------------------------
-- Table structure for "ALEXLEE"."ACTIVE"
-- ----------------------------
-- DROP TABLE "ALEXLEE"."ACTIVE";
CREATE TABLE "ALEXLEE"."ACTIVE" (
"ID" NUMBER(10) NOT NULL ,
"NAME" VARCHAR2(20 CHAR) NOT NULL ,
"HEAT" FLOAT NULL ,
"TIME" FLOAT NOT NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
-- ----------------------------
-- Records of ACTIVE
-- ----------------------------
-- ----------------------------
-- Table structure for "ALEXLEE"."DAIRY"
-- ----------------------------
-- DROP TABLE "ALEXLEE"."DAIRY";
CREATE TABLE "ALEXLEE"."DAIRY" (
"DATETIME" VARCHAR2(20 CHAR) NOT NULL ,
"TEXT" VARCHAR2(2000 CHAR) NULL ,
"SLEEPHOUR" FLOAT NULL ,
"MOOD" VARCHAR2(255 CHAR) NULL ,
"CIGARETTE" NUMBER(10) NULL ,
"WEIGHT" FLOAT NULL ,
"PRESSURE" VARCHAR2(255 BYTE) NULL ,
"BPHIGH" FLOAT NULL ,
"BPLOW" FLOAT NULL ,
"BS" FLOAT NULL ,
"TEACHER_ID" NUMBER(10) NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
-- ----------------------------
-- Records of DAIRY
-- ----------------------------
INSERT INTO "ALEXLEE"."DAIRY" VALUES ('2014-4-14', '123', '1', '1', '1', '1', null, '1', null, '1', null);
INSERT INTO "ALEXLEE"."DAIRY" VALUES ('2014-4-20', '今天心情好', '12', '好', '0', '44', null, '123', '112', '12', null);
INSERT INTO "ALEXLEE"."DAIRY" VALUES ('2014-5-2', '五一放假3天', '6', '好', '2', '44', '无', '120', '90', '222', '1');
INSERT INTO "ALEXLEE"."DAIRY" VALUES ('2014-5-1', '进', '1', '1', '1', '1', '11', '1', '1', '1', '1');
INSERT INTO "ALEXLEE"."DAIRY" VALUES ('2014-5-3', '今天心情好', '12', '好', '0', '44', '无', '120', '90', '170', '1');
INSERT INTO "ALEXLEE"."DAIRY" VALUES ('2014-5-4', '今天雾霾严重,呼吸不畅', '12', '好', '0', '44', '无', '120', '100', '132', '1');
INSERT INTO "ALEXLEE"."DAIRY" VALUES ('2014-5-15', '五一放假3天', '6', '好', '2', '44', '无', '120', '90', '222', '1');
INSERT INTO "ALEXLEE"."DAIRY" VALUES ('2014-6-12', '<span style="color:#337FE5;font-size:16px;">毕业论文无限修改中。。。</span>', '9', '好', '0', '44', '无', '120', '90', '222', '1');
-- ----------------------------
-- Table structure for "ALEXLEE"."DAIRY_ACTIVE"
-- ----------------------------
-- DROP TABLE "ALEXLEE"."DAIRY_ACTIVE";
CREATE TABLE "ALEXLEE"."DAIRY_ACTIVE" (
"ACTIVE_ID" NUMBER(10) NOT NULL ,
"DAIRY_ID" VARCHAR2(20 CHAR) NOT NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
-- ----------------------------
-- Records of DAIRY_ACTIVE
-- ----------------------------
-- ----------------------------
-- Table structure for "ALEXLEE"."DAIRY_FOOD"
-- ----------------------------
-- DROP TABLE "ALEXLEE"."DAIRY_FOOD";
CREATE TABLE "ALEXLEE"."DAIRY_FOOD" (
"DAIRY_ID" VARCHAR2(20 CHAR) NOT NULL ,
"FOOD_ID" NUMBER(10) NOT NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
-- ----------------------------
-- Records of DAIRY_FOOD
-- ----------------------------
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-4-14', '11');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-4-14', '12');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-4-20', '1');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-1', '1');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-15', '5');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-15', '15');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-15', '16');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-15', '17');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-15', '26');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-2', '3');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-2', '4');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-2', '5');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-2', '6');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-2', '7');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-3', '1');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-3', '6');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-3', '12');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-3', '14');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-3', '29');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-4', '2');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-4', '14');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-4', '18');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-4', '29');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-6-12', '3');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-6-12', '4');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-6-12', '5');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-6-12', '6');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-6-12', '7');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-6-12', '26');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-6-12', '27');
-- ----------------------------
-- Table structure for "ALEXLEE"."EXAM"
-- ----------------------------
-- DROP TABLE "ALEXLEE"."EXAM";
CREATE TABLE "ALEXLEE"."EXAM" (
"ID" NUMBER(10) NOT NULL ,
"DATETIME" TIMESTAMP(6) NOT NULL ,
"SBP" VARCHAR2(255 CHAR) NULL ,
"DBP" VARCHAR2(255 CHAR) NULL ,
"BMI" VARCHAR2(255 CHAR) NULL ,
"WHR" VARCHAR2(255 CHAR) NULL ,
"BUN" VARCHAR2(255 CHAR) NULL ,
"UA" VARCHAR2(255 CHAR) NULL ,
"CREA" VARCHAR2(255 CHAR) NULL ,
"TG" VARCHAR2(255 CHAR) NULL ,
"CHOL" VARCHAR2(255 CHAR) NULL ,
"HDL" VARCHAR2(255 CHAR) NULL ,
"LDL" VARCHAR2(255 CHAR) NULL ,
"GLU" VARCHAR2(255 CHAR) NULL ,
"HCY" VARCHAR2(255 CHAR) NULL ,
"M_ALB" VARCHAR2(255 CHAR) NULL ,
"M_ALB_CREA" VARCHAR2(255 CHAR) NULL ,
"TEACHER_ID" NUMBER(10) NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
-- ----------------------------
-- Records of EXAM
-- ----------------------------
INSERT INTO "ALEXLEE"."EXAM" VALUES ('1', TO_TIMESTAMP(' 2014-05-02 14:01:26:000000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '130', '100', '13', '0.6', '6', '150', '50', '0.6', '3.68', '1.06', '2.3', '3.7', '20', '22', '13.7', '1');
INSERT INTO "ALEXLEE"."EXAM" VALUES ('3', TO_TIMESTAMP(' 2014-04-23 19:02:30:000000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '110', '90', '15', '0.6', '8', '135', '62', '0.5', '2.34', '1.45', '3.4', '4.6', '33', '35', '12.9', '1');
INSERT INTO "ALEXLEE"."EXAM" VALUES ('4', TO_TIMESTAMP(' 2014-05-22 19:04:14:000000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '115', '97', '14', '0.5', '8', '158', '55', '0.6', '2.56', '1.67', '3.2', '4.8', '34', '23', '13.9', '1');
-- ----------------------------
-- Table structure for "ALEXLEE"."FOOD"
-- ----------------------------
-- DROP TABLE "ALEXLEE"."FOOD";
CREATE TABLE "ALEXLEE"."FOOD" (
"ID" NUMBER(10) NOT NULL ,
"NAME" VARCHAR2(20 CHAR) NOT NULL ,
"HEAT" FLOAT NULL ,
"CARBOHYDRATE" FLOAT NULL ,
"FAT" FLOAT NULL ,
"PROTEIN" FLOAT NULL ,
"FIBER" FLOAT NULL ,
"TYPE" NUMBER(10) NOT NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
-- ----------------------------
-- Records of FOOD
-- ----------------------------
INSERT INTO "ALEXLEE"."FOOD" VALUES ('1', '豆浆', null, null, null, null, null, '1');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('2', '肉松面包', null, null, null, null, null, '2');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('3', '煎蛋', null, null, null, null, null, '3');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('4', '苹果', null, null, null, null, null, '4');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('5', '香煎排骨', null, null, null, null, null, '5');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('6', '清炒西兰花', null, null, null, null, null, '6');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('7', '米饭', null, null, null, null, null, '7');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('8', '玉米羹', null, null, null, null, null, '8');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('9', '家常豆腐', null, null, null, null, null, '9');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('10', '清炒苦瓜', null, null, null, null, null, '10');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('11', '小米粥', null, null, null, null, null, '11');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('12', '馒头', null, null, null, null, null
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
数据库:MySQL 语言:Java 架构:SSH 功能:(1)用户模块: 实现登录功能 实现用户登录的退出 实现用户注册 (2)教师饮食管理: 根据教师的相关信息,计算其每天所需热量,给出一周的推荐菜单。 (3)教师健康日志: 用户可以记录自己健康日记,记录每一天的睡眠,饮酒,吸烟,血压,体重等情况。 (4)教师体检管理: 教师可通过该平台查询每次的体检结果,显示部分项目随时间变化的曲线 (5)疾病预测评估: 针对糖尿病和高血压两种疾病,利用数学线性回归的方法,模拟计算出教师患病概率。 (6) 后台管理员模块 管理员用户登录功能:通过账号登录系统。 管理员管理教师功能:可以增删改查教师基本信息。 管理员管理体检结果:可以增删改查教师体检记录。 健康新闻管理:可以发布或删除、编辑新闻
资源推荐
资源详情
资源评论
收起资源包目录
健康管理系统.rar (2个子文件)
健康管理系统
ALEXLEE.sql 23KB
Healthy_manager.zip 21.55MB
共 2 条
- 1
资源评论
- ctrl-00后2020-04-11不是mysql数据库
一点博客
- 粉丝: 197
- 资源: 38
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功