#include?“database.h“
#include?


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

//創(chuàng)建表格
#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

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????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