Qt新手求助：如何按点击次数在QTableView显示SQLite指定行数数据

Hey there! I've got you covered with a step-by-step solution for your Qt + SQLite project. Let's walk through how to make that "Show" button behave exactly as you want.

First, Set Up Your Member Variables #

You'll need a counter to track how many times the button's been clicked, plus your database connection and a model to link your data to the QTableView. Add these to your window class's header file:

private:
    int m_clickCount; // Tracks button clicks
    QSqlDatabase m_db; // SQLite connection
    QSqlQueryModel* m_model; // Model for QTableView

Initialize Everything in the Constructor #

Next, set up your database connection and initialize the model and counter in your window's constructor:

// Initialize SQLite database
m_db = QSqlDatabase::addDatabase("QSQLITE");
m_db.setDatabaseName("your_database_file.db"); // Replace with your DB filename
if (!m_db.open()) {
    qDebug() << "Failed to open DB:" << m_db.lastError().text();
    return;
}

// Initialize counter and model
m_clickCount = 0;
m_model = new QSqlQueryModel(this);
ui->tableView->setModel(m_model); // Link model to your QTableView

Don't forget to replace your_database_file.db with your actual database file name, and make sure you've added QT += sql to your project's .pro file to enable Qt's SQL module.

Write the Button Click Slot #

This is where the magic happens. Create a slot for your "Show" button's click event, and handle the logic to load the correct rows based on click count:

void YourWindowClass::on_showButton_clicked() {
    m_clickCount++;
    QString queryStr;

    // Determine which rows to load
    if (m_clickCount == 1) {
        // First click: Load last 5 rows
        // Replace `your_table_name` and `id` with your table name and primary key column
        // Option 1: Loads rows in reverse order (newest first)
        queryStr = "SELECT * FROM your_table_name ORDER BY id DESC LIMIT 5;";
        // Option 2: Loads rows in original order (oldest of the last 5 first)
        // queryStr = "SELECT * FROM your_table_name WHERE id > (SELECT COUNT(*) FROM your_table_name) - 5 ORDER BY id ASC;";
    } else if (m_clickCount == 2) {
        // Second click: Load last 10 rows
        queryStr = "SELECT * FROM your_table_name ORDER BY id DESC LIMIT 10;";
        // Option 2 for original order:
        // queryStr = "SELECT * FROM your_table_name WHERE id > (SELECT COUNT(*) FROM your_table_name) - 10 ORDER BY id ASC;";
    } else {
        // Optional: Reset counter or keep showing last 10 rows after second click
        m_clickCount = 2; // Lock to showing last 10 rows
        queryStr = "SELECT * FROM your_table_name ORDER BY id DESC LIMIT 10;";
    }

    // Execute query and update the table
    m_model->setQuery(queryStr, m_db);
    if (m_model->lastError().isValid()) {
        qDebug() << "Query error:" << m_model->lastError().text();
        return;
    }

    // Optional: Set custom header names for your table columns
    m_model->setHeaderData(0, Qt::Horizontal, tr("ID"));
    m_model->setHeaderData(1, Qt::Horizontal, tr("Your Column 1"));
    // Add more setHeaderData calls for all your columns
}

Key Notes #

• Replace your_table_name and id with your actual table name and primary key column (if you don't have an auto-increment ID, you can use another column that defines the row order).
• Choose between the two query options based on whether you want the rows displayed in reverse order (newest first) or their original order in the database.
• The counter logic can be adjusted if you want different behavior after the second click (like resetting to show last 5 again on third click).

内容的提问来源于stack exchange，提问作者Ashu Ansari