一起看代码来玩玩QT之18 QSqlDatabase (one 传统方法SQL语句) 用的少

来源：互联网发布：斗鱼直播软件编辑：程序博客网时间：2024/06/11 09:11

Widget01.h

#ifndef WIDGET01_H#define WIDGET01_H#include <QWidget>class Widget01 : public QWidget{    Q_OBJECTpublic:    explicit Widget01(QWidget *parent = 0);signals:public slots:};#endif // WIDGET01_H

Widget01.cpp

#include "Widget01.h"#include <QSqlDatabase>#include <QSqlError> //查看错误码#include <QSqlQuery>#include <QSqlResult>#include <QDebug>Widget01::Widget01(QWidget *parent) :    QWidget(parent){    /* QSQLITE QODBC QPLSQL 数据库名子*/    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");    db.setHostName("127.0.0.1");    db.setUserName("root");    db.setPassword("iamxgl");    db.setDatabaseName("d0718");    bool bRet = db.open();    if(bRet == false)    {        qDebug() << "error open database" << db.lastError().text();        exit(0);    }    qDebug() << "open database success"; //   db.exec("insert into tuser (username, password, gender) values('xueguoliang', 'xxdfsdf', 1)");    QSqlQuery query = db.exec("select * from d0718");   // int size = query.size();    bool b = query.first();    while(b)    { //       QSqlResult* result = query.result();  //      QVector<QVariant> values =  result->boundValues();     //   qDebug() << values;        b = query.next();    }}

1 0