看不到表格,高手指点下,谢谢。代码如下:
mainwindow.cpp
MainWindow::MainWindow(QWidget *parent) :
QMainWindow(parent),
ui(new Ui::MainWindow)
{
dataView *viewData= new dataView;
setCentralWidget(viewData);
setWindowTitle(tr("Mail Client"));
ui->setupUi(this);
}
dataview.cpp
dataView::dataView(QWidget *parent) :
QWidget(parent)
{
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("10.35.12.211");
db.setDatabaseName("wlh");
db.setUserName("root");
db.setPassword("rootme");//密码
if(!db.open())
{
QMessageBox::critical(0,QObject::tr("Database Error"),db.lastError().text());
// QMessageB
}
enum
{
id = 0,
title= 1,
year = 2
};
QSqlTableModel *model=new QSqlTableModel;
model->setTable("cd");
model->setFilter("year >= 1998");
model->setSort(id,Qt::AscendingOrder);//排序
model->setHeaderData(title,Qt::Horizontal,QObject::tr("标题"));
model->setHeaderData(year,Qt::Horizontal,QObject::tr("年"));
model->select();
QTableView *dataView = new QTableView;
dataView->setModel(model);
// dataView->setItemDelegate();
dataView->setSelectionBehavior(QAbstractItemView::SelectRows);
dataView->show();
QHBoxLayout *layout = new QHBoxLayout;
layout->addWidget(dataView);
setLayout(layout);
}