jsp ssm养生食谱与健康餐饮平台 食谱餐饮管理 项目源码 web java【项目源码+数据库脚本+项目说明+软件工具】毕设

/* Navicat Premium Data Transfer Source Server : mysql Source Server Type : MySQL Source Server Version : 50731 Source Host : localhost:3306 Source Schema : jspm09hbt Target Server Type : MySQL Target Server Version : 50731 File Encoding : 65001 Date: 29/09/2024 16:12:16 */ drop database if exists jspm09hbt; create database jspm09hbt charset utf8; use jspm09hbt; SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for address -- ---------------------------- DROP TABLE IF EXISTS `address`; CREATE TABLE `address` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `userid` bigint(20) NOT NULL COMMENT '用户id', `address` varchar(200) NOT NULL COMMENT '地址', `name` varchar(200) NOT NULL COMMENT '收货人', `phone` varchar(200) NOT NULL COMMENT '电话', `isdefault` varchar(200) NOT NULL COMMENT '是否默认地址[是/否]', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='地址'; -- ---------------------------- -- Records of address -- ---------------------------- BEGIN; INSERT INTO `address` (`id`, `addtime`, `userid`, `address`, `name`, `phone`, `isdefault`) VALUES (1, '2024-09-07 17:27:51', 11, '宇宙银河系金星1号', '金某', '13823888881', '是'); INSERT INTO `address` (`id`, `addtime`, `userid`, `address`, `name`, `phone`, `isdefault`) VALUES (2, '2024-09-07 17:27:51', 12, '宇宙银河系木星1号', '木某', '13823888882', '是'); INSERT INTO `address` (`id`, `addtime`, `userid`, `address`, `name`, `phone`, `isdefault`) VALUES (3, '2024-09-07 17:27:51', 13, '宇宙银河系水星1号', '水某', '13823888883', '是'); INSERT INTO `address` (`id`, `addtime`, `userid`, `address`, `name`, `phone`, `isdefault`) VALUES (4, '2024-09-07 17:27:51', 14, '宇宙银河系火星1号', '火某', '13823888884', '是'); INSERT INTO `address` (`id`, `addtime`, `userid`, `address`, `name`, `phone`, `isdefault`) VALUES (5, '2024-09-07 17:27:51', 15, '宇宙银河系土星1号', '土某', '13823888885', '是'); INSERT INTO `address` (`id`, `addtime`, `userid`, `address`, `name`, `phone`, `isdefault`) VALUES (6, '2024-09-07 17:27:51', 16, '宇宙银河系月球1号', '月某', '13823888886', '是'); COMMIT; -- ---------------------------- -- Table structure for caipinleixing -- ---------------------------- DROP TABLE IF EXISTS `caipinleixing`; CREATE TABLE `caipinleixing` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `caipinleixing` varchar(200) DEFAULT NULL COMMENT '菜品类型', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1692756894535 DEFAULT CHARSET=utf8 COMMENT='菜品类型'; -- ---------------------------- -- Records of caipinleixing -- ---------------------------- BEGIN; INSERT INTO `caipinleixing` (`id`, `addtime`, `caipinleixing`) VALUES (1692756864357, '2024-09-23 10:14:24', '凉菜'); INSERT INTO `caipinleixing` (`id`, `addtime`, `caipinleixing`) VALUES (1692756870493, '2024-09-23 10:14:29', '主食'); INSERT INTO `caipinleixing` (`id`, `addtime`, `caipinleixing`) VALUES (1692756878355, '2024-09-23 10:14:38', '小吃'); INSERT INTO `caipinleixing` (`id`, `addtime`, `caipinleixing`) VALUES (1692756894534, '2024-09-23 10:14:53', '家常菜'); COMMIT; -- ---------------------------- -- Table structure for caipinxinxi -- ---------------------------- DROP TABLE IF EXISTS `caipinxinxi`; CREATE TABLE `caipinxinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `caipinmingcheng` varchar(200) NOT NULL COMMENT '菜品名称', `caipinleixing` varchar(200) NOT NULL COMMENT '菜品类型', `tupian` varchar(200) DEFAULT NULL COMMENT '图片', `yujishijian` varchar(200) DEFAULT NULL COMMENT '预计时间', `kouwei` varchar(200) NOT NULL COMMENT '口味', `caipinjieshao` longtext COMMENT '菜品介绍', `clicktime` datetime DEFAULT NULL COMMENT '最近点击时间', `clicknum` int(11) DEFAULT '0' COMMENT '点击次数', `price` float DEFAULT NULL COMMENT '价格', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1692757404786 DEFAULT CHARSET=utf8 COMMENT='菜品信息'; -- ---------------------------- -- Records of caipinxinxi -- ---------------------------- BEGIN; INSERT INTO `caipinxinxi` (`id`, `addtime`, `caipinmingcheng`, `caipinleixing`, `tupian`, `yujishijian`, `kouwei`, `caipinjieshao`, `clicktime`, `clicknum`, `price`) VALUES (1692757025662, '2024-09-23 10:17:05', '拍黄瓜', '凉菜', 'upload/1692756942327.jpg', '5分钟', '酸甜', '<h3 style=\"margin: 0px; padding: 0px; font-size: 20px; font-weight: normal;\">食材明细</h3><p>主料</p><ul style=\"list-style-type: none;\" class=\" list-paddingleft-2\"><li><p><span class=\"category_s1\" style=\"margin: 0px; padding: 0px; display: block; font-size: 20px; width: 159px; height: 40px; line-height: 45px; text-overflow: ellipsis; text-wrap: nowrap; overflow: hidden; color: rgb(102, 102, 102);\"><a href=\"https://www.meishichina.com/YuanLiao/HuangGua/\" title=\"黄瓜的做法\" target=\"_blank\" style=\"margin: 0px; padding: 0px; color: rgb(51, 51, 51); text-decoration-line: none; display: block; width: 159px; height: 40px; text-overflow: ellipsis; overflow: hidden;\"><span style=\"margin: 0px; padding: 0px;\">黄瓜</span></a></span><span class=\"category_s2\" style=\"margin: 0px auto; padding: 0px; color: rgb(153, 153, 153); display: block; line-height: 16px; overflow: hidden; width: 133.55px;\">3根</span></p></li><li><p><span class=\"category_s1\" style=\"margin: 0px; padding: 0px; display: block; font-size: 20px; width: 159px; height: 40px; line-height: 45px; text-overflow: ellipsis; text-wrap: nowrap; overflow: hidden; color: rgb(102, 102, 102);\"><a href=\"https://www.meishichina.com/YuanLiao/XiangCai/\" title=\"香菜的做法\" target=\"_blank\" style=\"margin: 0px; padding: 0px; color: rgb(51, 51, 51); text-decoration-line: none; display: block; width: 159px; height: 40px; text-overflow: ellipsis; overflow: hidden;\"><span style=\"margin: 0px; padding: 0px;\">香菜</span></a></span><span class=\"category_s2\" style=\"margin: 0px auto; padding: 0px; color: rgb(153, 153, 153); display: block; line-height: 16px; overflow: hidden; width: 133.55px;\">适量</span></p></li><li><p><span class=\"category_s1\" style=\"margin: 0px; padding: 0px; display: block; font-size: 20px; width: 159px; height: 40px; line-height: 45px; text-overflow: ellipsis; text-wrap: nowrap; overflow: hidden; color: rgb(102, 102, 102);\"><a href=\"https://www.meishichina.com/YuanLiao/HuaSheng/\" title=\"花生的做法\" target=\"_blank\" style=\"margin: 0px; padding: 0px; color: rgb(51, 51, 51); text-decoration-line: none; display: block; width: 159px; height: 40px; text-overflow: ellipsis; overflow: hidden;\"><span style=\"margin: 0px; padding: 0px;\">花生</span></a></span><span class=\"category_s2\" style=\"margin: 0px auto; padding: 0px; color: rgb(153, 153, 153); display: block; line-height: 16px; overflow: hidden; width: 133.55px;\">适量</span></p></li></ul><p>辅料</p><ul style=\"list-style-type: none;\" class=\" list-paddingleft-2\"><li><p><span class=\"category_s1\" style=\"margin: 0px; padding: 0px; display: block; font-size: 20px; width: 159px; height: 40px; line-height: 45px; text-overflow: ellipsis; text-wrap: nowrap; overflow: hidden; color: rgb(102, 102, 102);\"><a href=\"https://www.meishichina.com/YuanLiao/DaSuan/\" title=\"蒜头的做法\" target=\"_blank\" style=\"margin: 0px; padding: 0px; color: rgb(51, 51, 51); text-decoration-line: none; display: block; width: 159px; height: 40px; text-overflow: ellipsis; overflow: hidden;\"><span style=\"m