java sqlite3驱动下载_使用sqlite3驱动程序在QSqlQuery中使用多个sql语句

我写了一个简单的函数来从一个文件读取SQL并一次执行一个语句 .

/**

* @brief executeQueriesFromFile Read each line from a .sql QFile

* (assumed to not have been opened before this function), and when ; is reached, execute

* the SQL gathered until then on the query object. Then do this until a COMMIT SQL

* statement is found. In other words, this function assumes each file is a single

* SQL transaction, ending with a COMMIT line.

*/

void executeQueriesFromFile(QFile *file, QSqlQuery *query)

{

while (!file->atEnd()){

QByteArray readLine="";

QString cleanedLine;

QString line="";

bool finished=false;

while(!finished){

readLine = file->readLine();

cleanedLine=readLine.trimmed();

// remove comments at end of line

QStringList strings=cleanedLine.split("--");

cleanedLine=strings.at(0);

// remove lines with only comment, and DROP lines

if(!cleanedLine.startsWith("--")

&& !cleanedLine.startsWith("DROP")

&& !cleanedLine.isEmpty()){

line+=cleanedLine;

}

if(cleanedLine.endsWith(";")){

break;

}

if(cleanedLine.startsWith("COMMIT")){

finished=true;

}

}

if(!line.isEmpty()){

query->exec(line);

}

if(!query->isActive()){

qDebug() << QSqlDatabase::drivers();

qDebug() << query->lastError();

qDebug() << "test executed query:"<< query->executedQuery();

qDebug() << "test last query:"<< query->lastQuery();

}

}

}