c++ - 如何在 Qt 中创建和加载 SQLite？

Question

我有一个包含数据的表 (QTableWidget)。我如何创建数据库 SQLite 并保存我的数据。那我下次还需要重新载入数据吗？感谢提前!

Answer 1

/*constructor ...*/
{

    ...

    /* create TableView to hold our db */
    pcbtv = new QPcbView(this);
    pcbtv->setModel(tabsort);
    pcbtv->setAlternatingRowColors(true);
    pcbtv->setSortingEnabled(true);
    pcbtv->setCornerButtonEnabled(false);
    pcbtv->setSelectionMode(QAbstractItemView::SingleSelection);
    pcbtv->setSelectionBehavior(QAbstractItemView::SelectRows);
    pcbtv->setEditTriggers(QTableView::NoEditTriggers); /* start read-only */
    pcbtv->resizeColumnsToContents();

    /* Header titles must be set on the model */
    pcbtv->model()->setHeaderData(PartNo_PartNo, Qt::Horizontal, "Part No");
    pcbtv->model()->setHeaderData(PartNo_Name, Qt::Horizontal, "Name");
    pcbtv->model()->setHeaderData(PartNo_GteNo, Qt::Horizontal, "GT-E Part No");
    pcbtv->model()->setHeaderData(PartNo_GteName, Qt::Horizontal, "GT-Electronics Name");

    QHeaderView* header = pcbtv->horizontalHeader();
    //header->setToolTip("bliblabloo");
    header->setAlternatingRowColors(true);
    header->setSectionsMovable(true);
    header->setStretchLastSection(true);
    pcbtv->setHorizontalHeader(header);

    ...

}

void PcbList::loadDb(QString filepath)
{
    openSqliteDb(filepath, "PARTNO");
}

void PcbList::openSqliteDb(QString dbname, QString table)
{
    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
    db.setDatabaseName(dbname);
    db.open();
    qDebug() << "connected to db " << dbname;

    tabmod = new QSqlTableModel(this, db);
    tabmod->setTable(table);
    tabmod->setSort(PartNo_GteNo, Qt::AscendingOrder);
    tabmod->setEditStrategy(QSqlTableModel::OnFieldChange);
    tabmod->select();
}