博主介绍:本人专注于Android/java/数据库/微信小程序技术领域的开发,以及有好几年的计算机毕业设计方面的实战开发经验和技术积累;尤其是在安卓(Android)的app的开发和微信小程序的开发,很是熟悉和了解;本人也是多年的Android开发人员;希望我发布的此篇文件可以帮助到您;
🍅文章末尾获取源码下载方式🍅
源码下载
https://download.csdn.net/download/u014388322/88554709
一、项目介绍
面向用户主要有四部分功能:
健身部分、饮食部分、计划、个人数据
健身部分可以用来搜索健身视频,用户根据自己的锻炼需求搜索对应的视频,主要分为减脂、增肌、搏击、塑性、瑜伽、舞蹈、拉伸放松,每种锻炼都会有适用于不同性别的视频,也会为基础不同的用户提供不同难度的锻炼视频,用户可以将视频加入到计划中。
饮食部分分为减脂和增肌两种,有一些推荐食谱和推荐食材,用户也可根据自身需求制定个性食谱,可以将食谱加入到计划中。
计划是根据用户自身需求生成的,可以由系统推荐生成,也可以用户DIY。
个人数据是对自身体重及各种维度的记录,可以生成变化曲线,是对自身情况的记录。
后台管理者可实现:
管理视频,及时进行更新
二、运行环境
1:客户端使用Android stuido进行开发;
2:服务端后台使用Myeclipse2014进行开发;
3:mysql数据库进行数据存储;
4:需要jdk1.7以上
5:使用雷电模拟器或者Androidstuio自带的模拟器进行运行
三、使用技术
总体设计逻辑和思路:
1:先设计数据库表文件
2:写服务端jsp页面以及写api接口给客户端提供数据
3:完成后台服务端的数据交互,也就是jsp页面数据的存储和显示
4:进行客户端页面的开发;
5:进行客户端对api接口的调用,也就是获取数据库的数据以及在客户端进行显示移动端:
1:使用android原生控件以及xml布局文件来完成界面的显示
2:使用java代码完成功能的数据和逻辑交互
3:使用http网络请求完成数据的请求;
4:使用json数据解析完成客户端数据的回调和显示服务端后台:
1:使用mysql完成数据的存储
2:使用jdbc完成数据库和代码的逻辑交互
3:使用jsp完成网页数据的显示
4:使用java代码完成api接口的编写以及以及数据的回调
四、数据库设计
/*
Navicat MySQL Data TransferSource Server : mydata
Source Server Version : 50528
Source Host : localhost:3306
Source Database : exercisehealthdbTarget Server Type : MYSQL
Target Server Version : 50528
File Encoding : 65001Date: 2022-05-11 12:44:10
*/SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for choicetb
-- ----------------------------
DROP TABLE IF EXISTS `choicetb`;
CREATE TABLE `choicetb` (
`choiceId` int(11) NOT NULL AUTO_INCREMENT,
`choiceCourseId` int(11) DEFAULT NULL,
`choiceStuId` int(11) DEFAULT NULL,
`choiceFlag` varchar(100) DEFAULT NULL,
PRIMARY KEY (`choiceId`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of choicetb
-- ----------------------------
INSERT INTO `choicetb` VALUES ('38', '66', '123', '1');-- ----------------------------
-- Table structure for healthtb
-- ----------------------------
DROP TABLE IF EXISTS `healthtb`;
CREATE TABLE `healthtb` (
`healthId` int(11) NOT NULL AUTO_INCREMENT,
`healthLog` varchar(255) DEFAULT NULL,
`healthUserId` varchar(11) DEFAULT NULL,
`healthUserName` varchar(255) DEFAULT NULL,
`healthTime` varchar(100) DEFAULT NULL,
PRIMARY KEY (`healthId`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of healthtb
-- ----------------------------
INSERT INTO `healthtb` VALUES ('14', '56', '123', '好教练', '2022-01-30');
INSERT INTO `healthtb` VALUES ('15', '89', '123', '好教练', '2022-01-30');
INSERT INTO `healthtb` VALUES ('16', '52', '123', '好教练', '2022-01-30');
INSERT INTO `healthtb` VALUES ('17', '58', '123', '好教练', '2022-01-30');
INSERT INTO `healthtb` VALUES ('18', '49', '123', '好教练', '2022-01-30');
INSERT INTO `healthtb` VALUES ('19', '51', '123', '好教练', '2022-01-30');
INSERT INTO `healthtb` VALUES ('20', '62', '123', '好教练', '2022-01-30');
INSERT INTO `healthtb` VALUES ('21', '76', '123', '好教练', '2022-01-30');
INSERT INTO `healthtb` VALUES ('22', '88', '123', '好教练', '2022-03-08');-- ----------------------------
-- Table structure for newstb
-- ----------------------------
DROP TABLE IF EXISTS `newstb`;
CREATE TABLE `newstb` (
`newsId` int(11) NOT NULL AUTO_INCREMENT,
`newsTitle` varchar(255) DEFAULT NULL,
`newsMessage` varchar(255) DEFAULT NULL,
`newsTime` varchar(100) DEFAULT NULL,
PRIMARY KEY (`newsId`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of newstb
-- ----------------------------
INSERT INTO `newstb` VALUES ('8', '计算机基础编程', '使用java语言打印一个99乘法表出来;', '2021-01-12 15:49');
INSERT INTO `newstb` VALUES ('9', '计算机', '使用java语言打印一个99乘法表出来;', '2021-01-12 15:49');
INSERT INTO `newstb` VALUES ('10', '计算机作业99', '使用java语言打印一个99乘法表出来;', '2021-01-12 15:49');
INSERT INTO `newstb` VALUES ('11', '计算机基础', '使用java语言打印一个99乘法表出来;', '2021-01-12 15:49');-- ----------------------------
-- Table structure for plantb
-- ----------------------------
DROP TABLE IF EXISTS `plantb`;
CREATE TABLE `plantb` (
`planId` int(11) NOT NULL AUTO_INCREMENT,
`planName` varchar(255) DEFAULT NULL,
`planType` varchar(255) DEFAULT NULL,
`planMsg` varchar(255) DEFAULT NULL,
`planUserId` int(11) DEFAULT NULL,
`planUserName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`planId`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of plantb
-- ----------------------------
INSERT INTO `plantb` VALUES ('7', '美食计划', '健身', '饮食上,忙的话我每天中午在外面买两三个菜,一个双拼素菜+两块钱烫青菜+一个虎皮青椒+一根鸡腿(鸡皮绝对不敢吃)+一个四喜丸子(淀粉多)+一平碗杂粮米。', '123', '好教练');
INSERT INTO `plantb` VALUES ('8', '美食计划111', '健身', '饮食上,忙的话我每天中午在外面买两三个菜,一个双拼素菜+两块钱烫青菜+一个虎皮青椒+一根鸡腿(鸡皮绝对不敢吃)+一个四喜丸子(淀粉多)+一平碗杂粮米。', '123', '好教练');-- ----------------------------
-- Table structure for reviewtb
-- ----------------------------
DROP TABLE IF EXISTS `reviewtb`;
CREATE TABLE `reviewtb` (
`reviewId` int(50) NOT NULL AUTO_INCREMENT,
`reviewUserId` varchar(50) NOT NULL,
`reviewUserName` varchar(100) NOT NULL,
`reviewMessageId` varchar(100) NOT NULL,
`reviewInfor` varchar(255) DEFAULT NULL,
`reviewCreatime` varchar(100) NOT NULL,
PRIMARY KEY (`reviewId`)
) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of reviewtb
-- ----------------------------
INSERT INTO `reviewtb` VALUES ('119', '90', 'Tomcat', '15', '6666', '2020-12-23 17:29:25');
INSERT INTO `reviewtb` VALUES ('120', '90', 'Tomcat', '15', '6666', '2020-12-23 17:29:34');
INSERT INTO `reviewtb` VALUES ('121', '90', 'Tomcat', '15', '6666', '2020-12-23 17:29:36');
INSERT INTO `reviewtb` VALUES ('122', '100', '小康', '8', '你好啊', '2020-12-28 14:46:12');
INSERT INTO `reviewtb` VALUES ('123', '100', '小康', '8', '我来看看', '2020-12-28 14:46:18');
INSERT INTO `reviewtb` VALUES ('124', '101', '小卡卡', '8', '我来来来', '2020-12-28 14:56:55');
INSERT INTO `reviewtb` VALUES ('125', '', '', '24', '我好吧', '2021-01-12 10:39:11');
INSERT INTO `reviewtb` VALUES ('126', '', '', '25', '我弄', '2021-01-12 10:42:17');
INSERT INTO `reviewtb` VALUES ('127', '124', '学员', '26', '你好啊', '2021-01-12 15:58:13');
INSERT INTO `reviewtb` VALUES ('128', '124', '学员', '26', '我的评论内容', '2021-01-12 15:58:21');-- ----------------------------
-- Table structure for shoptb
-- ----------------------------
DROP TABLE IF EXISTS `shoptb`;
CREATE TABLE `shoptb` (
`shopId` int(50) NOT NULL AUTO_INCREMENT,
`shopName` varchar(255) DEFAULT NULL,
`shopTypeId` varchar(11) DEFAULT NULL,
`shopTypeName` varchar(255) DEFAULT NULL,
`shopMessage` varchar(500) DEFAULT NULL,
`shopImg` varchar(500) DEFAULT NULL,
`shopVideo` varchar(255) DEFAULT NULL,
PRIMARY KEY (`shopId`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of shoptb
-- ----------------------------
INSERT INTO `shoptb` VALUES ('65', '1', '21', '瑜伽', '1', '1497354408633.jpg', '1497354411282.jpg');
INSERT INTO `shoptb` VALUES ('66', '222', '23', '增肌', '1', '1501153407781.jpg', 'xian_duanshipin_01.mp4');-- ----------------------------
-- Table structure for token
-- ----------------------------
DROP TABLE IF EXISTS `token`;
CREATE TABLE `token` (
`tid` int(100) NOT NULL AUTO_INCREMENT,
`uid` varchar(100) CHARACTER SET utf8 NOT NULL,
`utoken` varchar(500) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=148 DEFAULT CHARSET=latin1;-- ----------------------------
-- Records of token
-- ----------------------------
INSERT INTO `token` VALUES ('129', '106', '9wWlv9HxUZzCAUsC1qH4Ru1UwArCn0GURMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');
INSERT INTO `token` VALUES ('130', '107', 'l+t213zhSFDCAUsC1qH4Rk4QyigDtcyWRMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');
INSERT INTO `token` VALUES ('131', '108', '410+eC84tRfCAUsC1qH4RrO7lhGoMwPZRMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');
INSERT INTO `token` VALUES ('132', '109', 'qUhVLBfskPfCAUsC1qH4RtxGEPel2fCfRMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');
INSERT INTO `token` VALUES ('133', '110', 'SdZWweWCOQPCAUsC1qH4RjmNGAvpdWg3RMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');
INSERT INTO `token` VALUES ('134', '111', 'hsOZccsK03jCAUsC1qH4Rj7VpGKotsPsRMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');
INSERT INTO `token` VALUES ('135', '112', '3VSpiIwAsnrCAUsC1qH4RhBfyKlyoY5oRMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');
INSERT INTO `token` VALUES ('136', '113', 'WBV8pdFwi8PCAUsC1qH4Rhjteb95A0M3RMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');
INSERT INTO `token` VALUES ('137', '114', 'jKFEMeIeepjCAUsC1qH4RlZNEiAJpdiURMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');
INSERT INTO `token` VALUES ('138', '115', 'Uq/Tj7VfO1/CAUsC1qH4RjiIeWwuMNWYRMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');
INSERT INTO `token` VALUES ('139', '116', 'qB5wp0DpH27CAUsC1qH4RvQPUoNJgNeTRMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');
INSERT INTO `token` VALUES ('140', '117', 'eCft8GFsvrHCAUsC1qH4Rqs8F5Soj5GERMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');
INSERT INTO `token` VALUES ('141', '118', '5NWwWGftOwnCAUsC1qH4RlDOp9N6HPz5RMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');
INSERT INTO `token` VALUES ('142', '119', 'SfS/uXrzwJ/CAUsC1qH4RjaX6Bti5cOWRMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');
INSERT INTO `token` VALUES ('143', '120', 'XtBtct3WZrrCAUsC1qH4RoUdesz3euWRRMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');
INSERT INTO `token` VALUES ('144', '121', 'jJIQa3IUFZbCAUsC1qH4RpHJPE1nmlpQRMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');
INSERT INTO `token` VALUES ('145', '122', 'Jjqoad/LbFTCAUsC1qH4RlfNWHOzFdPqRMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');
INSERT INTO `token` VALUES ('146', '123', 'dcJqnfd8fDXCAUsC1qH4RuaC1CRh4EKmRMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');
INSERT INTO `token` VALUES ('147', '124', 'rSJjvGtgtRXCAUsC1qH4RliSE47ISPuvRMJ0giwZZq0=@4ixh.cn.rongnav.com;4ixh.cn.rongcfg.com');-- ----------------------------
-- Table structure for topictb
-- ----------------------------
DROP TABLE IF EXISTS `topictb`;
CREATE TABLE `topictb` (
`topicId` int(11) NOT NULL AUTO_INCREMENT,
`topicInfor` varchar(255) DEFAULT NULL,
`topicFile` varchar(255) DEFAULT NULL,
`topicImg` varchar(255) DEFAULT NULL,
`topicUserId` varchar(255) DEFAULT NULL,
`topicUserName` varchar(255) DEFAULT NULL,
`topicTime` varchar(100) DEFAULT NULL,
PRIMARY KEY (`topicId`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of topictb
-- ----------------------------
INSERT INTO `topictb` VALUES ('22', '大家有什么好的冬季健身计划吗?求分享', 'WR_0902_03.mp4', '20201204170325.jpg,WR_0902_03.mp4', '118', '小红', '2021-01-11 17:52');
INSERT INTO `topictb` VALUES ('23', '大家有什么好的冬季健身计划吗?求分享', 'WR_0902_03.mp4', 'nvsheng2.jpg,WR_0902_03.mp4', '', '小红', '2021-01-11 17:57');
INSERT INTO `topictb` VALUES ('24', '大家有什么好的冬季健身计划吗?求分享', 'WR_0902_03.mp4', 'v2-a06bef977a9148954cbfa717596add6e_hd.jpg,20201204170325.jpg,20151025201509_VS8k4.jpeg', '118', '小红', '2021-01-12 09:48');
INSERT INTO `topictb` VALUES ('25', '大家有什么好的冬季健身计划吗?求分享', '', 'temphead.jpg,20161022082056_Z4fC3.thumb.700_0.jpeg,v2-a06bef977a9148954cbfa717596add6e_hd.jpg', '', '', '2021-01-12 10:42');
INSERT INTO `topictb` VALUES ('26', '大家有什么好的冬季健身计划吗?求分享', '', 'book_dl_6.jpg', '124', '学员', '2021-01-12 15:57');-- ----------------------------
-- Table structure for typetb
-- ----------------------------
DROP TABLE IF EXISTS `typetb`;
CREATE TABLE `typetb` (
`typeId` int(50) NOT NULL AUTO_INCREMENT,
`typeName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`typeId`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of typetb
-- ----------------------------
INSERT INTO `typetb` VALUES ('21', '瑜伽');
INSERT INTO `typetb` VALUES ('22', '减脂');
INSERT INTO `typetb` VALUES ('23', '增肌');
INSERT INTO `typetb` VALUES ('24', '搏击');
INSERT INTO `typetb` VALUES ('25', '塑性');
INSERT INTO `typetb` VALUES ('26', '舞蹈');
INSERT INTO `typetb` VALUES ('27', '拉伸');
INSERT INTO `typetb` VALUES ('28', '放松');-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`uid` int(255) NOT NULL AUTO_INCREMENT,
`uname` varchar(200) CHARACTER SET utf8 NOT NULL,
`uphone` varchar(100) CHARACTER SET utf8 NOT NULL,
`upswd` varchar(200) CHARACTER SET utf8 NOT NULL,
`uImg` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`utype` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`utime` varchar(300) CHARACTER SET utf8 NOT NULL,
`uage` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`ulike` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=125 DEFAULT CHARSET=latin1;-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('109', '王教练', '15249241001', '123456', '20201204162637.jpg', '教练', '2021-01-12 15:49', '35', '运动健身');
INSERT INTO `user` VALUES ('110', '李教练', '15249245001', '123456', '20201204165728.jpg', '教练', '2021-01-12 15:49', '40', '瑜伽健身');
INSERT INTO `user` VALUES ('111', '张教练', '15249247008', '123456', '20201204170325.jpg', '教练', '2021-01-12 15:49', '20', '康复健身');
INSERT INTO `user` VALUES ('118', '赵教练', '15249246009', '123456', '20201231151254.jpg', '教练', '2021-01-12 15:49', '27', '运动健身');
INSERT INTO `user` VALUES ('122', '小莫', '15249246058', '123456', '20210112105009.jpg', '会员', '2021-01-12 10:50', null, null);
INSERT INTO `user` VALUES ('123', '好教练', '15249249977', '123456', '20210112152009.jpg', '教练', '2021-01-12 15:20', '26', '瑜伽健身');
INSERT INTO `user` VALUES ('124', '学员', '15249249944', '123456', '20210112155544.jpg', '会员', '2021-01-12 15:55', null, null);
五、部分代码
六、浏览更多Android毕业设计
基于androidstudio校园快递APP系统的设计与实现
更多毕业设计可以浏览我的个人主页哦!
七、源码咨询
大家点赞、收藏、关注、评论啦 、查看👇🏻👇🏻👇🏻获取联系方式👇🏻👇🏻👇🏻