最近看到关于qt 中mysql 浏览数据分页,有人用到了qtablewidget 翻页时手动添加
就在想,既然qt中提供了view和model,为什么放着不用哪?
简单实现了一把,记录一下
首先重新继承一下QSqlTableModel,翻页时修改记录数
userSqlTableModel.h
#ifndef USERSQLTABLEMODEL_H
#define USERSQLTABLEMODEL_H
#include
class UserSqlTableModel : public QSqlTableModel
{
Q_OBJECT
public:
explicit UserSqlTableModel(QObject *parent = 0,QSqlDatabase db = QSqlDatabase() );
void setStart(int start){this->m_nStart = start;}
int getStart(){return this->m_nStart;}
public:
QVariant headerData(int section, Qt::Orientation orientation, int role) const;
private:
int m_nStart; //记录数据起始id