Qt的SQL操作，DELETE，SELECT

最新推荐文章于 2025-06-06 08:32:40 发布

转载最新推荐文章于 2025-06-06 08:32:40 发布 · 321 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/browncrane/p/4209028.html

文章标签：

#数据库

本文提供了一个使用Qt进行数据库管理的示例代码，包括打开数据库、删除记录和获取记录等功能。详细介绍了如何通过QSqlQuery执行SQL语句，并展示了如何处理结果集。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

#include <QObject>
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QString>
 
class DatabaseManager : public QObject
    {
    public:
        DatabaseManager(QObject *parent = 0);
        ~DatabaseManager();
 
    public:
        bool openDB();
        bool deletePerson(int id);
 
    private:
        QSqlDatabase db;
    };

Delete a person from the database:

bool DatabaseManager::deletePerson(int id)
    {
    bool ret = false;
    if (db.isOpen())
        {
        QSqlQuery query;
        ret = query.exec(QString("delete from person where id=%1").arg(id));
        }
    return ret;
    }

The rest of the code:

bool DatabaseManager::openDB()
    {
    // Find QSLite driver
    db = QSqlDatabase::addDatabase("QSQLITE");
 
    #ifdef Q_OS_LINUX
    // NOTE: We have to store database file into user home folder in Linux
    QString path(QDir::home().path());
    path.append(QDir::separator()).append("my.db.sqlite");
    path = QDir::toNativeSeparators(path);
    db.setDatabaseName(path);
    #else
    // NOTE: File exists in the application private folder, in Symbian Qt implementation
    db.setDatabaseName("my.db.sqlite");
    #endif
 
    // Open databasee
    return db.open();
    }

以上参考http://developer.nokia.com/community/wiki/Deleting_data_from_a_database_in_Qt

SELECT核心语句

bool DatabaseManager::getPerson(int id, PersonData*& person)
    {
    bool ret = false;
 
    QSqlQuery query(QString("select * from person where id = %1").arg(id));
    if (query.next())
        {
        person->id = query.value(0).toInt();
        person->firstname = query.value(1).toString();
        person->lastname = query.value(2).toString();
        person->age = query.value(3).toInt();
        ret = true;
        }
 
    return ret;
    }