#include?“database.h“
#include?“welcome.h“

QSqlDatabase?mydatabase;
database::database（）
{

}
bool?database::CreateDatabase（）
{
????//創建數據庫CreateDatabase

????if?（QSqlDatabase::contains（“qt_sql_default_connection“））
????{
??????mydatabase?=?QSqlDatabase::database（“qt_sql_default_connection“）;
????}
????else
????{
????????mydatabase?=?QSqlDatabase::addDatabase（“QSQLITE“）;
????????mydatabase.setDatabaseName（“doorDatabase.db“）;
????????mydatabase.setUserName（“abc“）;
????????mydatabase.setPassword（“123456“）;

????}
????if?（!mydatabase.open（））
????{
????????return?false;
????}
????return?true;
}
bool?database::createTable（）
{
????if（mydatabase.isOpen（））
????{
????????QSqlQuery?sql_query;
????????QString?create_sql;
????????if（!mydatabase.tables（）.contains（“user“））
????????{

????????????create_sql=?“create?table?user（name?char（20）?primary?key?password?char（20））“;
????????????sql_query.prepare（create_sql）;
????????????if（!sql_query.exec（））
????????????{
????????????????qDebug（）?<????????????????return?false;
????????????}
????????????else
????????????{
????????????????QSqlQuery?sql_query;
????????????????QString?insert_sql?=?“insert?into?user?values?（??）“;
????????????????sql_query.prepare（insert_sql）;
????????????????sql_query.addBindValue（“asd“）;
????????????????sql_query.addBindValue（“asd“）;

????????????????if（!sql_query.exec（））
????????????????{
????????????????????qDebug（）?<????????????????????return?false;
????????????????}

????????????????qDebug（）?<????????????}
????????}
?????????if（!mydatabase.tables（）.contains（“family_info“））
?????????{
?????????????create_sql?=?“create?table?family_info（cardid?char（20）?primary?keyname?char（20）sex?char（2）age?intaddr?char（50）?tel?char（20））“;
?????????????sql_query.prepare（create_sql）;
?????????????if（!sql_query.exec（））
?????????????{
?????????????????qDebug（）?<?????????????????return?false;
?????????????}
?????????????else
?????????????{
?????????????????qDebug（）?<?????????????}
?????????}
??????????if（!mydatabase.tables（）.contains（“open_info“））
??????????{
??????????????create_sql?=?“create?table?open_info（cardid?char（20）time?char（20）foreign?key（cardid）?references?family_info（cardid）?primary?key（cardidtime））“;
??????????????sql_query.prepare（create_sql）;
??????????????if（!sql_query.exec（））
??????????????{
??????????????????qDebug（）?<??????????????????return?false;
??????????????}
??????????????else
??????????????{
??????????????????qDebug（）?<??????????????}
??????????}
????}
????return?true;
}
bool?database::checkUsers（QString?user?QString?passwd）
{
????QSqlQuery?sql_query;
????QString?select_sql?=?“select?*?from?user“;
????sql_query.p

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件?????????48??2018-05-24?18:32??aiDoor\serial\bg.qrc

?????文件???????7363??2018-05-23?16:11??aiDoor\serial\database.cpp

?????文件????????825??2018-05-23?14:00??aiDoor\serial\database.h

?????文件?????461454??2018-01-15?11:40??aiDoor\serial\Debug\debug\main.o

?????文件?????875258??2018-01-15?11:40??aiDoor\serial\Debug\debug\mainwindow.o

?????文件???????5695??2018-01-15?11:40??aiDoor\serial\Debug\debug\moc_mainwindow.cpp

?????文件?????290765??2018-01-15?11:40??aiDoor\serial\Debug\debug\moc_mainwindow.o

?????文件????1921341??2018-01-15?11:37??aiDoor\serial\Debug\debug\qrc_myimage.cpp

?????文件?????388653??2018-01-15?11:37??aiDoor\serial\Debug\debug\qrc_myimage.o

?????文件????2022529??2018-01-15?11:40??aiDoor\serial\Debug\debug\serial.exe

?????文件?????100816??2018-01-15?11:37??aiDoor\serial\Debug\debug\serial_resource_res.o

?????文件??????21886??2018-01-02?10:19??aiDoor\serial\Debug\Makefile

?????文件??????40986??2018-01-02?10:19??aiDoor\serial\Debug\Makefile.Debug

?????文件??????41078??2018-01-02?10:19??aiDoor\serial\Debug\Makefile.Release

?????文件????????805??2017-12-29?09:07??aiDoor\serial\Debug\serial_resource.rc

?????文件??????29620??2018-01-15?11:40??aiDoor\serial\Debug\ui_mainwindow.h

?????文件????????183??2017-12-28?18:08??aiDoor\serial\main.cpp

?????文件??????13735??2018-05-25?14:56??aiDoor\serial\mainwindow.cpp

?????文件???????1626??2018-05-23?08:18??aiDoor\serial\mainwindow.h

?????文件??????18311??2018-05-24?18:02??aiDoor\serial\mainwindow.ui

?????文件??????26356??2018-05-22?22:33??aiDoor\serial\music\welcome.mp3

?????文件??????99678??2010-04-19?09:36??aiDoor\serial\myico.ico

?????文件????????602??2018-05-24?17:52??aiDoor\serial\serial.pro

?????文件??????18027??2018-05-25?15:14??aiDoor\serial\serial.pro.user

?????文件??????23639??2018-01-15?11:42??aiDoor\serial\serial.pro.user.18

?????文件???????3154??2018-05-25?14:02??aiDoor\serial\welcome.cpp

?????文件????????483??2018-05-23?14:10??aiDoor\serial\welcome.h

?????文件??????26356??2018-05-22?22:33??aiDoor\serial\welcome.mp3

?????文件???????7857??2018-05-25?14:02??aiDoor\serial\welcome.ui

?????目錄??????????0??2018-01-15?11:40??aiDoor\serial\Debug\debug

............此處省略9個文件信息