【2025】中医药健康管理小程序(安卓原生开发+用户+管理员）

博主介绍：
✌我是阿龙，一名专注于Java技术领域的程序员，全网拥有10W+粉丝。作为CSDN特邀作者、博客专家、新星计划导师，我在计算机毕业设计开发方面积累了丰富的经验。同时，我也是掘金、华为云、阿里云、InfoQ等平台的优质作者。通过长期分享和实战指导，我致力于帮助更多学生完成毕业项目和技术提升。

技术范围：
我熟悉的技术领域涵盖SpringBoot、Vue、SSM、HLMT、Jsp、PHP、Nodejs、Python、爬虫、数据可视化、小程序、安卓app、大数据、物联网、机器学习等方面的设计与开发。如果你有任何技术难题，我都乐意与你分享解决方案。

主要内容：
我的服务内容包括：免费功能设计、开题报告、任务书、中期检查PPT、系统功能实现、代码编写、论文撰写与辅导、论文降重、长期答辩答疑辅导。此外，我还提供腾讯会议一对一的专业讲解和模拟答辩演练，帮助你全面掌握答辩技巧与代码逻辑。

🍅获取源码请在文末联系我🍅
如果你对我的内容感兴趣，记得先收藏！对于毕设选题、项目开发或论文撰写等相关问题，随时欢迎留言咨询，我会尽力帮助更多同学顺利完成学业。

最主要的是免费咨询相关问题！！

一、详细操作演示视频

在文章的尾声，您会发现一张电子名片👤，欢迎通过名片上的联系方式与我取得联系，以获取更多关于项目演示的详尽视频内容。视频将帮助您全面理解项目的关键点和操作流程。期待与您的进一步交流！
承诺所有开发的项目，全程售后陪伴！！！文章结尾有历年的好评（部分）！！

文档学习资料（阿龙可以赠送所有的录制好的讲解视频）：

项目实现界面：

核心代码：


<template>
	<div>
		<div class="app-contain">
			<div class="list_search_view">
				<el-form :model="searchQuery" class="search_form" >
					<div class="search_view">
						<div class="search_label">
							用户姓名：
						</div>
						<div class="search_box">
							<el-input class="search_inp" v-model="searchQuery.yonghuxingming" placeholder="用户姓名"
								clearable>
							</el-input>
						</div>
					</div>
					<div class="search_btn_view">
						<el-button class="search_btn" type="primary" @click="searchClick()" size="small">搜索</el-button>
					</div>
				</el-form>
				<br>
				<div class="btn_view">
					<el-button type="success" @click="addClick" v-if="btnAuth('jiankangdangan','新增')">新增</el-button>
					<el-button  v-if=" btnAuth('jiankangdangan','查看')" type="info"  :disabled="selRows.length==1?false:true" @click="infoClick(null)">详情</el-button>
					<el-button type="primary" :disabled="selRows.length==1?false:true" @click="editClick" v-if=" btnAuth('jiankangdangan','修改')">修改</el-button>
					<el-button type="danger" :disabled="selRows.length?false:true" @click="delClick(null)"  v-if="btnAuth('jiankangdangan','删除')">删除</el-button>
				</div>
			</div>
			<br>
			<el-table
				v-loading="listLoading"
				border 
				:stripe='false'
				@selection-change="handleSelectionChange" 
				ref="table"
				v-if="btnAuth('jiankangdangan','查看')"
				:data="list"
				@row-click="listChange">
				<el-table-column :resizable='true' align="left" header-align="left" type="selection" width="55" />
				<el-table-column label="序号" width="70" :resizable='true' :sortable='true' align="left" header-align="left">
					<template #default="scope">{{ scope.$index + 1}}</template>
				</el-table-column>
				<el-table-column
					 :resizable='true' 
					 :sortable='true' 
					 align="left" 
					 header-align="left"
					 prop="yonghuzhanghao"
					label="用户账号">
					<template #default="scope">
						{{scope.row.yonghuzhanghao}}
					</template>
				</el-table-column>
				<el-table-column
					 :resizable='true' 
					 :sortable='true' 
					 align="left" 
					 header-align="left"
					 prop="yonghuxingming"
					label="用户姓名">
					<template #default="scope">
						{{scope.row.yonghuxingming}}
					</template>
				</el-table-column>
				<el-table-column
					 :resizable='true' 
					 :sortable='true' 
					 align="left" 
					 header-align="left"
					 prop="xingbie"
					label="性别">
					<template #default="scope">
						{{scope.row.xingbie}}
					</template>
				</el-table-column>
				<el-table-column
					 :resizable='true' 
					 :sortable='true' 
					 align="left" 
					 header-align="left"
					 prop="nianling"
					label="年龄">
					<template #default="scope">
						{{scope.row.nianling}}
					</template>
				</el-table-column>
				<el-table-column
					 :resizable='true' 
					 :sortable='true' 
					 align="left" 
					 header-align="left"
					 prop="tizhong"
					label="体重">
					<template #default="scope">
						{{scope.row.tizhong}}
					</template>
				</el-table-column>
				<el-table-column
					 :resizable='true' 
					 :sortable='true' 
					 align="left" 
					 header-align="left"
					 prop="xueya"
					label="血压">
					<template #default="scope">
						{{scope.row.xueya}}
					</template>
				</el-table-column>
				<el-table-column
					 :resizable='true' 
					 :sortable='true' 
					 align="left" 
					 header-align="left"
					 prop="xuezhi"
					label="血脂">
					<template #default="scope">
						{{scope.row.xuezhi}}
					</template>
				</el-table-column>
				<el-table-column
					 :resizable='true' 
					 :sortable='true' 
					 align="left" 
					 header-align="left"
					 prop="xinlv"
					label="心率">
					<template #default="scope">
						{{scope.row.xinlv}}
					</template>
				</el-table-column>
				<el-table-column
					 :resizable='true' 
					 :sortable='true' 
					 align="left" 
					 header-align="left"
					 prop="dengjishijian"
					label="登记时间">
					<template #default="scope">
						{{scope.row.dengjishijian}}
					</template>
				</el-table-column>
				<el-table-column label="操作" width="300" :resizable='true' :sortable='true' align="left" header-align="left">
					<template #default="scope">
						<el-button type="info" v-if=" btnAuth('jiankangdangan','查看')" @click="infoClick(scope.row.id)">详情</el-button>
					</template>
				</el-table-column>
			</el-table>
			<el-pagination 
				background
				:layout="layouts.join(',')"
				:total="total" 
				:page-size="listQuery.limit"
				prev-text="上一页"
				next-text="下一页"
				:hide-on-single-page="false"
				: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-change="sizeChange"
				@current-change="currentChange" 
				@prev-click="prevClick"
				@next-click="nextClick"  />
		</div>
		<formModel ref="formRef" @formModelChange="formModelChange"></formModel>
	</div>
</template>
<script setup>
	import axios from 'axios'
	import {
		reactive,
		ref,
		getCurrentInstance,
		nextTick,
		onMounted,
		watch,
	} from 'vue'
	import {
		useRoute,
		useRouter
	} from 'vue-router'
	import {
		ElMessageBox
	} from 'element-plus'
	const context = getCurrentInstance()?.appContext.config.globalProperties;
	import formModel from './formModel.vue'
	
	//基础信息
	const tableName = 'jiankangdangan'
	const 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 = true
		let params = JSON.parse(JSON.stringify(listQuery.value))
		params['sort'] = 'id'
		params['order'] = 'desc'
		if(searchQuery.value.yonghuxingming&&searchQuery.value.yonghuxingming!=''){
			params['yonghuxingming'] = '%' + searchQuery.value.yonghuxingming + '%'
		}
		context?.$http({
			url: `${tableName}/page`,
			method: 'get',
			params: params
		}).then(res => {
			listLoading.value = false
			list.value = res.data.data.list
			total.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 = size
		getList()
	}
	const currentChange = (page) => {
		listQuery.value.page = page
		getList()
	}
	const prevClick = () => {
		listQuery.value.page = listQuery.value.page - 1
		getList()
	}
	const nextClick = () => {
		listQuery.value.page = listQuery.value.page + 1
		getList()
	}
	//分页
	//权限验证
	const btnAuth = (e,a)=>{
		return context?.$toolUtil.isAuth(e,a)
	}
	//搜索
	const searchClick = () => {
		listQuery.value.page = 1
		getList()
	}
	//表单
	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 = (id=null)=>{
		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).length>1 ? 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;chartset=UTF-8'
			}))
			const a = document.createElement('a')
			a.href = objectUrl
			a.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 lang="scss" 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_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- 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`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 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`)
) 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,'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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='token表';
/*!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`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=187 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=utf8 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_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-05-09 12:02:53

为什么选择我：

我是程序员阿龙，专注于软件开发，拥有丰富的编程能力和实战经验。在过去的几年里，我辅导了上千名学生，帮助他们顺利完成毕业项目，同时我的技术分享也吸引了超过50W+的粉丝。我是CSDN特邀作者、博客专家、新星计划导师，并在Java领域内获得了多项荣誉，如博客之星。我的作品也被掘金、华为云、阿里云、InfoQ等多个平台推荐，成为各大平台的优质作者。

已经为上百名同学获得优秀毕业生！！！

源码获取：
大家点赞、收藏、关注、评论啦、查看👇🏻获取联系方式👇🏻

精彩专栏推荐订阅：在下方专栏👇🏻