日志
qt5.4做数据库插入时报Parameter count mismatch 问题
2014-12-16 23:52
qt5.4做数据库插入时报Parameter count mismatch 问题 请问大家是什么原因, 下面是插入代码:
QSqlQuery query; query.prepare("INSERT INTO stu(id, name, address) VALUES (:id, :name, :address)"); query.bindValue(":id",ui->idLineEdit->text().toInt()); query.bindValue(":name",ui->nameLineEdit->text()); query.bindValue(":address",ui->addressLineEdit->text()); //query.bindValue(":pickname",ui->pickNameLineEdit->text()); bool ok= query.exec(); if(ok) { qDebug()<<"insert database Success"; ui->idLineEdit->clear(); ui->nameLineEdit->clear(); ui->addressLineEdit->clear(); //ui->pickNameLineEdit->clear(); } else { qDebug()<<"error Message:"<<query.lastError().text(); } 运行就会报 Parameter count mismatch |
下一篇: qt 数据库编程