Java项目之基于springboot+vue智能推荐系统的设计与实现 （源码 + 演示视频）

DROP DATABASE IF EXISTS `yaopintuijian`; CREATE DATABASE `yaopintuijian`; use `yaopintuijian`; set global innodb_large_prefix=on; set global innodb_file_per_table=on; set global innodb_file_format=BARRACUDA; DROP DATABASE IF EXISTS `nx_system_file_info`; CREATE TABLE `nx_system_file_info` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID', `originName` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '原始文件名', `fileName` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '存储文件名', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='文件信息表'; DROP TABLE IF EXISTS `admin_info`; CREATE TABLE `admin_info` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID', `name` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '姓名', `password` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '密码', `nickName` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '昵称', `sex` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '性别', `age` int(10) COMMENT '年龄', `birthday` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '生日', `phone` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '手机号', `address` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '地址', `code` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '编号', `email` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '邮箱', `cardId` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '身份证', `level` int(10) NOT NULL DEFAULT '1' COMMENT '权限等级', UNIQUE KEY `uk_name` (`name`) USING BTREE, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='管理员信息表'; DROP TABLE IF EXISTS `user_info`; CREATE TABLE `user_info` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID', `name` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '姓名', `password` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '密码', `nickName` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '昵称', `sex` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '性别', `age` int(10) COMMENT '年龄', `birthday` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '生日', `phone` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '手机号', `address` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '地址', `email` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '邮箱', `cardId` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '身份证', `level` int(10) NOT NULL DEFAULT '2' COMMENT '权限等级', UNIQUE KEY `uk_name` (`name`) USING BTREE, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='用户信息表'; DROP TABLE IF EXISTS `zhineng_info`; CREATE TABLE `zhineng_info` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID', `name` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '症状', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='智能判断信息表'; DROP TABLE IF EXISTS `advertiser_info`; CREATE TABLE `advertiser_info` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID', `name` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '公告名称', `content` longtext COMMENT '公告内容', `time` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '公告时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='公告信息表'; DROP TABLE IF EXISTS `yufang_info`; CREATE TABLE `yufang_info` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID', `name` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '名称', `content` longtext COMMENT '公告内容', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='疾病预防信息表'; DROP TABLE IF EXISTS `baike_info`; CREATE TABLE `baike_info` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID', `name` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '名称', `content` longtext COMMENT '公告内容', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='健康百科信息表'; DROP TABLE IF EXISTS `yaodian_info`; CREATE TABLE `yaodian_info` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID', `name` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '名称', `content` longtext COMMENT '公告内容', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='药店信息表'; DROP TABLE IF EXISTS `comment_yufang_info`; CREATE TABLE `comment_yufang_info` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID', `content` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '评论内容', `time` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '评论时间', `name` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '评论人', `foreignId` bigint(20) NULL COMMENT '关联的模块id', `parentId` bigint(20) DEFAULT '0' COMMENT '父id', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='疾病预防评论信息表'; DROP TABLE IF EXISTS `comment_baike_info`; CREATE TABLE `comment_baike_info` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID', `content` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '评论内容', `time` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '评论时间', `name` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '评论人', `foreignId` bigint(20) NULL COMMENT '关联的模块id', `parentId` bigint(20) DEFAULT '0' COMMENT '父id', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='健康百科评论信息表'; DROP TABLE IF EXISTS `comment_yaodian_info`; CREATE TABLE `comment_yaodian_info` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID', `content` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '评论内容', `time` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '评论时间', `name` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '评论人', `foreignId` bigint(20) NULL COMMENT '关联的模块id', `parentId` bigint(20) DEFAULT '0' COMMENT '父id', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='药店评论信息表'; INSERT INTO `admin_info` (id, name, password, nickName, sex, age, birthday, phone, address, code, email, cardId, level) VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', '管理员', '男', 22, '2021-02-20 13:49:35', '18843232356', '上海市', '111', 'aa@163.com', '342425199001116372', 1); INSERT INTO `admin_info` (id, name, password, nickName, sex, age, birthday, phone, address, code, email, cardId, level) VALUES (2, 'admin2', 'e10adc3949ba59abbe56e057f20f883e', '管理员', '男', 23, '2021-02-20 13:49:35', '18843232356', '北京市', '222', 'bb@163.com', '342425199001116376', 1); INSERT INTO `admin_info` (id, name, password, nickName, sex, age, birthday, phone, address, code, email, cardId, level) VALUES (3, 'admin3', 'e10adc3949ba59abbe56e057f20f883e', '管理员', '女', 32, '2021-02-20 13:49:35', '18843232356', '合肥市', '333', 'cc@163.com', '342425199001116323', 1); INSERT INTO `admin_info` (id, name, password, nickName, sex, age, birthday, phone, address, code, email, cardId, level) VALUES (4, 'admin4', 'e10adc3949ba59abbe56e057f20f883e', '管理员', '女', 24, '2021-02-20 13:49:35', '18843232356', '北京市', '444', 'hahaha@126.com', '342425199001116837', 1); INSERT INTO `admin_info` (id, name, password, nickName, sex, age, birthday, phone, address, code, email, cardId, level) VALUES (5, 'admin5', 'e10adc3949ba59abbe56e057f20f883e', '管理员', '男', 25, '2021-02-20 13:49:35', '18843232356', '合肥市', '555', '