資源簡介
自己寫的一個簡單的QT實例,數據庫的簡單的增刪改操作,以及導出數據到excel中,適合于學習。

代碼片段和文件信息
#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\databa
?????文件????????409??2012-02-21?09:46??mem\databa
?????文件???????3072??2012-02-21?10:44??mem\debug\databa
?????文件?????119505??2012-02-21?10:15??mem\debug\databa
?????文件?????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
- 上一篇:策略模式工廠方法模式觀察者模式
- 下一篇:mclmcrrt8_4.dll
評論
共有 條評論