学步园

代码：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