项目场景:
提示:这里简述项目相关背景:
本来是想写一个注册场景,结果无法写入数据库。
问题描述
提示:这里描述项目中遇到的问题:
数据写入过程中,
写法一报错
“INSERT INTO user ( user_id, password, name, age, gender, phone, ad在这里插入代码片
dress,avatar) VALUES (81986799,123123,‘刘志刚’,18,‘男’,12341234123,‘南昌’,NULL)”
m_query Error: QSqlError(“”, “Unable to fetch row”, “No query”)
写法二报错
m_query Error: QSqlError("", "Parameter count mismatch", "")
写法三报错
m_query Error: QSqlError("", "Parameter count mismatch", "")
bool DataBaseThread::setUserInfo(const QString user_id, const QString password, const QString name, const int age, const QString gender, const QString phone , const QString address,const QByteArray avatar)
{//接口
// QSqlQuery * qry=new QSqlQuery();
bool ok1 = m_db.open();
if(!ok1){//打开数据库失败时的操作
QMessageBox::critical(nullptr,"Tips","数据库未连接"+m_db.lastError().text());
emit ErrorDisconnection();
}
m_query=new QSqlQuery();
//写法一
// QString queryStr=QString("INSERT INTO user ( user_id, password, name, age, gender, phone, address,avatar) VALUES (%1,%2,'%3',%4,'%5',%6,'%7',%8)")
// .arg(user_id)
// .arg(password)
// .arg(name)
// .arg(age)
// .arg(gender)
// .arg(phone)
// .arg(address)
// .arg(avatar);
// qDebug()<<queryStr;
// m_query->prepare(queryStr);
//写法二
m_query->prepare("INSERT INTO user (user_id, password,name,age,gender,phone,address,avatar)VALUES (:user_id,:password,:name,:age,:gender,:phone,:address,:avatar)");
// m_query->bindValue(":avatar", avatar);
m_query->bindValue(":user_id", user_id);
m_query->bindValue(":password", password);
m_query->bindValue(":name", name);
m_query->bindValue(":age", age);
m_query->bindValue(":gender", gender);
m_query->bindValue(":phone", phone);
m_query->bindValue(":address", address);
m_query->bindValue(":avatar",avatar);
//写法三
// m_query = new QSqlQuery();
// QString queryStr = "INSERT INTO user ( avatar, user_id, password, name, age, gender, phone, address) "
// "VALUES ( ?, ?, '?', ?, '?', ?, '?', ?)";
// m_query->prepare(queryStr);
// m_query->bindValue(0, avatar, QSql::Binary);
// m_query->bindValue(1, user_id);
// m_query->bindValue(3, password);
// m_query->bindValue(4, name);
// m_query->bindValue(5, age);
// m_query->bindValue(6, gender);
// m_query->bindValue(7, phone);
// m_query->bindValue(8, address);
bool ok = m_query->exec();
if(!ok){
qDebug()<<"m_query Error:"<<m_query->lastError();
return false;
}
return true;
}
void RegisterDialog::on_btnOK_clicked()
{//点击后查询
bool isOK=m_dbthread->setUserInfo( ui->lineEditUser->text(),
ui->lineEditPWD_2->text(),
ui->lineEditName->text(),
ui->spinBoxAge->value(),
ui->comboSex->currentText(),
ui->lineEditPhoneNumber->text(),
ui->lineEditAddress->text(),
"NULL");
if(!isOK)
QMessageBox::critical(this,"Tips:","写入账户信息出错,请联系管理员");
this->close();
}
原因分析:
提示:这里填写问题的分析:写入过程中,参数不匹配。要么就是语法问题,实在解决不了
解决方案:
无