QSqlQueryModel+QTableView

#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,"订单编号"); this->setHeaderData(2,Qt::Horizontal,"工资"); } QVariant NewTableView::data(const QModelIndex &item, int role) const { QVariant value = QSqlQueryModel::data(item, role); if (role == Qt::TextAlignmentRole)//默认代理的对齐方式 { value = (Qt::AlignCenter);//对字体进行居中操作 return value; } else if(role == Qt::DisplayRole && item.column() == 2)//对第三列的数据转换类型 { value=value.toFloat(); return value; } else if(role==Qt::TextColorRole)//对每一列的数据加不同的颜色 { if(item.column() == 0) { return QColor(Qt::red); } else if(item.column() == 1) { return QColor(Qt::green); } else { return QColor(Qt::blue); } } else return QSqlQueryModel::data(item,role); }