qt.rar_QT_qt 数据库

#include <QCoreApplication> #include <QSqlDatabase> #include <QDebug> #include <QStringList> #include <QSqlQuery> int main(int argc, char *argv[]) { QCoreApplication a(argc, argv); // 输出可用数据库 qDebug() << "Available drivers:"; QStringList drivers = QSqlDatabase::drivers(); foreach(QString driver, drivers) qDebug() << driver; // 打开MySQL QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL"); db.setHostName("localhost"); db.setDatabaseName("mydata"); db.setUserName("root"); db.setPassword(""); if (!db.open()) qDebug() << "Failed to connect to root mysql admin"; else qDebug() << "open"; QSqlQuery query(db); //注意这里varchar 一定要指定长度，不然会出错 query.exec("create table student(id int primary key,name varchar(20))"); query.exec("insert into student values(1,'xiaogang')"); query.exec("insert into student values(2,'xiaoming')"); query.exec("insert into student values(3,'xiaohong')"); query.exec("select id,name from student where id >= 2"); while(query.next()) { int value0 = query.value(0).toInt(); QString value1 = query.value(1).toString(); qDebug() << value0 << value1 ; } return a.exec(); }