一起看代码来玩玩QT之18 database(five 用lineEidt 对database 进行高级别的查询，使QTableView显示所需的数据)

最新推荐文章于 2023-03-30 11:06:07 发布

今个儿赛太阳

最新推荐文章于 2023-03-30 11:06:07 发布

阅读量525

点赞数 1

分类专栏： C++ Qt 代码

本文链接：https://blog.csdn.net/qq_15024937/article/details/50813424

版权

C++ Qt 代码专栏收录该内容

31 篇文章 0 订阅

订阅专栏

Contact.h

#ifndef CONTACT_H
#define CONTACT_H

#include <QWidget>
#include <QSqlTableModel>
#include <QTableView>
#include <QLineEdit>
#include <QPushButton>
class Contact : public QWidget
{
    Q_OBJECT
public:
    explicit Contact(QWidget *parent = 0);

    QSqlTableModel* _model;
    QTableView* _view;

    QLineEdit* _filter;
    QPushButton* _add;
    QPushButton* _del;
    QPushButton* _reset;
    QPushButton* _submit;
signals:

public slots:

    void slotModelDataChanged(QModelIndex,QModelIndex);
    void slotFilterChanged(QString filter);

};

#endif // CONTACT_H

Contact.cpp

#include "Contact.h"
#include <QVBoxLayout>
#include <QHBoxLayout>
#include <QSqlRecord>
#include <QCompleter>
#include <QDebug>
Contact::Contact(QWidget *parent) :
    QWidget(parent)
{
    _model = new QSqlTableModel;
    _view = new QTableView;
    _view->setModel(_model);

    _model->setTable("tcontact");
    _model->setEditStrategy(QSqlTableModel::OnManualSubmit);

    connect(_model, SIGNAL(dataChanged(QModelIndex,QModelIndex)),
            this, SLOT(slotModelDataChanged(QModelIndex,QModelIndex)));

    _model->select();

    // set Layout
    QVBoxLayout* vBox = new QVBoxLayout(this);
    vBox->addWidget(_view);

    QHBoxLayout* hBox = new QHBoxLayout;
    vBox->addLayout(hBox);

    hBox->addWidget(_filter = new QLineEdit, 1);
    hBox->addWidget(_add=new QPushButton("Add"));
    hBox->addWidget(_del=new QPushButton("Del"));
    hBox->addWidget(_reset=new QPushButton("Reset"));
    hBox->addWidget(_submit=new QPushButton("Submit"));

    connect(_add, &QPushButton::clicked, [&](){
        QSqlRecord record = _model->record();
        _model->insertRecord(-1, record);
    });
    connect(_del, &QPushButton::clicked, [&](){});
    connect(_reset, &QPushButton::clicked, [&](){});
    connect(_submit, &QPushButton::clicked, [&](){
        _model->submitAll();
    });

    connect(_filter, SIGNAL(textChanged(QString)),
            this, SLOT(slotFilterChanged(QString)));

    slotModelDataChanged(QModelIndex(), QModelIndex());
}

void Contact::slotFilterChanged(QString filter)
{
    if(filter.isEmpty())
    {
        _model->setFilter("");
        _model->select();
        return;
    }
 //  username like filter or password like  filter .......
    QSqlRecord record = _model->record();
    QString modelFilter;
    for(int i=0; i<record.count(); ++i)
    {
        if(i!=0)
        {
            modelFilter += " or ";
        }
        QString field = record.fieldName(i);
        QString subFilter = QString().sprintf("%s like '%%%s%%'", field.toUtf8().data(), filter.toUtf8().data());
      //  qDebug() << subFilter;

        modelFilter += subFilter;

    }
    qDebug() << modelFilter;
    _model->setFilter(modelFilter);
    _model->select();
}

void Contact::slotModelDataChanged(QModelIndex,QModelIndex)
{
    QStringList strList;
    for(int i=0; i<_model->rowCount(); ++i)
    {
        QSqlRecord record = _model->record(i);
        for(int j=0; j<record.count(); ++j)
        {
            QVariant var = record.value(j);
            if(var.isNull()) continue;
            strList << var.toString();
        }
    }
    qDebug() << strList;
    QCompleter* completer=new QCompleter(strList);
    _filter->setCompleter(completer);

}

main.cpp

#include <QApplication>
#include <QSqlDatabase>
#include <QSqlError>
#include <QDebug>
#include "Contact.h"

int main(int argc, char*argv[])
{
    QApplication app(argc, argv);

    /* 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";

    Contact w;
    w.show();
    return app.exec();
}