本来想自己封装一下sqlite操作类 写到一半才发现是脱裤子放屁 多此一举了

自己写的东西还没有Qt用起来简洁 唯一的好处估计就是能在整个工程里对同一个数据库进行操作 能通过QDir查找指定目录下的数据库文件 绑定到comboBox让用户手动选择操作的数据库 有空再添加以下数据库的备份函数 其实思路也就是文件另存为

一下代码贴出来自嘲一下 唉

.h文件

#ifndef <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ITEDB_H #define <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ITEDB_H #include <QString> #include <Qt<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>> class <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDB { public: <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDB(); <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDB(QString dbname); static void setDbName(QString name); static QString getDbName(); QStringList findDbfiles(); bool connDb(); Q<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Query search(QString <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>_string); void closeDb(); private: static QString DbName; Q<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Database dbconn; }; #endif // <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ITEDB_H

.cpp文件

#include "<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>itedb.h" #include <QDir> QString <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDB::DbName=""; <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDB::<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDB() { dbconn = Q<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Database::addDatabase("Q<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ITE"); dbconn.setDatabaseName("./DbfInUse/"+<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDB::DbName); } <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDB::<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDB(QString dbname) { dbconn = Q<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Database::addDatabase("Q<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ITE"); dbconn.setDatabaseName(dbname); } void <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDB::setDbName(QString name) { <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDB::DbName=name; } QString <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDB::getDbName() { return DbName; } QStringList <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDB::findDbfiles() { QDir dir; dir.setPath("./DbfInUse"); dir.setFilter(QDir::Files | QDir::Hidden); dir.setSorting(QDir::Name); QStringList names = dir.entryList(); QStringList newnames; newnames=names.filter(".dbf"); return newnames; } bool <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDB::connDb() { if(!dbconn.open()) { return false; } else { return true; } } Q<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Query <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDB::search(QString <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>_string) { Q<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Query query; query.exec(<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>_string); return query; } void <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDB::closeDb() { dbconn.close(); }