qtableview与qsqltablemodel结合现实数据的问题

TERRY-V 2013-07-10 10:15:53

GrammarPage::GrammarPage(QWidget *parent) :

    QWidget(parent),

    ui(new Ui::GrammarPage)

{

    ui->setupUi(this);



    QSqlDatabase db=QSqlDatabase::addDatabase("QMYSQL");

    db.setHostName("192.168.0.108");

    db.setDatabaseName("Pyweb");

    db.setUserName("root");

    db.setPassword("123456");

    db.open();



    QSqlTableModel *model=new QSqlTableModel();

    model->setTable("infopro_district_province");

    //model->setSort(Dict_Province, Qt::AscendingOrder);

    model->select();

    //model->setEditStrategy(QSqlTableModel::OnManualSubmit);

    model->setHeaderData(Dict_Id, Qt::Horizontal, tr("id"));

    model->setHeaderData(Dict_Province, Qt::Horizontal, tr("province"));

    model->setHeaderData(Dict_Syn, Qt::Horizontal, tr("syn"));

    model->setHeaderData(Dict_Abbr, Qt::Horizontal, tr("abbr"));



    for(int i=0; i<model->rowCount(); ++i) {

        QSqlRecord record=model->record(i);

        qDebug()<<record.value(0).toString()<<'\t'<<record.value(1).toString()<<'\t'<<record.value(2).toString()<<'\t'<<record.value(3).toString()<<'\n';

    }



    ui->tableView->setModel(model);

    ui->tableView->setSelectionMode(QAbstractItemView::SingleSelection);

    ui->tableView->setSelectionBehavior(QAbstractItemView::SelectRows);

    ui->tableView->hideColumn(Dict_Id);

    ui->tableView->resizeColumnsToContents();

    ui->tableView->setEditTriggers(QAbstractItemView::NoEditTriggers);



    QHeaderView *header=ui->tableView->horizontalHeader();

    header->setStretchLastSection(true);

}