Qt笔记——QSqlLite

静态数据库，简单方便

在.pro文件里添加 +sql

#ifndef WIDGET_H

#define WIDGET_H

#include <QWidget>

namespace Ui {

class Widget;

}

class Widget : public QWidget

{

    Q_OBJECT

public:

    explicit Widget(QWidget *parent = );

    ~Widget();

private:

    Ui::Widget *ui;

};

#endif // WIDGET_H

#include "widget.h"

#include "ui_widget.h"

#include <QSqlDatabase>

#include <QDebug>

#include <QMessageBox>

#include <QSqlError>

#include <QSqlQuery>

#include <QVariantList>

Widget::Widget(QWidget *parent) :

    QWidget(parent),

    ui(new Ui::Widget)

{

    ui->setupUi(this);

    //打印Qt支持的数据库驱动

    qDebug()<<QSqlDatabase::drivers();

    //添加Sqlite数据库

    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");

    //设置数据库

    db.setDatabaseName("../info.db");

    //打开数据库

    if(!db.open())

    {

        QMessageBox::warning(this,"error",db.lastError().text());

        return;

    }

    QSqlQuery query;

    query.exec("create table if not exists student(id int primary key, name varchar(255), age int, score int)");

    query.prepare("insert into student(id,name, age, score) values(:id,:name, :age, :score)");

    //给字段设置内容 list

    QVariantList idList;

    idList<<<<<<;

    QVariantList nameList;

    nameList << "xiaoming" << "xiaolong" << "xiaojiang";

    QVariantList ageList;

    ageList <<  <<  <<;

    QVariantList scoreList;

    scoreList <<  <<  << ;

    //给字段绑定相应的值 按顺序绑定

    query.addBindValue(idList);

    query.addBindValue(nameList);

    query.addBindValue(ageList);

    query.addBindValue(scoreList);

    //执行预处理命令

    query.execBatch();

    query.exec("select * from student");

    while(query.next())

    {

        //取出当前行的内容

        qDebug()<<query.value().toInt()

               << query.value().toString()

               << query.value("age").toInt()

               << query.value("score").toInt();

    }

}

Widget::~Widget()

{

    delete ui;

}