资源简介


资源截图

代码片段和文件信息

#include “database.h“
#include 


#define DATAbase_CREATE_SQL “CREATE DATAbase \
    ‘KylinPlayer‘ DEFAULT CHARACTER SET utf8;“

//创建表格
#define TABLE_CREATE_SQL \
    “CREATE TABLE FavoriteSong “\
    “(id INTEGER PRIMARY KEY song_id NUMERIC song_name TEXT album_name TEXT “\
    “singer_name TEXT song_url TEXT artcover_url TEXT lrc_url TEXTUNIQUE(song_id));“

#define INSERT_SONG_SQL “REPLACE INTO FavoriteSong \
    (song_id song_name album_name singer_name \
    song_url artcover_url lrc_url) \
     VALUES (? ? ? ? ? ? ?)“

#define SELECT_SONG_SQL “SELECT song_id song_name album_name \
     singer_namesong_urlartcover_urllrc_url \
     FROM FavoriteSong;“


Database::Database(Qobject *parent) :
    Qobject(parent)
{
}

bool Database::initDatabase()
{
    q

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件        883  2015-01-04 02:46  KylinPlayer\common.h

     文件       3023  2016-08-29 11:29  KylinPlayer\database.cpp

     文件        411  2015-01-04 02:46  KylinPlayer\database.h

     文件      10872  2015-01-04 02:46  KylinPlayer\images\KylinPlayer.png

     文件       6970  2015-01-04 02:46  KylinPlayer\images\next.png

     文件       6362  2015-01-04 02:46  KylinPlayer\images\pause.png

     文件       7602  2015-01-04 02:46  KylinPlayer\images\play.png

     文件       6975  2015-01-04 02:46  KylinPlayer\images\prev.png

     文件      22269  2015-01-04 02:46  KylinPlayer\images\Qt.png

     文件      10872  2015-01-04 02:46  KylinPlayer\images\ubuntukylin.png

     文件        591  2017-02-09 22:14  KylinPlayer\KylinPlayer.pro

     文件      18649  2017-02-09 22:17  KylinPlayer\KylinPlayer.pro.user

     文件        183  2015-01-04 02:46  KylinPlayer\main.cpp

     文件       7005  2016-08-29 21:51  KylinPlayer\network.cpp

     文件       1884  2017-01-21 18:26  KylinPlayer\network.h

     文件       5293  2016-08-29 21:57  KylinPlayer\osdlyricswidget.cpp

     文件        970  2016-08-29 15:43  KylinPlayer\osdlyricswidget.h

     文件      12878  2017-02-09 22:14  KylinPlayer\playermainwindow.cpp

     文件       1821  2016-08-29 09:48  KylinPlayer\playermainwindow.h

     文件       8029  2016-08-29 09:48  KylinPlayer\playermainwindow.ui

     文件        329  2017-02-09 22:14  KylinPlayer\resource.qrc

     目录          0  2017-02-09 22:11  KylinPlayer\images

     目录          0  2017-02-09 22:17  KylinPlayer

----------- ---------  ---------- -----  ----

               133871                    23


评论

共有 条评论