#include <QSqlDatabase>
#include <QSqlQuery>
static bool createConnection()
{
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("database.db");
if(!db.open())
return false;
QSqlQuery query;
query.exec("CREATE TABLE student (id int primary key)");
//query.exec("DELETE FROM student WHERE id = 1");
return true;
}
static bool modifyDatabase(int num)
{
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("database.db");
if(!db.open())
return false;
QSqlQuery query;
query.exec("CREATE TABLE student (id int primary key)");
query.prepare("INSERT INTO student (id) VALUES (:id)");
query.bindValue(0, 5);
query.exec();
return true;
}
#endif // DATABASE_H
编译结果:
D:\Files\Graduate Project\3-12\sendToDatabase-build-desktop-Qt_4_8_0_for_Desktop_-_MinGW__Qt_SDK__Debug\..\sendToDatabase\database.h:28: error: no matching function for call to 'QSqlQuery::bindValue(int, int)'
请教大侠们如何解决?谢谢!