
正文
QTableView加载数据
提示:扫一扫查出行【扫一扫了解最新限行尾号】
复制提示
void VCAdmin::searchAllUser()
{
strID_Index = "";
if (NULL == vcManageDatabaseObj)
{
vc_admin_ui.label_msg->setText(QString::fromLocal8Bit("请连接数据库!"));
return;
}
QSqlQuery query_sql = vcManageDatabaseObj->searchAllUser(); admin_model->clear();
int count_sr1 = ;
while (query_sql.next())
{ QString strID = query_sql.value().toString();
QString strUSerName = query_sql.value().toString();
QString strUserPWd = query_sql.value().toString(); QString strRealName = query_sql.value().toString();
QString strMobile = query_sql.value().toString();
QString strCreator = query_sql.value().toString();
QString strCreateDate = query_sql.value().toString(); admin_model->setItem(count_sr1, , new QStandardItem(strID));
admin_model->setItem(count_sr1, , new QStandardItem(strUSerName));
admin_model->setItem(count_sr1, , new QStandardItem(strUserPWd));
admin_model->setItem(count_sr1, , new QStandardItem(strRealName)); admin_model->setItem(count_sr1, , new QStandardItem(strMobile));
admin_model->setItem(count_sr1, , new QStandardItem(strCreator));
admin_model->setItem(count_sr1, , new QStandardItem(strCreateDate)); count_sr1++;
} //设置数据
setTableData();
}





