#include?“database.h“

database::database（）
{
}

bool?database::createConnection（）
{
????db=QSqlDatabase::addDatabase（“QSQLITE“）;
????db.setDatabaseName（“database.db“）;
????if（!db.open（））
????????return?false;
????return?true;
}
bool?database::createTable（）
{
????if（!createConnection（））
????????return?false;
????QSqlQuery?query;
????bool?b=?query.exec（Qobject::tr（“create?table?memo?（id?INTEGER?PRIMARY?KEY?AUTOINCREMENT?title?vchartxtime?vchar?switch?vchar（2）?content?vchar）“））;
????//query.exec（Qobject::tr（“insert?into?memo?values?（1‘liu‘‘2012-12-21‘‘是‘‘uuuuuuuuuuuuuuuuuuuuuuu‘）“））;
????//query.exec（Qobject::tr（“insert?into?memo?values?（2‘chen‘‘2012-11-21‘‘否‘‘hhhhhhhhhhhhhhhhh‘）“））;
????//query.exec（Qobject::tr（“insert?into?memo?values?（3‘wang‘‘2012-10-21‘‘是‘‘gyyyyyyyyyyyyyyyyyy‘）“））;
????return?b;
}
database::~database（）
{
????db.close（）;
}

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

?????文件????????901??2012-02-21?09:58??mem\database.cpp

?????文件????????409??2012-02-21?09:46??mem\database.h

?????文件???????3072??2012-02-21?10:44??mem\debug\database.db

?????文件?????119505??2012-02-21?10:15??mem\debug\database.o

?????文件?????205947??2012-02-21?10:39??mem\debug\main.o

?????文件????1280009??2012-02-21?10:47??mem\debug\mem.exe

?????文件?????225754??2012-02-21?10:15??mem\debug\memotable.o

?????文件???????2768??2012-02-21?10:32??mem\debug\moc_widget.cpp

?????文件?????209823??2012-02-21?10:32??mem\debug\moc_widget.o

?????文件????????149??2012-02-21?10:35??mem\debug\test.xls

?????文件?????244012??2012-02-21?10:47??mem\debug\widget.o

?????文件????????646??2012-02-21?10:39??mem\main.cpp

?????文件???????5939??2012-02-21?10:47??mem\Makefile

?????文件???????5916??2012-02-21?10:47??mem\Makefile.Debug

?????文件???????6004??2012-02-21?10:47??mem\Makefile.Release

?????文件????????337??2012-02-21?09:52??mem\mem.pro

?????文件??????13932??2012-02-21?10:47??mem\mem.pro.user

?????文件???????3857??2012-02-21?10:06??mem\memotable.cpp

?????文件????????424??2012-02-21?10:05??mem\memotable.h

?????文件???????6336??2012-02-21?10:47??mem\widget.cpp

?????文件???????1200??2012-02-21?10:26??mem\widget.h

?????目錄??????????0??2012-02-21?10:47??mem\debug

?????目錄??????????0??2012-02-21?09:49??mem\release

?????目錄??????????0??2012-02-21?10:47??mem

-----------?---------??----------?-----??----

??????????????2336940????????????????????24