QT连接mysql，已经正确输入sql插入语句，还是报SQL语句的错误，如何解决？

Question

void mainpage::on_pushButton_clicked()
{
QString name = ui->setname->text();//顾客办卡时输入的姓名
QString number = ui->setcardnum->text();//会员卡号
QString sex = ui->setsex->text();//性别
QString telephonenumber = ui->settelephone->text();//联系电话
QString point = ui->setpoint->text();//积分
QString childname = ui->setchildname->text();//儿童姓名
QString childsex = ui->setchildsex->text();
QString childbirthday = ui->setbirth->text();//儿童生日
QString address = ui->setaddress->text();//住址

qDebug()<<name;
qDebug()<<number;
qDebug()<<sex;


qDebug()<<telephonenumber;
qDebug()<<point;
qDebug()<<childname;
qDebug()<<childsex;
qDebug()<<childbirthday;
qDebug()<<address;

QSqlQuery sql;
sql.prepare("insert into vipinfotable1(name,cardnumber,sex)values(:name,:cardnumber,:sex)");
sql.prepare("insert into vipinfotable1(telephonenumber，point，childname，childsex，childbirthday，address)values(:telephonenumber,:point,:childname,:childsex,:childbirthday,:address)");
sql.bindValue(":name",name);
sql.bindValue(":cardnumber",number);
sql.bindValue(":sex",sex);
sql.bindValue(":telephonenumber",telephonenumber);
sql.bindValue(":point",point);
sql.bindValue(":childname",childname);
sql.bindValue(":childsex",childsex);
sql.bindValue(":childbirthday",childbirthday);
sql.bindValue(":address",address);

bool addIF = sql.exec();
if(addIF)
{
    qDebug()<<"建卡成功！";
    mainpage::getDatabaseInfo();


}
else
{
    qDebug()<<"建卡失败!";

}

}

Answer 1

不太懂，你还能一次执行多个prepare啊