16,213
社区成员
发帖
与我相关
我的任务
分享
#include <QtCore/QCoreApplication>
#include <QTextCodec>
#include <Qtsql/QSqlDatabase>
#include <Qtsql/QSqlError>
#include <Qtsql/QSqlQuery>
int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);
QSqlDatabase *SqliteDb;
SqliteDb = new QSqlDatabase(QSqlDatabase::addDatabase("QSQLITE","SqliteDb"));
SqliteDb->setDatabaseName("files.db");
SqliteDb->open();
QString SqlText = "SELECT FileName,Title FROM files" ;
qDebug(SqlText.toAscii());
QSqlQuery Query(*SqliteDb);
bool Result = Query.exec(SqlText);
if (!Result)
{
qCritical("SqliteDB Query Failed:%s",SqlText.toAscii().constData());
};
QString tmp, tmp2;
while(Query.next())
{
tmp = Query.value(0).toString();
tmp2 = Query.value(1).toString();
qDebug(tmp.toAscii().data());
qDebug(tmp2.toAscii().data());
}
return a.exec();
}