这篇文章主要针对java初学者，详细介绍怎么创建一个基本的springboot项目来对数据库进行crud操作。
目录
第一步：准备数据库
第二步：创建springboot项目
方法1：通过spring官网的spring initilizer创建springboot项目
方法2（推荐）：在IntelliJ IDEA中通过spring initilizer创建springboot项目
第三步：修改pom.xml，添加依赖
第四步：修改springboot的配置文件
第五步：创建数据库对应的实体类
第五步：创建持久层接口
第六步：创建SongMapper.java对应的mapper.xml文件
第七步：开启mapper包扫描
第八步：创建业务层接口
第九步：创建控制器类
第十步：开始开发业务功能
1、添加歌曲
controller层
service层（业务层）
mapper层（持久层）
2、删除歌曲
mapper层（持久层）
service层（业务层）
controller层
3、修改歌曲信息
mapper层（持久层）
service层（业务层）
controller层
4、查询歌曲详情
controller层
service层（业务层）
mapper层（持久层）
第一步：准备数据库
创建一个数据库springboot，然后执行以下脚本
/*
Navicat Premium Data Transfer
Source Server : MariaDB
Source Server Type : MariaDB
Source Server Version : 100605 (10.6.5-MariaDB)
Source Host : 127.0.0.1:3306
Source Schema : springboot
Target Server Type : MariaDB
Target Server Version : 100605 (10.6.5-MariaDB)
File Encoding : 65001
Date: 10/08/2023 15:20:52
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for song
-- ----------------------------
DROP TABLE IF EXISTS `song`;
CREATE TABLE `song` (
`id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '歌曲编号',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '歌曲名',
`singer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '歌手',
`note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述信息',
`last_update_time` datetime NULL DEFAULT NULL COMMENT '最后一次修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '歌曲表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of song
-- ----------------------------
INSERT INTO `song` VALUES ('20210522153649', '贩卖日落', '蓝心羽', '', '2022-06-06 23:45:04');
INSERT INTO `song` VALUES ('20210522153812', '宠坏', '李俊佑、潘柚彤', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522153941', '爱的魔法', '金莎', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522154139', '多肉少女', '赵芷彤Cassie', '', '2021-12-29 21:58:21');
INSERT INTO `song` VALUES ('20210522154331', '爱一点', '王力宏、章子怡', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522154653', '换世奇恋', '排骨教主', '《画江湖之换世门生 原声带》', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522154751', '镜心之歌', '邵夷贝', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522154945', '诺言', '陈洁丽', '《百变机兽之洛洛历险记》动画ED', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522155118', '无别', '张信哲', '《天官赐福》动画OP', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522155349', '快乐星猫', '牛奶咖啡', '《快乐星猫》动画主题曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522160205', '起风了', '周深', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522161509', '星辰觉醒', '屠化冰', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522184153', '可不可以撩', '曹懵萌', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522184207', '心动的感觉', '醋醋', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522184449', '百花香', '魏新雨', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522184618', '陨落', '不是花火呀', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522185212', '花开半夏', '爱朵女孩', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522190138', '白月光', '张信哲', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522191452', '小幸运', '田馥甄', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522192302', '大天蓬', '李袁杰', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522192641', '飞鸟和蝉', '任然', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210522193453', '爱，存在', '你的好上好佳', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210525233923', '喜欢你', '邓紫棋', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210525233936', '勇气', '梁静茹', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210530193908', '一爱难求', '徐佳莹', '《扶摇》电视剧主题曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210530194109', '桃花诺', '邓紫棋', '《上古情歌》电视剧主题曲', '2021-12-29 20:35:56');
INSERT INTO `song` VALUES ('20210530194410', '枕上书', '董贞', '《三生三世枕上书》网络剧主题曲', '2022-01-01 20:55:51');
INSERT INTO `song` VALUES ('20210530194546', '千年', '金志文、吉克隽逸', '《天乩之白蛇传说》网络剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210530194901', '古画', '鞠婧祎', '《如意芳霏》电视剧插曲', '2022-01-01 20:54:00');
INSERT INTO `song` VALUES ('20210530211557', '魔法城堡', 'TFBOYS', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601181447', '最美的期待', '周笔畅', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601195425', '晴天', '周杰伦', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601195830', '稻香', '周杰伦', '', '2021-12-29 20:57:30');
INSERT INTO `song` VALUES ('20210601195838', '七里香', '周杰伦', '', '2021-12-26 21:10:06');
INSERT INTO `song` VALUES ('20210601195852', '告白气球', '周杰伦', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601195903', '听妈妈的话', '周杰伦', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601195918', '青花瓷', '周杰伦', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601195931', '给我一首歌的时间', '周杰伦', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601195941', '明明就', '周杰伦', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601200013', '搁浅', '周杰伦', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601200019', '珊瑚海', '周杰伦、Lara梁心颐', '《十一月的萧郎》', '2021-12-26 21:13:24');
INSERT INTO `song` VALUES ('20210601200042', '兰亭序', '周杰伦', '', '2021-12-29 20:58:00');
INSERT INTO `song` VALUES ('20210601200111', '说好的幸福呢', '周杰伦', '', '2021-12-29 20:58:19');
INSERT INTO `song` VALUES ('20210601200116', '发如雪', '周杰伦', '', '2021-12-29 20:58:43');
INSERT INTO `song` VALUES ('20210601200212', '烟花易冷', '周杰伦', '', '2021-12-29 20:58:59');
INSERT INTO `song` VALUES ('20210601200231', '简单爱', '周杰伦', '', '2021-12-29 20:59:17');
INSERT INTO `song` VALUES ('20210601200243', '美人鱼', '林俊杰', '《第二天堂》', '2021-12-29 20:51:53');
INSERT INTO `song` VALUES ('20210601200304', '东风破', '周杰伦', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601200312', '安静', '周杰伦', '', '2021-12-29 21:01:58');
INSERT INTO `song` VALUES ('20210601200328', '爱在西元前', '周杰伦', '', '2021-12-29 21:11:22');
INSERT INTO `song` VALUES ('20210601200342', '龙卷风', '周杰伦', '', '2021-12-29 21:11:04');
INSERT INTO `song` VALUES ('20210601200353', '甜甜的', '周杰伦', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601200407', '千里之外', '周杰伦、费玉清 ', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601200429', '菊花台', '周杰伦', '', '2021-12-29 21:10:50');
INSERT INTO `song` VALUES ('20210601200455', '蜗牛', '周杰伦', '', '2021-12-29 21:10:37');
INSERT INTO `song` VALUES ('20210601200823', '可惜没如果', '林俊杰', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601200842', '修炼爱情', '林俊杰', '', '2021-12-29 22:04:18');
INSERT INTO `song` VALUES ('20210601200912', 'Always Online', '林俊杰', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601201433', '等一分钟', '徐誉滕', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601201449', '醉赤壁', '林俊杰', '', '2021-12-29 22:04:44');
INSERT INTO `song` VALUES ('20210601201613', '背对背拥抱', '林俊杰', '《爱情睡醒了》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601201651', '她说', '林俊杰', '', '2021-12-29 22:05:00');
INSERT INTO `song` VALUES ('20210601201714', '不潮不用花钱', '林俊杰', '', '2021-12-29 22:05:15');
INSERT INTO `song` VALUES ('20210601201726', '一千年以后', '林俊杰', '', '2021-12-29 21:47:53');
INSERT INTO `song` VALUES ('20210601201742', '爱不会绝迹', '林俊杰', '', '2021-12-29 22:05:29');
INSERT INTO `song` VALUES ('20210601201752', '曹操', '林俊杰', '', '2021-12-29 22:05:43');
INSERT INTO `song` VALUES ('20210601201819', '江南', '林俊杰', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601201902', '小酒窝', '蔡卓妍、林俊杰', '', '2021-12-29 22:06:05');
INSERT INTO `song` VALUES ('20210601201920', '爱要怎么说出口', '林俊杰', '', '2021-12-29 22:06:18');
INSERT INTO `song` VALUES ('20210601202232', '匆匆那年', '王菲', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601202251', '泡沫', '邓紫棋', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601202445', '爱丫爱丫', 'By2', '《爱情是从告白开始的》电视剧原声带', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601202557', '玫瑰花的葬礼', '许嵩', '', '2021-12-29 20:22:56');
INSERT INTO `song` VALUES ('20210601202625', '断桥残雪', '许嵩', '', '2021-12-29 20:28:17');
INSERT INTO `song` VALUES ('20210601202637', '庐州月', '许嵩', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601202653', '清明雨上', '许嵩', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601202659', '素颜', '许嵩', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601202712', '城府', '许嵩', '', '2021-12-29 20:28:44');
INSERT INTO `song` VALUES ('20210601202728', '幻听', '许嵩', '', '2021-12-29 20:27:40');
INSERT INTO `song` VALUES ('20210601202740', '你若成风', '许嵩', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601202751', '千百度', '许嵩', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601202808', '天龙八部之宿敌', '许嵩', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601202846', '燕归巢', '张靓颖、张杰', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601202900', '全球变冷', '许嵩', '', '2021-12-29 20:29:10');
INSERT INTO `song` VALUES ('20210601202912', '山水之间', '许嵩', '', '2021-12-29 20:29:34');
INSERT INTO `song` VALUES ('20210601203051', '破茧', '张韶涵', '《斗罗大陆》动画第107集ED', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601203136', '不舍', '徐佳莹', '《斗罗大陆》动画插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601203307', '此时此刻与你', '大酥', '《妖怪名单 第二季》主题曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601203343', '光与信仰', '血纯茗雅', '《妖怪名单 第一季》动画OP', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601203422', '破茧而出的光芒', '血纯茗雅', '《妖怪名单 第一季》动画ED', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601203443', '爱在身边', 'MOMOKO', '《妖怪名单》', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601203530', '红', '任然', '《妖怪名单之苏九儿》电影主题曲', '2021-12-29 20:29:51');
INSERT INTO `song` VALUES ('20210601203815', '思无邪', '阿敏', '《妖怪名单之苏九儿》电影土·宣传曲', '2021-12-29 22:14:55');
INSERT INTO `song` VALUES ('20210601204033', '有你的未来', 'MOMOKO', '《妖怪名单》', '2021-12-30 13:19:11');
INSERT INTO `song` VALUES ('20210601204118', '沉香', '王贰浪', '《妖怪名单之苏九儿》电影宣传曲', '2021-12-30 13:19:29');
INSERT INTO `song` VALUES ('20210601204140', '星落', '周思涵', '《妖怪名单之苏九儿》电影宣传曲', '2021-12-30 13:21:00');
INSERT INTO `song` VALUES ('20210601204217', '酒醉三巡', '尹熙水', '《妖怪名单之苏九儿》电影木·宣传曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601204321', '悲别', '王贰浪', '《妖怪名单之苏九儿》电影概念宣传曲', '2021-12-30 13:31:45');
INSERT INTO `song` VALUES ('20210601204418', '她的故事', '毛若琼', '《妖怪名单之苏九儿》电影合欢人物主题曲', '2021-12-30 13:32:34');
INSERT INTO `song` VALUES ('20210601204503', '轮回 ·他', '邓鼓', '《妖怪名单之苏九儿》电影封无夜人物主题曲', '2021-12-30 13:22:52');
INSERT INTO `song` VALUES ('20210601204532', '毒药', 'Mars毒药', '《妖怪名单之苏九儿》电影妖王人物主题曲', '2021-12-30 13:30:06');
INSERT INTO `song` VALUES ('20210601204817', '等', '毛若琼', '《妖怪名单之苏九儿》电影苏九儿人物主题曲', '2021-12-30 13:29:38');
INSERT INTO `song` VALUES ('20210601204949', '长恨歌', '王瑞淇', '《妖怪名单之苏九儿》电影召唤曲', '2021-12-30 13:28:59');
INSERT INTO `song` VALUES ('20210601205025', '河童', '王金金', '《妖怪名单之苏九儿》电影金·宣传曲', '2021-12-30 13:25:34');
INSERT INTO `song` VALUES ('20210601205214', '幼安', '阿敏', '《妖怪名单之苏九儿》电影概念先行曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601205256', '远行', '张迁', '《妖怪名单 第二季》动画ED', '2021-12-29 22:16:11');
INSERT INTO `song` VALUES ('20210601205521', '不败的英雄', '唐俊迪', '《铠甲勇士刑天》电视剧主题曲', '2022-01-01 20:55:36');
INSERT INTO `song` VALUES ('20210601205925', '光的战士', '陈致逸', '《铠甲勇士》电视剧第52集插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601205953', '穿越曙光', '唐丹', '《铠甲勇士刑天》电视剧片尾曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210601210159', '生生世世爱', '吴雨霏', '《仙剑奇侠传3》电视剧片尾曲', '2021-12-30 13:36:26');
INSERT INTO `song` VALUES ('20210601210221', '忘记时间', '胡歌', '《仙剑奇侠传3》电视剧片尾曲', '2021-12-30 13:38:02');
INSERT INTO `song` VALUES ('20210601210243', '偏爱', '张芸京', '《仙剑奇侠传3》电视剧插曲', '2021-12-30 13:38:17');
INSERT INTO `song` VALUES ('20210601210312', '六月的雨', '胡歌', '《仙剑奇侠传》电视剧插曲', '2021-12-30 13:38:35');
INSERT INTO `song` VALUES ('20210601210351', '一直很安静', '阿桑', '《仙剑奇侠传》电视剧插曲', '2021-12-30 13:38:48');
INSERT INTO `song` VALUES ('20210601210448', '终于明白', '动力火车', '《仙剑奇侠传》电视剧片尾曲', '2021-12-30 13:41:43');
INSERT INTO `song` VALUES ('20210601210603', '仙剑问情', '萧人凤', '《仙剑奇侠传3外传·问情篇》游戏主题曲', '2021-12-30 13:40:40');
INSERT INTO `song` VALUES ('20210601210626', '花与剑', 'JS', '《仙剑奇侠传》电视剧插曲', '2021-12-30 13:39:28');
INSERT INTO `song` VALUES ('20210601210727', '千年缘', '心然', '《仙剑奇侠传4》游戏非官方同人曲', '2021-12-30 13:40:53');
INSERT INTO `song` VALUES ('20210601210758', '千年泪', '董贞', '', '2022-01-01 20:55:22');
INSERT INTO `song` VALUES ('20210601210846', '情醉', '董贞、盛威', '', '2022-01-09 23:18:57');
INSERT INTO `song` VALUES ('20210601211014', '繁花', '董真', '《三生三世十里桃花》电视剧原声带', '2022-01-09 23:19:46');
INSERT INTO `song` VALUES ('20210601211100', '流恋', '吴奇隆、严艺丹', '《新白发魔女传》电视剧片尾曲', '2022-01-09 23:20:24');
INSERT INTO `song` VALUES ('20210601211306', '梦回还', '呦猫UNEKO', '《狐妖小红娘 王权篇》动画OP', '2021-12-30 14:14:17');
INSERT INTO `song` VALUES ('20210601211409', '若当来世', '冥月、Mario', '《狐妖小红娘 月红篇》动画主题曲', '2021-12-30 14:14:47');
INSERT INTO `song` VALUES ('20210601211619', '人间白首', '呦猫UNEKO', '《狐妖小红娘 竹业篇》动画插曲', '2021-12-30 14:15:16');
INSERT INTO `song` VALUES ('20210601211706', '落空', '落萱', '《狐妖小红娘 金晨曦篇》动画OP', '2021-12-30 14:15:51');
INSERT INTO `song` VALUES ('20210601211802', '此彼绘卷', '林和夜', '《狐妖小红娘王权篇》动画第20、27集插曲', '2021-12-30 14:16:09');
INSERT INTO `song` VALUES ('20210601211835', '铭记', '呦猫UNEKO', '《狐妖小红娘 千颜篇》动画OP', '2021-12-30 14:16:41');
INSERT INTO `song` VALUES ('20210601211942', '东流', '绯村柯北、灰老板', '《狐妖小红娘 下沙篇》动画ED', '2021-12-30 14:17:12');
INSERT INTO `song` VALUES ('20210601212221', '金色', 'Kinoko蘑菇', '《狐妖小红娘 沐天城篇》动画OP', '2021-12-30 14:17:38');
INSERT INTO `song` VALUES ('20210601212308', '满庭芳', 'Mr.mo', '《狐妖小红娘 竹业篇》动画OP', '2021-12-30 14:18:24');
INSERT INTO `song` VALUES ('20210601212338', '愿我', '呦猫UNEKO', '《狐妖小红娘 南国篇》动画插曲', '2021-12-30 14:47:32');
INSERT INTO `song` VALUES ('20210601212429', '我还记得', 'Shymie', '《狐妖小红娘 尾生篇》动画OP', '2021-12-30 14:19:08');
INSERT INTO `song` VALUES ('20210601212522', '铃舟', '匀子', '《狐妖小红娘 月红篇》动画第16集插曲', '2021-12-30 14:19:47');
INSERT INTO `song` VALUES ('20210601212551', '寄', 'JMJ', '《狐妖小红娘 竹业篇》动画ED', '2021-12-30 14:20:05');
INSERT INTO `song` VALUES ('20210601212655', '相聚万年树', '林和夜', '《狐妖小红娘 下沙篇》动画第6集插曲', '2021-12-30 14:20:46');
INSERT INTO `song` VALUES ('20210601212808', '相思树下', 'YNJ谢悦', '《狐妖小红娘》动画主题曲', '2021-12-30 14:47:52');
INSERT INTO `song` VALUES ('20210601213110', '万水依山', '叫ぶ獣', '《狐妖小红娘 月红篇》动画主题曲', '2021-12-30 15:47:56');
INSERT INTO `song` VALUES ('20210601213214', '下沙', '桂子油', '《狐妖小红娘 下沙篇》动画插曲', '2021-12-30 14:51:47');
INSERT INTO `song` VALUES ('20210601213316', '不易不移', 'Kinoko蘑菇', '《狐妖小红娘 金晨曦篇》动画ED', '2021-12-30 14:52:34');
INSERT INTO `song` VALUES ('20210601213446', '雪年轮', '苏尚卿', '《狐妖小红娘 千颜篇》动画第62集插曲', '2021-12-30 14:53:17');
INSERT INTO `song` VALUES ('20210601213520', '君路', '大酥', '《狐妖小红娘 北山妖帝篇》动画ED', '2021-12-30 14:53:34');
INSERT INTO `song` VALUES ('20210601213602', '岩心', '大帝', '《狐妖小红娘 月红篇》动画第46集插曲', '2021-12-30 14:22:10');
INSERT INTO `song` VALUES ('20210601213716', '未断', '陈爽朗、王志毅', '《狐妖小红娘 沐天城篇》动画ED', '2021-12-30 14:53:55');
INSERT INTO `song` VALUES ('20210601213829', '时之风', '方晓东', '《狐妖小红娘 尾生篇》动画概念主题曲', '2021-12-30 14:54:37');
INSERT INTO `song` VALUES ('20210601213923', '不忘', '张恋歌', '《狐妖小红娘 北山妖帝篇》动画第45集插曲', '2021-12-30 14:55:13');
INSERT INTO `song` VALUES ('20210601214021', '围城', 'Kinoko蘑菇、Mr.mo', '《狐妖小红娘 南国篇》动画插曲', '2021-12-30 14:42:18');
INSERT INTO `song` VALUES ('20210601214105', '盘根', '白止', '《狐妖小红娘 千颜篇》动画插曲', '2021-12-30 15:02:35');
INSERT INTO `song` VALUES ('20210601214150', '竹亭', '南偿', '《狐妖小红娘 竹业篇》动画插曲', '2021-12-30 15:03:06');
INSERT INTO `song` VALUES ('20210601214317', '瞳染', '蓮莉', '《狐妖小红娘 砂雪篇》动画OP', '2021-12-30 15:03:23');
INSERT INTO `song` VALUES ('20210601214424', '绝处风雪', '无问、D.rui、池年', '《狐妖小红娘 月红篇》动画插曲', '2021-12-30 15:03:47');
INSERT INTO `song` VALUES ('20210601214549', '刻印', '朱梓溶', '《狐妖小红娘 千颜篇》动画ED', '2021-12-30 15:47:20');
INSERT INTO `song` VALUES ('20210601214630', '雁归辞', '依平、无欢', '《狐妖小红娘》动画插曲', '2021-12-30 15:47:08');
INSERT INTO `song` VALUES ('20210601214724', '不醉', '余七趁', '《狐妖小红娘》动画插曲', '2021-12-30 15:46:57');
INSERT INTO `song` VALUES ('20210601214949', '思如雪', '董贞', '《画江湖之不良人3》动画第21集插曲', '2022-01-01 20:54:46');
INSERT INTO `song` VALUES ('20210601215118', '爱你让我像孩子一样', '俞灏明', '《因为爱情有奇迹》电视剧片尾曲', '2022-01-01 21:08:09');
INSERT INTO `song` VALUES ('20210601215206', '忐忑的距离', '萌学园', '《萌学园4 时空战役》电视剧片尾曲', '2022-01-01 21:08:49');
INSERT INTO `song` VALUES ('20210601215336', '月光', '胡彦斌', '《秦时明月·百步飞剑》动画主题曲', '2022-01-09 23:20:45');
INSERT INTO `song` VALUES ('20210601215451', '枫林残忆', '伍华、余文靖', '', '2022-01-09 23:20:58');
INSERT INTO `song` VALUES ('20210602181846', '远方', '郁可唯', '《古剑奇谭》电视剧片尾曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210602181910', '剑心', '张杰', '《古剑奇谭》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210602181950', '剑伤', '李易峰', '《古剑奇谭》电视剧插曲', '2022-01-01 21:20:27');
INSERT INTO `song` VALUES ('20210602182019', '恋人歌歌', '胡彦斌', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210602182119', '爱你没错', '张信哲', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210602182633', '双骄', '金志文', '《绝代双骄 2020版》电视剧主题曲', '2022-01-01 21:18:48');
INSERT INTO `song` VALUES ('20210602182658', '拆心', '刘惜君', '《绝代双骄 2020版》电视剧片尾曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210602182822', '红尘不悔', '陆虎', '《绝代双骄 2020版》电视剧插曲', '2022-01-01 21:19:12');
INSERT INTO `song` VALUES ('20210602183035', '翅膀', '林俊杰', '', '2021-12-29 22:06:38');
INSERT INTO `song` VALUES ('20210602183228', '独白', '周深', '《天乩之白蛇传说》网络剧插曲', '2022-01-01 21:11:48');
INSERT INTO `song` VALUES ('20210602183255', '幸福在梦中', '赵艺', '《大话西游之爱你一万年》网络剧紫霞仙子角色曲', '2022-01-09 23:21:11');
INSERT INTO `song` VALUES ('20210602183412', '凉凉', '杨宗纬、张碧晨', '《三生三世十里桃花》电视剧插曲', '2022-01-02 21:36:57');
INSERT INTO `song` VALUES ('20210602183449', '爱河', '神马乐园', '', '2022-01-09 23:21:25');
INSERT INTO `song` VALUES ('20210602183752', '为爱追寻', '朱倩汐JING', '《梦幻西游2》游戏主题曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210602183831', '恋西游', 'TFBOYS', '《梦幻西游2：化境飞升》动画主题曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210602183910', '入梦', 'SNH48', '《梦幻西游3：雷怒危机》动画主题曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210606174210', '留香', '吴奇隆', '《新白发魔女传》电视剧片尾曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210606174229', '无常', '吴奇隆', '《新白发魔女传》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210606174317', '无·果', '严艺丹', '《新白发魔女传》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210606175139', '十年', '陈奕迅', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210606175219', '十一年', '邱永传', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210606175333', '勿忘我', '刘庭羽', '《天天有喜2之人间有爱》电视剧片尾曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210606175435', '为了爱', '刘庭羽、陆昱霖', '《天天有喜》电视剧片尾曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210606175551', '望爱', '穆婷婷', '《天天有喜》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210606175629', '梦一场', '刘一祯', '《天天有喜2之人间有爱》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210606175907', '城门', '陈浩民、韩元元', '《活佛济公第3部》电视剧片尾曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210606175931', '胭脂泪', '刘依纯', '《活佛济公第2部》电视剧片尾曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210606175957', '忘了算了', '范怡文', '《活佛济公第3部》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210606180019', '最后的爱', '刘依纯', '《活佛济公第2部》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210606180205', '你的笑脸', '唐妞', '《蓝猫龙骑团》动画ED', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210606180333', '不怕', '赵蕾、赵蓓', '《神兵小将》动画片尾曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210606180905', '梦的光点', '王心凌', '《神兵小将1》动画OP', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607015143', '灯火', '龙飞龙泽', '《毛驴县令》电影主题曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607015413', '爱出发', 'TFBOYS', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607015443', '青春修炼手册', 'TFBOYS', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607015507', '宠爱', 'TFBOYS', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607015539', '大梦想家', 'TFBOYS', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607015640', '信仰之名', 'TFBOYS', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607015701', '想唱就唱', 'TFBOYS', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607015717', '少年说', 'TFBOYS', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607015905', '筝语', '卓舒晨', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607020110', '明天过后', '张杰', '', '2021-12-26 21:17:43');
INSERT INTO `song` VALUES ('20210607020212', '不可说', '霍建华、赵丽颖', '《花千骨》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607020408', '年轮', '张碧晨', '《花千骨》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607020727', '关山酒', '等什么君', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607020941', '爱在心中', '孙晔', '《东方神娃第2部》动画主题曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607021033', '可惜不是你', '梁静茹', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607021049', '日不落', '蔡依林', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607022951', '缘来', '潘辰、王铮亮', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607023038', '缘来', '张炜', '《神医大道公前传》电视剧片尾曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607023124', '仙女湖', '徐千雅', '《仙女湖》电视剧片尾曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607023205', '高飞', '张杰', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607141602', '后来遇见他', '胡66', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607141656', '世界那么大还是遇见你', '程响', '', '2021-12-30 15:50:00');
INSERT INTO `song` VALUES ('20210607142539', '后来', '刘若英', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607142657', '有点甜', '汪苏泷、BY2', '', '2021-12-29 21:49:45');
INSERT INTO `song` VALUES ('20210607142746', '平凡之路', '朴树', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607142910', '谪仙', '伊格赛听、叶里', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607143019', '你的答案', '阿冗', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607143402', '娃娃脸 ', '后弦', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607143451', '小可爱', '向梦园、徐木子', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607143557', '大鱼', '周深', '《大鱼海棠》电影印象曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607143713', '星辰大海', '黄霄芸', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607143751', '踏山河', '是七叔呢', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607143821', '云与海', '阿YueYue', '', '2022-01-09 23:10:58');
INSERT INTO `song` VALUES ('20210607143842', '解开', '曹洋', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607214920', '初恋未满', '张含韵、曹轩宾', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210607215029', '老人与海', '海鸣威、吴琼', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210608162857', '爱', '小虎队', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210608162917', '恋人未满', 'S.H.E', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210608165411', '我透明', '唐嫣', '《爱情睡醒了》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210608170005', '我的歌声里', '庄心妍', '', '2023-01-08 11:20:20');
INSERT INTO `song` VALUES ('20210608170053', '奇迹再现', '毛毛', '《迪迦奥特曼》电视剧主题曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210608170331', '天下', '张杰', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210608170546', '爱如潮水', '张信哲', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210608171323', '你从未离去', '白挺', '《熊出没2雪岭熊风》电影主题曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210608171416', '彩虹', '周杰伦', '', '2021-12-29 21:10:16');
INSERT INTO `song` VALUES ('20210608171449', '爱的供养', '杨幂', '《宫锁心玉》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210608172039', '永远永远', '李翊君', '《风云雄霸天下》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210611114058', '雨花石', '李玉刚、石头', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210611114123', '爱是你我', '云朵、刀郎', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210611114256', '你我', '陈晓、陈妍希', '《新神雕侠侣》电视剧片尾曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210611222556', '归寻', '等什么君', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210611222628', '寂寞咖啡', '王欣婷、蔡晓', '', '2021-12-29 21:56:49');
INSERT INTO `song` VALUES ('20210611222645', '戏影', '彭十六', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210611222705', '永不失联的爱', '王靖雯不胖', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210611222720', '夏天的风', '蓝心羽', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210611222750', '诺言', '李翊君', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210611223309', '年少有为', '李荣浩', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210611235357', '三国恋', 'Tank', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210613150907', '落日与鲸', '鬼鬼Gmer', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210613152400', '下雨天', '南拳妈妈', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210613153023', '四季予你', '程响', '', '2021-12-29 21:12:21');
INSERT INTO `song` VALUES ('20210613153108', '南山雪', '叶里', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210613153132', '夏恋', 'Ototaze', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210613155709', '倾城一笑', '艾辰', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210613155744', '离人殇', '赵方婧、音阙诗听', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210615000847', '绿色', '陈雪凝', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210615003504', '世间美好', '夏艺韩', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210615003810', '没有什么不同', '曲婉婷', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210615003901', '心愿', '四个女生', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210615004032', '神话', '韩红', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210615004059', '星月神话', '金莎', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210615011730', '原点', '西单女孩', '《画江湖之不良人2》动画ED', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210617234337', '一眼万年', 'S.H.E', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210617234407', '布格拉广场', '蔡依林、周杰伦', '', '2021-12-29 21:10:02');
INSERT INTO `song` VALUES ('20210617234526', '今天你要嫁给我', '蔡依林、陶喆', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210617234601', '五月天', 'S.H.E', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210617234629', '波斯猫', 'S.H.E', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210617234654', '不想长大', 'S.H.E', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210617234720', '中国话', 'S.H.E', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210617234737', 'Super Star', 'S.H.E', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210617234855', '爱的哲学', '牟凡', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210621230521', '来迟', '戴羽彤', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210621230712', '对不起，我爱你', '赵宥乔、陈知远', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210621230929', '失控', '井迪儿', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210622200206', '落空', '印子月', '《旋风少女第2季》电视剧主题曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210622200222', '单车', '陈奕迅', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210624200656', 'you are my sunshine', 'Angelika Vee', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210624200752', '三生三世', '张杰', '《三生三世十里桃花》电视剧主题曲', '2022-07-03 16:31:18');
INSERT INTO `song` VALUES ('20210624200948', 'you are beautiful', 'James Blunt', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210624201117', 'Baby', 'Justin Bieber、Lundacris', '《QQ飞车》手游插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210624201248', 'In The End', 'LINKIN PAPK', '《QQ飞车》手游插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210624201442', '无限速', '本息、阿悄', '《QQ飞车》游戏“SCC超级联赛”主题曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210624201757', 'Right Now(Na Na Na)', 'Akon', '《QQ飞车》手游插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210624202348', '骄傲的选择', '张杰', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210624202440', '全心出发', '小橘子、镜', '《QQ飞车》手游三周年主题曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210624205346', 'Ta', '胖虎', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210624205411', '开始懂了', '孙燕姿', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210707184539', '爱在一起创作的原声', '爱在一起', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210707184652', '半生雪', '七叔（叶泽浩）', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210710222743', '借过', '印子月', '《旋风少女》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210710223059', '那个远方', '陈楚生', '《旋风少女》电视剧片尾曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210710224218', '燃烧吧青春', '何洁', '《旋风少女》电视剧主题曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210710224424', '星星', '牛奶咖啡', '《旋风少女》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210710225113', '如果可以', '胡夏', '《旋风少女》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210710225313', '痛快', '金玟岐', '《旋风少女》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210713230210', '不是因为寂寞才想你', 'T.R.Y', '', '2021-12-29 21:54:52');
INSERT INTO `song` VALUES ('20210713231209', '净土', '孙楠', '《木府风云》电视剧主题曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210715134726', '不再联系', '程响', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210715134808', '你还要我怎样', '薛之谦', '', '2021-12-29 22:08:29');
INSERT INTO `song` VALUES ('20210715140403', '新娘不是我', '程响', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210715140440', '入戏太深', '马旭东', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210715140509', '后会无期', '徐良、汪苏泷', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210715151946', '别想她', '高进', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210715152049', '虹之间', '金贵晟', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210715152115', '愿得一人心', '李行亮', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210715152157', '爱的双重魔力', 'By2', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210715152620', '当你孤单你会想起谁', '张栋梁', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210716183438', '你在看孤独的风景', '本兮、单小源', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210716183554', '为你写诗', '吴克群', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210716183658', '一个人', '夏婉安', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210716183717', '突然好想你', '五月天', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210716183805', '不爱又何必纠缠', '阿夏、威仔', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210716183846', '童话', '光良', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210716184134', '认真的雪', '薛之谦', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210716195343', '有何不可', '许嵩', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210716213338', '预谋', '许佳慧', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210718233746', '全世界宣布爱你', '孙子涵、李潇潇', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210722152300', '潮汐（Natural）', '安苏羽、傅梦彤', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210722153248', '圆', 'AGA', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210818181834', '白月花红', '李宏毅', '《狐妖小红娘·月红2》动画片尾曲', '2021-12-30 15:46:40');
INSERT INTO `song` VALUES ('20210818182851', '转轮', '匀子', '《狐妖小红娘·月红2》动画主题曲', '2021-12-30 14:42:46');
INSERT INTO `song` VALUES ('20210818182955', '坠落星空', '小星星Aurora', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210818183314', '白鸽', '你的上好佳', '', '2022-01-09 23:07:51');
INSERT INTO `song` VALUES ('20210818183407', '微微', '傅如乔', '', '2022-04-03 23:33:23');
INSERT INTO `song` VALUES ('20210818183422', '无人之岛', '任然', '', '2022-01-09 22:48:07');
INSERT INTO `song` VALUES ('20210818183439', '星空剪影', '蓝心羽', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210820224354', '夜空中最亮的星', '逃跑计划', '', '2022-05-04 03:28:39');
INSERT INTO `song` VALUES ('20210822172529', '和光同尘', '周深', '《大江大河2》电视剧片尾曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210822172628', '寂寞沙洲冷', '周传雄', '《星空下的传说》', '2021-12-29 21:53:51');
INSERT INTO `song` VALUES ('20210822172657', '倔强', '五月天', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210822172719', '不安', '钟纯妍', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210822172737', '我和你', '皮卡丘多多', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210822172753', '岁月神偷', '金玟岐', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210826024509', '让我为你唱一首歌', '张翰、朱梓骁、魏晨、俞灏明', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210826024855', '错位时空', '夏文娜', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210829032726', '尘埃', '林小珂', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210829032854', '隔岸观火', 'Li-2c', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210829033225', '知否知否', '胡夏、郁可唯', '《知否知否应是绿肥红瘦》电视剧原声带', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210829033425', '追光者', '岑宁儿', '《夏至未至》电视剧插曲', '2022-01-09 22:20:04');
INSERT INTO `song` VALUES ('20210829034743', '冲动', '印子月', '《旋风少女第2季》电视剧主题曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210829034950', '爱之光', '本兮', '《旋风少女2季》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210829035656', '忘了牵手', '牛奶咖啡', '《旋风少女》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210829040433', '树叶的光', '徐菲', '《旋风少女2季》电视剧插曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210907225543', '囚鸟', '彭羚', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210911041342', 'My Way(AlbumVersion)', '张敬轩', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210912041848', '光年之外', 'G.E.M.邓紫棋', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20210912074632', '画心', '张靓颖', '', '2022-04-03 23:34:10');
INSERT INTO `song` VALUES ('20211023201003', '迷人的危险', '蔡黄汝', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211023201154', '曲中人', 'HITA', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211023201416', '牵丝戏', '银临、Aki阿杰', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211023201530', '你的承诺', '海鸣威', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211023201704', '邂逅', '云菲菲', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211023202253', '少年', '梦然', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211023203215', 'Believe', 'Frederic Delarue', '纯音乐', '2021-12-29 22:30:25');
INSERT INTO `song` VALUES ('20211023203317', '眼泪Tears', 'Daydream', '钢琴曲', '2021-12-29 22:27:15');
INSERT INTO `song` VALUES ('20211030131100', '千千万万', '深海鱼子酱', '', '2021-12-29 22:28:18');
INSERT INTO `song` VALUES ('20211030131147', '醒不来的梦', '回小仙', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211031193934', '甜甜咸咸', '赵芷彤Cassie', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211031200158', '春庭雪', '等什么君', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211108222914', '孤城', '洛先生', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211108223021', '我们的爱', 'F.I.R.飞儿乐园', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211108223036', '心不由己', '郁可唯', '', '2021-12-29 22:10:53');
INSERT INTO `song` VALUES ('20211108223053', '注定', '周笔畅、白举纲', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211108223102', '星辰', '张杰', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211108223223', '缺氧', '安苏羽', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211108223242', '佛系少女', '冯提莫', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211108223259', '恋人心', '魏新雨', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211108223340', '去年夏天', '王大毛', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211108224957', '追', '香香', '《追鱼传奇》电视剧主题曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211108232017', '有一种爱叫做放手', '阿木', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211108232635', '世界上的另一个我', '宋亚轩、刘耀文', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211110213501', '爱囚', '庄心妍', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211110213830', '黄昏', '周传雄', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211110214338', '一笑江湖', '闻人听書_', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211110214403', '动物世界', '薛之谦', '', '2021-12-29 22:08:41');
INSERT INTO `song` VALUES ('20211110214434', '不如', '秦海清', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211110214552', '凤御九天', '凌之轩', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211110214643', '风中的承诺', '李翊君', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211110214711', '别问我是谁', '王馨平', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211112190645', '一生所爱', '吉克隽逸', '《大话西游之爱你一万年》网络剧主题曲', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211114213128', '烟火', '陈翔', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211114213310', '花海', '周杰伦', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211114213407', '像小时候一样', '郁可唯', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211114213612', '流星雨', 'F4', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211114213919', '只是朋友', '无情学长', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211114214228', '天外来物', '薛之谦', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211114214456', '李白', '李荣浩', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211114214859', '金玉良缘', '李琦', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211114215414', '归去来兮', '叶炫清', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211114215457', '不浪漫罪名', '王杰', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211114215759', '让我欢喜让我忧', '周华健', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211114232637', '落日与晚风', 'IN-K、王忻辰、苏星婕', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211115230947', '仰望星空', '张杰', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211116195221', '明天，你好', '牛奶咖啡', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211116203620', '默', '那英', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211116205230', '勿忘心安', '张杰', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211116205453', '外面的世界', '莫文蔚', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211116205715', '红豆', '王菲', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211116210110', '执迷不悟', '孟西', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211116210147', '造梦人', '金玟岐', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211116211314', '丑八怪', '薛之谦', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211116211335', '演员', '薛之谦', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211116212211', '逆流成河', '金南玲', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211119154959', '阳光总在风雨后', '许美静', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211119160519', 'You are my sunshine', 'Angelika Vee', '', '2021-12-29 22:25:49');
INSERT INTO `song` VALUES ('20211119160636', '水手', '郑智化', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211119160907', '天使的翅膀', '徐誉滕', '', '2022-04-30 14:56:30');
INSERT INTO `song` VALUES ('20211121192028', '万有引力', '汪苏泷', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211121194705', '真英雄', '张卫健', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211201194631', '北极星的眼泪', '陈栋梁', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211201194657', '秋天不回来', '王强', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211201194845', '犯贱', '徐良', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211201195944', '我的梦', '张靓颖', '', '2022-05-02 12:46:47');
INSERT INTO `song` VALUES ('20211201200016', '不分手的恋爱', '汪苏泷', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211203234737', '时间煮雨', '郁可唯', '', '2021-12-29 22:11:11');
INSERT INTO `song` VALUES ('20211203234822', '虞兮叹', '深蓝儿', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211203235024', '坠', '添儿呗', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211203235155', '太迟', '王茗', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211203235216', '燕无歇', '蒋雪儿', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211203235247', '爱的代价', '张艾嘉', '', '2023-01-01 01:49:26');
INSERT INTO `song` VALUES ('20211203235454', '诛仙', '凤九、和尔盟', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211203235521', '小棉袄', '单夕', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211203235540', '再见', 'G.E.M邓紫棋', '', '2022-04-27 00:11:56');
INSERT INTO `song` VALUES ('20211203235600', '勇气', '棉子', '', '2022-01-01 21:39:14');
INSERT INTO `song` VALUES ('20211203235918', '因为爱情', '陈奕迅、王菲', '', '2022-01-01 21:38:14');
INSERT INTO `song` VALUES ('20211203235946', '雨花泪', '董贞', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211204000046', '情罪', '董贞、盛威', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211204000131', '逆战', '张杰', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211204000151', '我很快乐', '刘惜君', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211204000217', '坏孩子', '许嵩', '', '2022-01-01 21:16:33');
INSERT INTO `song` VALUES ('20211204000433', '爱很美', 'Sara、刘佳', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211204000531', '无心', '排骨教主', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211204000606', '死心塌地', '夹子道', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211204000812', '没有什么比失去更难过', '千竦嫣', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211207225217', '以后的以后', '庄心妍', '', '2021-12-29 21:46:28');
INSERT INTO `song` VALUES ('20211207225243', '梦醒时分', '陈淑桦', '', '2022-01-01 21:15:33');
INSERT INTO `song` VALUES ('20211207225316', '雨天', '呆呆破', '', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211221214941', '斗罗大陆·海神的眼泪', '苏忘川', '', '2022-01-01 21:29:49');
INSERT INTO `song` VALUES ('20211221215043', '风舞', '纯音乐', '《斗罗大陆》', '2021-12-26 20:07:31');
INSERT INTO `song` VALUES ('20211221215929', '几生欢', '杨紫', '《天乩之白蛇传说》网络剧插曲', '2021-12-26 20:09:44');
INSERT INTO `song` VALUES ('20211221220141', '流年', '何洁', '《天乩之白蛇传说》网络剧片尾曲', '2022-01-01 21:35:44');
INSERT INTO `song` VALUES ('20211221220242', '凡心', '董贞', '《天乩之白蛇传说》网络剧插曲', '2022-01-01 21:35:22');
INSERT INTO `song` VALUES ('20211221220308', '弱水', '任贤齐', '《天乩之白蛇传说》网络剧主题曲', '2022-01-01 21:35:05');
INSERT INTO `song` VALUES ('20211222233412', '从头再来', '刘晓', '《绝唱1》', '2021-12-26 19:50:04');
INSERT INTO `song` VALUES ('20211225212029', '因为爱所以爱', '谢霆锋', '《了解》', '2021-12-26 21:14:51');
INSERT INTO `song` VALUES ('20211225213035', '梦里水乡', '江珊', '《歌声伴随您》', '2021-12-26 20:04:03');
INSERT INTO `song` VALUES ('20211226195930', '一路生花', '温奕心', '《一路生花》', '2021-12-26 20:03:25');
INSERT INTO `song` VALUES ('20211229215051', '我们的明天', '鹿晗', '《重返20岁》电影原声带', '2021-12-29 21:51:34');
INSERT INTO `song` VALUES ('20211229215548', '莫问归期', '蒋雪儿', '《莫问归期》', '2021-12-29 21:56:04');
INSERT INTO `song` VALUES ('20211229221707', '刚刚好', '薛之谦', '《初学者》', '2021-12-29 22:18:20');
INSERT INTO `song` VALUES ('20211230133504', '此生不换', '青鸟飞鱼', '《仙剑奇侠传3》电视剧插曲', '2021-12-30 13:35:47');
INSERT INTO `song` VALUES ('20220101212137', '爱你没错', '张信哲', '《古剑奇谭》电视剧插曲', '2022-01-01 21:22:28');
INSERT INTO `song` VALUES ('20220102205933', '这就是爱', '张杰', '', '2022-01-02 21:20:03');
INSERT INTO `song` VALUES ('20220108235522', '遇见', '张燕姿', '', '2022-01-08 23:55:22');
INSERT INTO `song` VALUES ('20220109214430', '煮酒', '希涵', '', '2022-01-09 21:53:28');
INSERT INTO `song` VALUES ('20220109214831', '如一', '不是花火呀、小田音乐社', '', '2022-01-09 21:53:51');
INSERT INTO `song` VALUES ('20220109215714', '幻想', '赖美云、黄霄雲', '', '2022-01-09 21:59:05');
INSERT INTO `song` VALUES ('20220109224849', '爱就一个字', '张信哲', '', '2022-01-09 22:50:32');
INSERT INTO `song` VALUES ('20220109225242', '清空', '王忻辰、苏星婕', '', '2022-01-09 23:04:30');
INSERT INTO `song` VALUES ('20220113222151', '过火', '张信哲', '', '2022-01-13 22:21:51');
INSERT INTO `song` VALUES ('20220403232924', '浪子闲话', '花僮', '', '2022-04-03 23:32:12');
INSERT INTO `song` VALUES ('20220410191653', '最初的梦想', '范玮琪', '', '2022-04-10 19:27:12');
INSERT INTO `song` VALUES ('20220410192358', '毕业季', '贺劲轩', '', '2022-04-10 19:23:58');
INSERT INTO `song` VALUES ('20220410194554', '心痛2009', '欢子', '', '2022-04-10 19:45:54');
INSERT INTO `song` VALUES ('20220416191642', '说散就散', 'JC 陈咏桐', '', '2023-01-08 11:23:57');
INSERT INTO `song` VALUES ('20220426233155', '忽然之间', '莫文蔚', '', '2022-04-26 23:31:55');
INSERT INTO `song` VALUES ('20220426235926', '隐形的翅膀', '张韶涵', '', '2022-04-26 23:59:26');
INSERT INTO `song` VALUES ('20220427000057', '一个人挺好', '杨小壮', '', '2022-04-27 00:00:57');
INSERT INTO `song` VALUES ('20220427000128', '雨爱', '杨丞琳', '', '2022-04-27 00:01:28');
INSERT INTO `song` VALUES ('20220427000206', '不说再见', '好妹妹', '', '2022-04-27 00:02:06');
INSERT INTO `song` VALUES ('20220427000235', '最美的瞬间', '真瑞', '', '2022-04-27 00:02:35');
INSERT INTO `song` VALUES ('20220427000305', '最美的太阳', '张杰', '', '2022-04-27 00:03:05');
INSERT INTO `song` VALUES ('20220427000413', '不甘', '小乐哥（王唯乐）', '', '2022-04-27 00:04:13');
INSERT INTO `song` VALUES ('20220427000450', '剑魂', '鱼多余', '', '2022-04-27 00:04:50');
INSERT INTO `song` VALUES ('20220427000608', '满目星辰皆是你', 'LKer林柯', '', '2022-04-27 00:06:08');
INSERT INTO `song` VALUES ('20220427000653', '或许', '程今', '', '2022-04-27 00:06:53');
INSERT INTO `song` VALUES ('20220427000717', '不配念旧', '何文宇', '', '2022-04-27 00:07:17');
INSERT INTO `song` VALUES ('20220427000812', '最后的人', '杨小壮', '', '2022-04-27 00:08:12');
INSERT INTO `song` VALUES ('20220427000859', '有没有一首歌会让你想起我', '周华健', '', '2022-04-27 00:08:59');
INSERT INTO `song` VALUES ('20220427000921', '五十年以后', '海来阿木', '', '2022-04-27 00:09:21');
INSERT INTO `song` VALUES ('20220427001051', '以爱为囚', '莫叫弟弟', '', '2022-04-27 00:10:51');
INSERT INTO `song` VALUES ('20220427001219', '那些年', '胡夏', '', '2022-04-27 00:12:19');
INSERT INTO `song` VALUES ('20220427001249', '你有没有想过', '徐浩', '', '2022-04-27 00:12:49');
INSERT INTO `song` VALUES ('20220427001312', '梦里的星', '陈楚生', '', '2022-04-27 00:13:12');
INSERT INTO `song` VALUES ('20220427002631', '白月光与朱砂痣', '大籽', '', '2022-04-27 00:26:31');
INSERT INTO `song` VALUES ('20220427002715', '伤心城市', '云菲菲', '', '2022-04-27 00:27:15');
INSERT INTO `song` VALUES ('20220427002817', '红尘酒一壶', '希涵', '', '2022-04-27 00:28:17');
INSERT INTO `song` VALUES ('20220427003056', '弱点', '贺敬轩', '', '2022-04-27 00:30:56');
INSERT INTO `song` VALUES ('20220427003621', '谢谢你，曾用心骗过我', '任夏', '', '2022-04-27 00:36:21');
INSERT INTO `song` VALUES ('20220427162116', '记事本', '陈慧琳', '', '2022-04-27 16:21:16');
INSERT INTO `song` VALUES ('20220430145519', '坏女孩', '徐良、小凌', '', '2022-04-30 14:55:19');
INSERT INTO `song` VALUES ('20220502124728', '蒲公英的约定', '周杰伦', '', '2022-05-02 12:47:28');
INSERT INTO `song` VALUES ('20220502124753', '我的未来不是梦', '胡彦斌', '', '2022-05-02 12:47:53');
INSERT INTO `song` VALUES ('20220502124819', '第一次爱的人', '王心凌', '', '2022-05-02 12:56:29');
INSERT INTO `song` VALUES ('20220502184157', '七秒钟的记忆', '徐良、孙羽幽', '', '2023-03-01 03:38:52');
INSERT INTO `song` VALUES ('20220502185548', '我们说好的', '张靓颖', '', '2022-05-02 18:55:48');
INSERT INTO `song` VALUES ('20220503191146', '宁夏', '梁静茹', '', '2022-05-03 19:11:46');
INSERT INTO `song` VALUES ('20220503193156', '嘉宾', '张远', '', '2022-05-03 19:31:56');
INSERT INTO `song` VALUES ('20220504031838', '你的微笑', 'FIR飞儿乐园', '', '2022-05-04 03:18:38');
INSERT INTO `song` VALUES ('20220504031930', '说谎', '林宥嘉', '', '2022-05-04 03:39:04');
INSERT INTO `song` VALUES ('20220504032010', '和你一样', '李宇春', '', '2022-05-04 03:38:10');
INSERT INTO `song` VALUES ('20220504032040', '月牙湾', 'FIR飞儿乐园', '', '2022-05-04 03:37:05');
INSERT INTO `song` VALUES ('20220504032411', '独家记忆', '陈小春', '', '2022-05-04 03:35:21');
INSERT INTO `song` VALUES ('20220504033050', '陪你度过漫长岁月', '陈奕迅', '', '2022-05-04 03:31:36');
INSERT INTO `song` VALUES ('20220504033232', '淋雨一起走', '张韶涵', '', '2022-05-04 03:33:58');
INSERT INTO `song` VALUES ('20220504033322', '该死的温柔', '马天宇', '', '2022-05-04 03:34:30');
INSERT INTO `song` VALUES ('20220504034246', '会呼吸的痛', '梁静茹', '', '2022-05-04 03:43:25');
INSERT INTO `song` VALUES ('20220504151530', '光荣', 'BOBO', '', '2022-05-04 15:15:59');
INSERT INTO `song` VALUES ('20220504203313', '愿你', '黄静美', '', '2022-05-04 20:33:13');
INSERT INTO `song` VALUES ('20220504203516', '海市蜃楼', '三叔说', '', '2022-05-04 20:35:16');
INSERT INTO `song` VALUES ('20220508154250', '崇拜', '梁静茹', '', '2022-05-08 15:42:50');
INSERT INTO `song` VALUES ('20220510235606', '清风徐来', '王菲', '', '2022-05-10 23:56:06');
INSERT INTO `song` VALUES ('20220510235658', '欧若拉', '张韶涵', '', '2022-05-10 23:56:58');
INSERT INTO `song` VALUES ('20220604213448', '我们都是好孩子', '王筝', '', '2022-06-06 23:44:17');
INSERT INTO `song` VALUES ('20220630111246', '从别后', 'AZA微唱团', '', '2022-06-30 11:12:46');
INSERT INTO `song` VALUES ('20220703162350', '大艺术家', '蔡依林', '', '2022-07-03 16:23:50');
INSERT INTO `song` VALUES ('20220703162447', '我们的纪念', '李雅微', '《放羊的星星》电视剧主题曲', '2022-07-03 16:26:49');
INSERT INTO `song` VALUES ('20220710023600', '心之火', 'FIR飞儿乐园、彭佳慧', '《花千骨》电视剧主题曲', '2022-07-10 02:36:00');
INSERT INTO `song` VALUES ('20220710023636', '生死相随', '崔子格、杨培安', '', '2022-07-10 02:36:36');
INSERT INTO `song` VALUES ('20220710023658', '表白', '萧亚轩', '', '2022-07-10 02:36:58');
INSERT INTO `song` VALUES ('20220710023808', '王妃', '萧敬腾', '', '2022-07-10 02:38:08');
INSERT INTO `song` VALUES ('20220710023924', '同一首歌', '刘畅', '', '2022-07-10 02:39:24');
INSERT INTO `song` VALUES ('20220710024000', '孤城烟火', '季彦霖', '', '2022-07-10 02:40:00');
INSERT INTO `song` VALUES ('20220710024125', '寂寞在唱什么歌', 'Riyo橙', '', '2022-07-10 02:41:25');
INSERT INTO `song` VALUES ('20220710024338', '盗墓笔记·十年人间', '李常超（Lao乾妈）', '', '2022-07-10 02:43:38');
INSERT INTO `song` VALUES ('20220710024443', '爱到万年', '刘庭羽、蒲巴甲', '', '2022-07-10 02:44:43');
INSERT INTO `song` VALUES ('20220710024556', '千年之恋', 'F.I.R.飞儿乐园', '', '2022-07-10 02:47:34');
INSERT INTO `song` VALUES ('20220710024625', '体面', '于文文', '', '2022-07-10 02:46:25');
INSERT INTO `song` VALUES ('20220710024818', '无虞', '李紫婷、井胧', '', '2022-07-10 02:48:18');
INSERT INTO `song` VALUES ('20220710024856', '没有如果', '梁静茹', '', '2022-07-10 02:48:56');
INSERT INTO `song` VALUES ('20220710024931', 'I Miss You', '罗百吉、宝贝', '', '2022-07-10 02:49:31');
INSERT INTO `song` VALUES ('20220710025012', '你瞒我瞒', '陈柏宇', '', '2022-07-10 02:50:12');
INSERT INTO `song` VALUES ('20220710025048', '迷途的孤岛', '胡彦斌、张碧晨', '', '2022-07-10 02:50:48');
INSERT INTO `song` VALUES ('20220710025218', '如愿', '王菲', '', '2023-03-07 15:18:22');
INSERT INTO `song` VALUES ('20220710025238', '做你的猫', '尚文婷', '', '2022-07-10 02:52:38');
INSERT INTO `song` VALUES ('20220710025311', '思慕', '郁可唯', '', '2022-07-10 02:53:11');
INSERT INTO `song` VALUES ('20220710025401', '不染', '毛不易', '', '2022-07-10 02:54:01');
INSERT INTO `song` VALUES ('20220710025903', '爱情公寓', '娄艺潇、王传君、李金铭、陈赫、孙艺洲、邓家佳、金世佳', '《爱情公寓3》电视剧主题曲', '2022-08-23 19:37:18');
INSERT INTO `song` VALUES ('20220710025954', '靠近', '罗震环', '《爱情公寓3》电视剧插曲', '2022-07-10 02:59:54');
INSERT INTO `song` VALUES ('20220710030103', '像风一样', '薛之谦', '', '2022-07-10 03:01:03');
INSERT INTO `song` VALUES ('20220710030141', '多幸运', '韩安旭', '', '2022-07-10 03:01:41');
INSERT INTO `song` VALUES ('20220710030159', '你就不要想起我', '田馥甄', '', '2022-07-10 03:01:59');
INSERT INTO `song` VALUES ('20220710030229', '终于等到你', '张靓颖', '', '2022-07-10 03:02:29');
INSERT INTO `song` VALUES ('20220710030529', '你笑起真好看', '李昕融、樊桐舟、李凯稠', '', '2022-07-10 03:05:29');
INSERT INTO `song` VALUES ('20220710030618', '我们都一样', '张杰', '', '2022-07-10 03:06:18');
INSERT INTO `song` VALUES ('20220710030741', '再见', '张震岳', '', '2022-07-10 03:07:41');
INSERT INTO `song` VALUES ('20220710030813', '成全', '刘若英', '', '2022-07-10 03:08:13');
INSERT INTO `song` VALUES ('20220710030844', '怒放的生命', '汪峰', '', '2022-07-10 03:08:44');
INSERT INTO `song` VALUES ('20220710030938', '睫毛弯弯', '王心凌', '', '2022-07-10 03:09:38');
INSERT INTO `song` VALUES ('20220710031015', '寂寞在唱歌', '阿桑', '', '2022-07-10 03:10:15');
INSERT INTO `song` VALUES ('20220710031037', '雨蝶', '李翊君', '', '2022-07-10 03:10:37');
INSERT INTO `song` VALUES ('20220710031113', '再回首', '黑鸭子组合', '', '2022-07-10 03:11:13');
INSERT INTO `song` VALUES ('20220710031128', '手放开', '李圣杰', '', '2022-07-10 03:11:28');
INSERT INTO `song` VALUES ('20220710031201', '侧脸', '于果', '', '2022-07-10 03:12:01');
INSERT INTO `song` VALUES ('20220710031231', '青春不打烊', '郭静', '', '2022-07-10 03:12:31');
INSERT INTO `song` VALUES ('20220710031250', '背叛', '曹格', '', '2022-07-10 03:12:50');
INSERT INTO `song` VALUES ('20220710031312', '信仰', '张信哲', '', '2022-07-10 03:13:12');
INSERT INTO `song` VALUES ('20220710031340', '断点', '张敬轩', '', '2022-07-10 03:13:40');
INSERT INTO `song` VALUES ('20220710031406', '风起时', '胡歌', '', '2022-07-10 03:14:06');
INSERT INTO `song` VALUES ('20220710031502', '秋殇别恋', '牙牙乐、格子兮', '', '2022-07-10 03:15:02');
INSERT INTO `song` VALUES ('20220710031538', '苦笑', '汪苏泷', '', '2022-07-10 03:15:38');
INSERT INTO `song` VALUES ('20220710031628', '和平分手', '徐良、Britneylee小暖', '', '2022-07-10 03:16:28');
INSERT INTO `song` VALUES ('20220710031702', '触碰纯白', '单色凌', '', '2022-07-10 03:17:02');
INSERT INTO `song` VALUES ('20220710031752', '你还欠我一个拥抱', '后弦、Sara', '', '2022-07-10 03:17:52');
INSERT INTO `song` VALUES ('20220710031821', '红色高跟鞋', '蔡健雅', '', '2022-07-10 03:18:21');
INSERT INTO `song` VALUES ('20220710031924', 'Lydia', 'F.I.R.飞儿乐园', '', '2022-07-10 03:19:24');
INSERT INTO `song` VALUES ('20220710032224', '情难独钟', '吴珊珊', '', '2022-07-10 03:22:24');
INSERT INTO `song` VALUES ('20220710032249', '秋天你别离开我', '尤小米', '', '2022-07-10 03:22:49');
INSERT INTO `song` VALUES ('20220710032308', '当你老了', '莫文蔚', '', '2022-07-10 03:23:08');
INSERT INTO `song` VALUES ('20220710032332', '味道', '辛晓琪', '', '2022-07-10 03:23:32');
INSERT INTO `song` VALUES ('20220710032406', '知足', '五月天', '', '2022-07-10 03:24:06');
INSERT INTO `song` VALUES ('20220710032441', '分手假期', '钟洁、李佳思', '', '2022-07-10 03:24:41');
INSERT INTO `song` VALUES ('20220710032459', '独角戏', '许茹芸', '', '2022-07-10 03:24:59');
INSERT INTO `song` VALUES ('20220710032546', '丁香花', '唐磊', '', '2022-07-10 03:25:46');
INSERT INTO `song` VALUES ('20220710032609', '回心转意', '黑龙', '', '2022-07-10 03:26:09');
INSERT INTO `song` VALUES ('20220710032628', '星语心愿', '张柏芝', '', '2022-07-10 03:26:28');
INSERT INTO `song` VALUES ('20220710032807', '冰吻', '王健', '', '2022-07-10 03:28:07');
INSERT INTO `song` VALUES ('20220710032836', '裂缝中的阳光', '林俊杰', '', '2022-07-10 03:28:36');
INSERT INTO `song` VALUES ('20220710032943', '被风吹过的夏天', '金莎、林俊杰', '', '2022-07-10 03:29:43');
INSERT INTO `song` VALUES ('20220710033030', '阿依莫', '阿吉太组合', '', '2022-07-10 03:30:30');
INSERT INTO `song` VALUES ('20220710033053', '说爱你', '蔡依林', '', '2022-07-10 03:30:53');
INSERT INTO `song` VALUES ('20220710033152', '口是心非', '张雨生', '', '2022-07-10 03:31:52');
INSERT INTO `song` VALUES ('20220710033218', '给我一个理由忘记', 'A-Lin', '', '2022-07-10 03:32:18');
INSERT INTO `song` VALUES ('20220710033315', '下个，路口，见', '李宇春', '', '2022-07-10 03:33:15');
INSERT INTO `song` VALUES ('20220710033440', 'My Heart Will Go On', 'Céline Dion、James Horner', '', '2022-07-10 03:36:50');
INSERT INTO `song` VALUES ('20220823191312', '过客', '周思涵', '', '2022-08-23 19:13:12');
INSERT INTO `song` VALUES ('20220823191503', '彩虹天堂', '刘畊宏', '', '2022-08-23 19:15:03');
INSERT INTO `song` VALUES ('20220823191537', '我们', '陈奕迅', '', '2022-08-23 19:15:37');
INSERT INTO `song` VALUES ('20220823191611', '来不及勇敢', '周深', '', '2022-08-23 19:16:11');
INSERT INTO `song` VALUES ('20220823191730', '有多少爱可以重来', '黄仲昆', '', '2022-08-23 19:17:30');
INSERT INTO `song` VALUES ('20220823191943', '越长大越孤单', '牛奶咖啡', '', '2022-08-23 19:19:43');
INSERT INTO `song` VALUES ('20220823192012', '左边', '杨丞琳', '', '2022-08-23 19:20:12');
INSERT INTO `song` VALUES ('20220823192048', '哥只是一个传说', '陈旭', '', '2022-08-23 19:20:48');
INSERT INTO `song` VALUES ('20220823192114', '飞舞', '王冰洋', '', '2022-08-23 19:21:14');
INSERT INTO `song` VALUES ('20220823192142', '红装', '徐良、阿悄', '', '2022-08-23 19:21:42');
INSERT INTO `song` VALUES ('20220823192220', '空港', '戴爱玲', '', '2022-08-23 19:22:20');
INSERT INTO `song` VALUES ('20220823192239', '童年', '张艾嘉', '', '2022-08-23 19:22:39');
INSERT INTO `song` VALUES ('20220823192259', '淋雨一直走', '张韶涵', '', '2022-08-23 19:22:59');
INSERT INTO `song` VALUES ('20220823192324', '时光正好', '郁可唯', '', '2022-08-23 19:23:24');
INSERT INTO `song` VALUES ('20220823192350', '无人认领', '小阿七', '', '2022-08-23 19:23:50');
INSERT INTO `song` VALUES ('20220823192423', '你曾是少年', 'S.H.E', '', '2022-08-23 19:24:23');
INSERT INTO `song` VALUES ('20220823192649', '剩下的盛夏', 'TFBOYS、嘻游记', '', '2022-08-23 19:26:49');
INSERT INTO `song` VALUES ('20220823192803', '连名带姓', '张惠妹', '', '2022-08-23 19:28:03');
INSERT INTO `song` VALUES ('20220823193120', '身骑白马', '刘佳莹', '', '2022-08-23 19:31:20');
INSERT INTO `song` VALUES ('20220823193313', '越来越不懂', '蔡健雅', '', '2022-08-23 19:33:13');
INSERT INTO `song` VALUES ('20220823193429', '梦里花', '张韶涵', '', '2022-08-23 19:34:29');
INSERT INTO `song` VALUES ('20220823193607', '不将就', '李荣浩', '', '2022-08-23 19:36:07');
INSERT INTO `song` VALUES ('20220823194131', '白色风车', '周杰伦', '', '2022-08-23 19:41:31');
INSERT INTO `song` VALUES ('20220823194455', '半糖主义', 'S.H.E', '', '2022-08-23 19:44:55');
INSERT INTO `song` VALUES ('20220823194705', '微微一笑很倾城', '杨洋', '', '2022-08-23 19:47:05');
INSERT INTO `song` VALUES ('20220823194804', '暖暖', '梁静茹', '', '2022-08-23 19:48:04');
INSERT INTO `song` VALUES ('20220823195501', '那个男孩', '汪苏泷', '', '2022-08-23 19:55:01');
INSERT INTO `song` VALUES ('20220823195549', '情话微甜', '李朝、王圣锋', '', '2022-08-23 19:55:49');
INSERT INTO `song` VALUES ('20220823195629', '一次就好', '杨宗纬', '', '2022-08-23 19:56:29');
INSERT INTO `song` VALUES ('20220823195810', '绿光', '孙燕姿', '', '2022-08-23 19:58:10');
INSERT INTO `song` VALUES ('20220823195947', 'Love Love Love', '蔡依林', '', '2022-08-23 19:59:47');
INSERT INTO `song` VALUES ('20220825144711', '我好想你', '潘广益', '', '2022-08-25 14:47:11');
INSERT INTO `song` VALUES ('20220825144831', '麻雀', '李荣浩', '', '2022-08-25 14:48:31');
INSERT INTO `song` VALUES ('20220825144915', '叹云兮', '鞠婧祎', '', '2022-08-25 14:49:15');
INSERT INTO `song` VALUES ('20220825145102', '陪我去流浪', '阿悄', '', '2022-08-25 14:51:02');
INSERT INTO `song` VALUES ('20220825145134', '爱上你', 'BY2', '', '2022-08-25 14:51:34');
INSERT INTO `song` VALUES ('20220825145202', '天下无双', '张靓颖', '《神雕侠侣》电视剧主题曲', '2022-08-25 14:53:26');
INSERT INTO `song` VALUES ('20220826200207', '美丽的神话', '孙楠、韩红', '', '2022-08-26 20:02:07');
INSERT INTO `song` VALUES ('20220826200224', '是你', '梦然', '', '2023-08-02 12:30:25');
INSERT INTO `song` VALUES ('20220826200258', '不变的音乐', '王绎龙', '', '2022-08-26 20:02:58');
INSERT INTO `song` VALUES ('20220826200329', '咱们结婚吧', '齐晨', '', '2022-08-26 20:03:29');
INSERT INTO `song` VALUES ('20220826200355', '纸短情长', '烟把儿乐队', '', '2022-08-26 20:03:55');
INSERT INTO `song` VALUES ('20220826200421', '超级喜欢你', '金南玲', '', '2022-08-26 20:04:21');
INSERT INTO `song` VALUES ('20220826200456', '八年的爱', '冰冰超人', '', '2022-08-26 20:04:56');
INSERT INTO `song` VALUES ('20220826200529', '勇敢爱', 'Mi2', '', '2022-08-26 20:05:29');
INSERT INTO `song` VALUES ('20220828025656', '我的楼兰', '云朵', '', '2022-08-28 02:56:56');
INSERT INTO `song` VALUES ('20220830011955', '不知所措', '王靖雯', '', '2022-08-30 01:19:55');
INSERT INTO `song` VALUES ('20220830012050', '空空如也', '任然', '', '2022-08-30 01:20:50');
INSERT INTO `song` VALUES ('20220830012124', '如果这就是爱情', '张靓颖', '', '2022-08-30 01:21:24');
INSERT INTO `song` VALUES ('20220830012215', '我怀念的', '孙燕姿', '', '2022-08-30 01:22:15');
INSERT INTO `song` VALUES ('20220830012259', '有没有人告诉你', '陈楚生', '', '2022-08-30 01:22:59');
INSERT INTO `song` VALUES ('20220830012348', '外滩十八号', '袁成杰、戚薇', '', '2022-08-30 01:23:48');
INSERT INTO `song` VALUES ('20220830012453', '猜不透', '丁当', '', '2022-08-30 01:24:53');
INSERT INTO `song` VALUES ('20220830012510', '在他乡', '水木年华', '', '2022-08-30 01:25:10');
INSERT INTO `song` VALUES ('20220830012537', '不得不爱', '潘玮柏、弦子', '', '2022-08-30 01:25:37');
INSERT INTO `song` VALUES ('20220905223042', '约定', '周蕙', '', '2022-09-05 22:31:59');
INSERT INTO `song` VALUES ('20220905223514', '心雪', '邓颖', '', '2022-09-05 22:35:14');
INSERT INTO `song` VALUES ('20220905223619', '只若初见', '张德伊玲', '', '2022-09-05 22:36:19');
INSERT INTO `song` VALUES ('20220905223724', '突然想起你', '萧亚轩', '', '2022-09-05 22:37:24');
INSERT INTO `song` VALUES ('20220906221938', '这个夏天', '威仔、夏婉安', '', '2022-09-06 22:19:38');
INSERT INTO `song` VALUES ('20220909210214', '那年错过的爱情', '白小白', '', '2022-09-09 21:02:14');
INSERT INTO `song` VALUES ('20220909212827', '逆光', '孙燕姿', '', '2022-09-09 21:28:27');
INSERT INTO `song` VALUES ('20220910021557', '洛先生', '孤城', '', '2022-09-10 02:15:57');
INSERT INTO `song` VALUES ('20220910021718', '七日七日晴', '许慧欣', '', '2022-09-10 02:17:18');
INSERT INTO `song` VALUES ('20220912200953', '春娇与志明', '街道办GDC、欧阳耀莹', '', '2022-09-12 20:09:53');
INSERT INTO `song` VALUES ('20220913222727', '学猫叫', '潘友彤、陈锋', '', '2022-09-13 22:27:27');
INSERT INTO `song` VALUES ('20220913222746', '最后我们没在一起', '白小白', '', '2022-09-13 22:27:46');
INSERT INTO `song` VALUES ('20220927234645', '往后余生', '马良、孙茜茹', '', '2022-09-27 23:46:45');
INSERT INTO `song` VALUES ('20220928000750', '缘分一道桥', '王力宏、谭维维', '', '2022-09-28 00:07:50');
INSERT INTO `song` VALUES ('20220928000839', '你的酒馆对我打了烊', '陈雪凝', '', '2022-09-28 00:08:39');
INSERT INTO `song` VALUES ('20220928000933', '骄傲的少年', '南征北战NZBZ', '', '2022-09-28 00:09:33');
INSERT INTO `song` VALUES ('20220928000957', '勋章', '鹿晗', '', '2022-09-28 00:09:57');
INSERT INTO `song` VALUES ('20220928001022', '后来的你在哪', '范茹', '', '2022-09-28 00:10:22');
INSERT INTO `song` VALUES ('20220928212041', '滚烫的青春', '王源', '', '2022-09-28 21:20:41');
INSERT INTO `song` VALUES ('20221011213356', '笑柄', '陈小满', '', '2022-10-11 21:33:56');
INSERT INTO `song` VALUES ('20221011214012', '玫瑰少年', '周深、GAI周延', '', '2022-10-11 21:40:12');
INSERT INTO `song` VALUES ('20221011224135', '春三月', '司南', '', '2022-10-11 22:41:35');
INSERT INTO `song` VALUES ('20221011225722', '善变', '王靖雯', '', '2022-10-11 22:57:40');
INSERT INTO `song` VALUES ('20221101001112', '凉城', '任然', '', '2022-11-01 00:11:12');
INSERT INTO `song` VALUES ('20221101001157', '多想在平庸的生活拥抱你', '隔壁老樊', '', '2022-11-01 00:11:57');
INSERT INTO `song` VALUES ('20221101220602', '漫长的告白', '陈元汐', '', '2022-11-01 22:06:02');
INSERT INTO `song` VALUES ('20221102232804', '冬眠', '司南', '', '2022-11-02 23:28:04');
INSERT INTO `song` VALUES ('20221102232834', '9420', '麦小兜', '', '2022-11-02 23:28:34');
INSERT INTO `song` VALUES ('20221102232947', '落在生命里的光', '尹昔眠', '', '2022-11-02 23:29:47');
INSERT INTO `song` VALUES ('20221102233927', '满天星辰不及你', 'yccc', '', '2022-11-02 23:39:27');
INSERT INTO `song` VALUES ('20221102234602', '天下有情人', '唐艺', '', '2022-11-02 23:46:02');
INSERT INTO `song` VALUES ('20221102235955', '像鱼', '王贰浪', '', '2022-11-02 23:59:55');
INSERT INTO `song` VALUES ('20221105212921', '相见恨晚', '半吨兄弟', '', '2022-11-05 21:29:21');
INSERT INTO `song` VALUES ('20221105212944', '光的方向', '张碧晨', '', '2022-11-05 21:29:44');
INSERT INTO `song` VALUES ('20221105213004', '老男孩', '筷子兄弟', '', '2022-11-05 21:30:04');
INSERT INTO `song` VALUES ('20221105213200', '追梦赤子心', 'GALA乐队', '', '2022-11-05 21:32:00');
INSERT INTO `song` VALUES ('20221105213722', '光明', '谭艳', '', '2022-11-05 21:37:22');
INSERT INTO `song` VALUES ('20221105213942', '雪落下的声音', '陆虎', '', '2022-11-05 21:39:42');
INSERT INTO `song` VALUES ('20221202231801', '寻人启事', '徐佳莹', '', '2022-12-02 23:18:01');
INSERT INTO `song` VALUES ('20221202232233', '少年泪', '王梓钰', '', '2022-12-02 23:22:33');
INSERT INTO `song` VALUES ('20221203003654', '雪下的时候', '乔佳旭', '', '2022-12-03 00:36:54');
INSERT INTO `song` VALUES ('20221203003804', '无药可愈', '胡小斐', '', '2022-12-03 00:38:04');
INSERT INTO `song` VALUES ('20221203003941', '落在生命的光', '尹昔眠', '', '2022-12-03 00:39:41');
INSERT INTO `song` VALUES ('20221203004012', '消愁', '毛不易', '', '2022-12-03 00:40:12');
INSERT INTO `song` VALUES ('20221203151255', '青花', '周传雄', '', '2022-12-03 15:12:55');
INSERT INTO `song` VALUES ('20221203154318', '关不上的窗', '周传雄', '', '2022-12-03 15:43:18');
INSERT INTO `song` VALUES ('20221203184826', '当你', '林俊杰', '', '2022-12-03 18:48:26');
INSERT INTO `song` VALUES ('20221204202711', '樱花草', 'Sweety', '', '2023-04-30 02:53:41');
INSERT INTO `song` VALUES ('20221204204552', '再见只是陌生人', '庄心妍', '', '2022-12-04 20:45:52');
INSERT INTO `song` VALUES ('20221204210042', '做我老婆好不好', '徐腾誉', '', '2022-12-04 21:00:42');
INSERT INTO `song` VALUES ('20230101014728', '大海', '张雨生', '', '2023-01-01 01:47:28');
INSERT INTO `song` VALUES ('20230101015009', '只对你有感觉', '飞轮海、田馥甄', '', '2023-01-01 01:50:09');
INSERT INTO `song` VALUES ('20230101015049', '烟火', '光良', '', '2023-01-01 01:50:49');
INSERT INTO `song` VALUES ('20230101015135', '恋爱面板', '锦零', '', '2023-01-01 01:51:35');
INSERT INTO `song` VALUES ('20230101015221', '守护者我的光', '李巍V仔', '', '2023-01-01 01:52:21');
INSERT INTO `song` VALUES ('20230101015308', '你的眼睛像星星', '郭正正、园C', '', '2023-01-01 01:53:08');
INSERT INTO `song` VALUES ('20230104004128', '期待你的爱', '林俊杰', '', '2023-01-04 00:41:28');
INSERT INTO `song` VALUES ('20230104004237', '倒数', 'G.E.M.邓紫棋', '', '2023-01-04 00:42:37');
INSERT INTO `song` VALUES ('20230105183335', '九张机', '叶炫清', '', '2023-01-05 18:33:35');
INSERT INTO `song` VALUES ('20230105183404', '可不可以', '张紫豪', '', '2023-01-05 18:34:04');
INSERT INTO `song` VALUES ('20230108112042', '替我照顾她', '胡夏', '', '2023-01-08 11:20:42');
INSERT INTO `song` VALUES ('20230108112101', '三寸天堂', '严艺丹', '', '2023-01-08 11:21:01');
INSERT INTO `song` VALUES ('20230108112154', '时光背对着我', '鱼闪闪BLING', '', '2023-01-08 11:21:54');
INSERT INTO `song` VALUES ('20230108112219', '广东爱情故事', '广东雨神', '', '2023-01-08 11:22:19');
INSERT INTO `song` VALUES ('20230108112428', '多喜欢你', '小贱', '', '2023-01-08 11:24:28');
INSERT INTO `song` VALUES ('20230108112937', '情深深雨濛濛', '杨胖雨', '', '2023-01-08 11:29:37');
INSERT INTO `song` VALUES ('20230124220413', '热带雨林', 'S.H.E', '', '2023-01-24 22:04:13');
INSERT INTO `song` VALUES ('20230124220525', '曾经你说', '赵乃吉', '', '2023-01-24 22:05:25');
INSERT INTO `song` VALUES ('20230124220611', '迷失在梦中', '韩可可', '', '2023-01-24 22:06:11');
INSERT INTO `song` VALUES ('20230124220644', '生僻字', '陈柯宇', '', '2023-01-24 22:06:44');
INSERT INTO `song` VALUES ('20230124220722', '黎明前的黑暗', '孟颖', '', '2023-01-24 22:07:22');
INSERT INTO `song` VALUES ('20230124220753', '你若三冬', '阿悠悠', '', '2023-01-24 22:07:53');
INSERT INTO `song` VALUES ('20230202222834', '裹着心的光', '林俊杰', '', '2023-02-02 22:28:34');
INSERT INTO `song` VALUES ('20230208085355', '镜中渊', '周林枫', '', '2023-02-08 08:53:55');
INSERT INTO `song` VALUES ('20230208085434', '等你归来', '程响', '', '2023-02-08 08:54:34');
INSERT INTO `song` VALUES ('20230208085544', '千年之恋', '双笙（陈元汐）', '', '2023-02-08 08:55:44');
INSERT INTO `song` VALUES ('20230208085617', '人间惊鸿客', '叶里', '', '2023-02-08 08:56:17');
INSERT INTO `song` VALUES ('20230208085719', '骁', '井胧、井迪儿', '', '2023-02-08 08:57:19');
INSERT INTO `song` VALUES ('20230208085807', '天问', '摩登兄弟刘宇宁', '', '2023-02-08 08:58:07');
INSERT INTO `song` VALUES ('20230208085851', '手心', '林俊杰、G.E.M. 邓紫棋', '', '2023-02-08 08:58:51');
INSERT INTO `song` VALUES ('20230208090000', '伯虎说', '伯爵Johnny、唐伯虎Annie', '', '2023-02-08 09:00:00');
INSERT INTO `song` VALUES ('20230208090305', '落差', '王忻辰', '', '2023-02-08 09:03:05');
INSERT INTO `song` VALUES ('20230208090421', '不仅仅是喜欢', '孙语赛、萧全', '', '2023-02-08 09:04:21');
INSERT INTO `song` VALUES ('20230208090451', '沙漠骆驼', '展展与罗罗', '', '2023-02-08 09:04:51');
INSERT INTO `song` VALUES ('20230213065854', '下山', '麦小兜', '', '2023-02-13 06:58:54');
INSERT INTO `song` VALUES ('20230213065929', '再也不会遇见第二个她', '李哈哈', '', '2023-02-13 06:59:29');
INSERT INTO `song` VALUES ('20230213070002', '尽头', '赵方婧', '', '2023-02-13 07:00:02');
INSERT INTO `song` VALUES ('20230301033754', '找到你是我最伟大的成功', '古巨基', '', '2023-03-01 03:37:54');
INSERT INTO `song` VALUES ('20230301042321', '说好了不见面', '小贱', '', '2023-03-01 04:23:21');
INSERT INTO `song` VALUES ('20230301042412', '星月为媒', '王茗', '', '2023-03-01 04:24:12');
INSERT INTO `song` VALUES ('20230310171712', '从前', '董贞、王敬轩', '', '2023-03-10 17:18:30');
INSERT INTO `song` VALUES ('20230310180219', 'Far Away From Home', 'Groove Coverage', '', '2023-03-10 18:02:19');
INSERT INTO `song` VALUES ('20230310180354', 'God Is a Girl', 'Groove Coverage', '', '2023-03-10 18:03:54');
INSERT INTO `song` VALUES ('20230310180434', 'Sunshine Girl', 'mounmoon', '', '2023-03-10 18:04:34');
INSERT INTO `song` VALUES ('20230310180532', 'Beautiful Now', 'Zedd、Jon Bellion', '', '2023-03-10 18:05:32');
INSERT INTO `song` VALUES ('20230310180555', 'She', 'Groove Coverage', '', '2023-03-10 18:05:55');
INSERT INTO `song` VALUES ('20230310180647', 'Apologize', 'Timbaland、OneRepublic', '', '2023-03-10 18:06:47');
INSERT INTO `song` VALUES ('20230310181036', 'Cry On My Shoulder', 'Daniel Küblböck', '', '2023-03-10 18:10:36');
INSERT INTO `song` VALUES ('20230310181130', 'Poker Face', 'Lady Gaga', '', '2023-03-10 18:11:30');
INSERT INTO `song` VALUES ('20230310181252', 'Good Time', 'Owl City、carly Rae Jepsen', '', '2023-03-10 18:12:52');
INSERT INTO `song` VALUES ('20230310181343', 'Trouble Is Friend', 'Lenka', '', '2023-03-10 18:13:43');
INSERT INTO `song` VALUES ('20230310181435', 'Dream It Possible', 'Delacey', '', '2023-03-10 18:14:35');
INSERT INTO `song` VALUES ('20230310181503', '从前', '安苏羽', '', '2023-03-10 18:15:03');
INSERT INTO `song` VALUES ('20230312030905', '后来我们的爱', '陆杰awr', '', '2023-03-12 03:09:05');
INSERT INTO `song` VALUES ('20230322085203', '重返地球', '黄霄雲', '', '2023-03-22 08:52:03');
INSERT INTO `song` VALUES ('20230322085911', '终会与你同行', '白挺', '', '2023-03-22 08:59:11');
INSERT INTO `song` VALUES ('20230322085945', '心中的另一个自己', '翟亚楠', '', '2023-03-22 08:59:45');
INSERT INTO `song` VALUES ('20230322090122', '我和你', '皮卡丘多多', '', '2023-03-22 09:01:22');
INSERT INTO `song` VALUES ('20230322091050', '并肩', '丁钰', '', '2023-03-22 09:10:50');
INSERT INTO `song` VALUES ('20230322091139', '勇往直前', '洪辰HUNG', '', '2023-03-22 09:11:39');
INSERT INTO `song` VALUES ('20230322091216', '这样爱了', '张婧', '', '2023-03-22 09:12:16');
INSERT INTO `song` VALUES ('20230322091237', '恋爱画板', '锦零', '', '2023-03-22 09:12:37');
INSERT INTO `song` VALUES ('20230324080521', '彼岸花', '周深', '', '2023-03-24 08:05:21');
INSERT INTO `song` VALUES ('20230324080549', '镜中人', '郁可唯', '', '2023-03-24 08:05:49');
INSERT INTO `song` VALUES ('20230324080623', '不弃不离', '丁于', '', '2023-03-24 08:06:23');
INSERT INTO `song` VALUES ('20230403082335', '突然之间', '莫文蔚', '', '2023-04-03 08:23:35');
INSERT INTO `song` VALUES ('20230403082409', '对方正在输入', '电流妹', '', '2023-04-03 08:24:09');
INSERT INTO `song` VALUES ('20230403082548', '小雨天气', '嘿人李逵Noisemakers、徐梦圆', '', '2023-04-03 08:25:48');
INSERT INTO `song` VALUES ('20230403082638', '转呀转呀', '锦零', '', '2023-04-03 08:26:38');
INSERT INTO `song` VALUES ('20230403082726', '热爱105℃的你', '阿肆', '', '2023-04-03 08:27:26');
INSERT INTO `song` VALUES ('20230403082918', '暧昧', '杨丞琳', '', '2023-04-03 08:29:18');
INSERT INTO `song` VALUES ('20230412175625', '听说你', '于冬然', '', '2023-04-12 17:56:25');
INSERT INTO `song` VALUES ('20230412180914', '心跳回应', '辛雯', '', '2023-04-12 18:09:14');
INSERT INTO `song` VALUES ('20230412181016', '把回忆拼好给你', 'cici_', '', '2023-04-12 18:10:16');
INSERT INTO `song` VALUES ('20230412181101', '江湖之间', '曹雨航', '', '2023-04-12 18:11:01');
INSERT INTO `song` VALUES ('20230412181147', '听众', '王志心', '', '2023-04-12 18:11:47');
INSERT INTO `song` VALUES ('20230412181238', '在你的身边', '盛哲', '', '2023-04-12 18:12:38');
INSERT INTO `song` VALUES ('20230412181305', '像雨吹起了风', 'Liko、庄淇文29', '', '2023-04-12 18:13:05');
INSERT INTO `song` VALUES ('20230412182750', '星与岛', '南葵', '', '2023-04-12 18:27:50');
INSERT INTO `song` VALUES ('20230412183905', '星河陨落', '霍含蕾Rea', '', '2023-04-12 18:39:05');
INSERT INTO `song` VALUES ('20230412212834', '嫁', 'L(桃籽)、周林枫、三楠', '', '2023-04-12 21:28:34');
INSERT INTO `song` VALUES ('20230412212948', '红黑', '小星星Aurora', '', '2023-04-12 21:29:48');
INSERT INTO `song` VALUES ('20230425121252', '相拥星空', '张洛', '', '2023-04-25 12:12:52');
INSERT INTO `song` VALUES ('20230425121400', '一个深爱的女孩', '本兮', '', '2023-04-25 12:14:00');
INSERT INTO `song` VALUES ('20230425121416', '酸酸甜甜就是我', '张含韵', '', '2023-04-25 12:14:16');
INSERT INTO `song` VALUES ('20230425122636', '对着天空说爱你', '莫小滢', '', '2023-04-25 12:26:36');
INSERT INTO `song` VALUES ('20230425122656', '躲避的爱', '小小', '', '2023-04-25 12:26:56');
INSERT INTO `song` VALUES ('20230425122721', '雪', '杜婧荧、王艺翔', '', '2023-04-25 12:27:21');
INSERT INTO `song` VALUES ('20230425123113', '爱啦啦', '海楠', '', '2023-04-25 12:31:13');
INSERT INTO `song` VALUES ('20230430024622', '奇妙能力歌', '陈粒', '', '2023-04-30 02:46:22');
INSERT INTO `song` VALUES ('20230430025256', '彩虹的微笑', '王心凌', '', '2023-04-30 02:52:56');
INSERT INTO `song` VALUES ('20230515100601', '水中花(Live)', '郁可唯', '', '2023-05-15 10:06:01');
INSERT INTO `song` VALUES ('20230515101615', '慢冷', '梁静茹', '', '2023-05-15 10:16:15');
INSERT INTO `song` VALUES ('20230521091306', '快乐小神仙', '天唱组合', '《快乐星球1》电视剧主题曲', '2023-05-21 09:13:06');
INSERT INTO `song` VALUES ('20230521091423', '月亮船', '王英姿', '《快乐星球3》电视剧片尾曲', '2023-05-21 09:14:23');
INSERT INTO `song` VALUES ('20230521093442', '小小少年', '天唱组合', '《快乐星球1》电视剧插曲', '2023-05-21 09:35:23');
INSERT INTO `song` VALUES ('20230521093645', '梦幻童年', '天唱组合', '《快乐星球1》电视剧片尾曲', '2023-05-21 09:36:45');
INSERT INTO `song` VALUES ('20230521100316', '路过人间', '郁可唯', '', '2023-05-21 10:03:16');
INSERT INTO `song` VALUES ('20230707221954', '奔赴星空', '尹昔眠', '', '2023-07-07 22:19:54');
INSERT INTO `song` VALUES ('20230707225305', '银河和星斗', 'yihuik苡慧', '', '2023-07-07 22:53:05');
INSERT INTO `song` VALUES ('20230709031543', '入阵曲', '五月天', '', '2023-07-09 03:15:43');
INSERT INTO `song` VALUES ('20230715033446', '眼泪的错觉', '王露凝、乔海清', '', '2023-07-15 03:35:18');
INSERT INTO `song` VALUES ('20230802122319', '地老天荒', '张丹峰', '《花千骨》电视剧原声带', '2023-08-02 12:23:19');
INSERT INTO `song` VALUES ('20230802122425', '往事随风', '齐秦', '', '2023-08-02 12:24:25');
INSERT INTO `song` VALUES ('20230802122729', '难诀别', '弦子、ycccc', '', '2023-08-02 12:27:29');
INSERT INTO `song` VALUES ('20230802122845', '蔓延', '许美静', '', '2023-08-02 12:28:45');
INSERT INTO `song` VALUES ('20230802122918', '第一次', '光良', '', '2023-08-02 12:29:18');
INSERT INTO `song` VALUES ('20230802123058', '我超喜欢你', '欧阳朵', '', '2023-08-02 12:30:58');
INSERT INTO `song` VALUES ('20230802123128', '恋爱的猫', '月小妞', '', '2023-08-02 12:31:28');
INSERT INTO `song` VALUES ('20230802123256', '骄傲的你', '尹昔眠', '', '2023-08-02 12:32:56');
INSERT INTO `song` VALUES ('20230802123341', '勉为其难', '王冕', '', '2023-08-02 12:33:41');
SET FOREIGN_KEY_CHECKS = 1;第二步：创建springboot项目
创建springboot项目的方法有两种，推荐使用方法2
方法1：通过spring官网的spring initilizer创建springboot项目
如下图，访问spring官网，点击右上角的菜单栏中的Projects>>Spring Boot
然后再页面往下滚动，找到红框内的区域
点击第二个红框内蓝色的链接
这个页面看起来是不是有点熟悉，和我们在idea里面创建springboot项目有一点相似，接下来修改对应的设置，修改完之后点击generate按钮。然后就会把创建的项目下载为压缩文件，
如图，下载完成后，把文件解压出来，然后通过idea打开就可以了
方法2（推荐）：在IntelliJ IDEA中通过spring initilizer创建springboot项目
如下图，打开idea，点击左上角的菜单栏中File>>New>>Project...
然后在打开的窗口左侧选择Spring Initilizer，在右侧面板修改项目名和jdk版本
点击Next按钮，接着点击Finish按钮，等待idea创建并下载项目。
第三步：修改pom.xml，添加依赖
这篇文章中，springboot版本用的是2.5.9，直接复制下面的内容即可
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.5.9</version>
<relativePath/>
</parent>
<groupId>com.example</groupId>
<artifactId>springboot</artifactId>
<version>0.0.1-SNAPSHOT</version>
<properties>
<java.version>1.8</java.version>
<mysql.version>8.0.28</mysql.version>
<druid.version>1.1.21</druid.version>
<lombok.version>1.18.22</lombok.version>
<mybatis-boot.version>2.2.2</mybatis-boot.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>${lombok.version}</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${mysql.version}</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>${druid.version}</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>${mybatis-boot.version}</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>第四步：修改springboot的配置文件
一般配置文件有两种格式，即application.properties或application.yml。
推荐使用yml文件格式，重命名application.properties为application.yml。然后添加数据库的数据源设置，并修改项目的启动端口号为8083，然后设置mybatis的mapper.xml文件的位置。
spring:
datasource:
username: root
password: root
url: jdbc:mysql://localhost:3306/springboot
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
mybatis:
mapper-locations: classpath:mapper/*Mapper.xml
logging:
level:
springfox: error
com.example.springboot: debug
server:
port: 8083第五步：创建数据库对应的实体类
在项目的根目录com.example.springboot下创建一个entity包，然后在entity包下面创建一个实体类Song.java，最好实现一下序列化接口Serializable。
package com.example.springboot.entity;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import java.io.Serializable;
import java.time.LocalDateTime;
/**
* 歌曲
* @author heyunlin
* @version 1.0
*/
@Data
public class Song implements Serializable {
private static final long serialVersionUID = 18L;
private String id;
/**
* 歌曲名
*/
private String name;
/**
* 歌手
*/
private String singer;
/**
* 描述信息
*/
private String note;
/**
* 最后一次修改时间
*/
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
private LocalDateTime lastUpdateTime;
}第五步：创建持久层接口
同样的，在项目根路径下创建mapper包，在mapper包下创建接口SongMapper.java，在接口上添加组件注解@Repository。
package com.example.springboot.mapper;
import org.springframework.stereotype.Repository;
/**
* @author heyunlin
* @version 1.0
*/
@Repository
public interface SongMapper {
}第六步：创建SongMapper.java对应的mapper.xml文件
在src\main\resources下创建mapper包，然后在mapper包下面创建一个xml文件SongMapper.xml。其中namespace属性的值为SongMapper.java的全限定名
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.springboot.mapper.SongMapper">
</mapper>第七步：开启mapper包扫描
因为我们的持久层接口没有使用@Mapper注解，mybatis并不知道SongMapper是一个mapper接口，需要通过@MapperScan来配置mapper的包路径，通常我们会在一个单独的配置类上添加@MapperScan注解。
在项目根路径下创建config包，在config包下创建MybatisConfig.java，在类上面使用@Configuration将该类声明为配置类，同时开启mapper包扫描。
package com.example.springboot.config;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Configuration;
/**
* @author heyunlin
* @version 1.0
*/
@Configuration
@MapperScan(basePackages = "com.example.springboot.mapper")
public class MybatisConfig {
}第八步：创建业务层接口
在项目根路径下创建service包，在service包下创建接口SongService.java
package com.example.springboot.service;
/**
* @author heyunlin
* @version 1.0
*/
public interface SongService {
}然后在service包下创建impl子包，创建一个SongService接口的实现类，并在实现类上使用@Service注解。
package com.example.springboot.service.impl;
import com.example.springboot.service.SongService;
import org.springframework.stereotype.Service;
/**
* @author heyunlin
* @version 1.0
*/
@Service
public class SongServiceImpl implements SongService {
}第九步：创建控制器类
在项目根路径下创建controller包，在controller包下创建SongController.java类。
其中，@RestController注解是一个复合注解，由两个注解@RespondBody和@Controller组成，@RespondBody表示类下面的方法的返回值会被转换为json格式的字符串返回给调用者。
package com.example.springboot.controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
/**
* @author heyunlin
* @version 1.0
*/
@RestController
@RequestMapping(path = "/song", produces="application/json;charset=utf-8")
public class SongController {
}第十步：开始开发业务功能
完成以上步骤之后，springboot项目的基本开发环境就搭建好了，接下来开始实现song表的增、删、查、改功能。
再次之前，需要把service层的SongService注入到SongController中，在这里使用《阿里巴巴开发规范》推荐的构造器注入方式。
package com.example.springboot.controller;
import com.example.springboot.service.SongService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
/**
* @author heyunlin
* @version 1.0
*/
@RestController
@RequestMapping(path = "/song", produces="application/json;charset=utf-8")
public class SongController {
private final SongService songService;
@Autowired
public SongController(SongService songService) {
this.songService = songService;
}
}1、添加歌曲
controller层
首先，在controller层创建一个方法，取名为insert，在方法内调用service层的对应方法，为了方便同样取名为insert
package com.example.springboot.controller;
import com.example.springboot.entity.Song;
import com.example.springboot.service.SongService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;
/**
* @author heyunlin
* @version 1.0
*/
@RestController
@RequestMapping(path = "/song", produces="application/json;charset=utf-8")
public class SongController {
private final SongService songService;
@Autowired
public SongController(SongService songService) {
this.songService = songService;
}
@RequestMapping(value = "/insert", method = RequestMethod.POST)
public void insert(Song song) {
songService.insert(song);
}
}service层（业务层）
这时候，songService.insert(song);这行代码会报错，因为我们SongService接口没有这个方法，把鼠标移到红色的地方，键盘按alt+enter（回车键），选择第一个选项，在SongService创建insert()方法。
package com.example.springboot.service;
import com.example.springboot.entity.Song;
/**
* @author heyunlin
* @version 1.0
*/
public interface SongService {
void insert(Song song);
}然后这时候发现SongService这个类也有红色的提示，因为SongServiceImpl实现了SongService接口，但是没有实现刚刚添加的insert()方法。
如上图，点击红色的提示信息，会自动打开SongServiceImpl
我们把鼠标移到类上面，会提示实现方法，点击蓝色implement methods自动生成insert()方法
package com.example.springboot.service.impl;
import com.example.springboot.entity.Song;
import com.example.springboot.service.SongService;
import org.springframework.stereotype.Service;
/**
* @author heyunlin
* @version 1.0
*/
@Service
public class SongServiceImpl implements SongService {
@Override
public void insert(Song song) {
}
}然后，为了能操作数据库，需要注入持久成的接口SongMapper，并调用持久层接口的方法来操作数据库。
package com.example.springboot.service.impl;
import com.example.springboot.entity.Song;
import com.example.springboot.mapper.SongMapper;
import com.example.springboot.service.SongService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
/**
* @author heyunlin
* @version 1.0
*/
@Service
public class SongServiceImpl implements SongService {
private final SongMapper songMapper;
@Autowired
public SongServiceImpl(SongMapper songMapper) {
this.songMapper = songMapper;
}
@Override
public void insert(Song song) {
songMapper.insert(song);
}
}mapper层（持久层）
同样的，在SongMapper接口上创建insert()方法，如果安装了mybatisx插件，也会有红色的提示，让你在SongMapper.xml上创建对应的方法。
package com.example.springboot.mapper;
import com.example.springboot.entity.Song;
import org.springframework.stereotype.Repository;
/**
* @author heyunlin
* @version 1.0
*/
@Repository
public interface SongMapper {
void insert(Song song);
}mapper.xml中添加一个insert标签，id属性值为方法名
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.springboot.mapper.SongMapper">
<insert id="insert">
insert into song(id, name, singer, note, last_update_time)
values(#{id}, #{name}, #{singer}, #{note}, #{lastUpdateTime})
</insert>
</mapper>当然也可以在接口上使用注解来绑定SQL语句（推荐在xml文件中编写sql）
package com.example.springboot.mapper;
import com.example.springboot.entity.Song;
import org.apache.ibatis.annotations.Insert;
import org.springframework.stereotype.Repository;
/**
* @author heyunlin
* @version 1.0
*/
@Repository
public interface SongMapper {
@Insert("insert into song(id, name, singer, note, last_update_time) values(#{id}, #{name}, #{singer}, #{note}, #{lastUpdateTime})")
void insert(Song song);
}只能通过注解或mapper.xml其中一个方法来绑定SQL语句，否则会报错。
2、删除歌曲
同样的，依次创建controller、service和mapper层的方法，然后在controller调用service，service调用mapper。
mapper层（持久层）
package com.example.springboot.mapper;
import com.example.springboot.entity.Song;
import org.springframework.stereotype.Repository;
/**
* @author heyunlin
* @version 1.0
*/
@Repository
public interface SongMapper {
//@Insert("insert into song(id, name, singer, note, last_update_time) values(#{id}, #{name}, #{singer}, #{note}, #{lastUpdateTime})")
void insert(Song song);
//@Delete("delete from song where id = #{id}")
void deleteById(String id);
}<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.springboot.mapper.SongMapper">
<insert id="insert">
insert into song(id, name, singer, note, last_update_time)
values(#{id}, #{name}, #{singer}, #{note}, #{lastUpdateTime})
</insert>
<delete id="deleteById">
delete from song where id = #{id}
</delete>
</mapper>service层（业务层）
SongService.java
package com.example.springboot.service;
import com.example.springboot.entity.Song;
/**
* @author heyunlin
* @version 1.0
*/
public interface SongService {
void insert(Song song);
void delete(String id);
}SongServiceImpl
package com.example.springboot.service.impl;
import com.example.springboot.entity.Song;
import com.example.springboot.mapper.SongMapper;
import com.example.springboot.service.SongService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
/**
* @author heyunlin
* @version 1.0
*/
@Service
public class SongServiceImpl implements SongService {
private final SongMapper songMapper;
@Autowired
public SongServiceImpl(SongMapper songMapper) {
this.songMapper = songMapper;
}
@Override
public void insert(Song song) {
songMapper.insert(song);
}
@Override
public void delete(String id) {
songMapper.deleteById(id);
}
}controller层
在这里使用rest风格的请求方式，通过@PathVariable注解绑定路径参数，也就是下面歌曲编号（id）对应的字符串值
请求url格式
http://localhost:8083/song/delete/歌曲编号（id）
例如，这时候id获取到的值为10011
http://localhost:8083/song/delete/10011
package com.example.springboot.controller;
import com.example.springboot.entity.Song;
import com.example.springboot.service.SongService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;
/**
* @author heyunlin
* @version 1.0
*/
@RestController
@RequestMapping(path = "/song", produces="application/json;charset=utf-8")
public class SongController {
private final SongService songService;
@Autowired
public SongController(SongService songService) {
this.songService = songService;
}
@RequestMapping(value = "/insert", method = RequestMethod.POST)
public void insert(Song song) {
songService.insert(song);
}
@RequestMapping(value = "/delete/{id}", method = RequestMethod.GET)
public void delete(@PathVariable("id") String id) {
songService.delete(id);
}
}3、修改歌曲信息
mapper层（持久层）
SongMapper.java
package com.example.springboot.mapper;
import com.example.springboot.entity.Song;
import org.springframework.stereotype.Repository;
/**
* @author heyunlin
* @version 1.0
*/
@Repository
public interface SongMapper {
//@Insert("insert into song(id, name, singer, note, last_update_time) values(#{id}, #{name}, #{singer}, #{note}, #{lastUpdateTime})")
void insert(Song song);
//@Delete("delete from song where id = #{id}")
void deleteById(String id);
// @Update("update song set name = #{name}, singer = #{singer}, note = #{note}, last_update_time = #{lastUpdateTime} where id = #{id}")
void updateById(Song song);
}SongMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.springboot.mapper.SongMapper">
<insert id="insert">
insert into song(id, name, singer, note, last_update_time)
values(#{id}, #{name}, #{singer}, #{note}, #{lastUpdateTime})
</insert>
<delete id="deleteById">
delete from song where id = #{id}
</delete>
<update id="updateById">
update song set name = #{name}, singer = #{singer}, note = #{note}, last_update_time = #{lastUpdateTime} where id = #{id}
</update>
</mapper>service层（业务层）
SongService.java
package com.example.springboot.service;
import com.example.springboot.entity.Song;
/**
* @author heyunlin
* @version 1.0
*/
public interface SongService {
void insert(Song song);
void delete(String id);
void update(Song song);
}SongServiceImpl.java
package com.example.springboot.service.impl;
import com.example.springboot.entity.Song;
import com.example.springboot.mapper.SongMapper;
import com.example.springboot.service.SongService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.time.LocalDateTime;
/**
* @author heyunlin
* @version 1.0
*/
@Service
public class SongServiceImpl implements SongService {
private final SongMapper songMapper;
@Autowired
public SongServiceImpl(SongMapper songMapper) {
this.songMapper = songMapper;
}
@Override
public void insert(Song song) {
songMapper.insert(song);
}
@Override
public void delete(String id) {
songMapper.deleteById(id);
}
@Override
public void update(Song song) {
song.setLastUpdateTime(LocalDateTime.now());
songMapper.updateById(song);
}
}controller层
package com.example.springboot.controller;
import com.example.springboot.entity.Song;
import com.example.springboot.service.SongService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;
/**
* @author heyunlin
* @version 1.0
*/
@RestController
@RequestMapping(path = "/song", produces="application/json;charset=utf-8")
public class SongController {
private final SongService songService;
@Autowired
public SongController(SongService songService) {
this.songService = songService;
}
@RequestMapping(value = "/insert", method = RequestMethod.POST)
public void insert(Song song) {
songService.insert(song);
}
@RequestMapping(value = "/delete/{id}", method = RequestMethod.GET)
public void delete(@PathVariable("id") String id) {
songService.delete(id);
}
@RequestMapping(value = "/update", method = RequestMethod.POST)
public void update(Song song) {
songService.update(song);
}
}4、查询歌曲详情
controller层
package com.example.springboot.controller;
import com.example.springboot.entity.Song;
import com.example.springboot.service.SongService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;
/**
* @author heyunlin
* @version 1.0
*/
@RestController
@RequestMapping(path = "/song", produces="application/json;charset=utf-8")
public class SongController {
private final SongService songService;
@Autowired
public SongController(SongService songService) {
this.songService = songService;
}
@RequestMapping(value = "/insert", method = RequestMethod.POST)
public void insert(Song song) {
songService.insert(song);
}
@RequestMapping(value = "/delete/{id}", method = RequestMethod.GET)
public void delete(@PathVariable("id") String id) {
songService.delete(id);
}
@RequestMapping(value = "/update", method = RequestMethod.POST)
public void update(Song song) {
songService.update(song);
}
@RequestMapping(value = "/detail/{id}", method = RequestMethod.GET)
public Song detail(@PathVariable("id") String id) {
return songService.detail(id);
}
}service层（业务层）
SongService.java
package com.example.springboot.service;
import com.example.springboot.entity.Song;
/**
* @author heyunlin
* @version 1.0
*/
public interface SongService {
void insert(Song song);
void delete(String id);
void update(Song song);
Song detail(String id);
}SongServiceImpl.java
package com.example.springboot.service.impl;
import com.example.springboot.entity.Song;
import com.example.springboot.mapper.SongMapper;
import com.example.springboot.service.SongService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
/**
* @author heyunlin
* @version 1.0
*/
@Service
public class SongServiceImpl implements SongService {
private final SongMapper songMapper;
@Autowired
public SongServiceImpl(SongMapper songMapper) {
this.songMapper = songMapper;
}
@Override
public void insert(Song song) {
songMapper.insert(song);
}
@Override
public void delete(String id) {
songMapper.deleteById(id);
}
@Override
public void update(Song song) {
songMapper.updateById(song);
}
@Override
public Song detail(String id) {
return songMapper.selectById(id);
}
}mapper层（持久层）
SongMapper.java
package com.example.springboot.mapper;
import com.example.springboot.entity.Song;
import org.springframework.stereotype.Repository;
/**
* @author heyunlin
* @version 1.0
*/
@Repository
public interface SongMapper {
//@Insert("insert into song(id, name, singer, note, last_update_time) values(#{id}, #{name}, #{singer}, #{note}, #{lastUpdateTime})")
void insert(Song song);
//@Delete("delete from song where id = #{id}")
void deleteById(String id);
// @Update("update song set name = #{name}, singer = #{singer}, note = #{note}, last_update_time = #{lastUpdateTime} where id = #{id}")
void updateById(Song song);
// @Select("select * from song where id = #{id})
Song selectById(String id);
}SongMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.springboot.mapper.SongMapper">
<insert id="insert">
insert into song(id, name, singer, note, last_update_time)
values(#{id}, #{name}, #{singer}, #{note}, #{lastUpdateTime})
</insert>
<delete id="deleteById">
delete from song where id = #{id}
</delete>
<update id="updateById">
update song set name = #{name}, singer = #{singer}, note = #{note}, last_update_time = #{lastUpdateTime} where id = #{id}
</update>
<select id="selectById" resultType="com.example.springboot.entity.Song">
select id, name, singer, note, last_update_time as lastUpdateTime from song where id = #{id}
</select>
</mapper>最后，我们简单测试一下写的4个接口，推荐使用postman进行测试，可以通过以下网盘链接下载
下载postman
https://pan.baidu.com/s/1ViOqK6pp_Yj0Wfi2vAJsnA?pwd=yr5a绝大多数java要用的开发工具博主这里都有保存，需要的可以留言或者私信
好了，文章就分享到这里了，代码已开源，按需获取，如果这篇文章对你有所帮助，不要忘了点赞+收藏哦~
springboot+mybatis实现简单增删查改demohttps://gitee.com/he-yunlin/springboot.git
