Question

Qt在mysql语句中如何使用变量

若以下回答无法解决问题，邀请你更新回答

Answer 1

QString strSql = QString("SELECT name,id,Eye FROM  patientInfo where isChecked = 'true' AND (name like ")+\
"'%"+ui->lineEditSearch->text()+"%'"+QString("or id like ")+"'%"+ui->lineEditSearch->text()+"%')";

直接加上变量就好了,看到了没,我这ui->lineEditSearch->text()和ui->lineEditSearch->text()都是变量