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,telephonenumber,point,childname,childsex,childbirthday,address)values(:name,:cardnumber,:sex,: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);