qt数据库插入问题求解

[SPZn_up]

插入数据的时候
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);

}

是不是数据插入失败，怎么破啊，求解……

[zyq5945]

占位符写错了,是？号，推荐使用方式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();