QString select_max_sql = QString("select max(id) from retention");
int max_id = 0;
sql_query.prepare(select_max_sql);
if (!sql_query.exec())
{
qDebug() << sql_query.lastError();
}
else
{
while (sql_query.next())
{
max_id = sql_query.value(0).toInt();
qDebug()<<max_id;
}
}
QString select_max_sql = QString("select Count(*) from retention");
sql_query.prepare(select_max_sql);
if (!sql_query.exec())
{
qDebug() << sql_query.lastError();
}
else
{
while (sql_query.next())
{
qDebug()<< sql_query.value(0).toInt();
}
}
所记录数据id与行数严格对应的话,获得总行数可以两种方法通用