qt连接数据库sqlite3，在网上看到好多人写的都有缺陷，经过努力，自己调试出来了一个

#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();

}