Question

怎样将mysql表格内容显示到qtablewidget上

Answer 1

QSqlQuery *sqlQuery = new QSqlQuery;
QString sqlStr = "select id, name from info";
sqlQuery->prepare( sqlStr );

if( sqlQuery->exec() )
{
//读取查询到的记录
while( sqlQuery->next() )
{
tableWidget->setItem( row, column, new QTableWidgetItem( sqlQuery->value(0).toString()));
tableWidget->setItem( row, column, new QTableWidgetItem( sqkQuery->value(1).toString()))
}
}
这样就把冲数据库中读取的内容写到表中了，自己获取表格的row，和column，