Python Flask音乐网：实现热门歌曲列表

获取热门歌曲数据

source d:\song.sql

Mysql 使用cmd运行sql脚本: https://www.cnblogs.com/ziquntheblog/p/7542958.html

-- ----------------------------
-- Records of song
-- ----------------------------
INSERT INTO `song` VALUES ('19', 'Lose Yourself ', 'Eminem', '16.mp3', '132', '2');
INSERT INTO `song` VALUES ('20', 'Love the Way You Lie ', 'Eminem', '17.mp3', '8', '2');
INSERT INTO `song` VALUES ('21', 'Lighters', 'Eminem', '18.mp3', '17', '2');
INSERT INTO `song` VALUES ('22', 'Innocence', 'Avril Lavigne', '19.mp3', '3', '2');
INSERT INTO `song` VALUES ('26', 'Here To Never Growing Up', 'Avril Lavigne', '20.mp3', '1', '2');
INSERT INTO `song` VALUES ('27', 'When You re Gone', 'Avril Lavigne', '21.mp3', '1', '2');
INSERT INTO `song` VALUES ('28', 'My Love', 'Westlife', '22.mp3', '0', '2');
INSERT INTO `song` VALUES ('29', 'Seasons In The Su', 'Westlife', '23.mp3', '1', '2');
INSERT INTO `song` VALUES ('30', 'You Raise Me Up', 'Westlife', '24.mp3', '1', '2');
INSERT INTO `song` VALUES ('31', 'Beautiful In White (Demo)', 'Westlife', '25.mp3', '0', '2');
INSERT INTO `song` VALUES ('32', 'Soledad', 'Westlife', '26.mp3', '2', '2');
INSERT INTO `song` VALUES ('33', 'Summer', '久石譲', '27.mp3', '0', '3');
INSERT INTO `song` VALUES ('34', 'The Rai', '久石譲', '28.mp3', '6', '3');
INSERT INTO `song` VALUES ('35', '月光の云海', '久石譲', '29.mp3', '33', '3');
INSERT INTO `song` VALUES ('36', 'Silent Love', '久石譲', '30.mp3', '0', '3');
INSERT INTO `song` VALUES ('37', '“天空の城ラピュタ”~君をのせて', '久石譲', '31.mp3', '0', '1');
INSERT INTO `song` VALUES ('38', '太阳照常升起', '久石譲', '32.mp3', '0', '3');
INSERT INTO `song` VALUES ('39', '《七大罪》', '小林未郁', '33.mp3', '0', '3');
INSERT INTO `song` VALUES ('40', 'Through My Blood', '小林未郁', '34.mp3', '0', '3');
INSERT INTO `song` VALUES ('41', 'Song of', '小林未郁', '35.mp3', '0', '3');
INSERT INTO `song` VALUES ('42', '夜の国 ', 'Annabel', '36.mp3', '1', '3');
INSERT INTO `song` VALUES ('43', 'Above your hand', 'Annabel', '37.mp3', '1', '3');
INSERT INTO `song` VALUES ('44', 'あなたの笑顔という', 'Annabel', '38.mp3', '1', '3');
INSERT INTO `song` VALUES ('45', '삐딱하게 ', 'G-Drago', '39.mp3', '0', '4');
INSERT INTO `song` VALUES ('46', 'Missing You', 'G-Drago', '40.mp3', '3', '4');
INSERT INTO `song` VALUES ('47', '少年啊', 'G-Drago', '41.mp3', '1', '4');
INSERT INTO `song` VALUES ('48', '我的天', 'G-Drago', '42.mp3', '1', '4');
INSERT INTO `song` VALUES ('50', '바람이나 좀 쐐', 'Gary', '44.mp3', '0', '4');
INSERT INTO `song` VALUES ('51', '戏子', 'Gary', '45.mp3', '0', '4');
INSERT INTO `song` VALUES ('52', '人情味', 'Gary', '46.mp3', '0', '4');
INSERT INTO `song` VALUES ('56', '제주도', '金泰妍', '47.mp3', '1', '4');
INSERT INTO `song` VALUES ('57', '잊어버리지마', '金泰妍', '48.mp3', '0', '4');
INSERT INTO `song` VALUES ('58', '만약에', '金泰妍', '49.mp3', '0', '4');
INSERT INTO `song` VALUES ('59', 'Ayaling', '艾力·阿克苏巴', '50.mp3', '0', '5');
INSERT INTO `song` VALUES ('60', 'in b Flat Minor Op. 9-1', '邓泰山', '51.mp3', '1', '5');
INSERT INTO `song` VALUES ('62', '别说我爱你', 'Dome Pakor', '52.mp3', '58', '5');

编写逻辑层

home/views.py:

@home.route("/contentFrame")
def contentFrame():
    """
    主页面
    """
    hot_artist = Artist.query.filter_by(isHot=1).limit(12).all()                              # 获取歌手数据
    hot_song = Song.query.order_by(Song.hits.desc()).limit(10).all()                          # 获取歌曲数据
    return render_template('home/contentFrame.html',hot_artist=hot_artist,hot_song=hot_song) # 渲染模板

编写模板文件

与Python Flask音乐网：实现热门歌手列表 同

效果图