Qt TableView实现翻页，翻页选中，删除，跳转

寒芒_

已于 2022-04-21 16:02:41 修改

阅读量2k

点赞数 1

文章标签： qt c++

于 2022-03-17 16:09:54 首次发布

本文链接：https://blog.csdn.net/qq_42919993/article/details/123552424

版权

案列参照飞扬青云大神的，添加了翻页后选中效果，模糊搜索，
选中删除和全部删除。

当前实现翻页选中，并将选中的删除
在这里插入图片描述

选中行和取消行的代码，并将选中情况放进map中去


on_tableView_SelectRows(const QItemSelection &selected, const QItemSelection &deselected)
{
    int selected_rows = -1;
    int deselected_rows = -1;
    int db_index_selected = -1;
    int db_index_deselected = -1;

    foreach(QModelIndex index, selected.indexes())
    {
        qDebug()<<"双击："<<index;
        //获取数据库的索引
        QSqlRecord record = queryModel->record(index.row());
        db_index_selected = record.value(0).toInt();
        //获取view索引
        selected_rows = index.row();
    }

    foreach(QModelIndex index, deselected.indexes())
    {
        //取消数据库的索引
        QSqlRecord record = queryModel->record(index.row());
        db_index_deselected = record.value(0).toInt();
        //取消view索引
        deselected_rows = index.row();
    }

    if(selected_rows > -1)
    {
        list_selectedRows.push_back(selected_rows);
        //list_Select.push_back(db_index_selected);
        map_Select.insert(db_index_selected,0);
    }

    if(deselected_rows > -1)
    {
        list_selectedRows.removeOne(deselected_rows);
        qDebug()<<"取消" << db_index_deselected;
        map_Select.remove(db_index_deselected);
    }

    qSort(list_selectedRows.begin(),list_selectedRows.end());

    rowMap.insert(pageCurrent,list_selectedRows);

    QMapIterator<int, QList<int>> rowMapIterator(rowMap);
    rowMapIterator.toBack();
    while (rowMapIterator.hasPrevious())
    {
        rowMapIterator.previous();
        QList<int> temp = rowMapIterator.value();
        if(temp.isEmpty())
        {
            rowMap.remove(rowMapIterator.key());
        }

    }

}

将容器中的数据删除


DeletRows()
{    

    dbConn.transaction();

    QMapIterator<int, int> rowMapIterator(map_Select);
    rowMapIterator.toBack();
    while (rowMapIterator.hasPrevious())
    {
        rowMapIterator.previous();

        QString sql = QString("delete from %1 where %2 = %3").arg(tableName).arg(m_condition)
                .arg(rowMapIterator.key());
        dbConn.exec(sql);
    }

    dbConn.commit();    //提交事物
    //清空map
    tableView->clearSelection();
    rowMap.clear();
    map_Select.clear();

    if(rowMap.isEmpty())
    {
        qDebug()<<"删除完成";
    }

    if(m_flag == true)   //此处表示当前页面在搜索页面
    {
        CalculatorRecordsCount(m_str_sourfind_query);
        SourceManage_Find();
    }
    else {
        CalculatorRecordsCount(m_str_query);
        bindData(getPageSql());
    }

}

搜索条件下的翻页情况

在这里插入图片描述