1.获取查询内容:
QString selectstr = QString("select malfunstrid from malfunct_str order by malfunstrid desc limit 1 ");
query.exec(selectstr);
QSqlRecord rec = query.record();
//1.获取选中选中id号的数据库数据
while(query.next())
{
int malfunimgid = rec.indexOf("malfunstrid");
QString malfunimgid_m = query.value(malfunimgid).toString();
qDebug() <<"获取的malfunimgid信息是" << malfunimgid_m << endl;
}
或者:
while (query.next()) {
QSqlRecord rec = query.record(); //
for(int i=0;i<rec.count();++i)//将每行的每一列结果得出来
{
QString strResult = query.value(i).toString();//表第i个字段的内容
}
}
2. 查询表的内容,获取表有多少行和列
QSqlQuery query2 = QSqlQuery(database_1);
query2.exec("SELECT * FROM db2.my_table"); // 查询数据库db2的表my_table的所有行和列
// 上面这2句等同于下面注释的这1句
// QSqlQuery query2("SELECT * FROM db2.my_table",database_1);
QSqlRecord rec = query2.record();
qDebug() << "表的列数:" << rec.count(); // 表一共有多少列
qDebug() << "表的行数:" << query2.size(); // 表一共有多少行