插入数据的时候
QString::arg: Argument missing: INSERT INTOA users(account,password,nickname) VALUES(1%,2%,3%), qtt
QString::arg: Argument missing: INSERT INTO users(account,password,nickname) VALUES(1%,2%,3%), 123456
QString::arg: Argument missing: INSERT INTO users(account,password,nickname) VALUES(1%,2%,3%), ahaha
QSqlQuery::value: not positioned on a valid record
QVariant(, )
以下是代码
QApplication a(argc, argv);
//Dialog w;
//w.show();
QSqlDatabase db;
bool create = QFile::exists("haoDatabase.db");
db = QSqlDatabase::addDatabase("QSQLITE"); //添加数据库驱动
db.setDatabaseName("haoDatabase.db"); //数据库连接命名
if (!db.open())
{
QMessageBox::warning(NULL, "Error",
"Can not open the sqlite database");
exit(2);
}
QSqlQuery query;
//用户表（帐号，密码，呢称，头像编号，状态，手机号码，电话号码，
//生日，城市，自我描述）
query.exec("create table users(account varchar(21) primary key, "
"password varchar(21) not null, "
"nickname nvarchar(41) not null)");
QString account1 ="qtt";
QString password1 ="123456";
QString nickname1 ="ahaha";
query.exec(QString("INSERT INTO users(account,password,nickname) VALUES(1%,2%,3%)").arg(account1).arg(password1).arg(nickname1));
query.addBindValue(account1);
query.addBindValue(password1);
query.addBindValue(nickname1);
query.exec("select * from users");
query.next();
//while (query.next())
{
qDebug()<<query.value(0);
}
是不是数据插入失败，怎么破啊，求解……
------解决思路----------------------
占位符写错了,是？号，推荐使用方式2
方式1：
QSqlQuery query;
query.prepare("INSERT INTO person (id, forename, surname) "
"VALUES (?, ?, ?)");
query.addBindValue(1001);
query.addBindValue("Bart");
query.addBindValue("Simpson");
query.exec();
方式2:
QSqlQuery query;
query.prepare("INSERT INTO person (id, forename, surname) "
"VALUES (?, ?, ?)");
query.bindValue(0, 1001);
query.bindValue(1, "Bart");
query.bindValue(2, "Simpson");
query.exec();