短网址网站,做图表的网站知乎,昆山网站建设设计,做网站收入怎样博主介绍#xff1a; ✌我是阿龙#xff0c;一名专注于Java技术领域的程序员#xff0c;全网拥有10W粉丝。作为CSDN特邀作者、博客专家、新星计划导师#xff0c;我在计算机毕业设计开发方面积累了丰富的经验。同时#xff0c;我也是掘金、华为云、阿里云、InfoQ等平台… 博主介绍 ✌我是阿龙一名专注于Java技术领域的程序员全网拥有10W粉丝。作为CSDN特邀作者、博客专家、新星计划导师我在计算机毕业设计开发方面积累了丰富的经验。同时我也是掘金、华为云、阿里云、InfoQ等平台的优质作者。通过长期分享和实战指导我致力于帮助更多学生完成毕业项目和技术提升。 技术范围 我熟悉的技术领域涵盖SpringBoot、Vue、SSM、HLMT、Jsp、PHP、Nodejs、Python、爬虫、数据可视化、小程序、安卓app、大数据、物联网、机器学习等方面的设计与开发。如果你有任何技术难题我都乐意与你分享解决方案。 主要内容 我的服务内容包括免费功能设计、开题报告、任务书、中期检查PPT、系统功能实现、代码编写、论文撰写与辅导、论文降重、长期答辩答疑辅导。此外我还提供腾讯会议一对一的专业讲解和模拟答辩演练帮助你全面掌握答辩技巧与代码逻辑。 获取源码请在文末联系我 如果你对我的内容感兴趣记得先收藏对于毕设选题、项目开发或论文撰写等相关问题随时欢迎留言咨询我会尽力帮助更多同学顺利完成学业。 最主要的是免费咨询相关问题 一、详细操作演示视频 在文章的尾声您会发现一张电子名片欢迎通过名片上的联系方式与我取得联系以获取更多关于项目演示的详尽视频内容。视频将帮助您全面理解项目的关键点和操作流程。期待与您的进一步交流 承诺所有开发的项目全程售后陪伴文章结尾有历年的好评部分 文档学习资料阿龙可以赠送所有的录制好的讲解视频 项目实现界面
核心代码 templatedivdiv classapp-containdiv classlist_search_viewel-form :modelsearchQuery classsearch_form div classsearch_viewdiv classsearch_label用户姓名/divdiv classsearch_boxel-input classsearch_inp v-modelsearchQuery.yonghuxingming placeholder用户姓名clearable/el-input/div/divdiv classsearch_btn_viewel-button classsearch_btn typeprimary clicksearchClick() sizesmall搜索/el-button/div/el-formbrdiv classbtn_viewel-button typesuccess clickaddClick v-ifbtnAuth(jiankangdangan,新增)新增/el-buttonel-button v-if btnAuth(jiankangdangan,查看) typeinfo :disabledselRows.length1?false:true clickinfoClick(null)详情/el-buttonel-button typeprimary :disabledselRows.length1?false:true clickeditClick v-if btnAuth(jiankangdangan,修改)修改/el-buttonel-button typedanger :disabledselRows.length?false:true clickdelClick(null) v-ifbtnAuth(jiankangdangan,删除)删除/el-button/div/divbrel-tablev-loadinglistLoadingborder :stripefalseselection-changehandleSelectionChange reftablev-ifbtnAuth(jiankangdangan,查看):datalistrow-clicklistChangeel-table-column :resizabletrue alignleft header-alignleft typeselection width55 /el-table-column label序号 width70 :resizabletrue :sortabletrue alignleft header-alignlefttemplate #defaultscope{{ scope.$index 1}}/template/el-table-columnel-table-column:resizabletrue :sortabletrue alignleft header-alignleftpropyonghuzhanghaolabel用户账号template #defaultscope{{scope.row.yonghuzhanghao}}/template/el-table-columnel-table-column:resizabletrue :sortabletrue alignleft header-alignleftpropyonghuxingminglabel用户姓名template #defaultscope{{scope.row.yonghuxingming}}/template/el-table-columnel-table-column:resizabletrue :sortabletrue alignleft header-alignleftpropxingbielabel性别template #defaultscope{{scope.row.xingbie}}/template/el-table-columnel-table-column:resizabletrue :sortabletrue alignleft header-alignleftpropnianlinglabel年龄template #defaultscope{{scope.row.nianling}}/template/el-table-columnel-table-column:resizabletrue :sortabletrue alignleft header-alignleftproptizhonglabel体重template #defaultscope{{scope.row.tizhong}}/template/el-table-columnel-table-column:resizabletrue :sortabletrue alignleft header-alignleftpropxueyalabel血压template #defaultscope{{scope.row.xueya}}/template/el-table-columnel-table-column:resizabletrue :sortabletrue alignleft header-alignleftpropxuezhilabel血脂template #defaultscope{{scope.row.xuezhi}}/template/el-table-columnel-table-column:resizabletrue :sortabletrue alignleft header-alignleftpropxinlvlabel心率template #defaultscope{{scope.row.xinlv}}/template/el-table-columnel-table-column:resizabletrue :sortabletrue alignleft header-alignleftpropdengjishijianlabel登记时间template #defaultscope{{scope.row.dengjishijian}}/template/el-table-columnel-table-column label操作 width300 :resizabletrue :sortabletrue alignleft header-alignlefttemplate #defaultscopeel-button typeinfo v-if btnAuth(jiankangdangan,查看) clickinfoClick(scope.row.id)详情/el-button/template/el-table-column/el-tableel-pagination background:layoutlayouts.join(,):totaltotal :page-sizelistQuery.limitprev-text上一页next-text下一页:hide-on-single-pagefalse:style{border:0px solid #e1e1e1,padding:10px 0,margin:20px 0 0,whiteSpace:nowrap,color:#333,textAlign:left,background:none,width:100%,fontWeight:500}size-changesizeChangecurrent-changecurrentChange prev-clickprevClicknext-clicknextClick //divformModel refformRef formModelChangeformModelChange/formModel/div
/template
script setupimport axios from axiosimport {reactive,ref,getCurrentInstance,nextTick,onMounted,watch,} from vueimport {useRoute,useRouter} from vue-routerimport {ElMessageBox} from element-plusconst context getCurrentInstance()?.appContext.config.globalProperties;import formModel from ./formModel.vue//基础信息const tableName jiankangdanganconst formName 健康档案const route useRoute()//基础信息onMounted((){})//列表数据const list ref(null)const table ref(null)const listQuery ref({page: 1,limit: 20,sort: id,order: desc})const searchQuery ref({})const selRows ref([])const listLoading ref(false)const listChange (row) {nextTick((){//table.value.clearSelection()table.value.toggleRowSelection(row)})}//列表const getList () {listLoading.value truelet params JSON.parse(JSON.stringify(listQuery.value))params[sort] idparams[order] descif(searchQuery.value.yonghuxingmingsearchQuery.value.yonghuxingming!){params[yonghuxingming] % searchQuery.value.yonghuxingming %}context?.$http({url: ${tableName}/page,method: get,params: params}).then(res {listLoading.value falselist.value res.data.data.listtotal.value Number(res.data.data.total)})}//删const delClick (id) {let ids ref([])if (id) {ids.value [id]} else {if (selRows.value.length) {for (let x in selRows.value) {ids.value.push(selRows.value[x].id)}} else {return false}}ElMessageBox.confirm(是否删除选中${formName}, 提示, {confirmButtonText: 是,cancelButtonText: 否,type: warning,}).then(() {context?.$http({url: ${tableName}/delete,method: post,data: ids.value}).then(res {context?.$toolUtil.message(删除成功, success,(){getList()})})})}//多选const handleSelectionChange (e) {selRows.value e}//列表数据//分页const total ref(0)const layouts ref([total,prev,pager,next,sizes,jumper])const sizeChange (size) {listQuery.value.limit sizegetList()}const currentChange (page) {listQuery.value.page pagegetList()}const prevClick () {listQuery.value.page listQuery.value.page - 1getList()}const nextClick () {listQuery.value.page listQuery.value.page 1getList()}//分页//权限验证const btnAuth (e,a){return context?.$toolUtil.isAuth(e,a)}//搜索const searchClick () {listQuery.value.page 1getList()}//表单const formRef ref(null)const formModelChange(){searchClick()}const addClick (){formRef.value.init()}const editClick (){if(selRows.value.length){formRef.value.init(selRows.value[0].id,edit)}}const infoClick (idnull){if(id){formRef.value.init(id,info)}else if(selRows.value.length){formRef.value.init(selRows.value[0].id,info)}}// 表单// 预览文件const preClick (file) {if(!file){context?.$toolUtil.message(文件不存在,error)}window.open(context?.$config.url file)// const a document.createElement(a);// a.style.display none;// a.setAttribute(target, _blank);// file a.setAttribute(download, file);// a.href context?.$config.url file;// document.body.appendChild(a);// a.click();// document.body.removeChild(a);}// 下载文件const download (file) {if(!file){context?.$toolUtil.message(文件不存在,error)}let arr file.replace(new RegExp(file/, g), )axios.get((location.href.split(context?.$config.name).length1 ? location.href.split(context?.$config.name)[0] :) context?.$config.name /file/download?fileName arr, {headers: {token: context?.$toolUtil.storageGet(Token)},responseType: blob}).then(({data}) {const binaryData [];binaryData.push(data);const objectUrl window.URL.createObjectURL(new Blob(binaryData, {type: application/pdf;chartsetUTF-8}))const a document.createElement(a)a.href objectUrla.download arr// a.click()// 下面这个写法兼容火狐a.dispatchEvent(new MouseEvent(click, {bubbles: true,cancelable: true,view: window}))window.URL.revokeObjectURL(data)})}//初始化const init () {getList()}init()
/script
style langscss scoped// 操作盒子.list_search_view {margin: 0 0 20px;display: flex;flex-wrap: wrap;// 搜索盒子.search_form {border: 0px solid #654B3C;border-radius: 20px;padding: 0 0 0 20px;margin: 0 20px 0 0;display: flex;align-items: center;order: 2;// 子盒子.search_view {padding: 0;margin: 0 0 0 0;display: flex;align-items: center;// 搜索label.search_label {margin: 0 5px 0;color: #666;background: none;font-weight: 500;display: inline-block;width: auto;font-size: 14px;line-height: 40px;text-align: right;height: 40px;}// 搜索item.search_box {padding: 0;display: inline-block;width: auto;// 输入框:deep(.search_inp) {border-radius: 4px;padding: 0 10px;background: #fff;width: 150px;border-color: #b9c8d2;border-width: 4px;line-height: 32px;box-sizing: border-box;border-style: solid;height: 40px;//去掉默认样式.el-input__wrapper{border: none;box-shadow: none;background: none;border-radius: 0;height: 100%;padding: 0;}.is-focus {box-shadow: none !important;}}}}// 搜索按钮盒子.search_btn_view {// 搜索按钮.search_btn {border: 4px inset #c1efff;cursor: pointer;border-radius: 4px;padding: 0 20px;margin: 0 0 0 10px;color: #fff;background: linear-gradient(180deg, rgba(193,239,255,1) 0%, rgba(41,139,161,1) 100%);width: auto;font-size: 14px;min-width: 90px;height: 40px;}// 搜索按钮-悬浮.search_btn:hover {}}}//头部按钮盒子.btn_view {display: flex;order: 1;// 其他:deep(.el-button--default){border: 4px inset #ccc;cursor: pointer;border-radius: 4px;padding: 0 20px;margin: 0 5px 0 0;color: #333;background: #fff;font-weight: 600;width: auto;font-size: 14px;height: 40px;}// 其他-悬浮:deep(.el-button--default:hover){opacity: 0.8;}// 新增:deep(.el-button--success){border: 4px inset #a8deec;cursor: pointer;border-radius: 4px;padding: 0 20px;margin: 0 5px 0 0;color: #51abca;background: #fff;font-weight: 600;width: auto;font-size: 14px;height: 40px;}// 新增-悬浮:deep(.el-button--success:hover){}// 修改:deep(.el-button--primary){border: 4px inset #99b6ec;cursor: pointer;border-radius: 4px;padding: 0 20px;margin: 0 5px 0 0;color: #6f9aea;background: #fff;font-weight: 600;width: auto;font-size: 14px;height: 40px;}// 修改-悬浮:deep(.el-button--primary:hover){}// 详情:deep(.el-button--info){border: 4px inset #a8deec;cursor: pointer;border-radius: 4px;padding: 0 20px;margin: 0 5px 0 0;color: #51abca;background: #fff;font-weight: 600;width: auto;font-size: 14px;height: 40px;}// 详情-悬浮:deep(.el-button--info:hover){}// 删除:deep(.el-button--danger){border: 4px inset #f1aba0;cursor: pointer;border-radius: 4px;padding: 0 20px;margin: 0 5px 0 0;color: #eb7865;background: #fff;font-weight: 600;width: auto;font-size: 14px;height: 40px;}// 删除-悬浮:deep(.el-button--danger:hover){}// 统计:deep(.el-button--warning){border: 4px inset #99b6ec;cursor: pointer;border-radius: 4px;padding: 0 20px;margin: 0 5px 0 0;color: #6f9aea;background: #fff;font-weight: 600;width: auto;font-size: 14px;height: 40px;}// 统计-悬浮:deep(.el-button--warning:hover){opacity: 0.8;}}}// 表格样式.el-table {border-radius: 0px;padding: 0;background: #fff;width: 100%;font-size: 14px;border-color: #73bac820;border-width: 1px 0 0 1px;border-style: solid;:deep(.el-table__header-wrapper) {thead {color: inherit;font-weight: 500;width: 100%;tr {background: #f8f8f8;th {padding: 5px 0;background: #f1ce55;border-color: #edf7f9;border-width: 0 0px 6px 0;border-style: solid;text-align: left;.cell {padding: 0 5px;word-wrap: normal;color: #3a7a90;white-space: normal;font-weight: bold;display: inline-block;vertical-align: middle;font-size: 16px;line-height: 24px;text-overflow: ellipsis;word-break: break-all;width: 100%;position: relative;}}}}}:deep(.el-table__body-wrapper) {tbody {width: 100%;tr {background: #fff;td {padding: 5px 0;color: #555;background: #fff;border-color: #edf7f9;border-width: 0 0px 6px 0;border-style: solid;text-align: left;.cell {padding: 0 10px;overflow: hidden;word-break: break-all;white-space: normal;line-height: 24px;text-overflow: ellipsis;// 编辑.el-button--primary {border: 0px solid #eee;cursor: pointer;border-radius: 20px;padding: 4px 8px;margin: 0 6px 6px 0;color: #fff;background: #6f9aea;width: auto;font-size: 13px;height: auto;}// 编辑-悬浮.el-button--primary:hover {}// 详情.el-button--info {border: 0px solid #eee;cursor: pointer;border-radius: 20px;padding: 4px 8px;margin: 0 6px 6px 0;color: #fff;background: #51abca;width: auto;font-size: 13px;height: auto;}// 详情-悬浮.el-button--info:hover {}// 删除.el-button--danger {border: 0px solid #eee;cursor: pointer;border-radius: 20px;padding: 4px 8px;margin: 0 6px 6px 0;color: #fff;background: #eb7865;width: auto;font-size: 13px;height: auto;}// 删除-悬浮.el-button--danger:hover {}// 跨表.el-button--success {border: 0px solid #eee;cursor: pointer;border-radius: 20px;padding: 4px 8px;margin: 0 6px 6px 0;color: #fff;background: #999;width: auto;font-size: 13px;height: auto;}// 跨表-悬浮.el-button--success:hover {}// 操作.el-button--warning {border: 0px solid #eee;cursor: pointer;border-radius: 20px;padding: 4px 8px;margin: 0 6px 6px 0;color: #fff;background: #ff9a48;width: auto;font-size: 13px;height: auto;}// 操作-悬浮.el-button--warning:hover {}}}}tr:hover {td {padding: 5px 0;color: #666;background: #73bac810;border-color: #edf7f9;border-width: 0 0px 6px 0;border-style: solid;text-align: left;}}}}}// 分页器.el-pagination {// 总页码:deep(.el-pagination__total) {margin: 0 10px 0 0;color: #666;font-weight: 400;display: inline-block;vertical-align: top;font-size: 13px;line-height: 28px;height: 28px;}// 上一页:deep(.btn-prev) {border: 1px solid #eee;border-radius: 0px;padding: 0 5px;margin: 0 5px;color: #666;background: #fff;display: inline-block;vertical-align: top;font-size: 13px;line-height: 26px;min-width: 35px;height: 26px;}// 下一页:deep(.btn-next) {border: 1px solid #eee;border-radius: 0px;padding: 0 5px;margin: 0 5px;color: #666;background: #fff;display: inline-block;vertical-align: top;font-size: 13px;line-height: 26px;min-width: 35px;height: 26px;}// 上一页禁用:deep(.btn-prev:disabled) {border: 1px solid #eee;cursor: not-allowed;border-radius: 0px;padding: 0 5px;margin: 0 5px;color: #666;background: #fff;display: inline-block;vertical-align: top;font-size: 13px;line-height: 26px;height: 26px;}// 下一页禁用:deep(.btn-next:disabled) {border: 1px solid #eee;cursor: not-allowed;border-radius: 0px;padding: 0 5px;margin: 0 5px;color: #666;background: #fff;display: inline-block;vertical-align: top;font-size: 13px;line-height: 26px;height: 26px;}// 页码:deep(.el-pager) {padding: 0;margin: 0;display: inline-block;vertical-align: top;// 数字.number {cursor: pointer;border: 1px solid #ddd;padding: 0 4px;margin: 0 5px;color: #666;display: inline-block;vertical-align: top;font-size: 13px;line-height: 26px;border-radius: 0px;background: #fff;text-align: center;min-width: 30px;height: 26px;}// 数字悬浮.number:hover {cursor: pointer;border: 1px solid #8ed0e8;padding: 0 4px;margin: 0 5px;color: #666;display: inline-block;vertical-align: top;font-size: 13px;line-height: 26px;border-radius: 0px;background: #bcedff;text-align: center;min-width: 30px;height: 26px;}// 选中.number.is-active {cursor: default;border: 1px solid #8ed0e8;padding: 0 4px;margin: 0 5px;color: #333;display: inline-block;vertical-align: top;font-size: 13px;line-height: 26px;border-radius: 0px;background: #bcedff;text-align: center;min-width: 30px;height: 26px;}}// sizes:deep(.el-pagination__sizes) {display: inline-block;vertical-align: top;font-size: 13px;line-height: 28px;height: 28px;.el-select {border: 1px solid #DCDFE6;cursor: pointer;padding: 0;color: #606266;display: inline-block;font-size: 13px;line-height: 28px;border-radius: 3px;outline: 0;background: #FFF;width: 100%;text-align: center;height: 28px;}}// 跳页:deep(.el-pagination__jump) {margin: 0 0 0 24px;color: #606266;display: inline-block;vertical-align: top;font-size: 13px;line-height: 28px;height: 28px;// 输入框.el-input {border: 1px solid #DCDFE6;cursor: pointer;padding: 0 3px;color: #606266;display: inline-block;font-size: 14px;line-height: 28px;border-radius: 3px;outline: 0;background: #FFF;width: auto;text-align: center;height: 28px;//去掉默认样式.el-input__wrapper{border: none;box-shadow: none;background: none;border-radius: 0;height: 100%;padding: 0;}.is-focus {box-shadow: none !important;}}}}
/style数据库代码
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost Database: cl08837313
-- ------------------------------------------------------
-- Server version 5.7.31/*!40101 SET OLD_CHARACTER_SET_CLIENTCHARACTER_SET_CLIENT */;
/*!40101 SET OLD_CHARACTER_SET_RESULTSCHARACTER_SET_RESULTS */;
/*!40101 SET OLD_COLLATION_CONNECTIONCOLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET OLD_TIME_ZONETIME_ZONE */;
/*!40103 SET TIME_ZONE00:00 */;
/*!40014 SET OLD_UNIQUE_CHECKSUNIQUE_CHECKS, UNIQUE_CHECKS0 */;
/*!40014 SET OLD_FOREIGN_KEY_CHECKSFOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS0 */;
/*!40101 SET OLD_SQL_MODESQL_MODE, SQL_MODENO_AUTO_VALUE_ON_ZERO */;
/*!40111 SET OLD_SQL_NOTESSQL_NOTES, SQL_NOTES0 */;--
-- Current Database: cl08837313
--/*!40000 DROP DATABASE IF EXISTS cl08837313*/;CREATE DATABASE /*!32312 IF NOT EXISTS*/ cl08837313 /*!40100 DEFAULT CHARACTER SET utf8mb4 */;USE cl08837313;--
-- Table structure for table chat
--DROP TABLE IF EXISTS chat;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE chat (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,adminid bigint(20) DEFAULT NULL COMMENT 管理员id,ask longtext COMMENT 提问内容,reply longtext COMMENT 回复内容,isreply int(11) DEFAULT NULL COMMENT 是否回复,userid bigint(20) NOT NULL COMMENT 用户id,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT107 DEFAULT CHARSETutf8 COMMENT在线咨询;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table chat
--LOCK TABLES chat WRITE;
/*!40000 ALTER TABLE chat DISABLE KEYS */;
INSERT INTO chat VALUES (101,2024-05-09 01:48:50,1,提问内容1,回复内容1,1,1),(102,2024-05-09 01:48:50,2,提问内容2,回复内容2,2,2),(103,2024-05-09 01:48:50,3,提问内容3,回复内容3,3,3),(104,2024-05-09 01:48:50,4,提问内容4,回复内容4,4,4),(105,2024-05-09 01:48:50,5,提问内容5,回复内容5,5,5),(106,2024-05-09 01:48:50,6,提问内容6,回复内容6,6,6);
/*!40000 ALTER TABLE chat 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)
) ENGINEInnoDB AUTO_INCREMENT4 DEFAULT CHARSETutf8 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,swiper1,file/swiperPicture1.jpg),(2,swiper2,file/swiperPicture2.jpg),(3,swiper3,file/swiperPicture3.jpg);
/*!40000 ALTER TABLE config ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table discussjiankangshipin
--DROP TABLE IF EXISTS discussjiankangshipin;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE discussjiankangshipin (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,refid bigint(20) NOT NULL COMMENT 关联表id,userid bigint(20) NOT NULL COMMENT 用户id,avatarurl longtext COMMENT 头像,nickname varchar(200) DEFAULT NULL COMMENT 用户名,content longtext NOT NULL COMMENT 评论内容,reply longtext COMMENT 回复内容,PRIMARY KEY (id)
) ENGINEInnoDB DEFAULT CHARSETutf8 COMMENT健康视频评论表;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table discussjiankangshipin
--LOCK TABLES discussjiankangshipin WRITE;
/*!40000 ALTER TABLE discussjiankangshipin DISABLE KEYS */;
/*!40000 ALTER TABLE discussjiankangshipin ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table jiankangdangan
--DROP TABLE IF EXISTS jiankangdangan;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE jiankangdangan (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,yonghuzhanghao varchar(200) DEFAULT NULL COMMENT 用户账号,yonghuxingming varchar(200) DEFAULT NULL COMMENT 用户姓名,xingbie varchar(200) DEFAULT NULL COMMENT 性别,nianling varchar(200) DEFAULT NULL COMMENT 年龄,tizhong double DEFAULT NULL COMMENT 体重,xueya double DEFAULT NULL COMMENT 血压,xuezhi double DEFAULT NULL COMMENT 血脂,xinlv varchar(200) DEFAULT NULL COMMENT 心率,dengjishijian datetime DEFAULT NULL COMMENT 登记时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT47 DEFAULT CHARSETutf8 COMMENT健康档案;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table jiankangdangan
--LOCK TABLES jiankangdangan WRITE;
/*!40000 ALTER TABLE jiankangdangan DISABLE KEYS */;
INSERT INTO jiankangdangan VALUES (41,2024-05-09 01:48:50,用户账号1,用户姓名1,性别1,年龄1,1,1,1,心率1,2024-05-09 09:48:50),(42,2024-05-09 01:48:50,用户账号2,用户姓名2,性别2,年龄2,2,2,2,心率2,2024-05-09 09:48:50),(43,2024-05-09 01:48:50,用户账号3,用户姓名3,性别3,年龄3,3,3,3,心率3,2024-05-09 09:48:50),(44,2024-05-09 01:48:50,用户账号4,用户姓名4,性别4,年龄4,4,4,4,心率4,2024-05-09 09:48:50),(45,2024-05-09 01:48:50,用户账号5,用户姓名5,性别5,年龄5,5,5,5,心率5,2024-05-09 09:48:50),(46,2024-05-09 01:48:50,用户账号6,用户姓名6,性别6,年龄6,6,6,6,心率6,2024-05-09 09:48:50);
/*!40000 ALTER TABLE jiankangdangan ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table jiankangshipin
--DROP TABLE IF EXISTS jiankangshipin;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE jiankangshipin (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,shipinbiaoti varchar(200) NOT NULL COMMENT 视频标题,shipinfengmian longtext NOT NULL COMMENT 视频封面,shipinleixing varchar(200) NOT NULL COMMENT 视频类型,shipin longtext NOT NULL COMMENT 视频,shipinjianjie longtext COMMENT 视频简介,fabushijian datetime DEFAULT NULL COMMENT 发布时间,clicktime datetime DEFAULT NULL COMMENT 最近点击时间,storeupnum int(11) DEFAULT NULL COMMENT 收藏数量,clicknum int(11) DEFAULT NULL COMMENT 点击次数,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT127 DEFAULT CHARSETutf8 COMMENT健康视频;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table jiankangshipin
--LOCK TABLES jiankangshipin WRITE;
/*!40000 ALTER TABLE jiankangshipin DISABLE KEYS */;
INSERT INTO jiankangshipin VALUES (121,2024-05-09 01:48:50,视频标题1,file/jiankangshipinShipinfengmian1.jpg,file/jiankangshipinShipinfengmian2.jpg,file/jiankangshipinShipinfengmian3.jpg,视频类型1,,视频简介1,2024-05-09 09:48:50,2024-05-09 09:48:50,1,1),(122,2024-05-09 01:48:50,视频标题2,file/jiankangshipinShipinfengmian2.jpg,file/jiankangshipinShipinfengmian3.jpg,file/jiankangshipinShipinfengmian4.jpg,视频类型2,,视频简介2,2024-05-09 09:48:50,2024-05-09 09:48:50,2,2),(123,2024-05-09 01:48:50,视频标题3,file/jiankangshipinShipinfengmian3.jpg,file/jiankangshipinShipinfengmian4.jpg,file/jiankangshipinShipinfengmian5.jpg,视频类型3,,视频简介3,2024-05-09 09:48:50,2024-05-09 09:48:50,3,3),(124,2024-05-09 01:48:50,视频标题4,file/jiankangshipinShipinfengmian4.jpg,file/jiankangshipinShipinfengmian5.jpg,file/jiankangshipinShipinfengmian6.jpg,视频类型4,,视频简介4,2024-05-09 09:48:50,2024-05-09 09:48:50,4,4),(125,2024-05-09 01:48:50,视频标题5,file/jiankangshipinShipinfengmian5.jpg,file/jiankangshipinShipinfengmian6.jpg,file/jiankangshipinShipinfengmian7.jpg,视频类型5,,视频简介5,2024-05-09 09:48:50,2024-05-09 09:48:50,5,5),(126,2024-05-09 01:48:50,视频标题6,file/jiankangshipinShipinfengmian6.jpg,file/jiankangshipinShipinfengmian7.jpg,file/jiankangshipinShipinfengmian8.jpg,视频类型6,,视频简介6,2024-05-09 09:48:50,2024-05-09 09:48:50,6,6);
/*!40000 ALTER TABLE jiankangshipin ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table menu
--DROP TABLE IF EXISTS menu;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE menu (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,menujson longtext COMMENT 菜单,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT2 DEFAULT CHARSETutf8 COMMENT菜单;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table menu
--LOCK TABLES menu WRITE;
/*!40000 ALTER TABLE menu DISABLE KEYS */;
INSERT INTO menu VALUES (1,2024-05-09 01:48:50,[{\backMenu\:[{\child\:[{\appFrontIcon\:\cuIcon-camera\,\buttons\:[\新增\,\查看\,\修改\,\删除\],\menu\:\轮播图\,\menuJump\:\列表\,\tableName\:\config\},{\appFrontIcon\:\cuIcon-skin\,\buttons\:[\新增\,\查看\,\修改\,\删除\],\menu\:\管理员\,\menuJump\:\列表\,\tableName\:\users\},{\appFrontIcon\:\cuIcon-phone\,\buttons\:[\新增\,\查看\,\修改\,\删除\],\menu\:\健康知识\,\menuJump\:\列表\,\tableName\:\news\}],\fontClass\:\icon-common47\,\menu\:\管理员管理\,\unicode\:\#xef63;\},{\child\:[{\appFrontIcon\:\cuIcon-discover\,\buttons\:[\新增\,\查看\,\修改\,\删除\],\menu\:\用户\,\menuJump\:\列表\,\tableName\:\yonghu\}],\fontClass\:\icon-user5\,\menu\:\用户管理\,\unicode\:\#xef9b;\},{\child\:[{\appFrontIcon\:\cuIcon-goods\,\buttons\:[\查看\,\删除\],\menu\:\健康档案\,\menuJump\:\列表\,\tableName\:\jiankangdangan\}],\fontClass\:\icon-common45\,\menu\:\健康档案管理\,\unicode\:\#xef3b;\},{\child\:[{\appFrontIcon\:\cuIcon-addressbook\,\buttons\:[\查看\,\删除\,\睡眠时长\,\首页总数\,\首页统计\,\睡眠建议\],\menu\:\睡眠管理\,\menuJump\:\列表\,\tableName\:\shuimianguanli\},{\appFrontIcon\:\cuIcon-paint\,\buttons\:[\查看\,\删除\],\menu\:\睡眠建议\,\menuJump\:\列表\,\tableName\:\shuimianjianyi\}],\fontClass\:\icon-common47\,\menu\:\睡眠管理\,\unicode\:\#xef63;\},{\child\:[{\appFrontIcon\:\cuIcon-present\,\buttons\:[\查看\,\删除\,\饮食建议\],\menu\:\饮食记录\,\menuJump\:\列表\,\tableName\:\yinshijilu\},{\appFrontIcon\:\cuIcon-discover\,\buttons\:[\查看\,\删除\],\menu\:\饮食建议\,\menuJump\:\列表\,\tableName\:\yinshijianyi\}],\fontClass\:\icon-common23\,\menu\:\饮食记录管理\,\unicode\:\#xee05;\},{\child\:[{\appFrontIcon\:\cuIcon-full\,\buttons\:[\查看\,\删除\,\建议\],\menu\:\运动记录\,\menuJump\:\列表\,\tableName\:\yundongjilu\},{\appFrontIcon\:\cuIcon-camera\,\buttons\:[\查看\,\删除\],\menu\:\运动建议\,\menuJump\:\列表\,\tableName\:\yundongjianyi\}],\fontClass\:\icon-common3\,\menu\:\运动记录管理\,\unicode\:\#xeda5;\},{\child\:[{\appFrontIcon\:\cuIcon-clothes\,\buttons\:[\新增\,\查看\,\修改\,\删除\],\menu\:\视频类型\,\menuJump\:\列表\,\tableName\:\shipinleixing\},{\appFrontIcon\:\cuIcon-copy\,\buttons\:[\新增\,\查看\,\修改\,\删除\,\查看评论\],\menu\:\健康视频\,\menuJump\:\列表\,\tableName\:\jiankangshipin\}],\fontClass\:\icon-common1\,\menu\:\健康视频管理\,\unicode\:\#xeda3;\},{\child\:[{\appFrontIcon\:\cuIcon-present\,\buttons\:[\新增\,\查看\,\修改\,\删除\],\menu\:\中药类别\,\menuJump\:\列表\,\tableName\:\zhongyaoleibie\},{\appFrontIcon\:\cuIcon-form\,\buttons\:[\新增\,\查看\,\修改\,\删除\],\menu\:\中药信息\,\menuJump\:\列表\,\tableName\:\zhongyaoxinxi\}],\fontClass\:\icon-common8\,\menu\:\中药信息管理\,\unicode\:\#xedb6;\},{\child\:[{\appFrontIcon\:\cuIcon-camera\,\buttons\:[\查看\,\调摄\,\删除\],\menu\:\心理健康\,\menuJump\:\列表\,\tableName\:\xinlijiankang\},{\appFrontIcon\:\cuIcon-discover\,\buttons\:[\查看\,\删除\],\menu\:\情志调摄\,\menuJump\:\列表\,\tableName\:\qingzhidiaoshe\}],\fontClass\:\icon-common49\,\menu\:\情志调摄管理\,\unicode\:\#xef79;\},{\child\:[{\appFrontIcon\:\cuIcon-time\,\buttons\:[\查看\],\menu\:\在线咨询\,\menuJump\:\列表\,\tableName\:\chat\}],\fontClass\:\icon-common42\,\menu\:\客服聊天管理\,\unicode\:\#xef24;\}],\frontMenu\:[],\hasBackLogin\:\是\,\hasBackRegister\:\否\,\hasFrontLogin\:\否\,\hasFrontRegister\:\否\,\roleName\:\管理员\,\tableName\:\users\},{\backMenu\:[{\child\:[{\appFrontIcon\:\cuIcon-goods\,\buttons\:[\新增\,\查看\,\修改\,\删除\],\menu\:\健康档案\,\menuJump\:\列表\,\tableName\:\jiankangdangan\}],\fontClass\:\icon-common45\,\menu\:\健康档案管理\,\unicode\:\#xef3b;\},{\child\:[{\appFrontIcon\:\cuIcon-addressbook\,\buttons\:[\新增\,\查看\,\修改\,\删除\],\menu\:\睡眠管理\,\menuJump\:\列表\,\tableName\:\shuimianguanli\},{\appFrontIcon\:\cuIcon-paint\,\buttons\:[\查看\,\删除\],\menu\:\睡眠建议\,\menuJump\:\列表\,\tableName\:\shuimianjianyi\}],\fontClass\:\icon-common47\,\menu\:\睡眠管理\,\unicode\:\#xef63;\},{\child\:[{\appFrontIcon\:\cuIcon-present\,\buttons\:[\新增\,\查看\,\修改\,\删除\],\menu\:\饮食记录\,\menuJump\:\列表\,\tableName\:\yinshijilu\},{\appFrontIcon\:\cuIcon-discover\,\buttons\:[\查看\,\删除\],\menu\:\饮食建议\,\menuJump\:\列表\,\tableName\:\yinshijianyi\}],\fontClass\:\icon-common23\,\menu\:\饮食记录管理\,\unicode\:\#xee05;\},{\child\:[{\appFrontIcon\:\cuIcon-full\,\buttons\:[\新增\,\查看\,\修改\,\删除\],\menu\:\运动记录\,\menuJump\:\列表\,\tableName\:\yundongjilu\},{\appFrontIcon\:\cuIcon-camera\,\buttons\:[\查看\,\删除\],\menu\:\运动建议\,\menuJump\:\列表\,\tableName\:\yundongjianyi\}],\fontClass\:\icon-common3\,\menu\:\运动记录管理\,\unicode\:\#xeda5;\},{\child\:[{\appFrontIcon\:\cuIcon-camera\,\buttons\:[\新增\,\查看\,\修改\,\删除\],\menu\:\心理健康\,\menuJump\:\列表\,\tableName\:\xinlijiankang\},{\appFrontIcon\:\cuIcon-discover\,\buttons\:[\查看\,\删除\],\menu\:\情志调摄\,\menuJump\:\列表\,\tableName\:\qingzhidiaoshe\}],\fontClass\:\icon-common49\,\menu\:\情志调摄管理\,\unicode\:\#xef79;\},{\child\:[{\appFrontIcon\:\cuIcon-time\,\buttons\:[\查看\],\menu\:\在线咨询\,\menuJump\:\列表\,\tableName\:\chat\}],\fontClass\:\icon-common42\,\menu\:\客服聊天管理\,\unicode\:\#xef24;\},{\child\:[{\appFrontIcon\:\cuIcon-taxi\,\buttons\:[\查看\],\menu\:\我的收藏\,\menuJump\:\1\,\tableName\:\storeup\}],\fontClass\:\icon-common35\,\menu\:\我的收藏管理\,\unicode\:\#xee8c;\}],\frontMenu\:[],\hasBackLogin\:\否\,\hasBackRegister\:\否\,\hasFrontLogin\:\是\,\hasFrontRegister\:\是\,\roleName\:\用户\,\tableName\:\yonghu\}]);
/*!40000 ALTER TABLE menu ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table news
--DROP TABLE IF EXISTS news;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
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 longtext NOT NULL COMMENT 图片,content longtext NOT NULL COMMENT 内容,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT67 DEFAULT CHARSETutf8 COMMENT健康知识;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table news
--LOCK TABLES news WRITE;
/*!40000 ALTER TABLE news DISABLE KEYS */;
INSERT INTO news VALUES (61,2024-05-09 01:48:50,青花瓷,素胚勾勒出青花笔锋浓转淡瓶身描绘的牡丹一如你初妆冉冉檀香透过窗心事我了然宣上走笔至此搁一半釉色渲染仕女图韵味被私藏而你嫣然的一笑如含苞待放你的美缕飘散去到我去不了的地方天青色等烟雨 而我在等你炊烟袅袅升起,file/newsPicture1.jpg,素胚勾勒出青花笔锋浓转淡瓶身描绘的牡丹一如你初妆冉冉檀香透过窗心事我了然宣上走笔至此搁一半釉色渲染仕女图韵味被私藏而你嫣然的一笑如含苞待放你的美缕飘散去到我去不了的地方天青色等烟雨 而我在等你炊烟袅袅升起 隔江千万里在瓶底书前朝的飘逸就当我为遇见你伏笔天青色等烟雨 而我在等你月色被打捞起 晕开了局如传世的青花瓷自顾自美丽你眼带笑意色白花青的锦鲤跃然于碗底临摹宋体落款时却惦记着你你隐藏在窑烧里千年的秘密极细腻犹如绣花针落地帘外芭蕉惹骤雨门环惹铜绿而我路过那江南小镇惹了你在泼墨山水画里你从墨色深处被隐去天青色等烟雨 而我在等你炊烟袅袅升起 隔江千万里在瓶底书汉隶仿前朝的飘逸就当我为遇见你伏笔天色等烟雨 而我在等你月色被打捞起 晕开了结局如传世的青花瓷自顾自美丽你眼带笑意天青色等烟雨 而我在等你炊烟袅袅升起 隔江千万里在瓶底书汉隶仿前朝的飘逸就当我为遇见你伏笔天青色等烟雨 而我在等你月色被打捞起 晕开了结局如传世的青花瓷自顾自美丽你眼带笑意。),(62,2024-05-09 01:48:50,理想三旬,雨后有车驶来驶过暮色苍白旧铁皮往南开恋人已不在收听浓烟下的诗歌电台不动情的咳嗽至少看起来归途也还可爱琴弦少了姿态再不见那夜里听歌的小孩时光匆匆独白将颠沛磨成卡带已枯倦的情怀踏碎成年代就老去吧孤独别醒来你渴望的离开只是无处停摆就歌唱吧眼睛眯起来而热泪的崩坏只是没抵达的存在,file/newsPicture2.jpg,雨后有车驶来驶过暮色苍白旧铁皮往南开恋人已不在收听浓烟下的诗歌电台不动情的咳嗽至少看起来归途也还可爱琴弦少了姿态再不见那夜里听歌的小孩时光匆匆独白将颠沛磨成卡带已枯倦的情怀踏碎成年代就老去吧孤独别醒来你渴望的离开只是无处停摆就歌唱吧眼睛眯起来而热泪的崩坏只是没抵达的存在青春又醉倒在籍籍无名的怀靠嬉笑来虚度聚散得慷慨辗转却去不到对的站台如果漂泊是成长必经的路牌你迷醒岁月中那贫瘠的未来像遗憾季节里未结果的爱弄脏了每一页诗吻最疼痛的告白而风声吹到这已不需要释怀就老去吧孤独别醒来渴望的离开只是无处停摆就歌唱吧眼睛眯起来而热泪的崩坏只是没抵达的存在就甜蜜地忍耐繁星润湿窗台光影跳动着像在困倦里说爱再无谓的感慨以为明白梦倒塌的地方今已爬满青苔。),(63,2024-05-09 01:48:50,七里香,窗外的麻雀在电线杆上多嘴你说这一句很有夏天的感觉手中的铅笔在纸上来来回回我用几行字形容你是我的谁秋刀鱼的滋味猫跟你都想了解初恋的香味就这样被我们寻回那温暖的阳光像刚摘的鲜艳草莓你说你舍不得吃掉这一种感觉雨下整夜我的爱溢出就像雨水院子落叶跟我的思念厚厚一叠,file/newsPicture3.jpg,窗外的麻雀在电线杆上多嘴你说这一句很有夏天的感觉手中的铅笔在纸上来来回回我用几行字形容你是我的谁秋刀鱼的滋味猫跟你都想了解初恋的香味就这样被我们寻回那温暖的阳光像刚摘的鲜艳草莓你说你舍不得吃掉这一种感觉雨下整夜我的爱溢出就像雨水院子落叶跟我的思念厚厚一叠几句是非也无法将我的热情冷却你出现在我诗的每一页雨下整夜我的爱溢出就像雨水窗台蝴蝶像诗里纷飞的美丽章节我接着写把永远爱你写进诗的结尾你是我唯一想要的了解雨下整夜我的爱溢出就像雨水院子落叶跟我的思念厚厚一叠几句是非也无法将我的热情冷却你出现在我诗的每一页那饱满的稻穗幸福了这个季节而你的脸颊像田里熟透的番茄你突然对我说七里香的名字很美我此刻却只想亲吻你倔强的嘴雨下整夜我的爱溢出就像雨水院子落叶跟我的思念厚厚一叠几句是非也无法将我的热情冷却你出现在我诗的每一页整夜我的爱溢出就像雨水窗台蝴蝶像诗里纷飞的美丽章节我接着写把永远爱你写进诗的结尾是我唯一想要的了解。),(64,2024-05-09 01:48:50,江南,风到这里就是粘粘住过客的思念雨到了这里缠成线缠着我们流连人世间你在身边就是缘缘分写在三生石上面爱有万分之一甜宁愿我就葬在这一点圈圈圆圆圈圈天天年年天天的我深深看你的脸生气的温柔埋怨的温柔的脸,file/newsPicture4.jpg,风到这里就是粘粘住过客的思念雨到了这里缠成线缠着我们流连人世间你在身边就是缘缘分写在三生石上面爱有万分之一甜宁愿我就葬在这一点圈圈圆圆圈圈天天年年天天的我深深看你的脸生气的温柔埋怨的温柔的脸不懂爱恨情愁煎熬的我们都以为相爱就像风云的善变相信爱一天抵过永远在这一刹那冻结了时间不懂怎么表现温柔的我们还以为殉情只是古老的传言离愁能有多痛痛有多浓当梦被埋在江南烟雨中心碎了才懂圈圈圆圆圈圈天天年年天天的我深深看你的脸生气的温柔埋怨的温柔的脸不懂爱恨情愁煎熬的我们都以为相爱就像风云的善变相信爱一天 抵过永远在这一刹那冻结了时间不懂怎么表现温柔的我们还以为殉情只是古老的传言离愁能有多痛 痛有多浓当梦被埋在江南烟雨中心碎了才懂相信爱一天抵过永远。在这一刹那冻结了时间不懂怎么表现温柔的我们还以为殉情只是古老的传言离愁能有多痛 痛有多浓当梦被埋在江南烟雨中心碎了才懂。),(65,2024-05-09 01:48:50,那些你很冒险的梦,当两颗心开始震动当你瞳孔学会闪躲当爱慢慢被遮住只剩下黑距离像影子被拉拖当爱的故事剩听说我找不到你单纯的面孔当生命每分每秒都为你转动心多执着就加倍心痛那些你很冒险的梦 我陪你去疯折纸飞机碰到雨天终究会坠落,file/newsPicture5.jpg,当两颗心开始震动当你瞳孔学会闪躲当爱慢慢被遮住只剩下黑距离像影子被拉拖当爱的故事剩听说我找不到你单纯的面孔当生命每分每秒都为你转动心多执着就加倍心痛那些你很冒险的梦 我陪你去疯折纸飞机碰到雨天终究会坠落太残忍的话我直说 因为爱很重你却不想懂 只往反方向走当爱的故事剩听说我找不到你单纯的面孔当生命每分每秒都为你转动心有多执着就加倍心痛那些你很冒险的梦 我陪你去疯折纸飞机 碰到雨天 终究会坠落太残忍的话我直说 因为爱很重你却不想懂 只往反方向走我不想放手 你松开的左手你爱的放纵 我白不回天空我输了 累了但你再也 不回头那些你很冒险的梦 我陪你去疯折纸飞机 碰到雨天 终究会坠落太残忍的话我直说 因为爱很重你却不想懂 只往反方向走你真的不懂 我的爱已降落。),(66,2024-05-09 01:48:50,孤勇者,都是勇敢的你额头的伤口 你的 不同 你犯的错都 不必隐藏你破旧的玩偶 你的 面具 你的自我他们说 要带着光 驯服每一头怪兽他们说 要缝好你的伤没有人爱小丑 为何孤独 不可 光荣人只有不完美 值得歌颂谁说污泥满身的不算英雄爱你孤身走暗巷爱你不跪的模样爱你对峙过绝望,file/newsPicture6.jpg,都是勇敢的你额头的伤口 你的 不同 你犯的错都 不必隐藏你破旧的玩偶 你的 面具 你的自我他们说 要带着光 驯服每一头怪兽他们说 要缝好你的伤没有人爱小丑 为何孤独 不可 光荣人只有不完美 值得歌颂谁说污泥满身的不算英雄爱你孤身走暗巷爱你不跪的模样爱你对峙过绝望不肯哭一场爱你破烂的衣裳却敢堵命运的枪爱你和我那么像缺口都一样去吗 配吗 这褴褛的披风战吗 战啊 以最卑微的梦致那黑夜中的呜咽与怒吼谁说站在光里的才算英雄他们说 要戒了你的狂就像擦掉了污垢他们说 要顺台阶而上而代价是低头那就让我 不可 乘风你一样骄傲着 那种孤勇谁说对弈平凡的不算英雄爱你孤身走暗巷 爱你不跪的模样爱你对峙过绝望 不肯哭一场爱你破烂的衣裳 却敢堵命运的枪爱你和我那么像 缺口都一样去吗 配吗 这褴褛的披风战吗 战啊 以最卑微的梦致那黑夜中的呜咽与怒吼谁说站在光里的才算英雄你的斑驳 与众不同 与众不同你的沉默 震耳欲聋 震耳欲聋You Are The Hero爱你孤身走暗巷 爱你不跪的模样爱你对峙过绝望 不肯哭一场爱你来自于蛮荒 一生不借谁的光你将造你的城邦 在废墟之上去吗 去啊 以最卑微的梦战吗 战啊 以最孤高的梦致那黑夜中的呜咽与怒吼谁说站在光里的才算英雄。);
/*!40000 ALTER TABLE news ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table qingzhidiaoshe
--DROP TABLE IF EXISTS qingzhidiaoshe;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE qingzhidiaoshe (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,diaoshebiaoti varchar(200) NOT NULL COMMENT 调摄标题,yinpin longtext COMMENT 音频,diaoshefangshi varchar(200) DEFAULT NULL COMMENT 调摄方式,shijian varchar(200) DEFAULT NULL COMMENT 事件,xinqingpingfen varchar(200) DEFAULT NULL COMMENT 心情评分,diaosheneirong longtext COMMENT 调摄内容,faburiqi date DEFAULT NULL COMMENT 发布日期,storeupnum int(11) DEFAULT NULL COMMENT 收藏数量,yonghuzhanghao varchar(200) DEFAULT NULL COMMENT 用户账号,yonghuxingming varchar(200) DEFAULT NULL COMMENT 用户姓名,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT167 DEFAULT CHARSETutf8 COMMENT情志调摄;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table qingzhidiaoshe
--LOCK TABLES qingzhidiaoshe WRITE;
/*!40000 ALTER TABLE qingzhidiaoshe DISABLE KEYS */;
INSERT INTO qingzhidiaoshe VALUES (161,2024-05-09 01:48:50,调摄标题1,,调摄方式1,事件1,心情评分1,调摄内容1,2024-05-09,1,用户账号1,用户姓名1),(162,2024-05-09 01:48:50,调摄标题2,,调摄方式2,事件2,心情评分2,调摄内容2,2024-05-09,2,用户账号2,用户姓名2),(163,2024-05-09 01:48:50,调摄标题3,,调摄方式3,事件3,心情评分3,调摄内容3,2024-05-09,3,用户账号3,用户姓名3),(164,2024-05-09 01:48:50,调摄标题4,,调摄方式4,事件4,心情评分4,调摄内容4,2024-05-09,4,用户账号4,用户姓名4),(165,2024-05-09 01:48:50,调摄标题5,,调摄方式5,事件5,心情评分5,调摄内容5,2024-05-09,5,用户账号5,用户姓名5),(166,2024-05-09 01:48:50,调摄标题6,,调摄方式6,事件6,心情评分6,调摄内容6,2024-05-09,6,用户账号6,用户姓名6);
/*!40000 ALTER TABLE qingzhidiaoshe ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table shipinleixing
--DROP TABLE IF EXISTS shipinleixing;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE shipinleixing (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,shipinleixing varchar(200) NOT NULL COMMENT 视频类型,PRIMARY KEY (id),UNIQUE KEY shipinleixing (shipinleixing)
) ENGINEInnoDB AUTO_INCREMENT117 DEFAULT CHARSETutf8 COMMENT视频类型;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table shipinleixing
--LOCK TABLES shipinleixing WRITE;
/*!40000 ALTER TABLE shipinleixing DISABLE KEYS */;
INSERT INTO shipinleixing VALUES (111,2024-05-09 01:48:50,视频类型1),(112,2024-05-09 01:48:50,视频类型2),(113,2024-05-09 01:48:50,视频类型3),(114,2024-05-09 01:48:50,视频类型4),(115,2024-05-09 01:48:50,视频类型5),(116,2024-05-09 01:48:50,视频类型6);
/*!40000 ALTER TABLE shipinleixing ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table shuimianguanli
--DROP TABLE IF EXISTS shuimianguanli;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE shuimianguanli (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,yonghuzhanghao varchar(200) DEFAULT NULL COMMENT 用户账号,yonghuxingming varchar(200) DEFAULT NULL COMMENT 用户姓名,rushuishijian datetime DEFAULT NULL COMMENT 入睡时间,qichuangshijian datetime DEFAULT NULL COMMENT 起床时间,shuimianshizhang int(11) DEFAULT NULL COMMENT 睡眠时长,shuimianzhiliang varchar(200) DEFAULT NULL COMMENT 睡眠质量,qingxingcishu int(11) DEFAULT NULL COMMENT 清醒次数,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT57 DEFAULT CHARSETutf8 COMMENT睡眠管理;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table shuimianguanli
--LOCK TABLES shuimianguanli WRITE;
/*!40000 ALTER TABLE shuimianguanli DISABLE KEYS */;
INSERT INTO shuimianguanli VALUES (51,2024-05-09 01:48:50,用户账号1,用户姓名1,2024-05-09 09:48:50,2024-05-09 09:48:50,1,睡眠质量1,1),(52,2024-05-09 01:48:50,用户账号2,用户姓名2,2024-05-09 09:48:50,2024-05-09 09:48:50,2,睡眠质量2,2),(53,2024-05-09 01:48:50,用户账号3,用户姓名3,2024-05-09 09:48:50,2024-05-09 09:48:50,3,睡眠质量3,3),(54,2024-05-09 01:48:50,用户账号4,用户姓名4,2024-05-09 09:48:50,2024-05-09 09:48:50,4,睡眠质量4,4),(55,2024-05-09 01:48:50,用户账号5,用户姓名5,2024-05-09 09:48:50,2024-05-09 09:48:50,5,睡眠质量5,5),(56,2024-05-09 01:48:50,用户账号6,用户姓名6,2024-05-09 09:48:50,2024-05-09 09:48:50,6,睡眠质量6,6);
/*!40000 ALTER TABLE shuimianguanli ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table shuimianjianyi
--DROP TABLE IF EXISTS shuimianjianyi;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE shuimianjianyi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,yonghuzhanghao varchar(200) DEFAULT NULL COMMENT 用户账号,yonghuxingming varchar(200) DEFAULT NULL COMMENT 用户姓名,shuimianzhiliang varchar(200) DEFAULT NULL COMMENT 睡眠质量,shuimianjianyi longtext COMMENT 睡眠建议,jianyishijian datetime DEFAULT NULL COMMENT 建议时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT177 DEFAULT CHARSETutf8 COMMENT睡眠建议;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table shuimianjianyi
--LOCK TABLES shuimianjianyi WRITE;
/*!40000 ALTER TABLE shuimianjianyi DISABLE KEYS */;
INSERT INTO shuimianjianyi VALUES (171,2024-05-09 01:48:50,用户账号1,用户姓名1,睡眠质量1,睡眠建议1,2024-05-09 09:48:50),(172,2024-05-09 01:48:50,用户账号2,用户姓名2,睡眠质量2,睡眠建议2,2024-05-09 09:48:50),(173,2024-05-09 01:48:50,用户账号3,用户姓名3,睡眠质量3,睡眠建议3,2024-05-09 09:48:50),(174,2024-05-09 01:48:50,用户账号4,用户姓名4,睡眠质量4,睡眠建议4,2024-05-09 09:48:50),(175,2024-05-09 01:48:50,用户账号5,用户姓名5,睡眠质量5,睡眠建议5,2024-05-09 09:48:50),(176,2024-05-09 01:48:50,用户账号6,用户姓名6,睡眠质量6,睡眠建议6,2024-05-09 09:48:50);
/*!40000 ALTER TABLE shuimianjianyi ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table storeup
--DROP TABLE IF EXISTS storeup;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE storeup (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,refid bigint(20) DEFAULT NULL COMMENT refid,tablename varchar(200) DEFAULT NULL COMMENT 表名,name varchar(200) NOT NULL COMMENT 名称,picture longtext NOT NULL COMMENT 图片,type varchar(200) DEFAULT NULL COMMENT 类型(1:收藏,21:赞,22:踩,31:竞拍参与,41:关注),inteltype varchar(200) DEFAULT NULL COMMENT 推荐类型,remark varchar(200) DEFAULT NULL COMMENT 备注,userid bigint(20) NOT NULL COMMENT 用户id,PRIMARY KEY (id)
) ENGINEInnoDB DEFAULT CHARSETutf8 COMMENT我的收藏;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table storeup
--LOCK TABLES storeup WRITE;
/*!40000 ALTER TABLE storeup DISABLE KEYS */;
/*!40000 ALTER TABLE storeup ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table token
--DROP TABLE IF EXISTS token;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
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 AUTO_INCREMENT2 DEFAULT CHARSETutf8 COMMENTtoken表;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table token
--LOCK TABLES token WRITE;
/*!40000 ALTER TABLE token DISABLE KEYS */;
INSERT INTO token VALUES (1,31,用户账号1,yonghu,用户,m89bbgwmdtvuv0o3peh3ko4lruehfcjk,2024-05-09 01:53:00,2024-05-09 02:53:00);
/*!40000 ALTER TABLE token ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table users
--DROP TABLE IF EXISTS users;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE users (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,username varchar(200) NOT NULL COMMENT 用户名,password varchar(200) NOT NULL COMMENT 密码,role varchar(200) DEFAULT NULL COMMENT 角色,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT2 DEFAULT CHARSETutf8 COMMENT管理员;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table users
--LOCK TABLES users WRITE;
/*!40000 ALTER TABLE users DISABLE KEYS */;
INSERT INTO users VALUES (1,2024-05-09 01:48:50,admin,admin,管理员);
/*!40000 ALTER TABLE users ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table xinlijiankang
--DROP TABLE IF EXISTS xinlijiankang;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE xinlijiankang (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,riqi date DEFAULT NULL COMMENT 日期,xinliqingxu longtext COMMENT 心理情绪,yonghuzhanghao varchar(200) DEFAULT NULL COMMENT 用户账号,yonghuxingming varchar(200) DEFAULT NULL COMMENT 用户姓名,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT157 DEFAULT CHARSETutf8 COMMENT心理健康;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table xinlijiankang
--LOCK TABLES xinlijiankang WRITE;
/*!40000 ALTER TABLE xinlijiankang DISABLE KEYS */;
INSERT INTO xinlijiankang VALUES (151,2024-05-09 01:48:50,2024-05-09,心理情绪1,用户账号1,用户姓名1),(152,2024-05-09 01:48:50,2024-05-09,心理情绪2,用户账号2,用户姓名2),(153,2024-05-09 01:48:50,2024-05-09,心理情绪3,用户账号3,用户姓名3),(154,2024-05-09 01:48:50,2024-05-09,心理情绪4,用户账号4,用户姓名4),(155,2024-05-09 01:48:50,2024-05-09,心理情绪5,用户账号5,用户姓名5),(156,2024-05-09 01:48:50,2024-05-09,心理情绪6,用户账号6,用户姓名6);
/*!40000 ALTER TABLE xinlijiankang ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table yinshijianyi
--DROP TABLE IF EXISTS yinshijianyi;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE yinshijianyi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,jiluriqi date DEFAULT NULL COMMENT 记录日期,shiwumingcheng varchar(200) DEFAULT NULL COMMENT 食物名称,reliang varchar(200) DEFAULT NULL COMMENT 热量,danbaizhi varchar(200) DEFAULT NULL COMMENT 蛋白质,zhifang varchar(200) DEFAULT NULL COMMENT 脂肪,yonghuzhanghao varchar(200) DEFAULT NULL COMMENT 用户账号,yinshijianyi longtext COMMENT 饮食建议,jianyishijian datetime DEFAULT NULL COMMENT 建议时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT187 DEFAULT CHARSETutf8 COMMENT饮食建议;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table yinshijianyi
--LOCK TABLES yinshijianyi WRITE;
/*!40000 ALTER TABLE yinshijianyi DISABLE KEYS */;
INSERT INTO yinshijianyi VALUES (181,2024-05-09 01:48:50,2024-05-09,食物名称1,热量1,蛋白质1,脂肪1,用户账号1,饮食建议1,2024-05-09 09:48:50),(182,2024-05-09 01:48:50,2024-05-09,食物名称2,热量2,蛋白质2,脂肪2,用户账号2,饮食建议2,2024-05-09 09:48:50),(183,2024-05-09 01:48:50,2024-05-09,食物名称3,热量3,蛋白质3,脂肪3,用户账号3,饮食建议3,2024-05-09 09:48:50),(184,2024-05-09 01:48:50,2024-05-09,食物名称4,热量4,蛋白质4,脂肪4,用户账号4,饮食建议4,2024-05-09 09:48:50),(185,2024-05-09 01:48:50,2024-05-09,食物名称5,热量5,蛋白质5,脂肪5,用户账号5,饮食建议5,2024-05-09 09:48:50),(186,2024-05-09 01:48:50,2024-05-09,食物名称6,热量6,蛋白质6,脂肪6,用户账号6,饮食建议6,2024-05-09 09:48:50);
/*!40000 ALTER TABLE yinshijianyi ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table yinshijilu
--DROP TABLE IF EXISTS yinshijilu;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE yinshijilu (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,jiluriqi date DEFAULT NULL COMMENT 记录日期,shiwumingcheng varchar(200) DEFAULT NULL COMMENT 食物名称,reliang varchar(200) DEFAULT NULL COMMENT 热量,danbaizhi varchar(200) DEFAULT NULL COMMENT 蛋白质,zhifang varchar(200) DEFAULT NULL COMMENT 脂肪,yonghuzhanghao varchar(200) DEFAULT NULL COMMENT 用户账号,yonghuxingming varchar(200) DEFAULT NULL COMMENT 用户姓名,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT77 DEFAULT CHARSETutf8 COMMENT饮食记录;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table yinshijilu
--LOCK TABLES yinshijilu WRITE;
/*!40000 ALTER TABLE yinshijilu DISABLE KEYS */;
INSERT INTO yinshijilu VALUES (71,2024-05-09 01:48:50,2024-05-09,食物名称1,热量1,蛋白质1,脂肪1,用户账号1,用户姓名1),(72,2024-05-09 01:48:50,2024-05-09,食物名称2,热量2,蛋白质2,脂肪2,用户账号2,用户姓名2),(73,2024-05-09 01:48:50,2024-05-09,食物名称3,热量3,蛋白质3,脂肪3,用户账号3,用户姓名3),(74,2024-05-09 01:48:50,2024-05-09,食物名称4,热量4,蛋白质4,脂肪4,用户账号4,用户姓名4),(75,2024-05-09 01:48:50,2024-05-09,食物名称5,热量5,蛋白质5,脂肪5,用户账号5,用户姓名5),(76,2024-05-09 01:48:50,2024-05-09,食物名称6,热量6,蛋白质6,脂肪6,用户账号6,用户姓名6);
/*!40000 ALTER TABLE yinshijilu ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table yonghu
--DROP TABLE IF EXISTS yonghu;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE yonghu (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,yonghuzhanghao varchar(200) NOT NULL COMMENT 用户账号,yonghumima varchar(200) NOT NULL COMMENT 用户密码,yonghuxingming varchar(200) NOT NULL COMMENT 用户姓名,touxiang longtext COMMENT 头像,xingbie varchar(200) DEFAULT NULL COMMENT 性别,shoujihaoma varchar(200) DEFAULT NULL COMMENT 手机号码,nianling varchar(200) DEFAULT NULL COMMENT 年龄,PRIMARY KEY (id),UNIQUE KEY yonghuzhanghao (yonghuzhanghao)
) ENGINEInnoDB AUTO_INCREMENT37 DEFAULT CHARSETutf8 COMMENT用户;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table yonghu
--LOCK TABLES yonghu WRITE;
/*!40000 ALTER TABLE yonghu DISABLE KEYS */;
INSERT INTO yonghu VALUES (31,2024-05-09 01:48:50,用户账号1,123456,用户姓名1,file/yonghuTouxiang1.jpg,男,19819881111,年龄1),(32,2024-05-09 01:48:50,用户账号2,123456,用户姓名2,file/yonghuTouxiang2.jpg,男,19819881112,年龄2),(33,2024-05-09 01:48:50,用户账号3,123456,用户姓名3,file/yonghuTouxiang3.jpg,男,19819881113,年龄3),(34,2024-05-09 01:48:50,用户账号4,123456,用户姓名4,file/yonghuTouxiang4.jpg,男,19819881114,年龄4),(35,2024-05-09 01:48:50,用户账号5,123456,用户姓名5,file/yonghuTouxiang5.jpg,男,19819881115,年龄5),(36,2024-05-09 01:48:50,用户账号6,123456,用户姓名6,file/yonghuTouxiang6.jpg,男,19819881116,年龄6);
/*!40000 ALTER TABLE yonghu ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table yundongjianyi
--DROP TABLE IF EXISTS yundongjianyi;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE yundongjianyi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,yundongriqi date NOT NULL COMMENT 运动日期,yundongmingcheng varchar(200) DEFAULT NULL COMMENT 运动名称,yundongqiangdu varchar(200) DEFAULT NULL COMMENT 运动强度,yundongshizhang varchar(200) DEFAULT NULL COMMENT 运动时长,xiaohaoreliang varchar(200) DEFAULT NULL COMMENT 消耗热量,yonghuzhanghao varchar(200) NOT NULL COMMENT 用户账号,yonghuxingming varchar(200) NOT NULL COMMENT 用户姓名,yundongjianyi longtext COMMENT 运动建议,jianyishijian datetime DEFAULT NULL COMMENT 建议时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT197 DEFAULT CHARSETutf8 COMMENT运动建议;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table yundongjianyi
--LOCK TABLES yundongjianyi WRITE;
/*!40000 ALTER TABLE yundongjianyi DISABLE KEYS */;
INSERT INTO yundongjianyi VALUES (191,2024-05-09 01:48:50,2024-05-09,运动名称1,运动强度1,运动时长1,消耗热量1,用户账号1,用户姓名1,运动建议1,2024-05-09 09:48:50),(192,2024-05-09 01:48:50,2024-05-09,运动名称2,运动强度2,运动时长2,消耗热量2,用户账号2,用户姓名2,运动建议2,2024-05-09 09:48:50),(193,2024-05-09 01:48:50,2024-05-09,运动名称3,运动强度3,运动时长3,消耗热量3,用户账号3,用户姓名3,运动建议3,2024-05-09 09:48:50),(194,2024-05-09 01:48:50,2024-05-09,运动名称4,运动强度4,运动时长4,消耗热量4,用户账号4,用户姓名4,运动建议4,2024-05-09 09:48:50),(195,2024-05-09 01:48:50,2024-05-09,运动名称5,运动强度5,运动时长5,消耗热量5,用户账号5,用户姓名5,运动建议5,2024-05-09 09:48:50),(196,2024-05-09 01:48:50,2024-05-09,运动名称6,运动强度6,运动时长6,消耗热量6,用户账号6,用户姓名6,运动建议6,2024-05-09 09:48:50);
/*!40000 ALTER TABLE yundongjianyi ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table yundongjilu
--DROP TABLE IF EXISTS yundongjilu;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE yundongjilu (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,yundongriqi date NOT NULL COMMENT 运动日期,yundongmingcheng varchar(200) DEFAULT NULL COMMENT 运动名称,yundongqiangdu varchar(200) DEFAULT NULL COMMENT 运动强度,yundongshizhang varchar(200) DEFAULT NULL COMMENT 运动时长/小时,xiaohaoreliang varchar(200) DEFAULT NULL COMMENT 消耗卡路里(cal),yonghuzhanghao varchar(200) NOT NULL COMMENT 用户账号,yonghuxingming varchar(200) NOT NULL COMMENT 用户姓名,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT87 DEFAULT CHARSETutf8 COMMENT运动记录;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table yundongjilu
--LOCK TABLES yundongjilu WRITE;
/*!40000 ALTER TABLE yundongjilu DISABLE KEYS */;
INSERT INTO yundongjilu VALUES (81,2024-05-09 01:48:50,2024-05-09,运动名称1,强,运动时长/小时1,消耗卡路里(cal)1,用户账号1,用户姓名1),(82,2024-05-09 01:48:50,2024-05-09,运动名称2,强,运动时长/小时2,消耗卡路里(cal)2,用户账号2,用户姓名2),(83,2024-05-09 01:48:50,2024-05-09,运动名称3,强,运动时长/小时3,消耗卡路里(cal)3,用户账号3,用户姓名3),(84,2024-05-09 01:48:50,2024-05-09,运动名称4,强,运动时长/小时4,消耗卡路里(cal)4,用户账号4,用户姓名4),(85,2024-05-09 01:48:50,2024-05-09,运动名称5,强,运动时长/小时5,消耗卡路里(cal)5,用户账号5,用户姓名5),(86,2024-05-09 01:48:50,2024-05-09,运动名称6,强,运动时长/小时6,消耗卡路里(cal)6,用户账号6,用户姓名6);
/*!40000 ALTER TABLE yundongjilu ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table zhongyaoleibie
--DROP TABLE IF EXISTS zhongyaoleibie;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE zhongyaoleibie (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,zhongyaoleibie varchar(200) NOT NULL COMMENT 中药类别,PRIMARY KEY (id),UNIQUE KEY zhongyaoleibie (zhongyaoleibie)
) ENGINEInnoDB AUTO_INCREMENT137 DEFAULT CHARSETutf8 COMMENT中药类别;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table zhongyaoleibie
--LOCK TABLES zhongyaoleibie WRITE;
/*!40000 ALTER TABLE zhongyaoleibie DISABLE KEYS */;
INSERT INTO zhongyaoleibie VALUES (131,2024-05-09 01:48:50,中药类别1),(132,2024-05-09 01:48:50,中药类别2),(133,2024-05-09 01:48:50,中药类别3),(134,2024-05-09 01:48:50,中药类别4),(135,2024-05-09 01:48:50,中药类别5),(136,2024-05-09 01:48:50,中药类别6);
/*!40000 ALTER TABLE zhongyaoleibie ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table zhongyaoxinxi
--DROP TABLE IF EXISTS zhongyaoxinxi;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE zhongyaoxinxi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,zhongyaomingcheng varchar(200) DEFAULT NULL COMMENT 中药名称,tupian longtext COMMENT 图片,zhongyaoleibie varchar(200) DEFAULT NULL COMMENT 中药类别,laiyuan varchar(200) DEFAULT NULL COMMENT 来源,zhuzhigongxiao varchar(200) DEFAULT NULL COMMENT 主治功效,chucuntiaojian varchar(200) DEFAULT NULL COMMENT 储存条件,yaocaigongxiao varchar(200) DEFAULT NULL COMMENT 药材功效,jinji varchar(200) DEFAULT NULL COMMENT 禁忌,yaocaijieshao longtext COMMENT 药材介绍,storeupnum int(11) DEFAULT NULL COMMENT 收藏数量,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT147 DEFAULT CHARSETutf8 COMMENT中药信息;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table zhongyaoxinxi
--LOCK TABLES zhongyaoxinxi WRITE;
/*!40000 ALTER TABLE zhongyaoxinxi DISABLE KEYS */;
INSERT INTO zhongyaoxinxi VALUES (141,2024-05-09 01:48:50,中药名称1,file/zhongyaoxinxiTupian1.jpg,file/zhongyaoxinxiTupian2.jpg,file/zhongyaoxinxiTupian3.jpg,中药类别1,来源1,主治功效1,储存条件1,药材功效1,禁忌1,药材介绍1,1),(142,2024-05-09 01:48:50,中药名称2,file/zhongyaoxinxiTupian2.jpg,file/zhongyaoxinxiTupian3.jpg,file/zhongyaoxinxiTupian4.jpg,中药类别2,来源2,主治功效2,储存条件2,药材功效2,禁忌2,药材介绍2,2),(143,2024-05-09 01:48:50,中药名称3,file/zhongyaoxinxiTupian3.jpg,file/zhongyaoxinxiTupian4.jpg,file/zhongyaoxinxiTupian5.jpg,中药类别3,来源3,主治功效3,储存条件3,药材功效3,禁忌3,药材介绍3,3),(144,2024-05-09 01:48:50,中药名称4,file/zhongyaoxinxiTupian4.jpg,file/zhongyaoxinxiTupian5.jpg,file/zhongyaoxinxiTupian6.jpg,中药类别4,来源4,主治功效4,储存条件4,药材功效4,禁忌4,药材介绍4,4),(145,2024-05-09 01:48:50,中药名称5,file/zhongyaoxinxiTupian5.jpg,file/zhongyaoxinxiTupian6.jpg,file/zhongyaoxinxiTupian7.jpg,中药类别5,来源5,主治功效5,储存条件5,药材功效5,禁忌5,药材介绍5,5),(146,2024-05-09 01:48:50,中药名称6,file/zhongyaoxinxiTupian6.jpg,file/zhongyaoxinxiTupian7.jpg,file/zhongyaoxinxiTupian8.jpg,中药类别6,来源6,主治功效6,储存条件6,药材功效6,禁忌6,药材介绍6,6);
/*!40000 ALTER TABLE zhongyaoxinxi ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONEOLD_TIME_ZONE */;/*!40101 SET SQL_MODEOLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKSOLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKSOLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENTOLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTSOLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTIONOLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTESOLD_SQL_NOTES */;-- Dump completed on 2024-05-09 12:02:53为什么选择我 我是程序员阿龙专注于软件开发拥有丰富的编程能力和实战经验。在过去的几年里我辅导了上千名学生帮助他们顺利完成毕业项目同时我的技术分享也吸引了超过50W的粉丝。我是CSDN特邀作者、博客专家、新星计划导师并在Java领域内获得了多项荣誉如博客之星。我的作品也被掘金、华为云、阿里云、InfoQ等多个平台推荐成为各大平台的优质作者。 已经为上百名同学获得优秀毕业生 源码获取 大家点赞、收藏、关注、评论啦 、查看获取联系方式 精彩专栏推荐订阅在下方专栏
