#include?
#include?
#include?“QVariant“
#include?“database.h“
#include?


Database::Database（）
{

}
bool?Database::createConnection（QString?dbname）
{
????QSqlDatabase?db=?QSqlDatabase::addDatabase（“QSQLITE“）?;
????db.setDatabaseName（dbname）;



????if（!db.open（））
????{
????????QMessageBox::critical（0“cannot?open?dataase““Unabel?to?connect“QMessageBox::Cancel）;

????????return?false;


????}
????qDebug（）<<“createConnection:“?;

????return?true;

}
void?Database::createTables（）
????{

????QSqlQuery?query;
????qDebug（）<????//創(chuàng)建一張可以進(jìn)入房間的人員表
????query.exec（“create?table?CanEnter（NUM?Integer?Primary?key?NAME?varchar（10）CurTime?DATETIME）“）;
????query.exec（“insert?into?CanEnter?values（119‘蔣春雨‘‘2010/1/21‘）“）;
????query.exec（“insert?into?CanEnter?values（118‘老蔣‘‘2011/12/32‘）“）;
????query.exec（“insert?into?CanEnter?values（117‘蔣委員長(zhǎng)‘‘2012/12/23‘）“）;

????//創(chuàng)建一張已經(jīng)進(jìn)入過該房間的人員表
????query.exec（“create?table?enterP（NUM?Integet?Primary?key?NAME?varchar（10）CurTime?DATETIME）?“）;

????//假設(shè)一下人員進(jìn)入過
????query.exec（“insert?into?enterP?values（116‘張三‘‘2011/12/31?‘）“）;
????query.exec（“insert?into?enterP?values（115‘李四‘‘2011/12/31‘）“）;
????query.exec（“insert?into?enterP?values（114‘王二‘‘2011/12/31‘）“）;


???????//密碼
????query.exec（“create?table?password（pwd?varchar?primary?key）“）;
????????query.exec（“insert?into?password?values（‘11111800210‘）“）;




}
void?Database::closeDatabase（）
{

????db.close（）;

}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-06-19?19:11??rfidTestMS\
?????文件????????1657??2013-06-19?19:08??rfidTestMS\database.cpp
?????文件?????????296??2013-04-27?10:27??rfidTestMS\database.h
?????目錄???????????0??2013-05-11?16:38??rfidTestMS\image\
?????文件???????25207??2011-12-07?18:24??rfidTestMS\image\4d655156376b121a574e006b.jpg
?????文件??????280387??2011-10-19?16:31??rfidTestMS\image\5e6c8c2f0d6aa5571f308981.jpg
?????文件?????2359350??2011-11-12?17:00??rfidTestMS\image\6f3bc0955cea0749d1135ed0.bmp
?????文件???????41272??2011-12-14?21:42??rfidTestMS\image\6fcd8c1b0e164bbf1bd5760a.jpg
?????文件??????717687??2013-04-05?12:31??rfidTestMS\image\IMG_20130405_123158.jpg
?????文件??????759031??2013-04-05?12:32??rfidTestMS\image\IMG_20130405_123201.jpg
?????文件??????748727??2013-04-05?12:32??rfidTestMS\image\IMG_20130405_123220.jpg
?????文件??????697463??2013-04-05?12:32??rfidTestMS\image\IMG_20130405_123251.jpg
?????文件??????860983??2013-04-05?12:32??rfidTestMS\image\IMG_20130405_123257.jpg
?????文件???????38745??2013-04-13?13:16??rfidTestMS\image\IMG_20130413_131633.jpg
?????文件??????708535??2013-04-14?11:34??rfidTestMS\image\IMG_20130414_113406.jpg
?????文件???????35737??2013-04-15?09:38??rfidTestMS\image\IMG_20130415_093844.jpg
?????文件????????1284??2013-06-19?19:08??rfidTestMS\logindlg.cpp
?????文件?????????393??2013-05-11?18:17??rfidTestMS\logindlg.h
?????文件????????3782??2013-06-19?19:08??rfidTestMS\logindlg.ui
?????文件?????????368??2013-05-09?20:48??rfidTestMS\main.cpp
?????文件?????????700??2013-05-11?16:38??rfidTestMS\resource.qrc
?????文件?????????527??2013-06-19?19:02??rfidTestMS\rfidTestMS.pro
?????文件???????31453??2013-06-19?19:11??rfidTestMS\rfidTestMS.pro.user
?????文件????????8333??2013-06-10?16:50??rfidTestMS\widget.cpp
?????文件????????1867??2013-05-11?18:17??rfidTestMS\widget.h
?????文件???????15382??2013-06-19?19:08??rfidTestMS\widget.ui