#ifndef NEWTABLEVIEW_H
#define NEWTABLEVIEW_H
#include <QDebug>
#include <QSqlQueryModel>
#include <QtSql>
class NewTableView : public QSqlQueryModel
{
Q_OBJECT
public:
explicit NewTableView(QObject *parent=0);
protected:
QVariant data(const QModelIndex &item, int role = Qt::DisplayRole) const;
};
#endif // NEWTABLEVIEW_H
△ 继承QSqlQueryModel来重写data函数
#include "newtableview.h"
NewTableView::NewTableView(QObject *parent):
QSqlQueryModel(parent)
{
QString sql="select "
"userNumId ,"
"TaskNum ,"
"totalMoney "
"from taskinfo where executor =''";
qDebug()<<sql;
this->setQuery(sql);
this->setHeaderData(0,Qt::Horizontal,"发布ID");
this->setHeaderData(1,Qt::Horizontal,"订单编号");
t