#include <QtCore/QCoreApplication>
#include <QtSql>
#include <qDebug>
int main(int argc, char *argv[]) {
QCoreApplication a(argc, argv);
//QApplication app(argc,argv);
QTextCodec::setCodecForCStrings(QTextCodec::codecForName("utf8"));
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("lqs.db"); // 数据库名与路径, 此时是放在同目录下
if(db.open()) // 连接数据库, 然后就可以使用了.
{
qDebug() << "Can open database";
}
QSqlQuery query;
QString name;
//query.executedQuery();
query.exec("select*from t");
if(query.next())
{
qDebug()<<"next() successfully";
}
else
{
qDebug()<<query.lastError();
}
while (query.next()) {
int id = query.value(0).toInt();
qDebug()<<"second";
QString name = query.value(1).toString();
//label.setText(name);
qDebug() << "Id=" << id << ", Name=" << name;
}
qDebug()<<"third";
//label.setText(name);
//label.show();
return a.exec();
}