#include <QCoreApplication>
#include <QtSql>
#include <QDebug>
int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);
// 创建数据库连接
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("localhost");
db.setDatabaseName("my_database");
db.setUserName("username");
db.setPassword("password");
if (!db.open()) {
qDebug() << "无法连接到数据库:" << db.lastError().text();
return -1;
}
// 创建QSqlQuery对象并执行SQL查询
QSqlQuery query;
if (query.exec("SELECT id, name FROM my_table")) {
while (query.next()) {
int id = query.value(0).toInt();
QString name = query.value(1).toString();
qDebug() << "ID:" << id << ", Name:" << name;
}
} else {
qDebug() << "查询失败:" << query.lastError().text();
}
return a.exec();
}
08-31
1万+
07-27
3010