QT中簡單使用SQLITE資料庫

代碼：mian.cpp

 

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

 

sql.pro:

QT += core sql<br />QT -= gui<br />TARGET = sql<br />CONFIG += console<br />CONFIG -= app_bundle<br />LIBS += -lsqlite3<br />TEMPLATE = app</p><p>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