|
哦哦,这样子。那我有一个qt程序,#include <QCoreApplication>#include <QtSql/QSqlDatabase>//#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 ; },为什么输出结果说database not open
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有帐号?立即注册
x
|