springboot+mybatis实现简单的增、删、查、改

这篇文章主要针对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 TransferSource Server         : MariaDBSource Server Type    : MariaDBSource Server Version : 100605 (10.6.5-MariaDB)Source Host           : 127.0.0.1:3306Source Schema         : springbootTarget Server Type    : MariaDBTarget Server Version : 100605 (10.6.5-MariaDB)File Encoding         : 65001Date: 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: rootpassword: rooturl: jdbc:mysql://localhost:3306/springbootdriver-class-name: com.mysql.cj.jdbc.Drivertype: com.alibaba.druid.pool.DruidDataSourcemybatis:mapper-locations: classpath:mapper/*Mapper.xmllogging:level:springfox: errorcom.example.springboot: debugserver: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;@Autowiredpublic 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;@Autowiredpublic 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 {@Overridepublic 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;@Autowiredpublic SongServiceImpl(SongMapper songMapper) {this.songMapper = songMapper;}@Overridepublic 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;@Autowiredpublic SongServiceImpl(SongMapper songMapper) {this.songMapper = songMapper;}@Overridepublic void insert(Song song) {songMapper.insert(song);}@Overridepublic 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;@Autowiredpublic 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;@Autowiredpublic SongServiceImpl(SongMapper songMapper) {this.songMapper = songMapper;}@Overridepublic void insert(Song song) {songMapper.insert(song);}@Overridepublic void delete(String id) {songMapper.deleteById(id);}@Overridepublic 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;@Autowiredpublic 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;@Autowiredpublic 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;@Autowiredpublic SongServiceImpl(SongMapper songMapper) {this.songMapper = songMapper;}@Overridepublic void insert(Song song) {songMapper.insert(song);}@Overridepublic void delete(String id) {songMapper.deleteById(id);}@Overridepublic void update(Song song) {songMapper.updateById(song);}@Overridepublic 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进行测试,可以通过以下网盘链接下载

下载postmanhttps://pan.baidu.com/s/1ViOqK6pp_Yj0Wfi2vAJsnA?pwd=yr5a绝大多数java要用的开发工具博主这里都有保存,需要的可以留言或者私信

 好了,文章就分享到这里了,代码已开源,按需获取,如果这篇文章对你有所帮助,不要忘了点赞+收藏哦~

springboot+mybatis实现简单增删查改demohttps://gitee.com/he-yunlin/springboot.git

本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如若转载,请注明出处:http://www.rhkb.cn/news/84987.html

如若内容造成侵权/违法违规/事实不符,请联系长河编程网进行投诉反馈email:809451989@qq.com,一经查实,立即删除!

相关文章

K8S系列文章 之 容器网络基础 Docker0

什么是Docker0 使用ip addr命令看一下网卡&#xff1a; rootKitDevVps:~# ip addr 1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00inet 127.0.0.1/8 scope host…

SpringWeb项目核心功能总结

SpringWeb项目核心功能总结 文章目录 SpringWeb项目核心功能总结1.浏览器与Java程序的连接&#xff08;个人偏好使用RequestMapping&#xff09;2.参数的传入3.结果的返回请求转发和请求重定向的区别 核心功能用到的注解&#xff1a; RestControllerControllerResponseBodyRequ…

前端主题切换方案——CSS变量

前言 主题切换是前端开发中老生常谈的问题&#xff0c;本文将介绍主流的前端主题切换实现方案——CSS变量 CSS变量 简介 编写CSS样式时&#xff0c;为了避免代码冗余&#xff0c;降低维护成本&#xff0c;一些CSS预编译工具&#xff08;Sass/Less/Stylus&#xff09;等都支…

AP2915DC-DC降压恒流驱动IC LED电源驱动芯片 汽车摩托电动车灯

AP2915 是一款可以一路灯串切换两路灯串的降压 恒流驱动器,高效率、外围简单、内置功率管&#xff0c;适用于 5-80V 输入的高精度降压 LED 恒流驱动芯片。内置功 率管输出功率可达 12W&#xff0c;电流 1.2A。 AP2915 一路灯亮切换两路灯亮&#xff0c;其中一路灯亮可 以全亮&a…

YOLOv5、YOLOv8改进:添加ShuffleAttention注意力机制

广泛应用的注意力机制主要有空间注意力机制和通道注意力机制&#xff0c;其目的分别是捕捉像素级的成对关系和通道依赖关系。虽然将两种机制融合在一起可以获得比单独更好的性能&#xff0c;但计算开销不可避免。因而&#xff0c;本文提出Shuffle Attetion&#xff0c;即SA&…

标准化归一化 batch norm, layer norm, group norm, instance norm

Layer Normalization - EXPLAINED (in Transformer Neural Networks) Layer Normalization - EXPLAINED (in Transformer Neural Networks) 0~4min:什么是multi-head attention 5~7min:layer norm图示 7~9min:公式举例layer norm 9:54-end:layer norm的代码示例 group n…

atx2环境搭建

1. 卸载python3.11.4版本 $sudo rm -rf /Library/Frameworks/Python.framework/Versions/3.11/ $sudo rm -rf /Applications/Python\ 3.11/ 第三步&#xff1a;删除指向python的链接 cd /usr/local/bin/ ls -l /usr/local/bin | grep /Library/Frameworks/Python.framework/…

详解使用SSH远程连接Ubuntu服务器系统

演示环境&#xff1a; 1.Windows10系统 2.VMware Workstation Pro虚拟机 2.Ubuntu16.04.6&#xff08;以上版本通用&#xff09; 回归正题 一、在Ubuntu端&#xff1a; 1.首先需要安装SSH服务器&#xff0c;在ubuntu终端输入以下指令 sudo apt-get install ssh2.输入你的ubu…

pytest 常用命令参数

-x 用例一旦失败或错误时就立即停止执行 共两条用例&#xff0c;运行第一条报错失败或报错&#xff0c;第二条就不会执行 pytest -vs -x test_pytest_study.py::TestCommon1 共2条用例&#xff0c;当执行到第一条失败时候&#xff0c;第二条不执行 --maxfailnum …

碳中和与碳达峰对卫星遥感的现实需求,遥感技术在生态系统碳储量、碳收支、碳排放、碳循环以及人为源排放反演等领域的技术发展

卫星遥感具有客观、连续、稳定、大范围、重复观测的优点&#xff0c;已成为监测全球碳盘查不可或缺的技术手段&#xff0c;卫星遥感也正在成为新一代 、国际认可的全球碳核查方法。本教程的目的就是梳理碳中和与碳达峰对卫星遥感的现实需求&#xff0c;系统总结遥感技术在生态系…

C++复习笔记——primer第五版

文章目录 一、引用和指针1.引用2.指针2.1利用指针访问对象2.2指针的值或指针所指对象的值的改变 3.赋值和指针4.指向指针的引用 二、String1.初始化String对象的方式2. string对象上的操作3.使用getline读取一整行4.字面值和字符串相加5.使用for循环改变字符串中的字符 三、Vec…

Ctfshow web入门 SSTI 模板注入篇 web361-web372 详细题解 全

CTFshow SSTI web361 笔记分享 一、代码块 变量块 {{}} 用于将表达式打印到模板输出 注释块 {##} 注释 控制块 {%%} 可以声明变量&#xff0c;也可以执行语句 {% for i in .__class__.__mro__[1].__subclasses__() %}{% if i.__name___wrap_close %}{% print i.__init__.…

WinServer2016 DHCPv6部署

Windows Server 2016 部署 DHCPv6 应用场景&#xff1a;如果服务器的 idrac 地址配置之后忘记了&#xff0c;又无法不能重启服务器&#xff0c;可以通过 DHCPv6 来解决。因为服务器 idrac 的 ipv6 自动获取是默认开启的&#xff0c;那么可以用笔记本装个 windwos server 的系统…

vue3多页面配置你一定会遇到的问题,踩坑指南

vue3实现多页面打包容易&#xff0c;关键是如何实现本地的开发和调试&#xff1f;我们接下来解决如下几个问题&#xff1a; 1 多页面项目的项目结构是怎样的&#xff1f; --public--src---App.vue---main.js---page1. ---App.vue---main.js----home.vue----list.vue---page2.…

【UE4 RTS】09-Day and Night

前言 本篇博客实现的效果是太阳和天空会随着游戏时间的变化而变化。 效果 步骤 1. 设置“LightSource”为可移动的 2. 新建一个文件夹&#xff0c;命名为“Lighting” 3. 打开游戏状态“RTS_GameState_BP”&#xff0c;添加一个函数命名为“GetGameSpeed” 添加一个浮点类型…

安卓:UDP通信

目录 一、介绍 网络通信的三要素&#xff1a; &#xff08;1&#xff09;、IP地址&#xff1a; IPv4: IPv6: IP地址形式&#xff1a; IP常用命令&#xff1a; IP地址操作类: &#xff08;2&#xff09;、端口&#xff1a; &#xff08;3&#xff09;、协议: UDP协…

【计算机视觉|生成对抗】条件生成对抗网络(CGAN)

本系列博文为深度学习/计算机视觉论文笔记&#xff0c;转载请注明出处 标题&#xff1a;Conditional Generative Adversarial Nets 链接&#xff1a;[1411.1784] Conditional Generative Adversarial Nets (arxiv.org) 摘要 生成对抗网络&#xff08;Generative Adversarial…

力扣:59. 螺旋矩阵 II(Python3)

题目&#xff1a; 给你一个正整数 n &#xff0c;生成一个包含 1 到 n2 所有元素&#xff0c;且元素按顺时针顺序螺旋排列的 n x n 正方形矩阵 matrix 。 来源&#xff1a;力扣&#xff08;LeetCode&#xff09; 链接&#xff1a;力扣&#xff08;LeetCode&#xff09;官网 - 全…

兰州https证书申请

https证书是由CA认证机构颁发的数字证书&#xff0c;可以为域名网站或者公网IP网站提供信息加密服务&#xff0c;正规CA认证机构签发的https证书可以兼容99%的主流浏览器和IOS、Windows系统&#xff0c;同样&#xff0c;现在流行的小程序也需要https证书。那么&#xff0c;该怎…

云原生是什么

目录 1. 云原生是什么1.1. 微服务1.2. DevOps1.3. 持续交付1.4. 容器化 2. 什么是云原生2.1. 云原生的诞生2.2. 云原生基金会2.3. 主要区别: 云原生与传统企业应用 1. 云原生是什么 云原生是面向"云"而设计的应用, 因此技术部分依赖于传统云计算的 3 层概念, 基础设…