写了一个SqliteHelper的demo.
打开,关闭和查询三个函数
运行之后提示找不到驱动的错误
源码如下:
qt控制台程序
main.cpp
#include <QCoreApplication>
#include <sqlitehelper.h>
#include <QDebug>
void SqliteDatabaseTest();
int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);
SqliteDatabaseTest();
return a.exec();
}
void SqliteDatabaseTest()
{
qDebug() << QSqlDatabase::drivers();
SqliteHelper *sql_helper = new SqliteHelper();
sql_helper->openDatabase();
QString sql_command = "insert into ANPRInfo valuses(1,'民航A12345', 'D:\')";
sql_helper->executeQuery(sql_command);
sql_helper->closeDatabase();
delete sql_helper;
}
sqlitehelper.h
#ifndef SQLITEHELPER_H
#define SQLITEHELPER_H
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
class SqliteHelper
{
public:
SqliteHelper();
QSqlDatabase database;
QSqlQuery sql_query;
void openDatabase();
void closeDatabase();
void executeQuery(QString sql_command);
};
#endif // SQLITEHELPER_H
sqlitehelper.cpp
#include "sqlitehelper.h"
#include <QDebug>
SqliteHelper::SqliteHelper()
{
if (QSqlDatabase::contains("qt_sql_default_connection"))
{
database = QSqlDatabase::database("qt_sql_default_connection");
}
else
{
database = QSqlDatabase::addDatabase("QSQLITE");
database.setDatabaseName("ANPRResults.sqlite");
//database.setUserName("seenboom");
//database.setPassword("seenboom");
}
}
void SqliteHelper::openDatabase()
{
if (!database.open())
{
qDebug() << "Error: Failed to connect database." << database.lastError();
}
else
{
// do something
}
}
void SqliteHelper::closeDatabase()
{
database.close();
}
void SqliteHelper::executeQuery(QString sql_command)
{
if(!sql_query.exec())
{
qDebug() << sql_query.lastError();
}
else
{
}
}
.pro里面加入了 st += sql
是哪里的问题呢,请指教