QT中简单使用SQLITE数据库

代码：mian.cpp

 

#include <QtCore/QCoreApplication> #include <QtSql> #include <QDebug> int main(int argc, char *argv[]) { QCoreApplication a(argc, argv); QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE"); db.setDatabaseName("/tmp/my.db"); if (!db.open()) { qDebug()<<"open database failed ---"<<db.lastError().text()<<"/n"; return -1; } QSqlQuery query; bool ok = query.exec("CREATE TABLE IF NOT EXISTS people (id INTEGER PRIMARY KEY AUTOINCREMENT," "name VARCHAR(20) NOT NULL," "age INTEGER NULL)"); if (ok) { qDebug()<<"ceate table partition success/n"; } else { qDebug()<<"ceate table partition failed/n"; } for (int i = 0; i< 3; ++i) { query.prepare("INSERT INTO people (id, name, age) VALUES (:id, :name, :age)"); query.bindValue(":name", QString("smith_%1").arg(i+1)); query.bindValue(":age", 20+i*5); query.exec(); } // QSqlQuery query; query.exec("SELECT id, name, age FROM people"); while (query.next()) { qDebug()<<"people("<<query.value(0).toInt()<<") name:"<<query.value(1).toString()<<" age:"<<query.value(2).toInt(); } return a.exec(); }

 

sql.pro:

QT += core sql QT -= gui TARGET = sql CONFIG += console CONFIG -= app_bundle LIBS += -lsqlite3 TEMPLATE = app SOURCES += main.cpp

 

编译运行，输出：

ceate table partition success

people( 1 ) name: "smith_1" age: 20

people( 2 ) name: "smith_2" age: 25

people( 3 ) name: "smith_3" age: 30