Qt:如何连接到 SQLite? [英] Qt: How to connect to SQLite?

问题描述

我安装了 SQLite3(解压到 c:/sqlite)，创建了一个数据库(c:/sqlite/mzsales).现在我试图在 QTableView 中显示它的内容.

I installed SQLite3 (unpacked to c:/sqlite), created a database (c:/sqlite/mzsales). Now I am trying to show its content in a QTableView.

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setHostName("localhost");
db.setDatabaseName("mzsales");
bool db_ok = db.open();

db_ok 是真的.那么

db_ok is true. Then

QSqlTableModel *model = new QSqlTableModel(0, db);
model->setTable("person");
model->setEditStrategy(QSqlTableModel::OnManualSubmit);
bool tbl_ok = model->select();

tbl_ok 是假的.

tbl_ok is false.

我做错了什么?我如何连接到数据库?谢谢！

What do I do wrong? How do I connect to db? Thanks!

推荐答案

得到了答案.这是:

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("C:\\sqlite\\mzsales");
bool db_ok = db.open();

无需连接，指定路径即可.

No need to connect, just specify the path and all is done.

这篇关于Qt:如何连接到 SQLite?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！