ResultSet DBService::query(const QString& sqlQuery)
{
// qDebug()<<"query sql : "<<sqlQuery;
ResultSet results;
isValid = true;
if(!open())
{
isValid = false;
return results;
}
QSqlQuery sql_query(database);
sql_query.prepare(sqlQuery);
if(!sql_query.exec())
{
isValid = false;
qDebug()<<sql_query.lastError();
return results;
}
else
{
QSqlRecord record = sql_query.record();
while(sql_query.next())
{
ResultRow resMap;
for(int i = 0;i < record.count();i++)
{
resMap.insert(record.fieldName(i),sql_query.value(i).toString());
}
results.resultList.append(resMap);
}
}
close();
return results;
}
