qt5连接sqlite数据库实例
建库
在VS下新建qt console appication
代码:
#include <iostream> #include <Qtsql/QSqlDatabase> #include <Qtsql/QSqlQuery> #include <QtCore/QCoreApplication> #include <QDebug> #pragma comment(lib, "Qt5Sql.lib") int main(int argc, char *argv[]) { QCoreApplication a(argc, argv); QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE"); db.setDatabaseName("user.db"); db.open(); QSqlQuery query; query.exec("select * from student"); while(query.next()) { int id = query.value(0).toInt(); QString str = query.value(1).toString(); qDebug() << id << "|" << str; } db.close(); return a.exec(); }