qt mysql分页查询_Qt开源作品19-通用数据库翻页查询

void DbPage::bindData(const QString &sql)

{

queryModel->setQuery(sql, QSqlDatabase::database(connName));

tableView->setModel(queryModel);

//依次设置列标题列宽 int columnCount = tableView->model()->columnCount();

int nameCount = columnNames.count();

columnCount = columnCount > nameCount ? nameCount : columnCount;

QList columnNames = this->columnNames;

QList columnWidths = this->columnWidths;

//根据设置添加新列,将对应新列的标题名称和宽度按照索引位置插 if (insertColumnIndex >= 0) {

columnCount++;

columnNames.insert(insertColumnIndex, insertColumnName);

columnWidths.insert(insertColumnIndex, insertColumnWidth);

queryModel->insertColumn(insertColumnIndex);

}

//设置列标题和列宽度 for (int i = 0; i < columnCount; i++) {

queryModel->setHeaderData(i, Qt::Horizo