QT中简单使用SQLITE数据库

长平狐 发布于 2013/01/11 10:33
阅读 3K+
收藏 0

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

 


原文链接:http://blog.csdn.net/fjb2080/article/details/6459599
加载中
返回顶部
顶部