Windows下qt使用sqlite

最新推荐文章于 2024-08-07 19:27:35 发布

wsx_iot

最新推荐文章于 2024-08-07 19:27:35 发布

阅读量1.6k

点赞数 1

分类专栏：数据库文章标签： qt windows sqlite sql

本文链接：https://blog.csdn.net/qq_29630271/article/details/54598236

版权

数据库专栏收录该内容

11 篇文章 0 订阅

订阅专栏

sqlitedemo.pro

QT += core sql
QT -= gui

CONFIG += c++11

TARGET = sqlitedemo
CONFIG += console
CONFIG -= app_bundle

TEMPLATE = app

SOURCES += main.cpp

main.c

#include <QtCore/QCoreApplication>
#include <QtSql>
#include <QDebug>
#include <QSqlDatabase>
int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);
    QSqlDatabase db;
    QDir dir(QDir::currentPath()+"/temp");
    if(!dir.exists()){
        dir.mkdir(QDir::currentPath()+"/temp");
    }
    bool isExist = QFile::exists(QDir::currentPath()+"/temp/my.db");
    if(!isExist){
        db = QSqlDatabase::addDatabase("QSQLITE","my");
    }else{
        db = QSqlDatabase::addDatabase("QSQLITE");
    }
    db.setDatabaseName(QDir::currentPath()+"/temp/my.db");
    if (!db.open())
    {
        qDebug()<<"open database failed ---"<<db.lastError().text()<<"/n";
        return -1;
    }
    QSqlQuery query(db);
    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();
    }
    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();
}