Question

qt qsqlquery 怎么和数据库联系起来

Answer 1

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("sqluser.db");
db.open();
QString sql("select * from quanbu");
QSqlQueryModel *model = new QSqlQueryModel();
model->setQuery(sql, db);

if (model->lastError().isValid()) {
QDebug() << "Query Error: " << qPrintable(model->lastError().text());
delete model;
model = 0;
} else {
//输出model数据
}
//close database