QtSQL连接查询SQLite3的使用方法示例

代码如下：

1、main.cpp

#include <QtCore/QCoreApplication> #include <QtSql/qsql.h> #include <QSqlDatabase> #include <QSqlQuery> #include <iostream> #include <QString> #include <QVariant> #include <QDebug> using namespace std; int main(int argc,char *argv[]) { QCoreApplication a(argc,argv); QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE"); db.setDatabaseName("./memory.xdb"); db.open(); cout << "Let's begin....../n"; QSqlQuery query; query.exec("create table person (id int primary key," "firstname varchar(20),lastname varchar(20))"); query.exec("insert into person values(101,'Danny','Young')"); query.exec("insert into person values(102,'Christine','Holand')"); query.exec("insert into person values(103,'Lars','Gordon')"); query.exec("insert into person values(104,'Roberto','Robitaille')"); query.exec("insert into person values(105,'Maria','Papadopoulos')"); query.exec("create table offices (id int primary key," "imagefile int," "location varchar(20)," "country varchar(20)," "description varchar(100))"); query.exec("insert into offices " "values(0,'Oslo','Norway'," "'Oslo is home to more than 500 000 citizens and has a " "lot to offer.It has been called /"The city with the big " "heart/" and this is a nickname we are happy to live up to.')"); query.exec("insert into offices " "values(1,1,'Brisbane','Australia'," "'Brisbane is the capital of Queensland,the Sunshine State," "where it is beautiful one day,perfect the next. " "Brisbane is Australia''s 3rd largest city,being home " "to almost 2 million people.')"); query.exec("insert into offices " "values(2,2,'Redwood City','US'," "'You find Redwood City in the heart of the Bay Area " "just north of Silicon Valley. The largest nearby city is " "San Jose which is the third largest city in California " "and the 10th largest in the US.')"); query.exec("insert into offices " "values(3,3,'Berlin','Germany'," "'Berlin,the capital of Germany is dynamic,cosmopolitan " "and creative,allowing for every kind of lifestyle. " "East meets West in the metropolis at the heart of a " "changing Europe.')"); query.exec("insert into offices " "values(4,4,'Munich'," "'Several technology companies are represented in Munich," "and the city is often called the /"Bavarian Silicon Valley/". " "The exciting city is also filled with culture," "art and music. ')"); query.exec("insert into offices " "values(5,5,'Beijing','China'," "'Beijing as a capital city has more than 3000 years of " "history. Today the city counts 12 million citizens,and " "is the political,economic and cultural centre of China.')"); query.exec("create table images (locationid int,file varchar(20))"); query.exec("insert into images values(0,'images/oslo.png')"); query.exec("insert into images values(1,'images/brisbane.png')"); query.exec("insert into images values(2,'images/redwood.png')"); query.exec("insert into images values(3,'images/berlin.png')"); query.exec("insert into images values(4,'images/munich.png')"); query.exec("insert into images values(5,'images/beijing.png')"); query.exec("select * from offices"); while (query.next()) { int id = query.value(0).toInt(); int imagefile = query.value(1).toInt(); QString location = query.value(2).toString(); QString country = query.value(3).toString(); QString description = query.value(4).toString(); qDebug() << "id = " <<id << "imagefile = "<< imagefile << "location = " <<location << "country = " << country << "description : " << description <<"/n"; } db.close(); cout << "/nOK./n"; return a.exec(); }

2、main.pro

#------------------------------------------------- # # Project created by QtCreator 2010-11-25T09:29:58 # #------------------------------------------------- QT += core sql QT -= gui TARGET = MyManage CONFIG += console CONFIG -= app_bundle TEMPLATE = app SOURCES += main.cpp

有一点要注意：

相关的头文件需要include进去，如:

#include <QtSql/qsql.h> #include <QSqlDatabase> #include <QSqlQuery> #include <iostream> #include <QString> #include <QVariant> #include <QDebug>

等等。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!