基于微信小程序的音乐播放器系统+后台管理系统(SSM+mysql)-JAVA.VUE【数据库设计、论文、源码、开题报告】

功能介绍

管理员：首页，个人中心，用户管理，音乐类型管理，音乐信息管理，音乐专辑管理，fm电台管理，音乐论坛管理，系统管理等

普通用户：登录注册、首页、音乐信息、音乐专辑、音乐论坛、我的等

数据库脚本

/*
 Navicat Premium Data Transfer

 Source Server         : root
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:3306
 Source Schema         : ssmxtg83

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 25/04/2022 10:45:29
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for chat
-- ----------------------------
DROP TABLE IF EXISTS `chat`;
CREATE TABLE `chat`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `adminid` bigint(20) NULL DEFAULT NULL COMMENT '管理员id',
  `ask` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '提问',
  `reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复',
  `isreply` int(11) NULL DEFAULT NULL COMMENT '是否回复',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1645177432898 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '在线咨询' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat
-- ----------------------------
INSERT INTO `chat` VALUES (61, '2022-04-23 17:33:23', 1, 1, '提问1', '回复1', 1);
INSERT INTO `chat` VALUES (62, '2022-04-23 17:33:23', 2, 2, '提问2', '回复2', 2);
INSERT INTO `chat` VALUES (63, '2022-04-23 17:33:23', 3, 3, '提问3', '回复3', 3);
INSERT INTO `chat` VALUES (64, '2022-04-23 17:33:23', 4, 4, '提问4', '回复4', 4);
INSERT INTO `chat` VALUES (65, '2022-04-23 17:33:23', 5, 5, '提问5', '回复5', 5);
INSERT INTO `chat` VALUES (66, '2022-04-23 17:33:23', 6, 6, '提问6', '回复6', 6);
INSERT INTO `chat` VALUES (1645177246670, '2022-04-23 17:33:23', 1645177126939, NULL, '的发是发多少', NULL, 0);
INSERT INTO `chat` VALUES (1645177432897, '2022-04-23 17:33:23', 1645177126939, 1, NULL, '时代发顺丰电商6655', NULL);

-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置参数名称',
  `value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置参数值',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置文件' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of config
-- ----------------------------
INSERT INTO `config` VALUES (1, 'picture1', 'upload/1645177096014.jpg');
INSERT INTO `config` VALUES (2, 'picture2', 'upload/picture2.jpg');
INSERT INTO `config` VALUES (3, 'picture3', 'upload/picture3.jpg');

-- ----------------------------
-- Table structure for discussfmdiantai
-- ----------------------------
DROP TABLE IF EXISTS `discussfmdiantai`;
CREATE TABLE `discussfmdiantai`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `refid` bigint(20) NOT NULL COMMENT '关联表id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `nickname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
  `reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复内容',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1645177221747 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'fm电台评论表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of discussfmdiantai
-- ----------------------------
INSERT INTO `discussfmdiantai` VALUES (121, '2022-04-23 17:33:23', 1, 1, '用户名1', '评论内容1', '回复内容1');
INSERT INTO `discussfmdiantai` VALUES (122, '2022-04-23 17:33:23', 2, 2, '用户名2', '评论内容2', '回复内容2');
INSERT INTO `discussfmdiantai` VALUES (123, '2022-04-23 17:33:23', 3, 3, '用户名3', '评论内容3', '回复内容3');
INSERT INTO `discussfmdiantai` VALUES (124, '2022-04-23 17:33:23', 4, 4, '用户名4', '评论内容4', '回复内容4');
INSERT INTO `discussfmdiantai` VALUES (125, '2022-04-23 17:33:23', 5, 5, '用户名5', '评论内容5', '回复内容5');
INSERT INTO `discussfmdiantai` VALUES (126, '2022-04-23 17:33:23', 6, 6, '用户名6', '评论内容6', '回复内容6');
INSERT INTO `discussfmdiantai` VALUES (1645177221746, '2022-04-23 17:33:23', 1645177087228, 1645177126939, '11', '水电费时代444', '');

-- ----------------------------
-- Table structure for discussyinlexinxi
-- ----------------------------
DROP TABLE IF EXISTS `discussyinlexinxi`;
CREATE TABLE `discussyinlexinxi`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `refid` bigint(20) NOT NULL COMMENT '关联表id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `nickname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
  `reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复内容',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1645177169903 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '音乐信息评论表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of discussyinlexinxi
-- ----------------------------
INSERT INTO `discussyinlexinxi` VALUES (101, '2022-04-23 17:33:23', 1, 1, '用户名1', '评论内容1', '回复内容1');
INSERT INTO `discussyinlexinxi` VALUES (102, '2022-04-23 17:33:23', 2, 2, '用户名2', '评论内容2', '回复内容2');
INSERT INTO `discussyinlexinxi` VALUES (103, '2022-04-23 17:33:23', 3, 3, '用户名3', '评论内容3', '回复内容3');
INSERT INTO `discussyinlexinxi` VALUES (104, '2022-04-23 17:33:23', 4, 4, '用户名4', '评论内容4', '回复内容4');
INSERT INTO `discussyinlexinxi` VALUES (105, '2022-04-23 17:33:23', 5, 5, '用户名5', '评论内容5', '回复内容5');
INSERT INTO `discussyinlexinxi` VALUES (106, '2022-04-23 17:33:23', 6, 6, '用户名6', '评论内容6', '回复内容6');