做房地产自己要花钱开网站,对网站建设在电子商务中的看法,网络管理员正在设计新的无线网络,杭州seo推广优化公司博主介绍#xff1a; ✌我是阿龙#xff0c;一名专注于Java技术领域的程序员#xff0c;全网拥有10W粉丝。作为CSDN特邀作者、博客专家、新星计划导师#xff0c;我在计算机毕业设计开发方面积累了丰富的经验。同时#xff0c;我也是掘金、华为云、阿里云、InfoQ等平台… 博主介绍 ✌我是阿龙一名专注于Java技术领域的程序员全网拥有10W粉丝。作为CSDN特邀作者、博客专家、新星计划导师我在计算机毕业设计开发方面积累了丰富的经验。同时我也是掘金、华为云、阿里云、InfoQ等平台的优质作者。通过长期分享和实战指导我致力于帮助更多学生完成毕业项目和技术提升。 技术范围 我熟悉的技术领域涵盖SpringBoot、Vue、SSM、HLMT、Jsp、PHP、Nodejs、Python、爬虫、数据可视化、小程序、安卓app、大数据、物联网、机器学习等方面的设计与开发。如果你有任何技术难题我都乐意与你分享解决方案。 主要内容 我的服务内容包括免费功能设计、开题报告、任务书、中期检查PPT、系统功能实现、代码编写、论文撰写与辅导、论文降重、长期答辩答疑辅导。此外我还提供腾讯会议一对一的专业讲解和模拟答辩演练帮助你全面掌握答辩技巧与代码逻辑。 获取源码请在文末联系我 如果你对我的内容感兴趣记得先收藏对于毕设选题、项目开发或论文撰写等相关问题随时欢迎留言咨询我会尽力帮助更多同学顺利完成学业。 最主要的是免费咨询相关问题 一、详细操作演示视频 在文章的尾声您会发现一张电子名片欢迎通过名片上的联系方式与我取得联系以获取更多关于项目演示的详尽视频内容。视频将帮助您全面理解项目的关键点和操作流程。期待与您的进一步交流 承诺所有开发的项目全程售后陪伴文章下方有历年的好评部分 文档学习资料阿龙可以赠送所有的录制好的讲解视频 系统界面实现 核心代码
{pages: [pages/index/index,pages/login/login,pages/forget/forget,pages/yonghu/register,pages/pay-confirm/pay-confirm,pages/user-info/user-info,pages/reply/reply,component/dateTimePicker/dateTime,component/com-date/com-date,component/com-editor/com-editor,component/edit-and-add/edit-and-add,component/comment-item/comment-item,component/com-popup/com-popup,component/com-video/com-video,component/com-manySel/com-manySel,component/tree-menu/tree-menu,pages/shop-orders/logistics,pages/yonghu/detail,pages/yonghu/update-and-add,pages/yonghu/list,pages/gerengedan/detail,pages/gerengedan/update-and-add,pages/gerengedan/list,pages/paixingbang/detail,pages/paixingbang/update-and-add,pages/paixingbang/list,pages/guanfanggedan/detail,pages/guanfanggedan/update-and-add,pages/guanfanggedan/list,pages/yinle/detail,pages/yinle/update-and-add,pages/yinle/list,pages/storeup/list,pages/discussyinle/detail,pages/discussyinle/update-and-add,pages/discussyinle/list,pages/addcomment/addcomment,pages/center/center],permission: {scope.userLocation: {desc: 你的位置信息将用于小程序位置接口的}},window: {backgroundTextStyle: light,navigationBarBackgroundColor: #fff,navigationBarTitleText: Weixin,navigationBarTextStyle: black},tabBar: {selectedColor: #33a3dc,list: [{pagePath: pages/index/index,iconPath: /static/index.png,selectedIconPath: /static/index1.png,text: 首页},{pagePath: pages/yinle/list,iconPath: /static/tabs/2/icon1.png,selectedIconPath: /static/tabs/2/icon1_act.png,text: 音乐},{pagePath: pages/center/center,iconPath: static/tabs/2/mine.png,selectedIconPath: static/tabs/2/mine1.png,text: 我的}]},sitemapLocation: sitemap.json
}
数据库核心代码
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost Database: cl58779116
-- ------------------------------------------------------
-- 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: cl58779116
--/*!40000 DROP DATABASE IF EXISTS cl58779116*/;CREATE DATABASE /*!32312 IF NOT EXISTS*/ cl58779116 /*!40100 DEFAULT CHARACTER SET utf8mb4 */;USE cl58779116;--
-- 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 discussyinle
--DROP TABLE IF EXISTS discussyinle;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE discussyinle (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 discussyinle
--LOCK TABLES discussyinle WRITE;
/*!40000 ALTER TABLE discussyinle DISABLE KEYS */;
/*!40000 ALTER TABLE discussyinle ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table gerengedan
--DROP TABLE IF EXISTS gerengedan;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE gerengedan (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,zhanghao varchar(200) DEFAULT NULL COMMENT 账号,nicheng varchar(200) DEFAULT NULL COMMENT 歌单所属用户,gedanmingcheng varchar(200) DEFAULT NULL COMMENT 歌单名称,songname varchar(200) NOT NULL COMMENT 歌名,songfile longtext NOT NULL COMMENT 音乐文件,singer varchar(200) NOT NULL COMMENT 歌手,geci longtext COMMENT 歌词,fengmian longtext COMMENT 封面,fabushijian varchar(200) DEFAULT NULL COMMENT 发布时间,fengge varchar(200) DEFAULT NULL COMMENT 风格,crossuserid bigint(20) DEFAULT NULL COMMENT 跨表用户id,crossrefid bigint(20) DEFAULT NULL COMMENT 跨表主键id,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT47 DEFAULT CHARSETutf8 COMMENT个人歌单;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table gerengedan
--LOCK TABLES gerengedan WRITE;
/*!40000 ALTER TABLE gerengedan DISABLE KEYS */;
INSERT INTO gerengedan VALUES (41,2024-03-19 07:28:09,账号1,歌单所属用户1,歌单名称1,歌名1,,歌手1,歌词1,file/gerengedanFengmian1.jpg,file/gerengedanFengmian2.jpg,file/gerengedanFengmian3.jpg,发布时间1,风格1,1,1),(42,2024-03-19 07:28:09,账号2,歌单所属用户2,歌单名称2,歌名2,,歌手2,歌词2,file/gerengedanFengmian2.jpg,file/gerengedanFengmian3.jpg,file/gerengedanFengmian4.jpg,发布时间2,风格2,2,2),(43,2024-03-19 07:28:09,账号3,歌单所属用户3,歌单名称3,歌名3,,歌手3,歌词3,file/gerengedanFengmian3.jpg,file/gerengedanFengmian4.jpg,file/gerengedanFengmian5.jpg,发布时间3,风格3,3,3),(44,2024-03-19 07:28:09,账号4,歌单所属用户4,歌单名称4,歌名4,,歌手4,歌词4,file/gerengedanFengmian4.jpg,file/gerengedanFengmian5.jpg,file/gerengedanFengmian6.jpg,发布时间4,风格4,4,4),(45,2024-03-19 07:28:09,账号5,歌单所属用户5,歌单名称5,歌名5,,歌手5,歌词5,file/gerengedanFengmian5.jpg,file/gerengedanFengmian6.jpg,file/gerengedanFengmian7.jpg,发布时间5,风格5,5,5),(46,2024-03-19 07:28:09,账号6,歌单所属用户6,歌单名称6,歌名6,,歌手6,歌词6,file/gerengedanFengmian6.jpg,file/gerengedanFengmian7.jpg,file/gerengedanFengmian8.jpg,发布时间6,风格6,6,6);
/*!40000 ALTER TABLE gerengedan ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table guanfanggedan
--DROP TABLE IF EXISTS guanfanggedan;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE guanfanggedan (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,zhuanjimingcheng varchar(200) DEFAULT NULL COMMENT 专辑名称,geci longtext COMMENT 歌词,fabushijian varchar(200) DEFAULT NULL COMMENT 发布时间,fengge varchar(200) DEFAULT NULL COMMENT 风格,fengmian longtext COMMENT 封面,songname varchar(200) NOT NULL COMMENT 歌名,songfile longtext NOT NULL COMMENT 音乐文件,singer varchar(200) NOT NULL COMMENT 歌手,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT67 DEFAULT CHARSETutf8 COMMENT官方歌单;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table guanfanggedan
--LOCK TABLES guanfanggedan WRITE;
/*!40000 ALTER TABLE guanfanggedan DISABLE KEYS */;
INSERT INTO guanfanggedan VALUES (61,2024-03-19 07:28:09,专辑名称1,歌词1,发布时间1,风格1,file/guanfanggedanFengmian1.jpg,file/guanfanggedanFengmian2.jpg,file/guanfanggedanFengmian3.jpg,歌名1,,歌手1),(62,2024-03-19 07:28:09,专辑名称2,歌词2,发布时间2,风格2,file/guanfanggedanFengmian2.jpg,file/guanfanggedanFengmian3.jpg,file/guanfanggedanFengmian4.jpg,歌名2,,歌手2),(63,2024-03-19 07:28:09,专辑名称3,歌词3,发布时间3,风格3,file/guanfanggedanFengmian3.jpg,file/guanfanggedanFengmian4.jpg,file/guanfanggedanFengmian5.jpg,歌名3,,歌手3),(64,2024-03-19 07:28:09,专辑名称4,歌词4,发布时间4,风格4,file/guanfanggedanFengmian4.jpg,file/guanfanggedanFengmian5.jpg,file/guanfanggedanFengmian6.jpg,歌名4,,歌手4),(65,2024-03-19 07:28:09,专辑名称5,歌词5,发布时间5,风格5,file/guanfanggedanFengmian5.jpg,file/guanfanggedanFengmian6.jpg,file/guanfanggedanFengmian7.jpg,歌名5,,歌手5),(66,2024-03-19 07:28:09,专辑名称6,歌词6,发布时间6,风格6,file/guanfanggedanFengmian6.jpg,file/guanfanggedanFengmian7.jpg,file/guanfanggedanFengmian8.jpg,歌名6,,歌手6);
/*!40000 ALTER TABLE guanfanggedan 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-03-19 07:28:10,[{\backMenu\:[{\child\:[{\appFrontIcon\:\cuIcon-addressbook\,\buttons\:[\新增\,\查看\,\修改\,\删除\],\menu\:\排行榜\,\menuJump\:\列表\,\tableName\:\paixingbang\}],\fontClass\:\icon-common48\,\menu\:\排行榜管理\,\unicode\:\#xef65;\},{\child\:[{\appFrontIcon\:\cuIcon-paint\,\buttons\:[\新增\,\查看\,\修改\,\删除\],\menu\:\用户\,\menuJump\:\列表\,\tableName\:\yonghu\}],\fontClass\:\icon-user6\,\menu\:\用户管理\,\unicode\:\#xef9c;\},{\child\:[{\appFrontIcon\:\cuIcon-vip\,\buttons\:[\查看\,\修改\],\menu\:\管理员\,\menuJump\:\列表\,\tableName\:\users\}],\fontClass\:\icon-common4\,\menu\:\管理员管理\,\unicode\:\#xedab;\},{\child\:[{\appFrontIcon\:\cuIcon-addressbook\,\buttons\:[\新增\,\查看\,\修改\,\删除\],\menu\:\海报\,\menuJump\:\列表\,\tableName\:\config\}],\fontClass\:\icon-common37\,\menu\:\海报管理\,\unicode\:\#xeea4;\},{\child\:[{\appFrontIcon\:\cuIcon-form\,\buttons\:[\新增\,\查看\,\修改\,\删除\,\查看评论\],\menu\:\音乐\,\menuJump\:\列表\,\tableName\:\yinle\}],\fontClass\:\icon-common20\,\menu\:\音乐管理\,\unicode\:\#xee02;\},{\child\:[{\appFrontIcon\:\cuIcon-circle\,\buttons\:[\查看\,\修改\,\删除\],\menu\:\个人歌单\,\menuJump\:\列表\,\tableName\:\gerengedan\},{\appFrontIcon\:\cuIcon-link\,\buttons\:[\新增\,\查看\,\修改\,\删除\],\menu\:\官方歌单\,\menuJump\:\列表\,\tableName\:\guanfanggedan\}],\fontClass\:\icon-common27\,\menu\:\歌单管理\,\unicode\:\#xee2c;\}],\frontMenu\:[{\child\:[{\appFrontIcon\:\cuIcon-list\,\buttons\:[\添加到歌单\],\menu\:\音乐\,\menuJump\:\列表\,\tableName\:\yinle\}],\menu\:\音乐管理\}],\hasBackLogin\:\是\,\hasBackRegister\:\否\,\hasFrontLogin\:\否\,\hasFrontRegister\:\否\,\roleName\:\管理员\,\tableName\:\users\},{\backMenu\:[{\child\:[{\appFrontIcon\:\cuIcon-link\,\buttons\:[\新增\,\查看\,\修改\,\删除\],\menu\:\我的收藏\,\menuJump\:\1\,\tableName\:\storeup\}],\fontClass\:\icon-common28\,\menu\:\我的收藏管理\,\unicode\:\#xee2d;\},{\child\:[{\appFrontIcon\:\cuIcon-circle\,\buttons\:[\查看\,\删除\],\menu\:\个人歌单\,\menuJump\:\列表\,\tableName\:\gerengedan\},{\appFrontIcon\:\cuIcon-link\,\buttons\:[\查看\],\menu\:\官方歌单\,\menuJump\:\列表\,\tableName\:\guanfanggedan\}],\fontClass\:\icon-common27\,\menu\:\歌单管理\,\unicode\:\#xee2c;\}],\frontMenu\:[{\child\:[{\appFrontIcon\:\cuIcon-list\,\buttons\:[\添加到歌单\],\menu\:\音乐\,\menuJump\:\列表\,\tableName\:\yinle\}],\menu\:\音乐管理\}],\hasBackLogin\:\否\,\hasBackRegister\:\否\,\hasFrontLogin\:\是\,\hasFrontRegister\:\是\,\roleName\:\用户\,\tableName\:\yonghu\}]);
/*!40000 ALTER TABLE menu ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table paixingbang
--DROP TABLE IF EXISTS paixingbang;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE paixingbang (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,songname varchar(200) NOT NULL COMMENT 歌名,songfile longtext NOT NULL COMMENT 音乐文件,singer varchar(200) NOT NULL COMMENT 歌手,fengmian longtext COMMENT 封面,paixingbang varchar(200) DEFAULT NULL COMMENT 排行榜,geci longtext COMMENT 歌词,fabushijian datetime DEFAULT NULL COMMENT 发布时间,fengge varchar(200) DEFAULT NULL COMMENT 风格,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT57 DEFAULT CHARSETutf8 COMMENT排行榜;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table paixingbang
--LOCK TABLES paixingbang WRITE;
/*!40000 ALTER TABLE paixingbang DISABLE KEYS */;
INSERT INTO paixingbang VALUES (51,2024-03-19 07:28:09,歌名1,,歌手1,file/paixingbangFengmian1.jpg,file/paixingbangFengmian2.jpg,file/paixingbangFengmian3.jpg,排行榜1,歌词1,2024-03-19 15:28:09,风格1),(52,2024-03-19 07:28:09,歌名2,,歌手2,file/paixingbangFengmian2.jpg,file/paixingbangFengmian3.jpg,file/paixingbangFengmian4.jpg,排行榜2,歌词2,2024-03-19 15:28:09,风格2),(53,2024-03-19 07:28:09,歌名3,,歌手3,file/paixingbangFengmian3.jpg,file/paixingbangFengmian4.jpg,file/paixingbangFengmian5.jpg,排行榜3,歌词3,2024-03-19 15:28:09,风格3),(54,2024-03-19 07:28:09,歌名4,,歌手4,file/paixingbangFengmian4.jpg,file/paixingbangFengmian5.jpg,file/paixingbangFengmian6.jpg,排行榜4,歌词4,2024-03-19 15:28:09,风格4),(55,2024-03-19 07:28:09,歌名5,,歌手5,file/paixingbangFengmian5.jpg,file/paixingbangFengmian6.jpg,file/paixingbangFengmian7.jpg,排行榜5,歌词5,2024-03-19 15:28:09,风格5),(56,2024-03-19 07:28:09,歌名6,,歌手6,file/paixingbangFengmian6.jpg,file/paixingbangFengmian7.jpg,file/paixingbangFengmian8.jpg,排行榜6,歌词6,2024-03-19 15:28:09,风格6);
/*!40000 ALTER TABLE paixingbang 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,1,admin,users,管理员,gwljrymszrh65zqwn76j2as837iya1mm,2024-03-19 07:43:11,2024-03-19 08:43:11);
/*!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-03-19 07:28:10,admin,admin,管理员);
/*!40000 ALTER TABLE users ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table yinle
--DROP TABLE IF EXISTS yinle;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE yinle (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,geci longtext COMMENT 歌词,fengmian longtext COMMENT 封面,storeupnum int(11) DEFAULT NULL COMMENT 收藏数量,clicknum int(11) DEFAULT NULL COMMENT 点击次数,songname varchar(200) NOT NULL COMMENT 歌名,songfile longtext NOT NULL COMMENT 音乐文件,singer varchar(200) NOT NULL COMMENT 歌手,fabushijian datetime DEFAULT NULL COMMENT 发布时间,gequfengge varchar(200) DEFAULT NULL COMMENT 歌曲风格,userid bigint(20) NOT NULL COMMENT 用户id,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT77 DEFAULT CHARSETutf8 COMMENT音乐;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table yinle
--LOCK TABLES yinle WRITE;
/*!40000 ALTER TABLE yinle DISABLE KEYS */;
INSERT INTO yinle VALUES (71,2024-03-19 07:28:09,歌词1,file/yinleFengmian1.jpg,file/yinleFengmian2.jpg,file/yinleFengmian3.jpg,1,1,歌名1,,歌手1,2024-03-19 15:28:09,歌曲风格1,1),(72,2024-03-19 07:28:09,歌词2,file/yinleFengmian2.jpg,file/yinleFengmian3.jpg,file/yinleFengmian4.jpg,2,2,歌名2,,歌手2,2024-03-19 15:28:09,歌曲风格2,2),(73,2024-03-19 07:28:09,歌词3,file/yinleFengmian3.jpg,file/yinleFengmian4.jpg,file/yinleFengmian5.jpg,3,3,歌名3,,歌手3,2024-03-19 15:28:09,歌曲风格3,3),(74,2024-03-19 07:28:09,歌词4,file/yinleFengmian4.jpg,file/yinleFengmian5.jpg,file/yinleFengmian6.jpg,4,4,歌名4,,歌手4,2024-03-19 15:28:09,歌曲风格4,4),(75,2024-03-19 07:28:09,歌词5,file/yinleFengmian5.jpg,file/yinleFengmian6.jpg,file/yinleFengmian7.jpg,5,5,歌名5,,歌手5,2024-03-19 15:28:09,歌曲风格5,5),(76,2024-03-19 07:28:09,歌词6,file/yinleFengmian6.jpg,file/yinleFengmian7.jpg,file/yinleFengmian8.jpg,6,6,歌名6,,歌手6,2024-03-19 15:28:09,歌曲风格6,6);
/*!40000 ALTER TABLE yinle 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 创建时间,zhanghao varchar(200) DEFAULT NULL COMMENT 账号,mima varchar(200) DEFAULT NULL COMMENT 密码,nicheng varchar(200) DEFAULT NULL COMMENT 昵称,shoujihao varchar(200) DEFAULT NULL COMMENT 手机号,xingbie varchar(200) DEFAULT NULL COMMENT 性别,shengri varchar(200) DEFAULT NULL COMMENT 生日,touxiang longtext COMMENT 头像,PRIMARY KEY (id),UNIQUE KEY zhanghao (zhanghao)
) 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-03-19 07:28:09,账号1,123456,昵称1,19819881111,男,生日1,file/yonghuTouxiang1.jpg),(32,2024-03-19 07:28:09,账号2,123456,昵称2,19819881112,男,生日2,file/yonghuTouxiang2.jpg),(33,2024-03-19 07:28:09,账号3,123456,昵称3,19819881113,男,生日3,file/yonghuTouxiang3.jpg),(34,2024-03-19 07:28:09,账号4,123456,昵称4,19819881114,男,生日4,file/yonghuTouxiang4.jpg),(35,2024-03-19 07:28:09,账号5,123456,昵称5,19819881115,男,生日5,file/yonghuTouxiang5.jpg),(36,2024-03-19 07:28:09,账号6,123456,昵称6,19819881116,男,生日6,file/yonghuTouxiang6.jpg);
/*!40000 ALTER TABLE yonghu 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-03-20 12:55:45为什么选择我 我是程序员阿龙专注于软件开发拥有丰富的编程能力和实战经验。在过去的几年里我辅导了上千名学生帮助他们顺利完成毕业项目同时我的技术分享也吸引了超过50W的粉丝。我是CSDN特邀作者、博客专家、新星计划导师并在Java领域内获得了多项荣誉如博客之星。我的作品也被掘金、华为云、阿里云、InfoQ等多个平台推荐成为各大平台的优质作者。 已经为上百名同学获得优秀毕业生 源码获取 大家点赞、收藏、关注、评论啦 、查看获取联系方式 精彩专栏推荐订阅在下方专栏
