1、构造QString,使用%1占位符,如
QString sqlquery = QObject::tr("insertinto table values('%1','%2')").arg(value1,value2);
query.exec(sqlquery);
2、使用query.prepare()和query.bindvalue()
3、使用c语言函数sprintf(Qt下不采用)
char szSql[200] ={0};
int pwd = 366;
sprintf(szSql,"select * from shopper where password='%d'",pwd);
4、采用"+变量+"
int pwd = 366;
stringsql = "select * from shopper where password='"+pwd+"'";